SAP ABAP Table S402 (Business entities)

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	S402	Table Relationship Diagram
Short Description	Business entities

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	T000
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	BUKRS_01	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	GSBER_02	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
10	SWENR_03	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
14	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
15	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
16	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
17	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
18	XPROFL	☐	VVXPROFL	TEXT30	CHAR	30	0	Settlement profile for costs
19	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
20	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
21	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
22	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
23	ANLN1	☐	VVANLN1	ANLN1	CHAR	12	0	Asset: main number	ANLH
24	ANZWE	☐	VVAWE	DEC6	DEC	6	0	No. of business entities
25	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
26	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
27	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
28	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
29	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
30	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
31	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
32	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
33	USR04	☐	USRQUAN151	USRQUAN15	QUAN	15	3	User Field 1 for Set (Length 12,3)
34	USR05	☐	USRQUAN152	USRQUAN15	QUAN	15	3	User Field 2 for Set (Length 12,3)
35	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
36	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	FEINS	☐	VVKFEINS	CHAR5	CHAR	5	0	Unit: area
39	VVLEN	☐	VVKLEN	CHAR5	CHAR	5	0	Unit: length
40	REINS	☐	VVKREINS	CHAR5	CHAR	5	0	Unit: room content
41	WAERS_01	☐	VVKWAERS	CHAR5	CHAR	5	0	Unit: currency
42	RFAKT	☐	VVXFAKT	CHAR6	CHAR	6	0	Conversion factor for fractional share of property
43	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
44	SINSTBEZ	☐	VVSINSTBEZ	SINSTBEZ	NUMC	5	0	Location: Maintenance district	*
45	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
46	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
47	SLAGEWE	☐	VVSLAGEWE	SLAGEWE	NUMC	4	0	Location: Business entity	TIV10
48	XINSTBEZ	☐	VVXINSTBEZ	CHAR15	CHAR	15	0	Location: Maintenance district
49	XOBJLAGE	☐	VVXOBJLAGE	CHAR15	CHAR	15	0	Location: district
50	XSTDORT	☐	VVXSTDORT	XTEXT35	CHAR	35	0	Regional location
51	XVERKEHR	☐	VVXERKEHR	XTEXT50	CHAR	50	0	Location: Transport connections
52	XLAGEWE	☐	VVXLAGEWE	CHAR15	CHAR	15	0	Location: Business ent.
53	XMIETR	☐	VVXMIETR	XTEXT30	CHAR	30	0	Tenancy law
54	SMIETR	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
55	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
56	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
57	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
58	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
59	RKZBEST	☐	RKZBEST	RKZBEST	CHAR	1	0	Object status
60	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
61	XPROFIL	☐	VVXPROFIL	TEXT40	CHAR	40	0	Planning profile
62	PROFIL	☐	VVPROFIL	VVPROFIL	CHAR	7	0	Planning profile for Real Estate objects	TIV98
63	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
64	SSTDORT	☐	VVSSTDORT2	VVSSTDORT	CHAR	10	0	Regional location	TIV35
65	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
66	XKZBEST	☐	VVXKZBEST	TEXT40	CHAR	40	0	Status: portfolio
67	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
68	XWETEXT	☐	VVXWETEXT	XMBEZ	CHAR	30	0	Text for Business Entity
69	SVERKEHR	☐	SVERKEHR2	SVERKEHR	CHAR	1	0	Location: Transport connections	TIV44
70	XVORBK	☐	VVXVORBK	CHAR50	CHAR	50	0	Predefined operating costs settlement variant
71	VORBK	☐	VORBK	ABRVAR	CHAR	4	0	Predefined operating costs settlement variant	TIA01
72	XVORHK	☐	VVXVORHK	CHAR50	CHAR	50	0	Predefined heating expenses settlement variant
73	VORHK	☐	VORHK	ABRVAR	CHAR	4	0	Predefined heating expenses settlement variant	TIA01
74	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
75	FUND_TYPE	☐	VVFUND_TYPE	VVFUND_TYPE	CHAR	1	0	IPD: Classification of participant	*
76	NATURE_INTEREST	☐	VVNATURE_INT	VVNATURE_INT	CHAR	1	0	IPD: Ownership structure	*
77	HEADLEASE_EXPIRE	☐	VVHEADLEASE_EXP	GJAHR	NUMC	4	0	IPD: Expiry year of hereditary tenancy
78	RETAIL_TYPE	☐	VVRETAIL_TYPE	VVRETAIL_TYPE	CHAR	1	0	IPD: Type of retail trade object
79	OFFICE_LOC	☐	VVOFFICE_LOC	VVOFFICE_LOC	CHAR	1	0	IPD: Region (only for usage type office > 50%)	*
80	OFFICE_TYPE	☐	VVOFFICE_TYPE	VVOFFICE_TYPE	CHAR	1	0	IPD: Office type	*
81	INDUSTRY_TYPE	☐	VVINDUSTRY_TYPE	VVINDUSTRY_TYPE	CHAR	1	0	IPD: Commercial object type
82	INDUSTRY_SIT	☐	VVINDUSTRY_SIT	VVINDUSTRY_SIT	CHAR	1	0	IPD: Location of commercial object	*
83	INDUSTRY_LOC	☐	VVINDUSTRY_LOC	VVINDUSTRY_LOC	CHAR	1	0	IPD: Link to commercial object	*
84	RESIDENT_TYPE	☐	VVRESIDENT_TYPE	VVRESIDENT_TYPE	CHAR	1	0	IPD: Type of resid. object (only for usage type apart.> 50%)	*
85	RENTAL_CATEGORY	☐	VVRENTAL_CAT	VVRENTAL_CAT	CHAR	1	0	IPD: Rent category (only for usage type apartment > 50%)	*
86	YEAR_CONSTRUCT	☐	VVYEAR_CONSTRUCT	GJAHR	NUMC	4	0	IPD: Constr.year or moderniz. (being modernized = '8888')
87	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
88	ADRZUS	☐	ADRZUS	TEXT35	CHAR	35	0	Address addit. info. (e.g. storey)
89	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
90	PURC_MONTH	☐	VVPURC_MONTH	VVPURC_MONTH	NUMC	2	0	IPD: Month of purchase
91	PURC_YEAR	☐	VVPURC_YEAR	GJAHR	NUMC	4	0	IPD: Year of purchase
92	PURC_PRICE_NET	☐	VVPURC_PRICE_NET	WRTV7	CURR	13	2	ROZ: Net purchase price
93	PURC_PRICE_GRO	☐	VVPURC_PRICE_GRO	WRTV7	CURR	13	2	IPD: Gross purchase price
94	PURC_PRICE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
95	SALE_MONTH	☐	VVSALE_MONTH	VVSALE_MONTH	NUMC	2	0	IPD: Month of sale
96	SALE_YEAR	☐	VVSALE_YEAR	GJAHR	NUMC	4	0	IPD: Sales year
97	SALE_PRICE_GRO	☐	VVSALE_PRICE_GRO	WRTV7	CURR	13	2	IPD: Gross sales price
98	SALE_PRICE_NET	☐	VVSALE_PRICE_NET	WRTV7	CURR	13	2	IPD: Net sales price
99	SALE_PRICE_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
100	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
101	.INCLUDE	☐				0	0	Customer Fields LIS: Include for Infostructure
102	DUMMYFIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
103	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S402	ANLN1	ANLH	ANLN1
2	S402	BUKRS	T001	BUKRS
3	S402	BUKRS_01	T001	BUKRS	KEY	1	CN
4	S402	GSBER	TGSB	GSBER
5	S402	GSBER_02	TGSB	GSBER
6	S402	KOKRS	TKA01	KOKRS
7	S402	KOSTL	CSKS	KOSTL
8	S402	MANDT	T000	MANDT
9	S402	OBJNR	ONR00	OBJNR
10	S402	PRCTR	CEPC	PRCTR
11	S402	PROFIL	TIV98	PROFIL
12	S402	PROFL	TKB1A	APROF
13	S402	SLAGEWE	TIV10	SLAGEWE
14	S402	SMIETR	TIV03	SMIETR
15	S402	SMIETSP	TIV20	SMIETSP
16	S402	SOBJLAGE	TIV45	SOBJLAGE
17	S402	SSTDORT	TIV35	SSTDORT
18	S402	SVERKEHR	TIV44	SVERKEHR
19	S402	SWENR	VIOB01	SWENR
20	S402	SWENR_03	VIOB01	SWENR
21	S402	USRCUKY1	TCURC	WAERS
22	S402	USRUNIT1	T006	MSEHI
23	S402	VORBK	TIA01	ABRVAR
24	S402	VORHK	TIA01	ABRVAR

History

Last changed by/on	SAP	20130529
SAP Release Created in