VIBDBU

Building | #masterdata | Component: Basic Data
Column Name Description
MANDT Client
INTRENO Internal Key of Real Estate Object
Column Name Description
πŸ’² Currency Key (WAERS):
BBAUW13 OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
BBAUWX Building Value
BBAUWAKT OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
BBAUWAKTX Current Building Value
BDMCBMRA Amount per volume unit
BEINHEITW OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
BEINHEITWX Assessed Value of Building
BVERSWRT OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
BVERSWRTX Insurable Value Amount
πŸ’² Currency Key (CURRENCY):
VPT Property Taxable Value
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
VALIDFROM Date: Object Valid From
VALIDTO Date: Object Valid To
YBAUJAHR ConstYr
YMODERN Year of modernization
YAUFBAU Year of reconstruction
DBAUBEGI Construction start date
DBAUGENE Building permit
DBEZUGSF Ready for occupancy
DFERTIG Completion
DSCHLUSS Final Inspection
DBAUVOR Date of planning inquiry
DVORBES Date of prior notice
DANTBAU Application for building permit
DWIRTUB Transfer usage / charges
DVERKAUF Sale date
DVRKPLAN Planned sale
DNUTZEND End of usage
DFRDVON Public funding from
DFRDBIS Public funding to
YEARDECONSTR Year of Demolition
KOCHDATE Date of Change in Kind of Change
Column Name Description
CREATIONTYPE How the Object Was Created Show values
JDENKMAL Protection of Historical Sites Show values
RVERSWRT Type of insurance value Show values
USESRLRA Representative List of Rents Is Used Show values
HASCOP Uses Current Occupancy Principle Show values
HOTWATERSUPPLY Central Hot Water Supply Show values
REPKOCH Kind of Change Show values
BDCONSTR Construction Status Show values
BDOWNSHIP Building Ownership Status Show values
Column Name Description Domain name
SWENR Business Entity Number REBDBENO
SGENR Number of Building REBDBUNO
IMKEY Internal Key of Real Estate Object (FI) IMKEY
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
AUTHGRP Authorization Group RECAAUTHGRP
XGETXT Description of Building RECAXLDESCRIPTION
XBAUGENE Note on building permit XMBEZ
NEINHEITW Assessed value base year GJAHR
BANZGE Number of floors DEC3_1
JUNUTZA OBSOLETE: Main Usage Type CHAR1
SSTCKBIS Uppermost Floor of a Building VVSSTOCKW
SLIFTBIS Elevator to Floor in Building VVSSTOCKW
AUGESCH Number of basements DEC2
JANLHIE OBSOLETE: Asset Assignment Also Applies for Subord. Building CHAR1
AREAVALUE Floor Area of Building in Square Meters REXCCHGWRFORMATUNITFIELD
POWERCONSUM Power Consumption of Building (in kWh) REXCCHGWRFORMATUNITFIELD
GLAZING Glazing Type TEXT15
ADMINNO Administrative Building Number REXCCHBUADMINNO
ADMINXGETXT Building Name RECAXLDESCRIPTION
GEMEINDECH Land Register District RELMLRDISTRICT
BANZGECH Number of floors DEC3_1
SSTCKBISCH Uppermost Floor of a Building VVSSTOCKW
SLIFTBISCH Elevator to Floor in Building VVSSTOCKW
AUGESCHCH Number of basements DEC2
SECCO Section Code SECCO
BUPLA Business Place J_1BBRANCH
BDFIREPREV Fire Fighting Method Number CHAR8
BDOTHOW Number of Another Owners in the Same Building INT4
Master Data Relations Join Conditions
Company Code
  • VIBDBU.MANDT == T001.MANDT
  • VIBDBU.BUKRS == T001.BUKRS
Conservation Level
  • Conservation Level
  • Client
Currency Key
  • VIBDBU.MANDT == TCURC.MANDT
  • VIBDBU.CURRENCY == TCURC.WAERS
Energy Carrier of Heating
Energy Carrier of Hot Water
Municipality key
  • VIBDBU.MANDT == TIVG1.MANDT
  • VIBDBU.GEMEINDE == TIVG1.GEMEINDE
Code of Heating Type
  • Code of Heating Type
  • Client
Heritable building right indicator
  • VIBDBU.MANDT == TDO9.MANDT
  • VIBDBU.JERBBAU == TDO9.SOBJERBBAU
Building Category Code
Code of Building Status
Unit for cubic volume
  • VIBDBU.MANDT == T006.MANDT
  • VIBDBU.REINS == T006.MSEHI
Person Responsible
  • VIBDBU.MANDT == USR02.MANDT
  • VIBDBU.RESPONSIBLE == USR02.BNAME
Type of building
  • VIBDBU.MANDT == TIV5A.MANDT
  • VIBDBU.RGEBART == TIV5A.SOBJART
Building Condition
  • VIBDBU.MANDT == TIV83.MANDT
  • VIBDBU.RGEBZUST == TIV83.RZUSTAND
Location Class
  • ?
  • Location Class
Main Usage Type
  • VIBDBU.MANDT == TIV36.MANDT
  • VIBDBU.SUNUTZA == TIV36.SUNART
User with Exclusive Change Authorization
  • VIBDBU.MANDT == USR02.MANDT
  • VIBDBU.USEREXCLUSIVE == USR02.BNAME
Function of Object
  • ?
  • Function of Object
Currency Key
  • VIBDBU.MANDT == TCURC.MANDT
  • VIBDBU.WAERS == TCURC.WAERS