SAP TABLES | Real Estate Management | Flexible Real Estate Management | Basic Data(RE-FX-BD) SAP RE

VIBDBU SAP Building Table and data







VIBDBU is a standard SAP Table which is used to store Building data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VIBDBU Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VIBDBU Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
INTRENORECAINTRENOCHAR13 Internal Key of Real Estate Object
.INCLUDEVIBDBU_KEY Building: Key Fields
BUKRSBUKRSCHAR4 T001Company Code
SGENRREBDBUNOCHAR8 Number of BuildingSGENR
.INCLUDEVIBDBU_TAB Building: Non-Key Fields
OBJNRRECAOBJNRCHAR22
*
Object Number
IMKEYRECAIMKEYCHAR8 Internal Key of Real Estate Object (FI)IMKEY
CREATIONTYPERECACREATIONTYPECHAR1 How the Object Was Created
.INCLUDERUSER Field String for Maintenance of User Data
RERFRERFCHAR12 Entered by
DERFDERFDATS8 First Entered on
TERFTERFTIMS6 Time of Initial Entry
REHERREHERCHAR10 Source of initial entry
RBEARRBEARCHAR12 Employee ID
DBEARDBEARDATS8 Last Edited on
TBEARTBEARTIMS6 Last Edited at
RBHERRBHERCHAR10 Editing Source
RESPONSIBLERECARESPONSIBLECHAR12 USR02Person Responsible
USEREXCLUSIVERECAUSEREXCLUSIVECHAR12 USR02User with Exclusive Change Authorization
AUTHGRPRECAAUTHGRPCHAR40 Authorization Group
VALIDFROMREBDOBJVALIDFROMDATS8 Date: Object Valid From
VALIDTOREBDOBJVALIDTODATS8 Date: Object Valid ToREDAT
XGETXTREBDXBUCHAR60 Description of Building
RGEBARTRGEBARTNUMC2 TIV5AType of building
JERBBAUJERBBAUCHAR1 TDO9Heritable building right indicator
RGEBZUSTRGEBZUSTNUMC2 TIV83General condition of building
YBAUJAHRVVYBAUJAHRDATS8 ConstYr
YMODERNVVYMODERNDATS8 Year of modernization



YAUFBAUVVYAUFBAUDATS8 Year of reconstruction
DBAUBEGIDBAUBEGIDATS8 Construction start date
BBAUW13BBAUWXOLDCURR11(2) OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
BBAUWXBBAUWXCURR15(2) Building Value
BBAUWAKTBBAUWAKTXOLDCURR11(2) OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
BBAUWAKTXBBAUWAKTXCURR15(2) Current Building Value
BDMCBMRABDMCBMRACURR11(2) Amount per volume unit
DBAUGENEDBAUGENEDATS8 Building permit
XBAUGENEXBAUGENECHAR30 Note on building permit
DBEZUGSFDBEZUGSFDATS8 Ready for occupancy
DFERTIGDFERTIGDATS8 Completion
DSCHLUSSDSCHLUSSDATS8 Final Inspection
JDENKMALJDENKMALCHAR1 Protection of Historical Sites
DBAUVORDBAUVORDATS8 Date of planning inquiry
DVORBESDVORBESDATS8 Date of prior notice
DANTBAUDANTBAUDATS8 Application for building permit
BEINHEITWBEINHEITWXOLDCURR11(2) OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
BEINHEITWXBEINHEITWXCURR15(2) Assessed Value of Building
NEINHEITWNEINHEITWNUMC4 Assessed value base yearGJAHR
BVERSWRTBVERSWRTXOLDCURR11(2) OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
BVERSWRTXBVERSWRTXCURR15(2) Insurable Value Amount
RVERSWRTRVERSWRTNUMC1 Type of insurance value
DWIRTUBVVDWIRTUBDATS8 Transfer usage / charges
DVERKAUFVVDVERKAUFDATS8 Sale date
DVRKPLANVVDVRKPLANDATS8 Planned sale
DNUTZENDVVDNUTZENDDATS8 End of usage
DFRDVONVVDFRDVONDATS8 Public funding from
DFRDBISVVDFRDBISDATS8 Public funding to
BANZGEVVBANZGEDEC4(1) Number of floors
SUNUTZAVVSUNARTCHAR8 TIV36Main usage type
JUNUTZAREBDJUNUTZAOBSCHAR1 OBSOLETE: Main Usage Type
SSTCKBISVVSTCKBISNUMC3
*
Uppermost Floor of a Building
SLIFTBISVVLIFTBISNUMC3
*
Elevator to Floor in Building
AUGESCHAUGESCHDEC2 Number of basements
JANLHIEREBDJANLHIEOBSCHAR1 OBSOLETE: Asset Assignment Also Applies for Subord. Building
RLRALOCREAJRLRALOCCHAR6 TIVAJRLRALOCLocation ClassALPHA
USESRLRAREAJUSESRLRACHAR1 Representative List of Rents Is Used
GEMEINDEVVGEMEINDECHAR8 TIVG1Municipality key
REINSREINSUNIT3 T006Unit for cubic volumeCUNIT
WAERSWAERSCUKY5 TCURCCurrency Key
HASCOPRESCHASCOPCHAR1 Uses Current Occupancy Principle
USGFUNCTIONREBDUSGFUNCTIONCHAR4 TIVBDUSGFUNCFunction of ObjectALPHA
.APPENDREXC_CH_VIBDBU_APP Country specific fields (CI) for Switzerland - BU
.INCLUDEREXC_CH_BOBJECT Building Customer fields
OBJCONDREXCCHBUCONDNUMC4 TIVXCCHCONDCode of Building Status
OBJCATREXCCHBUCATEGORYNUMC4 TIVXCCHKATBuilding Category Code
YEARDECONSTRREXCCHBUDECONYEARDATS8 Year of Demolition
AREAVALUEREXCCHBUAREADEC10(2) Floor Area of Building in Square Meters
HEATINGTYPEREXCCHBUHEATINGTYPENUMC4 TIVXCCHHEATCode of Heating Type





