SAP ABAP Table U_22501 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_22501	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number
4	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
5	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
6	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
7	XWETEXT	☐	XWETEXT	XMBEZ	CHAR	30	0	Business entity identification
8	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
9	RKZBEST	☐	RKZBEST	RKZBEST	CHAR	1	0	Object status
10	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
11	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
12	RARTOPT	☐	RARTOPT	RARTOPT	NUMC	1	0	Option rate calculation type
13	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
15	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
16	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
17	NUMKIGR	☐	NUMKIGR	NUMKIGR	NUMC	8	0	Internal number range for property
18	NUMKIGE	☐	NUMKIGE	NUMKIGE	NUMC	8	0	Building internal number range
19	NUMKIME	☐	NUMKIME	SMENR	CHAR	8	0	Internal number range for rental unit
20	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
21	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
22	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
24	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
25	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
26	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
27	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
28	SMIETR	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
29	VORBK	☐	VORBK	ABRVAR	CHAR	4	0	Predefined operating costs settlement variant	TIA01
30	VORHK	☐	VORHK	ABRVAR	CHAR	4	0	Predefined heating expenses settlement variant	TIA01
31	DAKTBEST	☐	DAKTBEST	DATUM	DATS	8	0	Date active in portfolio
32	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number
33	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
34	VVLEN	☐	VVLEN	MEINS	UNIT	3	0	Unit of length	T006
35	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
36	J_OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
37	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
38	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
39	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	SANO1
40	SSTDORT	☐	VVSSTDORT	VVSSTDORT	CHAR	10	0	Regional location	TIV35
41	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
42	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
43	PROFIL	☐	VVPROFIL	VVPROFIL	CHAR	7	0	Planning profile for Real Estate objects	TIV98
44	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_22501	ADRNR	SANO1	OBJNR	KEY	1	C
2	U_22501	BUKRS	T001	BUKRS	KEY	1	CN
3	U_22501	FEINS	T006	MSEHI	KEY	1	CN
4	U_22501	GSBER	TGSB	GSBER	KEY	1	CN
5	U_22501	J_OBJNR	ONR00	OBJNR	KEY	1	CN
6	U_22501	KOKRS	TKA01	KOKRS	REF	C	CN
7	U_22501	MANDT	T000	MANDT	KEY	1	CN
8	U_22501	PRCTR	CEPC	PRCTR	KEY	1	CN
9	U_22501	PROFIL	TIV98	PROFIL
10	U_22501	PROFL	TKB1A	APROF	REF	C	CN
11	U_22501	REINS	T006	MSEHI	KEY	1	CN
12	U_22501	SINSTBEZ	TIV16	SINSTBEZ	REF	1	CN
13	U_22501	SLAGEWE	TIV10	SLAGEWE	REF	1	CN
14	U_22501	SMIETR	TIV03	SMIETR	KEY	1	CN
15	U_22501	SMIETSP	TIV20	SMIETSP	KEY	1	CN
16	U_22501	SOBJLAGE	TIV45	SOBJLAGE	KEY	1	CN
17	U_22501	SSTDORT	TIV35	SSTDORT	KEY	1	CN
18	U_22501	SVERKEHR	TIV44	SVERKEHR	KEY	1	CN
19	U_22501	VORBK	TIA01	ABRVAR	KEY	1	CN
20	U_22501	VORHK	TIA01	ABRVAR	KEY	1	CN
21	U_22501	VVLEN	T006	MSEHI	KEY	1	CN
22	U_22501	WAERS	TCURC	WAERS	REF	1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in