SAP VIBDBU Building Table

Overview

VIBDBU is a standard SAP S/4HANA table that stores Building data. There are total 96 fields in the VIBDBU table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIBDBU belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Building (Master Data) (RE_BD_BU).

In addition, following links provide an overview of foreign key relationships, if any, that link VIBDBU to other SAP tables and standard CDS views available based on VIBDBU table in S/4HANA 2020.

Techincal Settings of VIBDBU

Below are technical details of the table VIBDBU

Buffering not allowed
No buffering
Storage type is Column Store

List of VIBDBU Fields

The following table gives you an overview of the fields available in VIBDBU

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
INTRENO	Internal Key of Real Estate Object	RECAINTRENO		CHAR	13
BUKRS	Company Code	BUKRS	T001	CHAR	4
SWENR	Business Entity Number	REBDBENO	*	CHAR	8
SGENR	Number of Building	REBDBUNO		CHAR	8
OBJNR	Object Number	RECAOBJNR	*	CHAR	22
IMKEY	Internal Key of Real Estate Object (FI)	RECAIMKEY		CHAR	8
CREATIONTYPE	How the Object Was Created	RECACREATIONTYPE		CHAR	1
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
AUTHGRP	Authorization Group	RECAAUTHGRP		CHAR	40
VALIDFROM	Date: Object Valid From	REBDOBJVALIDFROM		DATS	8
VALIDTO	Date: Object Valid To	REBDOBJVALIDTO		DATS	8
XGETXT	Description of Building	REBDXBU		CHAR	60
RGEBART	Type of building	RGEBART	TIV5A	NUMC	2
JERBBAU	Heritable building right indicator	JERBBAU	TDO9	CHAR	1
RGEBZUST	General condition of building	RGEBZUST	TIV83	NUMC	2
YBAUJAHR	ConstYr	VVYBAUJAHR		DATS	8
YMODERN	Year of modernization	VVYMODERN		DATS	8
YAUFBAU	Year of reconstruction	VVYAUFBAU		DATS	8
DBAUBEGI	Construction start date	DBAUBEGI		DATS	8
BBAUW13	OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933	BBAUWXOLD		CURR	11
BBAUWX	Building Value	BBAUWX		CURR	15
BBAUWAKT	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933	BBAUWAKTXOLD		CURR	11
BBAUWAKTX	Current Building Value	BBAUWAKTX		CURR	15
BDMCBMRA	Amount per volume unit	BDMCBMRA		CURR	11
DBAUGENE	Building permit	DBAUGENE		DATS	8
XBAUGENE	Note on building permit	XBAUGENE		CHAR	30
DBEZUGSF	Ready for occupancy	DBEZUGSF		DATS	8
DFERTIG	Completion	DFERTIG		DATS	8
DSCHLUSS	Final Inspection	DSCHLUSS		DATS	8
JDENKMAL	Protection of Historical Sites	JDENKMAL		CHAR	1
DBAUVOR	Date of planning inquiry	DBAUVOR		DATS	8
DVORBES	Date of prior notice	DVORBES		DATS	8
DANTBAU	Application for building permit	DANTBAU		DATS	8
BEINHEITW	OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933	BEINHEITWXOLD		CURR	11
BEINHEITWX	Assessed Value of Building	BEINHEITWX		CURR	15
NEINHEITW	Assessed value base year	NEINHEITW		NUMC	4
BVERSWRT	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933	BVERSWRTXOLD		CURR	11
BVERSWRTX	Insurable Value Amount	BVERSWRTX		CURR	15
RVERSWRT	Type of insurance value	RVERSWRT		NUMC	1
DWIRTUB	Transfer usage / charges	VVDWIRTUB		DATS	8
DVERKAUF	Sale date	VVDVERKAUF		DATS	8
DVRKPLAN	Planned sale	VVDVRKPLAN		DATS	8
DNUTZEND	End of usage	VVDNUTZEND		DATS	8
DFRDVON	Public funding from	VVDFRDVON		DATS	8
DFRDBIS	Public funding to	VVDFRDBIS		DATS	8
BANZGE	Number of floors	VVBANZGE		DEC	4
SUNUTZA	Main usage type	VVSUNART	TIV36	CHAR	8
JUNUTZA	OBSOLETE: Main Usage Type	REBDJUNUTZAOBS		CHAR	1
SSTCKBIS	Uppermost Floor of a Building	VVSTCKBIS	*	NUMC	3
SLIFTBIS	Elevator to Floor in Building	VVLIFTBIS	*	NUMC	3
AUGESCH	Number of basements	AUGESCH		DEC	2
JANLHIE	OBSOLETE: Asset Assignment Also Applies for Subord. Building	REBDJANLHIEOBS		CHAR	1
RLRALOC	Location Class	REAJRLRALOC	TIVAJRLRALOC	CHAR	6
USESRLRA	Representative List of Rents Is Used	REAJUSESRLRA		CHAR	1
GEMEINDE	Municipality key	VVGEMEINDE	TIVG1	CHAR	8
REINS	Unit for cubic volume	REINS	T006	UNIT	3
WAERS	Currency Key	WAERS	TCURC	CUKY	5
HASCOP	Uses Current Occupancy Principle	RESCHASCOP		CHAR	1
USGFUNCTION	Function of Object	REBDUSGFUNCTION	TIVBDUSGFUNC	CHAR	4
OBJCOND	Code of Building Status	REXCCHBUCOND	TIVXCCHCOND	NUMC	4
OBJCAT	Building Category Code	REXCCHBUCATEGORY	TIVXCCHKAT	NUMC	4
YEARDECONSTR	Year of Demolition	REXCCHBUDECONYEAR		DATS	8
AREAVALUE	Floor Area of Building in Square Meters	REXCCHBUAREA		DEC	10
HEATINGTYPE	Code of Heating Type	REXCCHBUHEATINGTYPE	TIVXCCHHEAT	NUMC	4
ENERGYHEAT	Energy Carrier of Heating	REXCCHBUENERGYSOURCEH	TIVXCCHGENSRC	NUMC	4
ENERGYWATER	Energy Carrier of Hot Water	REXCCHBUENERGYSOURCEW	TIVXCCHGENSRC	NUMC	4
HOTWATERSUPPLY	Central Hot Water Supply	REXCCHBUHOTWATER		CHAR	1
POWERCONSUM	Power Consumption of Building (in kWh)	REXCCHBUPOWERCONSUMPTION		DEC	10
GLAZING	Glazing Type	REXCCHBUGLAZING		CHAR	15
ADMINNO	Administrative Building Number	REXCCHBUADMINNO		CHAR	12
ADMINXGETXT	Building Name	REXCCHBUADMINXBU		CHAR	60
GEMEINDECH	Land Register District	RELMLRDISTRICT		CHAR	6
BANZGECH	Number of floors	VVBANZGE		DEC	4
SSTCKBISCH	Uppermost Floor of a Building	VVSTCKBIS	*	NUMC	3
SLIFTBISCH	Elevator to Floor in Building	VVLIFTBIS	*	NUMC	3
AUGESCHCH	Number of basements	AUGESCH		DEC	2
SECCO	Section Code	SECCO		CHAR	4
BUPLA	Business Place	BUPLA	*	CHAR	4
REPKOCH	Kind of Change	REXCJPREPKOCH		CHAR	1
BDCONSTR	Construction Status	REXCJPBDCONSTR		CHAR	1
BDFIREPREV	Fire Fighting Method Number	REXCJPBDFIREPREV		CHAR	8
BDOTHOW	Number of Another Owners in the Same Building	REXCJPBDOTHOW		INT4	10
BDOWNSHIP	Building Ownership Status	REXCJPBDOWNSHIP		CHAR	1
KOCHDATE	Date of Change in Kind of Change	REXCJPKOCHDATE		DATS	8
VPT	Property Taxable Value	REXCPTVPT_NOSIGN		CURR	15
CURRENCY	Currency Key	WAERS	TCURC	CUKY	5

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 VIBDBU

