SAP table VIBDRO (Rental Object)

SAP table VIBDRO has 2 primary key fields being MANDT,INTRENO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
INTRENO Internal Key of Real Estate Object CHAR 13 0 RECAINTRENO
BUKRS Company Code CHAR 4 0 T001 BUKRS
SWENR Business Entity Number CHAR 8 0 * REBDBENO
SMENR Number of Rental Object CHAR 8 0 REBDRONO
OBJNR Object Number CHAR 22 0 * RECAOBJNR
IMKEY Internal Key of Real Estate Object (FI) CHAR 8 0 RECAIMKEY
CREATIONTYPE How the Object Was Created CHAR 1 0 RECACREATIONTYPE
Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
RESPONSIBLE Person Responsible CHAR 12 0 USR02 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 USR02 RECAUSEREXCLUSIVE
AUTHGRP Authorization Group CHAR 40 0 RECAAUTHGRP
VALIDFROM Date: Object Valid From DATS 8 0 REBDOBJVALIDFROM
VALIDTO Date: Object Valid To DATS 8 0 REBDOBJVALIDTO
ROTYPE Rental Object Type CHAR 2 0 REBDROTYPE
CO Comparative Apartment
PS Pooled Space
RS Rental Space
RU Rental Unit
SNUNR Usage Type of Rental Object NUMC 4 0 TIV01 REBDUSAGETYPE
XMETXT Rental Object Name CHAR 60 0 REBDXRO
SGRNR Number of Land CHAR 8 0 REBDPRNO
SGENR Number of Building CHAR 8 0 REBDBUNO
SALTNR Number of rental unit in existing real estate system CHAR 20 0 SALTNR
CANBECOMMON Common Usage Possible CHAR 1 0 REBDCANBECOMMON
FIRSTPOSTING Cash Flow Generated Starting On DATS 8 0 RECDCFSTARTFROM
DBEZU Date of initial usage DATS 8 0 DBEZU
DWTVERM Date: Subsequent rental DATS 8 0 DWTVERM
DRESAB Date: Reserved from DATS 8 0 DRESA
DRESBIS Date: Reserved upto DATS 8 0 DRESB
SGEBT Part of Building CHAR 2 0 TIV12 SGEBT
RLRAFIXFITCATE Fixtures and Fittings Category CHAR 6 0 TIVAJRLRAFFCT REAJRLRAFIXFITCATE
RLRALOC Location Class CHAR 6 0 TIVAJRLRALOC REAJRLRALOC
PZUABSP Increase or Reduction for Representative List of Rents DEC 4 2 REBDSUREPERCENT
SPOSINMSP Method for Calculating Base Rent of Rep. List of Rents CHAR 1 0 REBDRLRABASEIND
PPOSINMSP Percentage for Positioning RU in RLR Spread DEC 5 2 REBDRLRAPERCENT
PERHOE Percentage rate increase DEC 5 2 PERHOE
RPROZGRD Reason for variance in rate of percentage increase CHAR 2 0 TIV43 RPROZGRD
RLGESCH Location on Floor CHAR 2 0 TIV38 RLGESCH
XSTANDNR Number of garage / parking space CHAR 5 0 VVXSTANDNR
JEIGWOHN Rental Unit in Separate Ownership (COA) CHAR 1 0 VVJEIGWOHN
SSTOCKW Floor NUMC 3 0 TIV37 VVSSTOCKW
SSTCKBIS For RUs with Multiple Floors: Top Floor of RU NUMC 3 0 TIV37 VVSSTCKBIS
DRESTAUR Date of reconstruction/extensive modernization DATS 8 0 VVDRESTAUR
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived DATS 8 0 RECDCFARCHIVEDTO
CFLOCKEDTO Date Until Which the Cash Flow Is Locked DATS 8 0 RECDCFLOCKEDTO
CFPOSTINGFROM First Posting From DATS 8 0 RECDCFPOSTINGFROM
HASCOP Uses Current Occupancy Principle CHAR 1 0 RESCHASCOP
RLRA Representative List of Rents CHAR 6 0 TIVAJRLRA REAJRLRA
USESRLRA Representative List of Rents Is Used CHAR 1 0 REAJUSESRLRA
BUILDYEAR ConstYr DATS 8 0 VVYBAUJAHR
CURRENCY Currency Key CUKY 5 0 TCURC WAERS
COMMONOWNED Rental Object Is Common Property CHAR 1 0 REBDCOMMONOWNED
OOLOCK Do Not Consider Object for Real Estate Search CHAR 1 0 REOROOLOCK
NEIGHBORH1 Neighborhood CHAR 30 0 TIVBDNEIGHBORH REBDNEIGHBORHOOD
NEIGHBORH2 Neighborhood CHAR 30 0 TIVBDNEIGHBORH REBDNEIGHBORHOOD
NEIGHBORH3 Neighborhood CHAR 30 0 TIVBDNEIGHBORH REBDNEIGHBORHOOD
EDID Federal Building Entrance Identification Number (EDID) NUMC 2 0 REXCCHEDID
EGID Federal Building Identification Number (EGID) NUMC 9 0 REXCCHEGID
FLOOR Code of Floor NUMC 4 0 REXCCHROFLOOR
1000 Dwelling floor
FLOORLOC Location of Dwelling on a Floor CHAR 40 0 REXCCHROFLOORLOC
EWID Federal Dwelling Identification Number (EWID) NUMC 3 0 REXCCHEWID
KITCHEN Code of Cooking Facilities NUMC 4 0 REXCCHROKITCHEN
1000 Cooking infrastructure
ADMINNO Administrative Dwelling Number CHAR 12 0 REXCCHROADMINNO
DOORNO Door Number of Dwelling CHAR 8 0 REXCCHRODOORNO
OBJCOND Code of Dwelling Status NUMC 4 0 REXCCHROCOND
1000 Dwelling condition
YEARDECONSTR Year of Demolition DATS 8 0 REXCCHBUDECONYEAR
NUMROOMS Number of Rooms in the Dwelling NUMC 4 0 REXCCHRONUMROOMS
LIVINGAREA Floor Area of Dwelling in M2 DEC 10 2 REXCCHROAREA
USAGETYPE Code of Usage Type NUMC 4 0 REXCCHROUSAGETYPE
1000 Dwelling usage type
GEMEINDECH Land Register District CHAR 6 0 RELMLRDISTRICT
PROTCV Protected City View (Conservation Law 1988, Article 1g) CHAR 1 0 REXCNLPROTCV
LLPMON Conservation Paid by Landlord CHAR 1 0 REXCNLLLPMON
CAREHOME Care Home CHAR 1 0 REXCNLCAREHOME
STATMON State Monument (Conservation Law 1988, Article 1d) CHAR 1 0 REXCNLSTATMON
VPT Property Taxable Value CURR 15 2 REXCPTVPT_NOSIGN
VPTCURRENCY Currency Key CUKY 5 0 TCURC WAERS
CONDK Conservation Level CHAR 4 0 TIVXCPTRACONS REXCPTRACONS

