SAP table REBDROFLDS (RE Rental Object: Work and Screen Fields)

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
BUKRSTXT Name of Company Code or Company CHAR 25 0 BUTXT
XWETEXT Business Entity Name CHAR 60 0 REBDXBE
XGRTXT Name of Land CHAR 60 0 REBDXPR
XGETXT Description of Building CHAR 60 0 REBDXBU
XLROTYPE Name of Rental Object Type CHAR 60 0 REBDXLROTYPE
XMBEZ Description of external usage type of rental unit CHAR 30 0 XNUNRM
XRLRA Description of Representative List of Rents CHAR 60 0 REAJXRLRA
XRLRAFIXFITCATE Description of Fixtures and Fittings Category CHAR 60 0 REAJXRLRAFIXFITCATE
XRLRALOC Name of Location Class CHAR 60 0 REAJXRLRALOC
XAUSTKLL Long text of fixture and fitting category CHAR 50 0 XAUSTKLL
XSTOCKK Short name of floor CHAR 4 0 VVXSTOCKK
XSTOCKL Floor ID CHAR 30 0 VVXSTOCKL
XSTBISK For RUs with several storeys: Top storey of RU CHAR 4 0 VVXSTBISK
XSTBISL For RUs with Multiple Floors: Top Floor of RU CHAR 30 0 REBDXSTBISL
XKLGESCH Location in floor short name CHAR 15 0 XKLGESCH
XSLIFTBIS Elevator to floor in building CHAR 4 0 VVXLIFTB
XSTOCKL_LIFTBIS Elevator to (Floor Name) CHAR 30 0 REBDXLSTOCKL
XGBVON Land register district CHAR 25 0 XGBVON
NBANDNR Land register volume number CHAR 15 0 NBANDNR
NBLATTNR Land register page number CHAR 15 0 NBLATTNR
XGEBK Short name for parts of building CHAR 15 0 XGEBK
XADDRESS Compact Display of Address CHAR 80 0 REBPXADDRESS
GSBER Business Area CHAR 4 0 * GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
KOSTL Cost Center CHAR 10 0 * KOSTL
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
REALVALIDFROM Date: Valid from (Effective) DATS 8 0 REBDREALVALIDFROM
REALVALIDTO Date: Valid to (Effective) DATS 8 0 REBDREALVALIDTO
XAUTHGRP Description of Authorization Group CHAR 60 0 RECAXAUTHGRP
RLRAAGE Building Age Category CHAR 6 0 TIVAJRLRAAGE REAJRLRAAGE
RLRASIZ Size Class CHAR 6 0 TIVAJRLRASIZ REAJRLRASIZ
RLRALABEL Representative List of Rents Label CHAR 10 0 TIVAJRLRALABEL REAJRLRALABEL
XRLRALABEL Name of Representative List of Rents Label CHAR 60 0 REAJXRLRALABEL
XGEBM Building parts long text CHAR 30 0 XGEBM
SLIFTBIS Elevator to Floor in Building NUMC 3 0 * VVLIFTBIS
XSVACREASON Individual status of an object (short form) CHAR 4 0 J_TXT04
XMVACREASON Object status CHAR 30 0 J_TXT30
XVACCOSTCENTER General Name CHAR 20 0 KTEXT
XKBELBEZ Occupancy obligation short text CHAR 15 0 XKBELBEZ
XKPROZGRD Reason for percentage rate increase CHAR 15 0 XKPROZGRD
PHPZSAKT Interest rate of mortgage loan on a specific date DEC 5 3 VVPHPZSAKT
PUTBKAKT Change in maint./operating costs index in percentage points DEC 8 3 VVPUTBKAKT
PTEURAKT Standard of living index point status on a date DEC 8 3 VVPTEURAKT
XBEWERBER Name of applicant CHAR 60 0 XBEWERBER
REINS Unit for cubic volume UNIT 3 0 REINS
XSTOCKDD Floor Number for Drop-Down Boxes CHAR 60 0 REBDXSTOCKWDD
XSTBISDD Floor Number for Drop-Down Boxes CHAR 60 0 REBDXSTOCKWDD
POOLID Number of Pooled Space CHAR 8 0 REBDRONOPS
XPOOL Rental Object Name CHAR 60 0 REBDXRO
CH_SLASH1 Single-Character Flag CHAR 1 0 CHAR1
CH_PERCENT1 Single-Character Flag CHAR 1 0 CHAR1
ISRLRALOCFROMSUPER General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
BUILDINGYEAR Construction Year of Building CHAR 10 0 REBDXBUILDINGYEAR
ISRLRAFROMSUPER General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
ISBUILDYEARFROMSUPER General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
XBUILDINGYEARICON Carrier field for icons CHAR 132 0 ICON_TEXT
XRLRAICON Carrier field for icons CHAR 132 0 ICON_TEXT
XRLRALOCICON Carrier field for icons CHAR 132 0 ICON_TEXT
ISCURRENCYFROMSUPER General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes

REBDROFLDS foreign key relationships

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