Table Name	Field	Cardinality	Check Table
VIBDBU	BUKRS	1: CN	T001
VIBDBU	CONDK	:	TIVXCPTRACONS
VIBDBU	CURRENCY	:	TCURC
VIBDBU	ENERGYHEAT	:	TIVXCCHGENSRC
VIBDBU	ENERGYWATER	:	TIVXCCHGENSRC
VIBDBU	GEMEINDE	C: CN	TIVG1
VIBDBU	HEATINGTYPE	:	TIVXCCHHEAT
VIBDBU	JERBBAU	1: CN	TDO9
VIBDBU	OBJCAT	:	TIVXCCHKAT
VIBDBU	OBJCOND	:	TIVXCCHCOND
VIBDBU	OBJNR	1: CN	*
VIBDBU	REINS	C: CN	T006
VIBDBU	RESPONSIBLE	1: CN	USR02
VIBDBU	RGEBART	C: CN	TIV5A
VIBDBU	RGEBZUST	C: CN	TIV83
VIBDBU	RLRALOC	C: CN	TIVAJRLRALOC
VIBDBU	SUNUTZA	C: CN	TIV36
VIBDBU	USEREXCLUSIVE	C: CN	USR02
VIBDBU	USGFUNCTION	C: CN	TIVBDUSGFUNC
VIBDBU	WAERS	C: CN	TCURC

SAP VIBDBU Building Table

Overview

Techincal Settings of VIBDBU

List of VIBDBU Fields

Foreign Key Relationships

Other References