SAP ABAP Table S401 (RE standard analysis partner)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S401	Table Relationship Diagram
Short Description	RE standard analysis partner

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	PARTNR_01	☑	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
9	ROLE_02	☑	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
10	VWDAT	☑	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
11	.INCLUDE	☐				0	0	RE standard analysis partner
12	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
13	ROLE	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type	*
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
15	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
16	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
17	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
18	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
19	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
20	E_SMIVE	☐	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
21	XWETEXT	☐	XWETEXT	XMBEZ	CHAR	30	0	Business entity identification
22	XGRTXT	☐	XGRTXT	XLBEZ	CHAR	60	0	Text for property
23	XGETXT	☐	XGETXT	XLBEZ	CHAR	60	0	Building text
24	XMETXT	☐	VVXMETXT	XMBEZ	CHAR	30	0	Text for rental unit
25	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
26	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
27	TYPE	☐	BP_TYPE	BP_TYPE	CHAR	1	0	Partner category
28	GROUP_ID	☐	BP_GRP_ID	BP_GRP_ID	CHAR	4	0	Business Partner Grouping	*
29	NAME1	☐	BP_NAME1	TEXT40	CHAR	40	0	Name 1 (surname for persons, otherwise company name)
30	NAME2	☐	BP_NAME2	TEXT40	CHAR	40	0	Name 2 (Continuation of NAME 1)
31	NAME_LAST	☐	BP_NAMLAST	TEXT40	CHAR	40	0	Last Name
32	NAME_FIRST	☐	BP_NAMFRST	TEXT40	CHAR	40	0	First Name
33	LANGU	☐	LANGU	SPRAS	LANG	1	0	Language Key	*
34	TITLE	☐	BP_TITLE	BP_TITLE	NUMC	2	0	Form of Address (Key)	*
35	TITLE_LET	☐	BP_TITL_LT	BP_TITL_LT	NUMC	2	0	Salutation	*
36	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
37	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
38	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
39	ANZPT	☐	VVAPT	DEC5	DEC	5	0	No. of partners
40	TITLE_AC	☐	BP_TITL_AC	TEXT20	CHAR	20	0	Academic Title
41	N_PREFIX	☐	BP_PREFIX	TEXT20	CHAR	20	0	Name Prefix
42	N_ADDITION	☐	BP_ADDITN	TEXT20	CHAR	20	0	Name Affix
43	NICKNAME	☐	BP_NICKNAM	TEXT20	CHAR	20	0	Known As
44	SEX	☐	BP_SEX	BP_SEX	CHAR	1	0	Gender of business partner
45	PROFESSION	☐	BP_PROFESS	TEXT40	CHAR	40	0	Description of Occupation for Business Partner
46	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	*
47	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	*
48	PERS_NR	☐	BP_PERS_NR	CHAR15	CHAR	15	0	Personnel Number
49	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	*
50	HR_ORG_REF	☐	HR_ORG_REF	XFELD	CHAR	1	0	HR Org. Link
51	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
52	STAFF_REF	☐	BP_STAFF_R	XFELD	CHAR	1	0	Employee
53	ADR_REF_K	☐	BP_ADR_REF	BP_ADR_REF	CHAR	10	0	Address ID	*
54	ADR_DAT	☐	BP_ADR_DAT	DATUM	DATS	8	0	Business partner address relationship valid from
55	ADRNR	☐	BP_ADRNR	SADRNR	CHAR	10	0	Address Number	*
56	ADR_D_E	☐	BP_ADR_D_E	DATUM	DATS	8	0	Business Partner Address Relationship Valid Until
57	ADR_LOC	☐	VV_ADR_LOC2	CHAR20	CHAR	20	0	Partner: Building
58	FLOOR	☐	VV_FLOOR	CHAR10	CHAR	10	0	Partner: Storey
59	ROOM_NR	☐	VV_ROOM_NR	CHAR10	CHAR	10	0	Partner: Room number
60	XOBJTXT	☐	VVXOBJTXT	XMBEZ	CHAR	30	0	Text for Real Estate object
61	DBEBEZ	☐	DBEBEZ	DATUM	DATS	8	0	Date of start of relationship
62	DENBEZ	☐	DENBEZ	DATUM	DATS	8	0	Date of end of relationship
63	ROLETYP	☐	BP_ROLETYP	BP_ROLETYP	CHAR	4	0	Business Partner Role Category	*
64	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
65	XORT2	☐	ORT02_GP	TEXT35	CHAR	35	0	District
66	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
67	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
68	XSTRASSE2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street

History

Last changed by/on	SAP	20130529
SAP Release Created in