VIOB02 - Property master data

Property master data information is stored in SAP table VIOB02.
It is part of development package FVVI in software component RE. This development package consists of objects that can be grouped under "R/3 appl.dev. for Financial Assets Management: Real estate".

Fields for table VIOB02

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
SWENR	Business Entity Number	X	SWENR	CHAR	16	VIOB01
SGRNR	Land Number for BE	X	SGRNR	CHAR	16
XGRTXT	Text for property		XGRTXT	CHAR	120
SGRUNDB	Land register number		SGRUNDB	NUMC	16	VIGBUCH
RGRNART	Usage Type of Property According to Land Use Map		RGRNART	CHAR	4	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	16
RBEPLAN	Development plan		RBEPLAN	CHAR	60
DBEPLAN	Date of development plan		DBEPLAN	DATS	16
XNUTZGRU	Current usage of property		XNUTZGRU	CHAR	60
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
JVORKAUF	Preemptive right indicator		JVORKAUF	CHAR	2
JAUSNAHM	Special licence indicator		JAUSNAHM	CHAR	2
JGRUNDW	Ground water indicator		JGRUNDW	CHAR	2
JUEBERS	Danger of flooding indicator		JUEBERS	CHAR	2
RARTOPT	Option rate calculation type		RARTOPT	NUMC	2
JLOESCH	Real Estate Deletion Indicator/Flag		JLOESCH	CHAR	2
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
DAKTBEST	Date active in portfolio		DAKTBEST	DATS	16
ADRNR	Object number (virtual object)		SOBJNR	NUMC	20	SANO1
RNBPLAN	Usage type according to development plan		RNBPLAN	CHAR	8	TIVB3
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
KOSTL	Cost Center		KOSTL	CHAR	20
J_OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
RFAKT	Conversion factor for fractional share of property		VVRFAKT	NUMC	12
SGRART	Property type		VVSGRART	NUMC	8	TIV56
SGRQAL	Property: Quality of location		VVSGRQAL	NUMC	6	TIV57
SGRFRM	Property ground type		VVSGRFRM	NUMC	6	TIV58
SGRGZS	Overall condition of property		VVSGRGZS	NUMC	6	TIV59
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
DWIRTUB	Transfer usage / charges		VVDWIRTUB	DATS	16
DVERKAUF	Sale date		VVDVERKAUF	DATS	16
SUNUTZA	Main usage type		VVSUNART	CHAR	16	TIV36
JUNUTZA	Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36		VVJUNUTZA	CHAR	2
PROFL	Settlement profile for costs		VVAPROF	CHAR	12	TKB1A
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
DVRKPLAN	Planned sale		VVDVRKPLAN	DATS	16
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
GSBER	Business Area		GSBER	CHAR	8	TGSB
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30
BERGRP	Authorization group		VVBERGRP	CHAR	80
XGEMARK	Local Subdistrict		VVGEMARK	CHAR	24	TIVG2
NFLURNR	Number of Tract of Land in Land Register		NFLURNR	CHAR	12
XFLURST	Parcel of Land		XFLURST	CHAR	20
BRFLURST	Fractional Parcel of Land		VVBRFLURST	CHAR	8
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	2	TDO9
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	16	TIVG1
LEINS	Unit of length		VVLEINS	UNIT	6
.INCLUDE				CI_VIOB02	0
.INCLU--AP				VIOB02_APP	0
.INCLUDE	REBD_PROPERTY_APP			REBD_PROPERTY_APP	0
.INCLUDE	REBD_MASTER_DATA_APP			REBD_MASTER_DATA_APP	0
VALIDFROM	Date: Object Valid From		REBDOBJVALIDFROM	DATS	16
VALIDTO	Date: Object Valid To		REBDOBJVALIDTO	DATS	16
CREATIONTYPE	How the Object Was Created		RECACREATIONTYPE	CHAR	2
RESPONSIBLE	Person Responsible		RECARESPONSIBLE	CHAR	24
USEREXCLUSIVE	User with Exclusive Change Authorization		RECAUSEREXCLUSIVE	CHAR	24