ENERGYHEATREXCCHBUENERGYSOURCEHNUMC4 TIVXCCHGENSRCEnergy Carrier of Heating
ENERGYWATERREXCCHBUENERGYSOURCEWNUMC4 TIVXCCHGENSRCEnergy Carrier of Hot Water
HOTWATERSUPPLYREXCCHBUHOTWATERCHAR1 Central Hot Water Supply
POWERCONSUMREXCCHBUPOWERCONSUMPTIONDEC10(2) Power Consumption of Building (in kWh)
GLAZINGREXCCHBUGLAZINGCHAR15 Glazing Type
ADMINNOREXCCHBUADMINNOCHAR12 Administrative Building NumberALPHA
ADMINXGETXTREXCCHBUADMINXBUCHAR60 Building Name
GEMEINDECHRELMLRDISTRICTCHAR6
*
Land Register District
BANZGECHVVBANZGEDEC4(1) Number of floors
SSTCKBISCHVVSTCKBISNUMC3
*
Uppermost Floor of a Building
SLIFTBISCHVVLIFTBISNUMC3
*
Elevator to Floor in Building
AUGESCHCHAUGESCHDEC2 Number of basements
.APPENDREXC_IN_VIBDBU_APP Country specific fields for India - BU
SECCOSECCOCHAR4
*
Section Code
BUPLABUPLACHAR4
*
Business Place
.APPENDREXC_JP_VIBDBU_APP Localization Japan: Additional fields Building
.INCLUDEREXCJPBDBU Country Specific Fields for Japan
REPKOCHREXCJPREPKOCHCHAR1 Kind of Change
BDCONSTRREXCJPBDCONSTRCHAR1 Construction Status
BDFIREPREVREXCJPBDFIREPREVCHAR8 Fire Fighting Method Number
BDOTHOWREXCJPBDOTHOWINT410 Number of Another Owners in the Same Building
BDOWNSHIPREXCJPBDOWNSHIPCHAR1 Building Ownership Status
KOCHDATEREXCJPKOCHDATEDATS8 Date of Change in Kind of Change
.APPENDREXC_PT_VIBDBU_APP Country-Specific fields for Portugal - Building
.INCLUDEREXCPTBDBU Country-Specific Fields for Portugal - Building
VPTREXCPTVPT_NOSIGNCURR15(2) Property Taxable Value
CURRENCYWAERSCUKY5 TCURCCurrency Key
CONDKREXCPTRACONSCHAR4 TIVXCPTRACONSConservation Level



Key field
Non-key field