VIBDAO

Architectural Object | #masterdata | Component: Basic Data
Column Name Description
MANDT Client
INTRENO Internal Object Number for Architecture Objects (INTRENO)
Column Name Description
Column Name Description
Column Name Description
VALIDFROM Date: Object Valid From
VALIDTO Date: Object Valid To
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
LASTRENO Date of last redecoration
DBEPLAN Date of development plan
YBAUJAHR ConstYr
YMODERN Year of modernization
YAUFBAU Year of reconstruction
DBAUBEGI Construction start date
DBAUVOR Date of planning inquiry
DVORBES Date of prior notice
DANTBAU Application for building permit
DBAUGENE Building permit
DFERTIG Completion
DSCHLUSS Final Inspection
DBEZUGSF Ready for occupancy
DFRDVON Public funding from
DFRDBIS Public funding to
Column Name Description
USAGECOMMON Common Usage Show values
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 Show values
JNURJAHR Indicator: Only regard construction date in terms of years Show values
JDENKMAL Protection of Historical Sites Show values
Column Name Description Domain name
AOID Identification of Architectural Object REBDAOID
AONR Number of Architectural Object REBDAONR
PARTSEPARATOR AOID Code: Separator REBDPARTSEPARATOR
PARTAOID AOID Code REBDPARTAOID
XAO Name of Architectural Object RECAXLDESCRIPTION
OBJNR Object Number J_OBJNR
AUTHGRP Authorization Group RECAAUTHGRP
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
DOORPLT Short description REBDDOORPLT
RBEPLAN Development plan XMBEZ
XNUTZGRU Current usage of property XMBEZ
NZGRZ Permitted Usage: Site Occupancy Index DEC1_2
NZGFZ Permitted Usage: Floor Area Ratio DEC2_2
NZBMZ Permitted Usage: Construction Dimension Number DEC3_2
NTGRZ Actual Usage: Site Occupancy Index DEC1_2
NTGFZ Actual Usage: Floor Area Ratio DEC2_2
NTBMZ Actual Usage: Construction Dimension Number DEC3_2
ZULBAUH Allowed Building Height (as Integer) REBDALLOWEDHEIGHT
XBAUGENE Note on building permit XMBEZ
RDAZUST Dummy: No Longer Used NUMC2
RFAZUST Dummy: No Longer Used NUMC2
BANZGE Number of floors DEC3_1
AUGESCH Number of basements DEC2
NSTCKLFT Number of highest floor reached by elevator NUMC3
ESTATEDESCR Location Description of Land Acc. To Land Register RECAXLDESCRIPTION
Master Data Relations | to Other Relations ↓ Join Conditions
Function of Architectural Object
  • Architectural Object Type
  • Function of Architectural Object
  • Client
Architectural Object Type
  • Architectural Object Type
  • Client
Heritable building right indicator
  • VIBDAO.MANDT == TDO9.MANDT
  • VIBDAO.JERBBAU == TDO9.SOBJERBBAU
Measurement Structure
  • Measurement Structure
  • Client
Person Responsible
  • VIBDAO.MANDT == USR02.MANDT
  • VIBDAO.RESPONSIBLE == USR02.BNAME
Type of building
  • VIBDAO.MANDT == TIV5A.MANDT
  • VIBDAO.RGEBART == TIV5A.SOBJART
General condition of building
  • VIBDAO.MANDT == TIV83.MANDT
  • VIBDAO.RGEBZUST == TIV83.RZUSTAND
Usage Type of Property According to Land Use Map
  • VIBDAO.MANDT == TIVC4.MANDT
  • VIBDAO.RGRNART == TIVC4.RGRNART
Usage type according to development plan
  • VIBDAO.MANDT == TIVB3.MANDT
  • VIBDAO.RNBPLAN == TIVB3.RNBPLAN
Reservation Area
Property type
  • VIBDAO.MANDT == TIV56.MANDT
  • VIBDAO.SGRART == TIV56.SGRART
Property ground type
  • VIBDAO.MANDT == TIV58.MANDT
  • VIBDAO.SGRFRM == TIV58.SGRFRM
Overall condition of property
  • VIBDAO.MANDT == TIV59.MANDT
  • VIBDAO.SGRGZS == TIV59.SGRGZS
Property: Quality of location
  • VIBDAO.MANDT == TIV57.MANDT
  • VIBDAO.SGRQAL == TIV57.SGRQAL
Elevator to Floor in Building
  • VIBDAO.MANDT == TIV37.MANDT
  • VIBDAO.SLIFTBIS == TIV37.SSTOCKW
Indicator: District Location of Object
  • VIBDAO.MANDT == TIV45.MANDT
  • VIBDAO.SOBJLAGE == TIV45.SOBJLAGE
Uppermost Floor of a Building
  • VIBDAO.MANDT == TIV37.MANDT
  • VIBDAO.SSTCKBIS == TIV37.SSTOCKW
Main usage type
  • VIBDAO.MANDT == TIV36.MANDT
  • VIBDAO.SUNUTZA == TIV36.SUNART
Transport Connections of Business Entity
  • Transport Connections of Business Entity
  • Client
  • VIBDAO.SVERKEHR == TIV44.SVERKEHR
  • VIBDAO.MANDT == TIV44.MANDT
User with Exclusive Change Authorization
  • VIBDAO.MANDT == USR02.MANDT
  • VIBDAO.USEREXCLUSIVE == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Maintenance district
  • VIBDAO.MANDT == TIV16.MANDT
  • VIBDAO.SINSTBEZ == TIV16.SINSTBEZ
Business entity location number
  • VIBDAO.MANDT == TIV10.MANDT
  • VIBDAO.SLAGEWE == TIV10.SLAGEWE