SAP table VIBDAO (Architectural Object)

SAP table VIBDAO has 2 primary key fields being MANDT,INTRENO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
INTRENO Internal Object Number for Architecture Objects (INTRENO) CHAR 13 0 REBDINTRENOAO
AOID Identification of Architectural Object CHAR 30 0 REBDAOID
AOTYPE Architectural Object Type CHAR 4 0 TIVBDAROBJTYPE REBDAOTYPE
AONR Number of Architectural Object CHAR 13 0 REBDAONR
VALIDFROM Date: Object Valid From DATS 8 0 REBDOBJVALIDFROM
VALIDTO Date: Object Valid To DATS 8 0 REBDOBJVALIDTO
PARTSEPARATOR AOID Code: Separator CHAR 10 0 REBDPARTSEPARATOR
PARTAOID AOID Code CHAR 30 0 REBDPARTAOID
XAO Name of Architectural Object CHAR 60 0 REBDXAO
AOFUNCTION Function of Architectural Object CHAR 4 0 TIVBDARFUNC REBDAOFUNCTION
USAGECOMMON Common Usage CHAR 1 0 REBDUSCOMMON
Exclusive use of object
1 Common usage of object allowed
2 Only common usage of object allowed
OBJNR Object Number CHAR 22 0 * RECAOBJNR
AUTHGRP Authorization Group CHAR 40 0 RECAAUTHGRP
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
RESPONSIBLE Person Responsible CHAR 12 0 USR02 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 USR02 RECAUSEREXCLUSIVE
LASTRENO Date of last redecoration DATS 8 0 DRENOV
MEASSTRC Measurement Structure CHAR 4 0 TIVBDMEASSTRC REBDMEASSTRC
DOORPLT Short description CHAR 15 0 REBDDOORPLT
RSAREA Reservation Area CHAR 10 0 TIVORRSAREA REORRSAREA
SINSTBEZ Maintenance district NUMC 5 0 TIV16 SINSTBEZ
SVERKEHR Transport Connections of Business Entity CHAR 1 0 TIV44 SVERKEHR
SLAGEWE Business entity location number NUMC 4 0 TIV10 SLAGEWE
SOBJLAGE Indicator: District Location of Object NUMC 2 0 TIV45 RESOBJLAGE
RGRNART Usage Type of Property According to Land Use Map CHAR 2 0 TIVC4 RGRNART
RBEPLAN Development plan CHAR 30 0 RBEPLAN
DBEPLAN Date of development plan DATS 8 0 DBEPLAN
RNBPLAN Usage type according to development plan CHAR 4 0 TIVB3 RNBPLAN
XNUTZGRU Current usage of property CHAR 30 0 XNUTZGRU
SUNUTZA Main usage type CHAR 8 0 TIV36 VVSUNART
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 CHAR 1 0 VVJUNUTZA
NZGRZ Permitted Usage: Site Occupancy Index DEC 3 2 NZGRZ
NZGFZ Permitted Usage: Floor Area Ratio DEC 4 2 NZGFZ
NZBMZ Permitted Usage: Construction Dimension Number DEC 5 2 NZBMZ
NTGRZ Actual Usage: Site Occupancy Index DEC 3 2 NTGRZ
NTGFZ Actual Usage: Floor Area Ratio DEC 4 2 NTGFZ
NTBMZ Actual Usage: Construction Dimension Number DEC 5 2 NTBMZ
SGRART Property type NUMC 4 0 TIV56 VVSGRART
SGRQAL Property: Quality of location NUMC 3 0 TIV57 VVSGRQAL
SGRFRM Property ground type NUMC 3 0 TIV58 VVSGRFRM
SGRGZS Overall condition of property NUMC 3 0 TIV59 VVSGRGZS
JERBBAU Heritable building right indicator CHAR 1 0 TDO9 JERBBAU
ZULBAUH Allowed Building Height (as Integer) INT2 5 0 REBDALLOWEDHEIGHT
RGEBART Type of building NUMC 2 0 TIV5A RGEBART
RGEBZUST General condition of building NUMC 2 0 TIV83 RGEBZUST
YBAUJAHR ConstYr DATS 8 0 VVYBAUJAHR
JNURJAHR Indicator: Only regard construction date in terms of years CHAR 1 0 VVJNURJ
YMODERN Year of modernization DATS 8 0 VVYMODERN
YAUFBAU Year of reconstruction DATS 8 0 VVYAUFBAU
DBAUBEGI Construction start date DATS 8 0 DBAUBEGI
DBAUVOR Date of planning inquiry DATS 8 0 DBAUVOR
DVORBES Date of prior notice DATS 8 0 DVORBES
DANTBAU Application for building permit DATS 8 0 DANTBAU
DBAUGENE Building permit DATS 8 0 DBAUGENE
XBAUGENE Note on building permit CHAR 30 0 XBAUGENE
DFERTIG Completion DATS 8 0 DFERTIG
DSCHLUSS Final Inspection DATS 8 0 DSCHLUSS
DBEZUGSF Ready for occupancy DATS 8 0 DBEZUGSF
RDAZUST Dummy: No Longer Used NUMC 2 0 RECADUMMYN2
RFAZUST Dummy: No Longer Used NUMC 2 0 RECADUMMYN2
JDENKMAL Protection of Historical Sites CHAR 1 0 JDENKMAL
DFRDVON Public funding from DATS 8 0 VVDFRDVON
DFRDBIS Public funding to DATS 8 0 VVDFRDBIS
BANZGE Number of floors DEC 4 1 VVBANZGE
AUGESCH Number of basements DEC 2 0 AUGESCH
SSTCKBIS Uppermost Floor of a Building NUMC 3 0 TIV37 VVSTCKBIS
SLIFTBIS Elevator to Floor in Building NUMC 3 0 TIV37 VVLIFTBIS
NSTCKLFT Number of highest floor reached by elevator NUMC 3 0 VVNSTCKLFT
ESTATEDESCR Location Description of Land Acc. To Land Register CHAR 60 0 REXCCHPRDESCRIPTION

