VIBDPR - Land

Land information is stored in SAP table VIBDPR.
It is part of development package RE_BD_PR in software component RE-FX-BD. This development package consists of objects that can be grouped under "RE: Property Master Data".

Fields for table VIBDPR

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			VIBDPR_KEY	0
BUKRS	Company Code		BUKRS	CHAR	4	T001
SWENR	Business Entity Number		REBDBENO	CHAR	8	*
SGRNR	Number of Land		REBDPRNO	CHAR	8
.INCLUDE	TAB			VIBDPR_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
XGRTXT	Name of Land		REBDXPR	CHAR	60
RGRNART	Usage Type of Property According to Land Use Map		RGRNART	CHAR	2	TIVC4
BDMQMB1	Market value		BDMQMB1	CURR	7
BDMQMB2	Purchase price		BDMQMB2	CURR	7
BDNRWERT	Land reference value for determining current market value		BDNRWERT	CURR	7
BDNWERT	Land value for determining current market value		BDNWERT	CURR	7
DBDNWERT	Date of land value		DBDNWERT	DATS	8
RBEPLAN	Development plan		RBEPLAN	CHAR	30
DBEPLAN	Date of development plan		DBEPLAN	DATS	8
XNUTZGRU	Current usage of property		XNUTZGRU	CHAR	30
NZGRZ	Permitted Usage: Site Occupancy Index		NZGRZ	DEC	2
NZGFZ	Permitted Usage: Floor Area Ratio		NZGFZ	DEC	3
NZBMZ	Permitted Usage: Construction Dimension Number		NZBMZ	DEC	3
NTGRZ	Actual Usage: Site Occupancy Index		NTGRZ	DEC	2
NTGFZ	Actual Usage: Floor Area Ratio		NTGFZ	DEC	3
NTBMZ	Actual Usage: Construction Dimension Number		NTBMZ	DEC	3
RNBPLAN	Usage type according to development plan		RNBPLAN	CHAR	4	TIVB3
SGRART	Property type		VVSGRART	NUMC	4	TIV56
SGRQAL	Property: Quality of location		VVSGRQAL	NUMC	3	TIV57
SGRFRM	Property ground type		VVSGRFRM	NUMC	3	TIV58
SGRGZS	Overall condition of property		VVSGRGZS	NUMC	3	TIV59
DWIRTUB	Transfer usage / charges		VVDWIRTUB	DATS	8
DVERKAUF	Sale date		VVDVERKAUF	DATS	8
SUNUTZA	Main usage type		VVSUNART	CHAR	8	TIV36
JUNUTZA	OBSOLETE: Main Usage Type		REBDJUNUTZAOBS	CHAR	1
DVRKPLAN	Planned sale		VVDVRKPLAN	DATS	8
XGEMARK	Local Subdistrict		VVGEMARK	CHAR	12	TIVG2
NFLURNR	Number of Tract of Land in Land Register		NFLURNR	CHAR	6
XFLURST	Parcel of Land		XFLURST	CHAR	10
BRFLURST	Fractional Parcel of Land		VVBRFLURST	CHAR	4
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	1	TDO9
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	8	TIVG1
LEINS	Unit of length		VVLEINS	UNIT	3	T006
WAERS	Currency Key		WAERS	CUKY	5	TCURC
USGFUNCTION	Function of Object		REBDUSGFUNCTION	CHAR	4	TIVBDUSGFUNC
.INCLUDE	CI_VIBDPR			CI_VIBDPR	0
.INCLU--AP				REXC_CH_VIBDPR_APP	0
.INCLUDE	REXC_CH_VIBDPR			REXC_CH_PROBJECT	0
PLANNO	Real Properties Register Number		RELMRPRGNO	NUMC	6
LOCATIONCH	Location Description of Land Acc. To Tax Auth.		REXCCHPRLOCATION	CHAR	60
ESTATEDESCR	Location Description of Land Acc. To Land Register		REXCCHPRDESCRIPTION	CHAR	60
GEMEINDECH	Land Register District		RELMLRDISTRICT	CHAR	6	*
.INCLU--AP				REXC_IN_VIBDPR_APP	0
SECCO	Section Code		SECCO	CHAR	4	*
BUPLA	Business Place		BUPLA	CHAR	4	*
.INCLU--AP				REXC_PT_VIBDPR_APP	0
.INCLUDE				REXCPTBDPR	0
VPT	Property Taxable Value		REXCPTVPT_NOSIGN	CURR	8
CURRENCY	Currency Key		WAERS	CUKY	5	TCURC