SAP VIBDAO Architectural Object Table
Overview
VIBDAO is a standard SAP S/4HANA table that stores Architectural Object data. There are total 77 fields in the VIBDAO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBDAO belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Arch. Object (Master Data of Architectural Object) (RE_BD_AO).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBDAO to other SAP tables and standard CDS views available based on VIBDAO table in S/4HANA 2020.
Techincal Settings of VIBDAO
Below are technical details of the table VIBDAO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBDAO Fields
The following table gives you an overview of the fields available in VIBDAO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Object Number for Architecture Objects (INTRENO) | REBDINTRENOAO | CHAR | 13 | |
| AOID | Identification of Architectural Object | REBDAOID | CHAR | 30 | |
| AOTYPE | Architectural Object Type | REBDAOTYPE | TIVBDAROBJTYPE | CHAR | 4 |
| AONR | Number of Architectural Object | REBDAONR | CHAR | 13 | |
| VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | |
| VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | |
| PARTSEPARATOR | AOID Code: Separator | REBDPARTSEPARATOR | CHAR | 10 | |
| PARTAOID | AOID Code | REBDPARTAOID | CHAR | 30 | |
| XAO | Name of Architectural Object | REBDXAO | CHAR | 60 | |
| AOFUNCTION | Function of Architectural Object | REBDAOFUNCTION | TIVBDARFUNC | CHAR | 4 |
| USAGECOMMON | Common Usage | REBDUSCOMMON | CHAR | 1 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | CHAR | 12 |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | CHAR | 12 |
| LASTRENO | Date of last redecoration | DRENOV | DATS | 8 | |
| MEASSTRC | Measurement Structure | REBDMEASSTRC | TIVBDMEASSTRC | CHAR | 4 |
| DOORPLT | Short description | REBDDOORPLT | CHAR | 15 | |
| RSAREA | Reservation Area | REORRSAREA | TIVORRSAREA | CHAR | 10 |
| SINSTBEZ | Maintenance district | SINSTBEZ | TIV16 | NUMC | 5 |
| SVERKEHR | Transport Connections of Business Entity | SVERKEHR | TIV44 | CHAR | 1 |
| SLAGEWE | Business entity location number | SLAGEWE | TIV10 | NUMC | 4 |
| SOBJLAGE | Indicator: District Location of Object | RESOBJLAGE | TIV45 | NUMC | 2 |
| RGRNART | Usage Type of Property According to Land Use Map | RGRNART | TIVC4 | CHAR | 2 |
| RBEPLAN | Development plan | RBEPLAN | CHAR | 30 | |
| DBEPLAN | Date of development plan | DBEPLAN | DATS | 8 | |
| RNBPLAN | Usage type according to development plan | RNBPLAN | TIVB3 | CHAR | 4 |
| XNUTZGRU | Current usage of property | XNUTZGRU | CHAR | 30 | |
| SUNUTZA | Main usage type | VVSUNART | TIV36 | CHAR | 8 |
| JUNUTZA | Indicator: Predominant usage type ' '-ANLKL 'X'-TIV36 | VVJUNUTZA | CHAR | 1 | |
| NZGRZ | Permitted Usage: Site Occupancy Index | NZGRZ | DEC | 3 | |
| NZGFZ | Permitted Usage: Floor Area Ratio | NZGFZ | DEC | 4 | |
| NZBMZ | Permitted Usage: Construction Dimension Number | NZBMZ | DEC | 5 | |
| NTGRZ | Actual Usage: Site Occupancy Index | NTGRZ | DEC | 3 | |
| NTGFZ | Actual Usage: Floor Area Ratio | NTGFZ | DEC | 4 | |
| NTBMZ | Actual Usage: Construction Dimension Number | NTBMZ | DEC | 5 | |
| SGRART | Property type | VVSGRART | TIV56 | NUMC | 4 |
| SGRQAL | Property: Quality of location | VVSGRQAL | TIV57 | NUMC | 3 |
| SGRFRM | Property ground type | VVSGRFRM | TIV58 | NUMC | 3 |
| SGRGZS | Overall condition of property | VVSGRGZS | TIV59 | NUMC | 3 |
| JERBBAU | Heritable building right indicator | JERBBAU | TDO9 | CHAR | 1 |
| ZULBAUH | Allowed Building Height (as Integer) | REBDALLOWEDHEIGHT | INT2 | 5 | |
| RGEBART | Type of building | RGEBART | TIV5A | NUMC | 2 |
| RGEBZUST | General condition of building | RGEBZUST | TIV83 | NUMC | 2 |
| YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | |
| JNURJAHR | Indicator: Only regard construction date in terms of years | VVJNURJ | CHAR | 1 | |
| YMODERN | Year of modernization | VVYMODERN | DATS | 8 | |
| YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | |
| DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | |
| DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | |
| DVORBES | Date of prior notice | DVORBES | DATS | 8 | |
| DANTBAU | Application for building permit | DANTBAU | DATS | 8 | |
| DBAUGENE | Building permit | DBAUGENE | DATS | 8 | |
| XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | |
| DFERTIG | Completion | DFERTIG | DATS | 8 | |
| DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | |
| DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | |
| RDAZUST | Dummy: No Longer Used | RECADUMMYN2 | NUMC | 2 | |
| RFAZUST | Dummy: No Longer Used | RECADUMMYN2 | NUMC | 2 | |
| JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | |
| DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | |
| DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | |
| BANZGE | Number of floors | VVBANZGE | DEC | 4 | |
| AUGESCH | Number of basements | AUGESCH | DEC | 2 | |
| SSTCKBIS | Uppermost Floor of a Building | VVSTCKBIS | TIV37 | NUMC | 3 |
| SLIFTBIS | Elevator to Floor in Building | VVLIFTBIS | TIV37 | NUMC | 3 |
| NSTCKLFT | Number of highest floor reached by elevator | VVNSTCKLFT | NUMC | 3 | |
| ESTATEDESCR | Location Description of Land Acc. To Land Register | REXCCHPRDESCRIPTION | CHAR | 60 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIBDAO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBDAO | AOFUNCTION | 1: CN | TIVBDARFUNC |
| VIBDAO | AOTYPE | 1: CN | TIVBDAROBJTYPE |
| VIBDAO | JERBBAU | : | TDO9 |
| VIBDAO | MEASSTRC | 1: CN | TIVBDMEASSTRC |
| VIBDAO | RESPONSIBLE | 1: CN | USR02 |
| VIBDAO | RGEBART | C: CN | TIV5A |
| VIBDAO | RGEBZUST | C: CN | TIV83 |
| VIBDAO | RGRNART | 1: CN | TIVC4 |
| VIBDAO | RNBPLAN | 1: CN | TIVB3 |
| VIBDAO | RSAREA | : | TIVORRSAREA |
| VIBDAO | SGRART | C: CN | TIV56 |
| VIBDAO | SGRFRM | C: CN | TIV58 |
| VIBDAO | SGRGZS | C: CN | TIV59 |
| VIBDAO | SGRQAL | C: CN | TIV57 |
| VIBDAO | SINSTBEZ | C: CN | TIV16 |
| VIBDAO | SLAGEWE | C: CN | TIV10 |
| VIBDAO | SLIFTBIS | C: CN | TIV37 |
| VIBDAO | SOBJLAGE | C: CN | TIV45 |
| VIBDAO | SSTCKBIS | C: CN | TIV37 |
| VIBDAO | SUNUTZA | C: CN | TIV36 |
| VIBDAO | SVERKEHR | C: CN | TIV44 |
| VIBDAO | USEREXCLUSIVE | C: CN | USR02 |