SAP ABAP Table RECP_OI_DOC_AO_DETAIL (Basic Data of Arch. Object)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_XX (Package) RE: Obsolete Objects (Do Not Delete!!!)

Basic Data

Table Category	INTTAB	Structure
Structure	RECP_OI_DOC_AO_DETAIL	Table Relationship Diagram
Short Description	Basic Data of Arch. Object

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	AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
2	AOTYPE	☐	REBDAOTYPE	REBDAOTYPE	CHAR	4	0	Architectural Object Type	TIVBDAROBJTYPE
3	XMAOTYPE	☐	REBDXMAOTYPE	RECAXMDESCRIPTION	CHAR	30	0	Name of Architectural Object Type
4	AONR	☐	REBDAONR	REBDAONR	CHAR	13	0	Number of Architectural Object
5	REALVALIDFROM	☐	REBDREALVALIDFROM	RECADATEBEG	DATS	8	0	Date: Valid from (Effective)
6	REALVALIDTO	☐	REBDREALVALIDTO	RECADATEEND	DATS	8	0	Date: Valid to (Effective)
7	PARTSEPARATOR	☐	REBDPARTSEPARATOR	REBDPARTSEPARATOR	CHAR	10	0	AOID Code: Separator
8	PARTAOID	☐	REBDPARTAOID	REBDPARTAOID	CHAR	30	0	AOID Code
9	XAO	☐	REBDXAO	RECAXLDESCRIPTION	CHAR	60	0	Name of Architectural Object
10	AOFUNCTION	☐	REBDAOFUNCTION	REBDAOFUNCTION	CHAR	4	0	Function of Architectural Object	*
11	XMAOFUNCTION	☐	REBDXMAOFUNCTION	RECAXMDESCRIPTION	CHAR	30	0	Name of Function of Arch. Object - Medium-Length
12	USAGECOMMON	☐	REBDUSCOMMON	REBDUSCOMMON	CHAR	1	0	Common Usage
13	XUSAGECOMMON	☐	REBDXUSAGECOMMON	RECAXLDESCRIPTION	CHAR	60	0	Text for Common Usage
14	LASTRENO	☐	DRENOV	DATUM	DATS	8	0	Date of last redecoration
15	MEASSTRC	☐	REBDMEASSTRC	REBDMEASSTRC	CHAR	4	0	Measurement Structure	TIVBDMEASSTRC
16	XMMEASSTRC	☐	REBDXMMEASSTRC	RECAXMDESCRIPTION	CHAR	30	0	Name of Measurement Structure - Medium-Length
17	DOORPLT	☐	REBDDOORPLT	REBDDOORPLT	CHAR	15	0	Short description
18	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
19	XINSTBEZM	☐	XINSTBEZM	XMBEZ	CHAR	30	0	Description of maintenance district
20	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
21	XVERKEHR	☐	XVERKEHR	XTEXT50	CHAR	50	0	Transport connections
22	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
23	XLAGEWEM	☐	XLAGEWEM	XMBEZ	CHAR	30	0	Description of location of business entity
24	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
25	XOBJLAGE	☐	XOBJLAGE	XTEXT50	CHAR	50	0	District Location
26	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
27	XGRNART	☐	XGRNART	XTEXT50	CHAR	50	0	Property usage type according to development plan
28	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
29	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
30	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
31	RNBPLANMBZ	☐	RNBPLANMBZ	XMBEZ	CHAR	30	0	Description of usage type according to development plan
32	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
33	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
34	XUNART	☐	VVXUNART	XTEXT35	CHAR	35	0	Main usage type
35	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
36	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
37	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
38	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
39	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
40	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
41	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
42	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
43	XGRART	☐	VVXGRART	VVXTEXT20	CHAR	20	0	Property type
44	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
45	XGRQAL	☐	VVXGRQAL	VVXTEXT20	CHAR	20	0	Quality of property location
46	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
47	XGRFRM	☐	VVXGRFRM	VVXTEXT20	CHAR	20	0	Text: Ground type of property
48	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
49	XGRGZS	☐	VVXGRGZS	VVXTEXT20	CHAR	20	0	Text about property overall condition
50	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
51	XLJERBBAU	☐	XTEXT30	TEXT30	CHAR	30	0	Name
52	ZULBAUH	☐	REBDALLOWEDHEIGHT	REBDALLOWEDHEIGHT	INT2	5	0	Allowed Building Height (as Integer)
53	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
54	XOBJARTM	☐	XOBJARTM	XMBEZ	CHAR	30	0	Description of object type
55	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
56	XGEBZUST	☐	XGEBZUS	XTEXT50	CHAR	50	0	General condition of building
57	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
58	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
59	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
60	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
61	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
62	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
63	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
64	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
65	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
66	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
67	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
68	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
69	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
70	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
71	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
72	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
73	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
74	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
75	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
76	XSTOCKO	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
77	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
78	XSTOCKL	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
79	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
80	ISROOT	☐	REBDISROOT	RECABOOL	CHAR	1	0	Top Level Object Type of Architectural Hierarchy
81	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECP_OI_DOC_AO_DETAIL	AOTYPE	TIVBDAROBJTYPE	AOTYPE	REF	1	CN
2	RECP_OI_DOC_AO_DETAIL	JERBBAU	TDO9	SOBJERBBAU
3	RECP_OI_DOC_AO_DETAIL	MEASSTRC	TIVBDMEASSTRC	MEASSTRC	REF	C	CN
4	RECP_OI_DOC_AO_DETAIL	RGEBART	TIV5A	SOBJART
5	RECP_OI_DOC_AO_DETAIL	RGEBZUST	TIV83	RZUSTAND
6	RECP_OI_DOC_AO_DETAIL	RGRNART	TIVC4	RGRNART	KEY	1	CN
7	RECP_OI_DOC_AO_DETAIL	RNBPLAN	TIVB3	RNBPLAN		1	CN
8	RECP_OI_DOC_AO_DETAIL	SGRART	TIV56	SGRART
9	RECP_OI_DOC_AO_DETAIL	SGRFRM	TIV58	SGRFRM
10	RECP_OI_DOC_AO_DETAIL	SGRGZS	TIV59	SGRGZS
11	RECP_OI_DOC_AO_DETAIL	SGRQAL	TIV57	SGRQAL
12	RECP_OI_DOC_AO_DETAIL	SINSTBEZ	TIV16	SINSTBEZ
13	RECP_OI_DOC_AO_DETAIL	SLAGEWE	TIV10	SLAGEWE
14	RECP_OI_DOC_AO_DETAIL	SLIFTBIS	TIV37	SSTOCKW
15	RECP_OI_DOC_AO_DETAIL	SOBJLAGE	TIV45	SOBJLAGE
16	RECP_OI_DOC_AO_DETAIL	SSTCKBIS	TIV37	SSTOCKW
17	RECP_OI_DOC_AO_DETAIL	SUNUTZA	TIV36	SUNART
18	RECP_OI_DOC_AO_DETAIL	SVERKEHR	TIV44	SVERKEHR

History

Last changed by/on	SAP	20110901
SAP Release Created in	110