VIBDAO SAP table for – Architectural Object

Here we would like to draw your attention to VIBDAO table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIBDAO is a SAP standard transp table used for storing Architectural Object related data in SAP. It comes under the package RE_BD_AO.

SAP VIBDAO table

Table VIBDAO technical data

TableVIBDAO
Data storingArchitectural Object
ModuleRE
Sub ModuleRE-FX-BD
SAP PackageRE_BD_AO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIBDAO Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIBDAO table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Object Number for Architecture Objects (INTRENO)
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Architectural Object: Key
  • AOID : Identification of Architectural Object
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Architectural Object: Attributes
  • .INCLUDE : Architectural Object: Header
  • AOTYPE : Architectural Object Type
    Its data type is CHAR (Character String) with field length 4
  • AONR : Number of Architectural Object
    Its data type is CHAR (Character String) with field length 13
  • VALIDFROM : Date: Object Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Date: Object Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTSEPARATOR : AOID Code: Separator
    Its data type is CHAR (Character String) with field length 10
  • PARTAOID : AOID Code
    Its data type is CHAR (Character String) with field length 30
  • XAO : Name of Architectural Object
    Its data type is CHAR (Character String) with field length 60
  • AOFUNCTION : Function of Architectural Object
    Its data type is CHAR (Character String) with field length 4
  • USAGECOMMON : Common Usage
    Its data type is CHAR (Character String) with field length 1
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Architectural Object: Detail Data
  • .INCLUDE : Architectural Object: General Attributes
  • LASTRENO : Date of last redecoration
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MEASSTRC : Measurement Structure
    Its data type is CHAR (Character String) with field length 4
  • DOORPLT : Short description
    Its data type is CHAR (Character String) with field length 15
  • RSAREA : Reservation Area
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Architectural Object: Attributes of Business Entity
  • SINSTBEZ : Maintenance district
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • SVERKEHR : Transport Connections of Business Entity
    Its data type is CHAR (Character String) with field length 1
  • SLAGEWE : Business entity location number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SOBJLAGE : Indicator: District Location of Object
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Architectural Object: Attributes of Property
  • RGRNART : Usage Type of Property According to Land Use Map
    Its data type is CHAR (Character String) with field length 2
  • RBEPLAN : Development plan
    Its data type is CHAR (Character String) with field length 30
  • DBEPLAN : Date of development plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RNBPLAN : Usage type according to development plan
    Its data type is CHAR (Character String) with field length 4
  • XNUTZGRU : Current usage of property
    Its data type is CHAR (Character String) with field length 30
  • SUNUTZA : Main usage type
    Its data type is CHAR (Character String) with field length 8
  • JUNUTZA : Indicator: Predominant usage type ‘ ‘-ANLKL, ‘X’-TIV36
    Its data type is CHAR (Character String) with field length 1
  • NZGRZ : Permitted Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NZGFZ : Permitted Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NZBMZ : Permitted Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • NTGRZ : Actual Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NTGFZ : Actual Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NTBMZ : Actual Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SGRART : Property type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SGRQAL : Property: Quality of location
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRFRM : Property ground type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRGZS : Overall condition of property
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • JERBBAU : Heritable building right indicator
    Its data type is CHAR (Character String) with field length 1
  • ZULBAUH : Allowed Building Height (as Integer)
  • .INCLUDE : Architectural Object: Attributes of Building
  • RGEBART : Type of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RGEBZUST : General condition of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • YBAUJAHR : ConstYr
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JNURJAHR : Indicator: Only regard construction date in terms of years
    Its data type is CHAR (Character String) with field length 1
  • YMODERN : Year of modernization
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • YAUFBAU : Year of reconstruction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUBEGI : Construction start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUVOR : Date of planning inquiry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVORBES : Date of prior notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANTBAU : Application for building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUGENE : Building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XBAUGENE : Note on building permit
    Its data type is CHAR (Character String) with field length 30
  • DFERTIG : Completion
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DSCHLUSS : Final Inspection
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBEZUGSF : Ready for occupancy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RDAZUST : Dummy: No Longer Used
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RFAZUST : Dummy: No Longer Used
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • JDENKMAL : Protection of Historical Sites
    Its data type is CHAR (Character String) with field length 1
  • DFRDVON : Public funding from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFRDBIS : Public funding to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BANZGE : Number of floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • AUGESCH : Number of basements
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • SSTCKBIS : Uppermost Floor of a Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SLIFTBIS : Elevator to Floor in Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NSTCKLFT : Number of highest floor reached by elevator
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes