REBDPRFLDS SAP (Real Estate Property: Work and Screen Fields) Structure details

Dictionary Type: Structure
Description: Real Estate Property: Work and Screen Fields




ABAP Code to SELECT data from REBDPRFLDS
Related tables to REBDPRFLDS
Access table REBDPRFLDS




Structure field list including key, data, relationships and ABAP select examples

REBDPRFLDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Real Estate Property: Work and Screen Fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_REBDPRFLDS TYPE REBDPRFLDS.

The REBDPRFLDS table consists of various fields, each holding specific information or linking keys about Real Estate Property: Work and Screen Fields data available in SAP. These include MANDT (Client), INTRENO (Internal Key of Real Estate Object), BUKRS (Company Code), SWENR (Site Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP REBDPRFLDS structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SWENRSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
SGRNRNumber of Land REBDPRNOCHAR8Assigned to domainSGRNRREBDPRNOREBDPRNOREBDPRNO
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IMKEYInternal Key of Real Estate Object (FI) RECAIMKEYCHAR8IMKEYIMKEYRECLFXCAIMKEY
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
VALIDFROMDate: Object Valid From REBDOBJVALIDFROMDATS8RECADATEBEG
VALIDTODate: Object Valid To REBDOBJVALIDTODATS8REDATRECADATEEND
XGRTXTName of Land REBDXPRCHAR60RECAXLDESCRIPTION
RGRNARTUsage Type of Property According to Land Use Map RGRNARTCHAR2TIVC4CHAR2
BDMQMB1Market value BDMQMB1CURR13(2) WRTV7
BDMQMB2Purchase price BDMQMB2CURR13(2) WRTV7
BDNRWERTLand reference value for determining current market value BDNRWERTCURR13(2) WRTV7
BDNWERTLand value for determining current market value BDNWERTCURR13(2) WRTV7
DBDNWERTDate of land value DBDNWERTDATS8DDAT
RBEPLANDevelopment plan RBEPLANCHAR30XMBEZ
DBEPLANDate of development plan DBEPLANDATS8DDAT
XNUTZGRUCurrent usage of property XNUTZGRUCHAR30XMBEZ
NZGRZPermitted Usage: Site Occupancy Index NZGRZDEC3(2) DEC1_2
NZGFZPermitted Usage: Floor Area Ratio NZGFZDEC4(2) DEC2_2
NZBMZPermitted Usage: Construction Dimension Number NZBMZDEC5(2) DEC3_2
NTGRZActual Usage: Site Occupancy Index NTGRZDEC3(2) DEC1_2
NTGFZActual Usage: Floor Area Ratio NTGFZDEC4(2) DEC2_2
NTBMZActual Usage: Construction Dimension Number NTBMZDEC5(2) DEC3_2
RNBPLANUsage type according to development plan RNBPLANCHAR4TIVB3RGRNART
SGRARTProperty type VVSGRARTNUMC4TIV56VVSGRART
SGRQALProperty: Quality of location VVSGRQALNUMC3TIV57VVSGRQAL
SGRFRMProperty ground type VVSGRFRMNUMC3TIV58VVSGRFRM
SGRGZSOverall condition of property VVSGRGZSNUMC3TIV59VVSGRGZS
DWIRTUBTransfer usage / charges VVDWIRTUBDATS8DATUM
DVERKAUFSale date VVDVERKAUFDATS8DATUM
SUNUTZAMain usage type VVSUNARTCHAR8TIV36VVSUNART
JUNUTZAOBSOLETE: Main Usage Type REBDJUNUTZAOBSCHAR1CHAR1
DVRKPLANPlanned sale VVDVRKPLANDATS8DATUM
XGEMARKLocal Subdistrict VVGEMARKCHAR12TIVG2VVGEMARK
NFLURNRNumber of Tract of Land in Land Register NFLURNRCHAR6NFLURNR
XFLURSTParcel of Land XFLURSTCHAR10TEXT10
BRFLURSTFractional Parcel of Land VVBRFLURSTCHAR4VVBRFLURST
JERBBAUHeritable building right indicator JERBBAUCHAR1TDO9SOBJERBBAU
GEMEINDEMunicipality key VVGEMEINDECHAR8TIVG1VVGEMEINDE
ZULBAUHPermitted building height VVZULBAUHQUAN4VVZULBAUH
LEINSUnit of length VVLEINSUNIT3T006CUNITMEINS
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
USGFUNCTIONFunction of Object REBDUSGFUNCTIONCHAR4TIVBDUSGFUNCALPHAREBDUSGFUNCTIONREBDUSGFUNC
.INCLU--AP 0
PLANNOReal Properties Register Number RELMRPRGNONUMC6RELMRPRGNO
LOCATIONCHLocation Description of Land Acc. To Tax Auth. REXCCHPRLOCATIONCHAR60RECAXLDESCRIPTION
ESTATEDESCRLocation Description of Land Acc. To Land Register REXCCHPRDESCRIPTIONCHAR60RECAXLDESCRIPTION
GEMEINDECHLand Register District RELMLRDISTRICTCHAR6Assigned to domainRELMLRDISTRICTRELMLRDISTRICTRELMLRDIST
.INCLU--AP 0
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
.INCLU--AP 0
VPTProperty Taxable Value REXCPTVPT_NOSIGNCURR15(2) REXCPTVPT_NOSIGN
CURRENCYCurrency Key WAERSCUKY5TCURCWAERSFWS
BUTXTName of Company Code or Company BUTXTCHAR25TEXT25
XWETEXTSite Name REBDXBECHAR60RECAXLDESCRIPTION
XUNARTMain usage type VVXUNARTCHAR35XTEXT35
KTEXTGeneral Name KTEXTCHAR20TEXT20
XGEMEINDEName of municipality VVXGEMEINDECHAR50VVXGEMEINDE
XKREISName of district VVXKREISCHAR30VVXKREIS
XREGIOName of federal state VVXREGIOCHAR30VVXREGIO
LGEMARKExplanation of sub-district VVLGEMARKCHAR25VVLGEMARK
XADDRESSCompact Display of Address REBPXADDRESSCHAR80REBPXADDRESS
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
REALVALIDFROMDate: Valid from (Effective) REBDREALVALIDFROMDATS8RECADATEBEG
REALVALIDTODate: Valid to (Effective) REBDREALVALIDTODATS8REDATRECADATEEND
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
XAUTHGRPDescription of Authorization Group RECAXAUTHGRPCHAR60RECAXLDESCRIPTION
XMUSGFUNCTIONName of Function of Object (Medium) REBDXMUSGFUNCTIONCHAR30RECAXMDESCRIPTION
XJERBBAUKName XTEXT15CHAR15TEXT15
XJERBBAULName XTEXT30CHAR30TEXT30
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
HASASSETSFixed Assets Assigned to Property REBDPRHASASSETSCHAR1RECABOOL
SLASH01Single-Character Indicator CHAR1CHAR1CHAR1
SLASH02Single-Character Indicator CHAR1CHAR1CHAR1
VVLENUnit of length VVLENUNIT3Assigned to domainCUNITMEINS
XWAEBPISO currency code ISOCDCHAR3ISOCD
XFLBPArea unit FEINSUNIT3Assigned to domainCUNITMEINSFEH
CURRAREA1Currency per Area Unit (Text Field for Screen) REBDCURRAREACHAR7REBDCURRAREA
CURRAREA2Currency per Area Unit (Text Field for Screen) REBDCURRAREACHAR7REBDCURRAREA
CURRAREA3Currency per Area Unit (Text Field for Screen) REBDCURRAREACHAR7REBDCURRAREA
CURRAREA4Currency per Area Unit (Text Field for Screen) REBDCURRAREACHAR7REBDCURRAREA

Key field Non-key field



How do I retrieve data from SAP structure REBDPRFLDS using ABAP code?

As REBDPRFLDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REBDPRFLDS as there is no data to select.

How to access SAP table REBDPRFLDS

Within an ECC or HANA version of SAP you can also view further information about REBDPRFLDS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!