SAP table REBD_RO_LDB (Rental Obj. w/ Hierarchy Info for Pooled Space +Rental Space)

SAP table REBD_RO_LDB has 2 primary key fields being NORUPS,NORS.

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 * 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 * 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 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 RPROZGRD
RLGESCH Location on Floor CHAR 2 0 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 VVSSTOCKW
SSTCKBIS For RUs with Multiple Floors: Top Floor of RU NUMC 3 0 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
NORUPS Number of Pooled Space or Rental Unit CHAR 8 0 REBDNORUPS
NORS Number of Rental Space CHAR 8 0 REBDNORS

REBD_RO_LDB foreign key relationships

Table Field Check Table Check Field
0 REBD_RO_LDB CONDK TIVXCPTRACONS customizing parameters for the conservation factor. CONSLEVEL
1 REBD_RO_LDB CURRENCY TCURC Currency Codes MANDT
1 REBD_RO_LDB CURRENCY TCURC Currency Codes WAERS
0 REBD_RO_LDB RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
1 REBD_RO_LDB RLRA TIVAJRLRA Basic Data for Rep. List of Rents MANDT
1 REBD_RO_LDB RLRA TIVAJRLRA Basic Data for Rep. List of Rents RLRA
0 REBD_RO_LDB RLRAFIXFITCATE TIVAJRLRAFFCT Fixtures and Fittings Category RLRA
1 REBD_RO_LDB RLRALOC TIVAJRLRALOC Location Class RLRA
0 REBD_RO_LDB USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
1 REBD_RO_LDB VPTCURRENCY TCURC Currency Codes MANDT
1 REBD_RO_LDB VPTCURRENCY TCURC Currency Codes WAERS