VIOB03 - Real estate building master

Real estate building master information is stored in SAP table VIOB03.
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 VIOB03

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
SGENR	Building Number	X	SGENR	CHAR	16
ADRNR	Object number (virtual object)		SOBJNR	NUMC	20	SANO1
RGEBART	Type of building		RGEBART	NUMC	4	TIV5A
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	2	TDO9
RGEBZUST	General condition of building		RGEBZUST	NUMC	4	TIV83
YBAUJAHR	ConstYr		VVYBAUJAHR	DATS	16
YMODERN	Year of modernization		VVYMODERN	DATS	16
YAUFBAU	Year of reconstruction		VVYAUFBAU	DATS	16
DBAUBEGI	Construction start date		DBAUBEGI	DATS	16
BBAUW13	Building value		BBAUW13	CURR	6
BBAUWAKT	Current building value		BBAUWAKT	CURR	6
BBETRIEB	Production equipment value		BBETRIEB	CURR	6
BAUSSEN	Grounds value		BAUSSEN	CURR	6
BSCHADEN	Structural damage value		BSCHADEN	CURR	6
BREPSTAU	Value of repair backlog		BREPSTAU	CURR	6
BDMCBMRA	Amount per volume unit		BDMCBMRA	CURR	6
DBAUGENE	Building permit		DBAUGENE	DATS	16
XBAUGENE	Note on building permit		XBAUGENE	CHAR	60
DBEZUGSF	Ready for occupancy		DBEZUGSF	DATS	16
DFERTIG	Completion		DFERTIG	DATS	16
DSCHLUSS	Final Inspection		DSCHLUSS	DATS	16
FDACHFL	Attic space		FDACHFL	DEC	5
RDAZUST	Condition of roof		RDAZUST	NUMC	4	TIV83
RFAZUST	Condition of facade		RFAZUST	NUMC	4	TIV83
BUBRA	Cubic Volume		BUBRA	DEC	6
JDENKMAL	Protection of Historical Sites		JDENKMAL	CHAR	2
AGESCH	Dummy, since replaced: Number of floors		AGESCH	DEC	2
AUGESCH	Number of basements		AUGESCH	DEC	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
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
DBAUVOR	Date of planning inquiry		DBAUVOR	DATS	16
DVORBES	Date of prior notice		DVORBES	DATS	16
DANTBAU	Application for building permit		DANTBAU	DATS	16
SGRUNDB	Land register number		SGRUNDB	NUMC	16
XGETXT	Building text		XGETXT	CHAR	120
BEINHEITW	Assessed value of building		BEINHEITW	CURR	6
NEINHEITW	Assessed value base year		NEINHEITW	NUMC	8
BVERSWRT	Insurable value amount		BVERSWRT	CURR	6
RVERSWRT	Type of insurance value		RVERSWRT	NUMC	2
SLAGK	Location class		SLAGK	NUMC	4	TIV22
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
JNURJAHR	Indicator: Only regard construction date in terms of years		VVJNURJ	CHAR	2
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		APROF	CHAR	12	TKB1A
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
DVRKPLAN	Planned sale		VVDVRKPLAN	DATS	16
DNUTZEND	End of usage		VVDNUTZEND	DATS	16
DFRDVON	Public funding from		VVDFRDVON	DATS	16
DFRDBIS	Public funding to		VVDFRDBIS	DATS	16
NSTCKLFT	Number of highest floor reached by elevator		VVNSTCKLFT	NUMC	6
BANZGE	Number of floors		VVBANZGE	DEC	3
RPGENR	Building no. of hierarchical superior building part		VVRPGENR	CHAR	16
JANLHIE	Indicator: Asset allocation valid for subordin. building		VVJANLHIE	CHAR	2
SSTCKBIS	Uppermost Floor of a Building		VVSTCKBIS	NUMC	6
SLIFTBIS	Elevator to Floor in Building		VVLIFTBIS	NUMC	6
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
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	16	TIVG1
.INCLUDE				CI_VIOB03	0
.INCLU--AP				VIOB03_APP	0
.INCLUDE	REBD_BUILDING_APP			REBD_BUILDING_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