SAP Table REBD_RO_LDB

Rental Obj. w/ Hierarchy Info for Pooled Space +Rental Space

REBD_RO_LDB (Rental Obj. w/ Hierarchy Info for Pooled Space +Rental Space) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REBD_RO_LDB to other SAP tables.

Source: REBD_RO_LDB (Rental Obj. w/ Hierarchy Info for Pooled Space +Rental Space)

REBD_RO_LDB table fields

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

REBD_RO_LDB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REBD_RO_LDB CONDK SYST MANDT TIVXCPTRACONS customizing parameters for the conservation factor. MANDT
REBD_RO_LDB CONDK REBD_RO_LDB CONDK TIVXCPTRACONS customizing parameters for the conservation factor. CONSLEVEL
REBD_RO_LDB CURRENCY REBD_RO_LDB CURRENCY TCURC Currency Codes WAERS
REBD_RO_LDB CURRENCY SYST MANDT TCURC Currency Codes MANDT
REBD_RO_LDB NEIGHBORH1 SYST MANDT TIVBDNEIGHBORH Neighborhood MANDT
REBD_RO_LDB NEIGHBORH1 REBD_RO_LDB NEIGHBORH1 TIVBDNEIGHBORH Neighborhood NEIGHBORHOOD
REBD_RO_LDB NEIGHBORH2 SYST MANDT TIVBDNEIGHBORH Neighborhood MANDT
REBD_RO_LDB NEIGHBORH2 REBD_RO_LDB NEIGHBORH2 TIVBDNEIGHBORH Neighborhood NEIGHBORHOOD
REBD_RO_LDB NEIGHBORH3 SYST MANDT TIVBDNEIGHBORH Neighborhood MANDT
REBD_RO_LDB NEIGHBORH3 REBD_RO_LDB NEIGHBORH3 TIVBDNEIGHBORH Neighborhood NEIGHBORHOOD
REBD_RO_LDB RESPONSIBLE REBD_RO_LDB RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
REBD_RO_LDB RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
REBD_RO_LDB RLRA REBD_RO_LDB RLRA TIVAJRLRA Basic Data for Rep. List of Rents RLRA
REBD_RO_LDB RLRA SYST MANDT TIVAJRLRA Basic Data for Rep. List of Rents MANDT
REBD_RO_LDB RLRAFIXFITCATE * TIVAJRLRAFFCT Fixtures and Fittings Category RLRA
REBD_RO_LDB RLRAFIXFITCATE REBD_RO_LDB RLRAFIXFITCATE TIVAJRLRAFFCT Fixtures and Fittings Category RLRAFIXFITCATE
REBD_RO_LDB RLRAFIXFITCATE SYST MANDT TIVAJRLRAFFCT Fixtures and Fittings Category MANDT
REBD_RO_LDB RLRALOC REBD_RO_LDB RLRALOC TIVAJRLRALOC Location Class RLRALOC
REBD_RO_LDB RLRALOC REBD_RO_LDB RLRA TIVAJRLRALOC Location Class RLRA
REBD_RO_LDB RLRALOC SYST MANDT TIVAJRLRALOC Location Class MANDT
REBD_RO_LDB USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
REBD_RO_LDB USEREXCLUSIVE REBD_RO_LDB USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME
REBD_RO_LDB VPTCURRENCY SYST MANDT TCURC Currency Codes MANDT
REBD_RO_LDB VPTCURRENCY REBD_RO_LDB VPTCURRENCY TCURC Currency Codes WAERS