REIS_OO_L SAP (ALV Reporting: Offered Object) Structure details

Dictionary Type: Structure
Description: ALV Reporting: Offered Object




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




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

REIS_OO_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: Offered Object" 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_OO_L TYPE REIS_OO_L.

The REIS_OO_L table consists of various fields, each holding specific information or linking keys about ALV Reporting: Offered Object data available in SAP. These include MANDT (Client), INTRENO (Internal Key of Real Estate Object), OOID (Offered Object 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_OO_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
OOIDOffered Object Number REOROOIDCHAR20ALPHAREOROOIDREOROOIDREOROO
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
OOBEGAvailable From REOROOBEGDATS8RECADATEBEG
OOENDAvailable To REOROOENDDATS8REDATRECADATEEND
MEASMeasurement Type REBDMEASCHAR4TIVBDMEASALPHAREBDMEASREBDMEASREBDMEAS
USAGETYPEUsage Type of Rental Object REBDUSAGETYPENUMC4TIV01SNUNRREBDUSAGETYPEREBDUSAGETYPE
RSOBJTYPEReservation Object Type REORRSOBJTYPECHAR2TIVORRSOBJTYPEREORRSOBJTYPEREORRSOBJTYPE
RSAREAReservation Area REORRSAREACHAR10TIVORRSAREAREORRSAREA
ACQUISTYPELease/Buy REORACQUISTYPECHAR2REORACQUISTYPE
XOOText for Offered Object REORXOOCHAR255REORXLDESCRIPTION
OOIDEXTExternal ID of Reservation Object REOROOIDEXTCHAR45REOROOIDEXTREOROOIDEXT
OBJTYPEREFObject Type RECAOBJTYPECHAR2Assigned to domainJ_OBARTRECAOBJTYPE
OBJNRREFObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
OODATAFROMOffer Data Valid From REOROODATAFROMDATS8REDATRECADATEEND
OODATATOOffer Data Valid To REOROODATATODATS8REDATRECADATEEND
OORESFROMOffer Reserved From REOROORESFROMDATS8RECADATEBEG
OORESTOOffered Object Reserved To REOROORESTODATS8REDATRECADATEEND
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BENOSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
BUNONumber of Building REBDBUNOCHAR8SGENRREBDBUNOREBDBUNOREBDBUNO
PRNONumber of Land REBDPRNOCHAR8SGRNRREBDPRNOREBDPRNOREBDPRNO
RONONumber of Rental Object REBDRONOCHAR8SMENRREBDRONOREBDRONOREBDRONO
OFIDContract Offer Number REOROFIDCHAR13ALPHAREOROFIDREOROFID
.INCLU-01 0
CDVALUE01Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR01Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-02 0
CDVALUE02Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR02Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-03 0
CDVALUE03Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR03Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-04 0
CDVALUE04Condition Amount REORCDVALUECURR15(2) RECACURR
CDCURR04Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
.INCLU-01 0
MSVALUE01Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT01Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-02 0
MSVALUE02Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT02Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-03 0
MSVALUE03Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT03Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
.INCLU-04 0
MSVALUE04Measurement Amount REORMSVALUEQUAN17(4) REBDMEASVALUE
MSUNIT04Measurement Unit REBDMEASUNITUNIT3Assigned to domainCUNITMEINS
FLOORFloor REORRRFLOORCHAR2REORRRFLOOR
SSTDORTRegional location VVSSTDORTCHAR10TIV35VVSSTDORT
SLAGEWEBusiness entity location number SLAGEWENUMC4TIV10SLAGEWE
SOBJLAGEIndicator: District Location of Object RESOBJLAGENUMC2TIV45RESOBJLAGE
TRANSPCONNTransport Connections of Business Entity SVERKEHRCHAR1TIV44SVERKEHR
BUILDYEARConstYr VVYBAUJAHRDATS8DATUM
RRCHARACTSTRFixtures and Fittings Characteristic String REORRRCHARACTSTRCHAR80REORCHARACTSTR
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
NEIGHBORH1Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
NEIGHBORH2Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
NEIGHBORH3Neighborhood REBDNEIGHBORHOODCHAR30REBDNEIGHBORHOOD
AECNEEDEDAccommodation Entitlement Certificate Required REORAECNEEDEDCHAR1RECABOOL
AECCLASSSTRAEC Level String REORAECCLASSSTRCHAR60REORAECCLASSSTR
OBJNRCNOutline Agreement REOROBJNRCNCHAR22Assigned to domainJ_OBJNR
ACCDETKEYAccount Determination Value RERAACCDETKEYCHAR10TIVRADETKEYRERAACCDETKEY
RESPOBJNRDEFResponsible Account Assignment Object (Default) REORRESPOBJNRDEFCHAR22Assigned to domainJ_OBJNR
RESPOBJNR1Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR2Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR3Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
RESPOBJNR4Responsible Account Assignment Object REORRESPOBJNRCHAR22Assigned to domainJ_OBJNR
PRICECODE1Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE2Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE3Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
PRICECODE4Price Code REORPRICECODECHAR10TIVORPRICECODEREORPRICECODE
LOCKEDFROMStart of Lock Period REORLOCKEDFROMDATS8RECADATEBEG
LOCKEDTOEnd of Lock Period REORLOCKEDTODATS8RECADATE
LOCKREASONLock Reason REORLOCKREASONCHAR4TIVORLOCKRSALPHAREORLOCKREASON
XLOCKREASONEXTOther Lock Reason REORXLOCKREASONEXTCHAR100RECAXCOMMENT
BILLEDTODate Up to Which Postings Were Made REORBILLEDTODATS8RECADATE
NTPERContract Notice Per RECNNTPERDATS8RECADATE
NTREQUESTONTenant's notice request date RECNNTREQUESTONDATS8RECADATE
BILLFROMFirst Posting From REORBILLFROMDATS8RECADATE
XAUTHGRPDescription of Authorization Group RECAXAUTHGRPCHAR60RECAXLDESCRIPTION
XRRFLOORName of Floor REORXRRFLOORCHAR30RECAXMDESCRIPTION
XSTDORTRegional location VVXSTDORTCHAR35XTEXT35
XMBEZDescription of location of business entity XLAGEWEMCHAR30XMBEZ
XOBJLAGEDistrict Location XOBJLAGECHAR50XTEXT50
XVERKEHRTransport connections XVERKEHRCHAR50XTEXT50
XSTOCKLLong Description for Floor XGMBEZCHAR30XMBEZ
IDENTRESPOBJDEFStandard Account Assignment Object (Default) REORRESPIDENTDEFCHAR50CHAR50
IDENTRESPOBJ1Responsible Account Assignment Object REORRESPIDENTCHAR50CHAR50
IDENTRESPOBJ2Responsible Account Assignment Object REORRESPIDENTCHAR50CHAR50
IDENTRESPOBJ3Responsible Account Assignment Object REORRESPIDENTCHAR50CHAR50
IDENTRESPOBJ4Responsible Account Assignment Object REORRESPIDENTCHAR50CHAR50
XLOCKREASONText for Lock Reason REORXLOCKREASONCHAR30RECAXMDESCRIPTION
XNEIGHBORH1Text for Neighborhood REBDXNEIGHBORHOODCHAR30RECAXMDESCRIPTION
XNEIGHBORH2Text for Neighborhood REBDXNEIGHBORHOODCHAR30RECAXMDESCRIPTION
XNEIGHBORH3Text for Neighborhood REBDXNEIGHBORHOODCHAR30RECAXMDESCRIPTION
XRSOBJTYPEName of Reservation Object Type REORXRSOBJTYPECHAR30RECAXMDESCRIPTION
XPRICECODE1Name of Price Code REORXPRICECODECHAR30RECAXMDESCRIPTION
XPRICECODE2Name of Price Code REORXPRICECODECHAR30RECAXMDESCRIPTION
XPRICECODE3Name of Price Code REORXPRICECODECHAR30RECAXMDESCRIPTION
XPRICECODE4Name of Price Code REORXPRICECODECHAR30RECAXMDESCRIPTION
XACCDETKEYAccount Determination Value Name RERAXMACCDETKEYCHAR30RECAXMDESCRIPTION
RECISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
RECISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE
XAECCLASSAccommodation Entitlement Certificate Level REORXAECCLASSCHAR60RECAXLDESCRIPTION
CHECKBOXIndicator for Reporting REISCHECKBOXCHAR1RECABOOL
XUSAGETYPEDescription of external usage type of rental unit XNUNRMCHAR30XMBEZ
ALVROWSNumber of Rows REISALVROWSINT25
.INCLU-01 0
CONDVALUE_BD01Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD01Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD01Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD01Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD01Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD01Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-02 0
CONDVALUE_BD02Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD02Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD02Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD02Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD02Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD02Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-03 0
CONDVALUE_BD03Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD03Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD03Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD03Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD03Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD03Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-04 0
CONDVALUE_BD04Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD04Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD04Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD04Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD04Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD04Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-05 0
CONDVALUE_BD05Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD05Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD05Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD05Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD05Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD05Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-06 0
CONDVALUE_BD06Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD06Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD06Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD06Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD06Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD06Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-07 0
CONDVALUE_BD07Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD07Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD07Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD07Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD07Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD07Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
.INCLU-08 0
CONDVALUE_BD08Condition item currency amount RECDCONDVALUECURR15(2) RECACURR
CONDCURR_BD08Currency of condition item RECDCONDCURRCUKY5Assigned to domainWAERS
FREQUENCY_BD08Name of Unit for Posting Frequency REISFREQUENCYCHAR12
CONDVALIDFROM_BD08Date from when condition is valid RECDVALIDFROMDATS8RECADATE
CONDVALIDTO_BD08Date up to when condition is valid RECDVALIDTODATS8REDATRECADATEEND
UNITPRICE_BD08Price per Measurement REISCONDMEASPRICEDEC19(6) RECDUNITPRICE
CONDVALUEFURTHER_BDTotal of Further Condition Amounts REISCONDVALUEFURTHERCURR15(2) RECACURR
TAXVALUE_BDTax on Sales/Purchase of Condition Item RECDTAXVALUECURR15(2) RECACURR
CDBDISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
CDBDISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE
.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_OO_L using ABAP code?

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

How to access SAP table REIS_OO_L

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