VIBDRO - Rental Object

Rental Object information is stored in SAP table VIBDRO.
It is part of development package RE_BD_RO in software component RE-FX-BD. This development package consists of objects that can be grouped under "RE: Rental Object Master Data".

Fields for table VIBDRO

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	26
.INCLUDE	KEY			VIBDRO_KEY	0
BUKRS	Company Code		BUKRS	CHAR	8	T001
SWENR	Business Entity Number		REBDBENO	CHAR	16	*
SMENR	Number of Rental Object		REBDRONO	CHAR	16
.INCLUDE	TAB			VIBDRO_TAB	0
OBJNR	Object Number		RECAOBJNR	CHAR	44	*
IMKEY	Internal Key of Real Estate Object (FI)		RECAIMKEY	CHAR	16
CREATIONTYPE	How the Object Was Created		RECACREATIONTYPE	CHAR	2
.INCLUDE	RUSER			RUSER	0
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
RESPONSIBLE	Person Responsible		RECARESPONSIBLE	CHAR	24	USR02
USEREXCLUSIVE	User with Exclusive Change Authorization		RECAUSEREXCLUSIVE	CHAR	24	USR02
AUTHGRP	Authorization Group		RECAAUTHGRP	CHAR	80
VALIDFROM	Date: Object Valid From		REBDOBJVALIDFROM	DATS	16
VALIDTO	Date: Object Valid To		REBDOBJVALIDTO	DATS	16
ROTYPE	Rental Object Type		REBDROTYPE	CHAR	4
SNUNR	Usage Type of Rental Object		REBDUSAGETYPE	NUMC	8	TIV01
XMETXT	Rental Object Name		REBDXRO	CHAR	120
SGRNR	Number of Land		REBDPRNO	CHAR	16
SGENR	Number of Building		REBDBUNO	CHAR	16
SALTNR	Number of rental unit in existing real estate system		SALTNR	CHAR	40
CANBECOMMON	Common Usage Possible		REBDCANBECOMMON	CHAR	2
FIRSTPOSTING	Cash Flow Generated Starting On		RECDCFSTARTFROM	DATS	16
DBEZU	Date of initial usage		DBEZU	DATS	16
DWTVERM	Date: Subsequent rental		DWTVERM	DATS	16
DRESAB	Date: Reserved from		DRESA	DATS	16
DRESBIS	Date: Reserved upto		DRESB	DATS	16
SGEBT	Part of Building		SGEBT	CHAR	4	TIV12
RLRAFIXFITCATE	Fixtures and Fittings Category		REAJRLRAFIXFITCATE	CHAR	12	TIVAJRLRAFFCT
RLRALOC	Location Class		REAJRLRALOC	CHAR	12	TIVAJRLRALOC
PZUABSP	Increase or Reduction for Representative List of Rents		REBDSUREPERCENT	DEC	3
SPOSINMSP	Method for Calculating Base Rent of Rep. List of Rents		REBDRLRABASEIND	CHAR	2
PPOSINMSP	Percentage for Positioning RU in RLR Spread		REBDRLRAPERCENT	DEC	3
PERHOE	Percentage rate increase		PERHOE	DEC	3
RPROZGRD	Reason for variance in rate of percentage increase		RPROZGRD	CHAR	4	TIV43
RLGESCH	Location on Floor		RLGESCH	CHAR	4	TIV38
XSTANDNR	Number of garage / parking space		VVXSTANDNR	CHAR	10
JEIGWOHN	Rental Unit in Separate Ownership (COA)		VVJEIGWOHN	CHAR	2
SSTOCKW	Floor		VVSSTOCKW	NUMC	6	TIV37
SSTCKBIS	For RUs with Multiple Floors: Top Floor of RU		VVSSTCKBIS	NUMC	6	TIV37
DRESTAUR	Date of reconstruction/extensive modernization		VVDRESTAUR	DATS	16
CFARCHIVEDTO	Date Up to Which the Cash Flow Is Archived		RECDCFARCHIVEDTO	DATS	16
CFLOCKEDTO	Date Until Which the Cash Flow Is Locked		RECDCFLOCKEDTO	DATS	16
CFPOSTINGFROM	First Posting From		RECDCFPOSTINGFROM	DATS	16
HASCOP	Uses Current Occupancy Principle		RESCHASCOP	CHAR	2
RLRA	Representative List of Rents		REAJRLRA	CHAR	12	TIVAJRLRA
USESRLRA	Representative List of Rents Is Used		REAJUSESRLRA	CHAR	2
BUILDYEAR	ConstYr		VVYBAUJAHR	DATS	16
CURRENCY	Currency Key		WAERS	CUKY	10	TCURC
COMMONOWNED	Rental Object Is Common Property		REBDCOMMONOWNED	CHAR	2
OOLOCK	Do Not Consider Object for Real Estate Search		REOROOLOCK	CHAR	2
NEIGHBORH1	Neighborhood		REBDNEIGHBORHOOD	CHAR	60	TIVBDNEIGHBORH
NEIGHBORH2	Neighborhood		REBDNEIGHBORHOOD	CHAR	60	TIVBDNEIGHBORH
NEIGHBORH3	Neighborhood		REBDNEIGHBORHOOD	CHAR	60	TIVBDNEIGHBORH
.INCLUDE	CI_VIBDRO			CI_VIBDRO	0
.INCLU--AP				REXC_CH_VIBDRO_APP	0
.INCLUDE	REXC_CH_VIBDRO			REXC_CH_ROBJECT	0
EDID	Federal Building Entrance Identification Number (EDID)		REXCCHEDID	NUMC	4
EGID	Federal Building Identification Number (EGID)		REXCCHEGID	NUMC	18
FLOOR	Code of Floor		REXCCHROFLOOR	NUMC	8
FLOORLOC	Location of Dwelling on a Floor		REXCCHROFLOORLOC	CHAR	80
EWID	Federal Dwelling Identification Number (EWID)		REXCCHEWID	NUMC	6
KITCHEN	Code of Cooking Facilities		REXCCHROKITCHEN	NUMC	8
ADMINNO	Administrative Dwelling Number		REXCCHROADMINNO	CHAR	24
DOORNO	Door Number of Dwelling		REXCCHRODOORNO	CHAR	16
OBJCOND	Code of Dwelling Status		REXCCHROCOND	NUMC	8
YEARDECONSTR	Year of Demolition		REXCCHBUDECONYEAR	DATS	16
NUMROOMS	Number of Rooms in the Dwelling		REXCCHRONUMROOMS	NUMC	8
LIVINGAREA	Floor Area of Dwelling in M2		REXCCHROAREA	DEC	6
USAGETYPE	Code of Usage Type		REXCCHROUSAGETYPE	NUMC	8
GEMEINDECH	Land Register District		RELMLRDISTRICT	CHAR	12
.INCLU--AP				REXC_NL_VIBDRO_APP	0
.INCLUDE	REXC_NL_VIBDRO			REXCNLBDRO	0
PROTCV	Protected City View (Conservation Law 1988, Article 1g)		REXCNLPROTCV	CHAR	2
LLPMON	Conservation Paid by Landlord		REXCNLLLPMON	CHAR	2
CAREHOME	Care Home		REXCNLCAREHOME	CHAR	2
STATMON	State Monument (Conservation Law 1988, Article 1d)		REXCNLSTATMON	CHAR	2
.INCLU--AP				REXC_PT_VIBDRO_APP	0
.INCLUDE				REXCPTBDRO	0
VPT	Property Taxable Value		REXCPTVPT_NOSIGN	CURR	8
VPTCURRENCY	Currency Key		WAERS	CUKY	10	TCURC
CONDK	Conservation Level		REXCPTRACONS	CHAR	8	TIVXCPTRACONS