VIBDRO foreign key relationships

Table Field Check Table Check Field
0 VIBDRO BUKRS T001 Company Codes BUKRS
1 VIBDRO CONDK TIVXCPTRACONS customizing parameters for the conservation factor. CONSLEVEL
0 VIBDRO CURRENCY TCURC Currency Codes MANDT
0 VIBDRO CURRENCY TCURC Currency Codes WAERS
1 VIBDRO RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
0 VIBDRO RLGESCH TIV38 Location on Floor RLGESCH
1 VIBDRO RLRA TIVAJRLRA Basic Data for Rep. List of Rents MANDT
1 VIBDRO RLRA TIVAJRLRA Basic Data for Rep. List of Rents RLRA
0 VIBDRO RLRAFIXFITCATE TIVAJRLRAFFCT Fixtures and Fittings Category RLRA
1 VIBDRO RLRALOC TIVAJRLRALOC Location Class RLRA
0 VIBDRO RPROZGRD TIV43 Reasons for reduced percentage rate increase RPROZGRD
1 VIBDRO SGEBT TIV12 Parts of building SGEBT
0 VIBDRO SNUNR TIV01 External usage types of rental unit MANDT
1 VIBDRO USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
0 VIBDRO VPTCURRENCY TCURC Currency Codes MANDT
0 VIBDRO VPTCURRENCY TCURC Currency Codes WAERS