REIS_OF_L SAP (ALV Reporting: Contract Offer) Structure details

Dictionary Type: Structure
Description: ALV Reporting: Contract Offer




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




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

REIS_OF_L 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 "ALV Reporting: Contract Offer" 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_REIS_OF_L TYPE REIS_OF_L.

The REIS_OF_L table consists of various fields, each holding specific information or linking keys about ALV Reporting: Contract Offer data available in SAP. These include MANDT (Client), INTRENO (Internal Key of Real Estate Object), OFID (Contract Offer Number), OBJNR (Object 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 REIS_OF_L 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
OFIDContract Offer Number REOROFIDCHAR13ALPHAREOROFIDREOROFID
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RECNTYPEContract Type RECNCONTRACTTYPECHAR4Assigned to domainSMVARTRECNTYPERECNCONTRACTTYPE
OFCNBEGDate of contract start RECNCNBEGDATS8RECADATE
OFCNENDABSTerm End Date RECNCNENDABSDATS8REDATRECADATEEND
XOFName of Contract Offer REORXOFCHAR60RECAXLDESCRIPTION
OFREJDATERejection of Contract Offer REOROFREJDATEDATS8RECADATE
RECNNRContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
RECNTLAWTenancy law SMIETRCHAR5TIV03SMIETR
RECNBUKRSCOLLECTCompany code of main contract RECNBUKRSCOLLECTCHAR4T001BUKRS
RECNNRCOLLECTNumber of Real Estate Main Contract RECNNUMBERCOLLECTCHAR13ALPHARECNNUMBERRECNNR
RECNCNCURRCurrency for Contract RECNWAERS_CNCUKY5TCURCWAERSFWS
INDUSTRYIndustry BU_IND_SECTORCHAR10Assigned to domainBU_INDSECTOR
SRRELEVANTRelevant to Sales RECNSALESRENTRELEVANTCHAR1RECABOOL
DPTARGETTYPESecurity Deposit Type RECNDPTYPECHAR4TIVCNDPTYPEALPHARECNDPTYPE
OFRESTOContract Offer Reserved To REOROFRESTODATS8RECADATE
RECNDATDate of Contract Conclusion RECNDATDATS8DDAT
RECNDPOCash Flow Generated Starting On RECDCFSTARTFROMDATS8RECADATE
RECNEND1STDate of First Contract End RECNCNEND1STDATS8RECADATE
BENOCNSite That Belongs to Contract RECNBENOCNCHAR8Assigned to domainSWENRREBDBENOREBDBENO
POSSDATEFROMDate From Which the Object Is Made Available for Use REBDPOSSDATEFROMDATS8RECADATE
POSSDATETODate Up to Which the Object Is Used REBDPOSSDATETODATS8RECADATE
XBUKRSName of Company Code or Company BUTXTCHAR25TEXT25
XRECNTYPEDescription of type of RE contract type XMVARTMCHAR30XMBEZ
XTENANCYLAWTenancy law long text XMIETRCHAR50XTEXT50
XCOLLECTContract name RECNTXTCHAR80XTEXT80
XAUTHGRPDescription of Authorization Group RECAXAUTHGRPCHAR60RECAXLDESCRIPTION
XINDUSTRYDescription BU_TEXT20CHAR20TEXT20
RECNTXTContract name RECNTXTCHAR80XTEXT80
RECISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
RECISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE
.INCLU-01 0
CONDVALUE_CN01Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN01Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN01Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN01Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN01Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN01Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN01Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN01Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-02 0
CONDVALUE_CN02Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN02Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN02Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN02Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN02Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN02Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN02Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN02Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-03 0
CONDVALUE_CN03Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN03Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN03Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN03Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN03Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN03Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN03Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN03Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-04 0
CONDVALUE_CN04Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN04Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN04Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN04Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN04Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN04Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN04Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN04Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-05 0
CONDVALUE_CN05Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN05Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN05Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN05Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN05Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN05Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN05Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN05Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-06 0
CONDVALUE_CN06Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN06Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN06Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN06Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN06Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN06Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN06Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN06Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-07 0
CONDVALUE_CN07Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN07Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN07Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN07Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN07Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN07Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN07Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN07Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
.INCLU-08 0
CONDVALUE_CN08Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_CN08Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_CN08Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_CN08Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_CN08Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_CN08Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUENET_CN08Currency Amount (Net) of Condition Item RECDCONDVALUENETCURR15(2) RECACURR
CONDVALUEGROSS_CN08Currency Amount (Gross) of Condition Item RECDCONDVALUEGROSSCURR15(2) RECACURR
CONDVALUEFURTHER_CNTotal of Further Condition Amounts REISCONDVALUEFURTHERCURR15(2) RECACURR
TAXVALUE_CNTax on Sales/Purchase of Condition Item RECDTAXVALUECURR15(2) RECACURR
CDCNISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
CDCNISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE
ROLE_BP1First Main Contractual Partner: Role REBPROLE1CHAR6Assigned to domainBU_ROLE
XROLE_BP11st Main Contractual Partner: Name of Role Category REBPXROLE1CHAR30RECAXMDESCRIPTION
PARTNER_BP1First Main Contractual Partner REBPPARTNER1CHAR10Assigned to domainALPHABU_PARTNERBPABUPA
XPARTNER_BP1Name/Address of 1st Business Partner REBPXPARTNER1CHAR80TEXT80
TEL_NUMBER_LONG_BP1Complete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
FAX_NUMBER_LONG_BP1Complete number: dialling code+number+extension AD_FXNRLNGCHAR30CHAR30
SMTP_ADDR_BP1E-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
XNAME_BP1Short Description of 1st Business Partner REBPXNAME1CHAR50BU_TEXT50
STREET_BP1Street AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1_BP1House Number AD_HSNM1CHAR10TEXT10
POST_CODE1_BP1City postal code AD_PSTCD1CHAR10CHAR10
CITY1_BP1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2_BP1District AD_CITY2CHAR40TEXT40CITY_PART
REGION_BP1STATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
PO_BOX_BP1PO Box AD_POBXCHAR10CHAR10
POST_CODE2_BP1PO Box Postal Code AD_PSTCD2CHAR10CHAR10
ROLE_BP2Second Main Contractual Partner: Role REBPROLE2CHAR6Assigned to domainBU_ROLE
XROLE_BP22nd Main Contractual Partner: Name of Role Category REBPXROLE2CHAR30RECAXMDESCRIPTION
PARTNER_BP2Second Main Contractual Partner REBPPARTNER2CHAR10Assigned to domainALPHABU_PARTNERBPABUPA
XPARTNER_BP2Name/Address of 2nd Business Partner REBPXPARTNER2CHAR80TEXT80
TEL_NUMBER_LONG_BP2Complete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
FAX_NUMBER_LONG_BP2Complete number: dialling code+number+extension AD_FXNRLNGCHAR30CHAR30
SMTP_ADDR_BP2E-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
XNAME_BP2Short Description of 2nd Business Partner REBPXNAME2CHAR50BU_TEXT50
STREET_BP2Street AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1_BP2House Number AD_HSNM1CHAR10TEXT10
POST_CODE1_BP2City postal code AD_PSTCD1CHAR10CHAR10
CITY1_BP2City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2_BP2District AD_CITY2CHAR40TEXT40CITY_PART
REGION_BP2STATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
PO_BOX_BP2PO Box AD_POBXCHAR10CHAR10
POST_CODE2_BP2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
ALVROWSNumber of Rows REISALVROWSINT25
.INCLU-01 0
MEASVALUE01Measurement Amount: Available REBDMEASVALUEQUAN17(4) REBDMEASVALUE
MEASVALUECMPL01Measurement Amount: Capacity REBDMEASVALUECMPLQUAN17(4) REBDMEASVALUE
MEASUNIT01Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
MEASVALIDFROM01Date: Measurement Valid From REBDMEASVALIDFROMDATS8RECADATE
MEASVALIDTO01Date: Measurement Valid To REBDMEASVALIDTODATS8REDATRECADATEEND
.INCLU-02 0
MEASVALUE02Measurement Amount: Available REBDMEASVALUEQUAN17(4) REBDMEASVALUE
MEASVALUECMPL02Measurement Amount: Capacity REBDMEASVALUECMPLQUAN17(4) REBDMEASVALUE
MEASUNIT02Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
MEASVALIDFROM02Date: Measurement Valid From REBDMEASVALIDFROMDATS8RECADATE
MEASVALIDTO02Date: Measurement Valid To REBDMEASVALIDTODATS8REDATRECADATEEND
.INCLU-03 0
MEASVALUE03Measurement Amount: Available REBDMEASVALUEQUAN17(4) REBDMEASVALUE
MEASVALUECMPL03Measurement Amount: Capacity REBDMEASVALUECMPLQUAN17(4) REBDMEASVALUE
MEASUNIT03Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
MEASVALIDFROM03Date: Measurement Valid From REBDMEASVALIDFROMDATS8RECADATE
MEASVALIDTO03Date: Measurement Valid To REBDMEASVALIDTODATS8REDATRECADATEEND
.INCLU-04 0
MEASVALUE04Measurement Amount: Available REBDMEASVALUEQUAN17(4) REBDMEASVALUE
MEASVALUECMPL04Measurement Amount: Capacity REBDMEASVALUECMPLQUAN17(4) REBDMEASVALUE
MEASUNIT04Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
MEASVALIDFROM04Date: Measurement Valid From REBDMEASVALIDFROMDATS8RECADATE
MEASVALIDTO04Date: Measurement Valid To REBDMEASVALIDTODATS8REDATRECADATEEND
.INCLU-05 0
MEASVALUE05Measurement Amount: Available REBDMEASVALUEQUAN17(4) REBDMEASVALUE
MEASVALUECMPL05Measurement Amount: Capacity REBDMEASVALUECMPLQUAN17(4) REBDMEASVALUE
MEASUNIT05Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
MEASVALIDFROM05Date: Measurement Valid From REBDMEASVALIDFROMDATS8RECADATE
MEASVALIDTO05Date: Measurement Valid To REBDMEASVALIDTODATS8REDATRECADATEEND
MEASISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
MEASISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE

Key field Non-key field



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

As REIS_OF_L 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 REIS_OF_L as there is no data to select.

How to access SAP table REIS_OF_L

Within an ECC or HANA version of SAP you can also view further information about REIS_OF_L 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!