VIBDBU - Building

Building information is stored in SAP table VIBDBU.
It is part of development package RE_BD_BU in software component RE-FX-BD. This development package consists of objects that can be grouped under "RE: Building (Master Data)".

Fields for table VIBDBU

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	*
INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	13
.INCLUDE	KEY			VIBDBU_KEY	0
BUKRS	Company Code		BUKRS	CHAR	4	T001
SWENR	Business Entity Number		REBDBENO	CHAR	8	*
SGENR	Number of Building		REBDBUNO	CHAR	8
.INCLUDE	TAB			VIBDBU_TAB	0
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
.INCLUDE	RUSER			RUSER	0
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	CHAR	12	USR02
USEREXCLUSIVE	User with Exclusive Change Authorization		RECAUSEREXCLUSIVE	CHAR	12	USR02
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	NUMC	2	TIV5A
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	1	TDO9
RGEBZUST	General condition of building		RGEBZUST	NUMC	2	TIV83
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	6
BBAUWX	Building Value		BBAUWX	CURR	8
BBAUWAKT	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933		BBAUWAKTXOLD	CURR	6
BBAUWAKTX	Current Building Value		BBAUWAKTX	CURR	8
BDMCBMRA	Amount per volume unit		BDMCBMRA	CURR	6
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	6
BEINHEITWX	Assessed Value of Building		BEINHEITWX	CURR	8
NEINHEITW	Assessed value base year		NEINHEITW	NUMC	4
BVERSWRT	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933		BVERSWRTXOLD	CURR	6
BVERSWRTX	Insurable Value Amount		BVERSWRTX	CURR	8
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	3
SUNUTZA	Main usage type		VVSUNART	CHAR	8	TIV36
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	CHAR	6	TIVAJRLRALOC
USESRLRA	Representative List of Rents Is Used		REAJUSESRLRA	CHAR	1
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	8	TIVG1
REINS	Unit for cubic volume		REINS	UNIT	3	T006
WAERS	Currency Key		WAERS	CUKY	5	TCURC
HASCOP	Uses Current Occupancy Principle		RESCHASCOP	CHAR	1
USGFUNCTION	Function of Object		REBDUSGFUNCTION	CHAR	4	TIVBDUSGFUNC
.INCLUDE	CI_VIBDBU			CI_VIBDBU	0
.INCLU--AP				REXC_CH_VIBDBU_APP	0
.INCLUDE	REXC_CH_VIBDBU			REXC_CH_BOBJECT	0
OBJCOND	Code of Building Status		REXCCHBUCOND	NUMC	4	TIVXCCHCOND
OBJCAT	Building Category Code		REXCCHBUCATEGORY	NUMC	4	TIVXCCHKAT
YEARDECONSTR	Year of Demolition		REXCCHBUDECONYEAR	DATS	8
AREAVALUE	Floor Area of Building in Square Meters		REXCCHBUAREA	DEC	6
HEATINGTYPE	Code of Heating Type		REXCCHBUHEATINGTYPE	NUMC	4	TIVXCCHHEAT
ENERGYHEAT	Energy Carrier of Heating		REXCCHBUENERGYSOURCEH	NUMC	4	TIVXCCHGENSRC
ENERGYWATER	Energy Carrier of Hot Water		REXCCHBUENERGYSOURCEW	NUMC	4	TIVXCCHGENSRC
HOTWATERSUPPLY	Central Hot Water Supply		REXCCHBUHOTWATER	CHAR	1
POWERCONSUM	Power Consumption of Building (in kWh)		REXCCHBUPOWERCONSUMPTION	DEC	6
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	3
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
.INCLU--AP				REXC_IN_VIBDBU_APP	0
SECCO	Section Code		SECCO	CHAR	4	*
BUPLA	Business Place		BUPLA	CHAR	4	*
.INCLU--AP				REXC_JP_VIBDBU_APP	0
.INCLUDE	REXCJPBDBU			REXCJPBDBU	0
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	4
BDOWNSHIP	Building Ownership Status		REXCJPBDOWNSHIP	CHAR	1
KOCHDATE	Date of Change in Kind of Change		REXCJPKOCHDATE	DATS	8
.INCLU--AP				REXC_PT_VIBDBU_APP	0
.INCLUDE				REXCPTBDBU	0
VPT	Property Taxable Value		REXCPTVPT_NOSIGN	CURR	8
CURRENCY	Currency Key		WAERS	CUKY	5	TCURC
CONDK	Conservation Level		REXCPTRACONS	CHAR	4	TIVXCPTRACONS