SAP ABAP Table AVIBDAO (Änderungsbelegstruktur Architektonisches Objekt (VIBDAO))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_AO (Package) RE: Arch. Object (Master Data of Architectural Object)

Basic Data

Table Category	INTTAB	Structure
Structure	AVIBDAO	Table Relationship Diagram
Short Description	Änderungsbelegstruktur Architektonisches Objekt (VIBDAO)

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	.INCLUDE	☐				0	0	Architectural Object
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	INTRENO	☐	REBDINTRENOAO	RECAINTRENO	CHAR	13	0	Internal Object Number for Architecture Objects (INTRENO)
4	.INCLUDE	☐				0	0	Architectural Object: Key
5	AOID	☐	REBDAOID	REBDAOID	CHAR	30	0	Identification of Architectural Object
6	.INCLUDE	☐				0	0	Architectural Object: Attributes
7	.INCLUDE	☐				0	0	Architectural Object: Header
8	AOTYPE	☐	REBDAOTYPE	REBDAOTYPE	CHAR	4	0	Architectural Object Type	TIVBDAROBJTYPE
9	AONR	☐	REBDAONR	REBDAONR	CHAR	13	0	Number of Architectural Object
10	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
11	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
12	PARTSEPARATOR	☐	REBDPARTSEPARATOR	REBDPARTSEPARATOR	CHAR	10	0	AOID Code: Separator
13	PARTAOID	☐	REBDPARTAOID	REBDPARTAOID	CHAR	30	0	AOID Code
14	XAO	☐	REBDXAO	RECAXLDESCRIPTION	CHAR	60	0	Name of Architectural Object
15	AOFUNCTION	☐	REBDAOFUNCTION	REBDAOFUNCTION	CHAR	4	0	Function of Architectural Object	TIVBDARFUNC
16	USAGECOMMON	☐	REBDUSCOMMON	REBDUSCOMMON	CHAR	1	0	Common Usage
17	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
18	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
19	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
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	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
29	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
30	.INCLUDE	☐				0	0	Architectural Object: Detail Data
31	.INCLUDE	☐				0	0	Architectural Object: General Attributes
32	LASTRENO	☐	DRENOV	DATUM	DATS	8	0	Date of last redecoration
33	MEASSTRC	☐	REBDMEASSTRC	REBDMEASSTRC	CHAR	4	0	Measurement Structure	TIVBDMEASSTRC
34	DOORPLT	☐	REBDDOORPLT	REBDDOORPLT	CHAR	15	0	Short description
35	RSAREA	☐	REORRSAREA	REORRSAREA	CHAR	10	0	Reservation Area	TIVORRSAREA
36	.INCLUDE	☐				0	0	Architectural Object: Attributes of Business Entity
37	SINSTBEZ	☐	SINSTBEZ	SINSTBEZ	NUMC	5	0	Maintenance district	TIV16
38	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
39	SLAGEWE	☐	SLAGEWE	SLAGEWE	NUMC	4	0	Business entity location number	TIV10
40	SOBJLAGE	☐	RESOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator: District Location of Object	TIV45
41	.INCLUDE	☐				0	0	Architectural Object: Attributes of Property
42	RGRNART	☐	RGRNART	CHAR2	CHAR	2	0	Usage Type of Property According to Land Use Map	TIVC4
43	RBEPLAN	☐	RBEPLAN	XMBEZ	CHAR	30	0	Development plan
44	DBEPLAN	☐	DBEPLAN	DDAT	DATS	8	0	Date of development plan
45	RNBPLAN	☐	RNBPLAN	RGRNART	CHAR	4	0	Usage type according to development plan	TIVB3
46	XNUTZGRU	☐	XNUTZGRU	XMBEZ	CHAR	30	0	Current usage of property
47	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
48	JUNUTZA	☐	VVJUNUTZA	JANE	CHAR	1	0	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36
49	NZGRZ	☐	NZGRZ	DEC1_2	DEC	3	2	Permitted Usage: Site Occupancy Index
50	NZGFZ	☐	NZGFZ	DEC2_2	DEC	4	2	Permitted Usage: Floor Area Ratio
51	NZBMZ	☐	NZBMZ	DEC3_2	DEC	5	2	Permitted Usage: Construction Dimension Number
52	NTGRZ	☐	NTGRZ	DEC1_2	DEC	3	2	Actual Usage: Site Occupancy Index
53	NTGFZ	☐	NTGFZ	DEC2_2	DEC	4	2	Actual Usage: Floor Area Ratio
54	NTBMZ	☐	NTBMZ	DEC3_2	DEC	5	2	Actual Usage: Construction Dimension Number
55	SGRART	☐	VVSGRART	VVSGRART	NUMC	4	0	Property type	TIV56
56	SGRQAL	☐	VVSGRQAL	VVSGRQAL	NUMC	3	0	Property: Quality of location	TIV57
57	SGRFRM	☐	VVSGRFRM	VVSGRFRM	NUMC	3	0	Property ground type	TIV58
58	SGRGZS	☐	VVSGRGZS	VVSGRGZS	NUMC	3	0	Overall condition of property	TIV59
59	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
60	ZULBAUH	☐	REBDALLOWEDHEIGHT	REBDALLOWEDHEIGHT	INT2	5	0	Allowed Building Height (as Integer)
61	.INCLUDE	☐				0	0	Architectural Object: Attributes of Building
62	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
63	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
64	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
65	JNURJAHR	☐	VVJNURJ	JANE	CHAR	1	0	Indicator: Only regard construction date in terms of years
66	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
67	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
68	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
69	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
70	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
71	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
72	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
73	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
74	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
75	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
76	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
77	RDAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
78	RFAZUST	☐	RECADUMMYN2	NUMC2	NUMC	2	0	Dummy: No Longer Used
79	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
80	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
81	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
82	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
83	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
84	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	TIV37
85	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	TIV37
86	NSTCKLFT	☐	VVNSTCKLFT	NUMC3	NUMC	3	0	Number of highest floor reached by elevator
87	.INCLUDE	☐				0	0
88	.INCLUDE	☐				0	0	Structures for generating change document update programs
89	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

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