1. Home
  2. Resources
  3. SAP Tables
  4. VIBDAO - Architectural Object

SAP Table VIBDAO

Architectural Object

VIBDAO (Architectural Object) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VIBDAO to other SAP tables.

VIBDAO table fields

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

VIBDAO foreign key relationships

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