1. Home
  2. Resources
  3. SAP Tables
  4. REBDROFLDS - RE Rental Object: Work and Screen Fields

SAP Table REBDROFLDS

RE Rental Object: Work and Screen Fields

REBDROFLDS (RE Rental Object: Work and Screen Fields) 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 REBDROFLDS to other SAP tables.

Source: REBDROFLDS (RE Rental Object: Work and Screen Fields)

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

REBDROFLDS foreign key relationships

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