VIBDAO foreign key relationships

Table Field Check Table Check Field
0 VIBDAO AOFUNCTION TIVBDARFUNC Function per Arch. Object Type AOTYPE
0 VIBDAO AOFUNCTION TIVBDARFUNC Function per Arch. Object Type AOFUNCTION
1 VIBDAO AOTYPE TIVBDAROBJTYPE Architectural Object Type MANDT
1 VIBDAO AOTYPE TIVBDAROBJTYPE Architectural Object Type AOTYPE
0 VIBDAO JERBBAU TDO9 Heritable Building Right Indicator for Collateral Objects MANDT
0 VIBDAO JERBBAU TDO9 Heritable Building Right Indicator for Collateral Objects SOBJERBBAU
1 VIBDAO MEASSTRC TIVBDMEASSTRC Measurement Structure MANDT
1 VIBDAO MEASSTRC TIVBDMEASSTRC Measurement Structure MEASSTRC
0 VIBDAO RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
1 VIBDAO RGEBART TIV5A Classification of real estate objects MANDT
1 VIBDAO RGEBART TIV5A Classification of real estate objects SOBJART
0 VIBDAO RGEBZUST TIV83 Condition of a real estate object MANDT
1 VIBDAO RGRNART TIVC4 Usage Type acc. to Area Usage Plan MANDT
0 VIBDAO RNBPLAN TIVB3 Usage Types acc. to Development plan RNBPLAN
1 VIBDAO RSAREA TIVORRSAREA Reservation Area RSAREA
0 VIBDAO SGRART TIV56 Property types MANDT
1 VIBDAO SGRFRM TIV58 Property ground type MANDT
0 VIBDAO SGRGZS TIV59 Overall condition of property MANDT
1 VIBDAO SGRQAL TIV57 Quality of property location MANDT
0 VIBDAO SINSTBEZ TIV16 Maintenance district SINSTBEZ
1 VIBDAO SLAGEWE TIV10 Bus. entity location MANDT
0 VIBDAO SOBJLAGE TIV45 District Location MANDT
0 VIBDAO SOBJLAGE TIV45 District Location SOBJLAGE
1 VIBDAO SUNUTZA TIV36 Main Usage Types MANDT
0 VIBDAO SVERKEHR TIV44 Transport connections MANDT
0 VIBDAO SVERKEHR TIV44 Transport connections SVERKEHR
1 VIBDAO USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME