REIS_SQ_CODATA_PER_CMP SAP (SAP Query: CO Reports - Comparison of Periods) Structure details

Dictionary Type: Structure
Description: SAP Query: CO Reports - Comparison of Periods




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




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

REIS_SQ_CODATA_PER_CMP 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 "SAP Query: CO Reports - Comparison of Periods" 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_SQ_CODATA_PER_CMP TYPE REIS_SQ_CODATA_PER_CMP.

The REIS_SQ_CODATA_PER_CMP table consists of various fields, each holding specific information or linking keys about SAP Query: CO Reports - Comparison of Periods data available in SAP. These include OBJNR (Object Number), OBJNRSRC (Object Number), IDENT (Complete Object Identification, for Example BE 1000/123), BUKRS (Company Code).. 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_SQ_CODATA_PER_CMP 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
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
OBJNRSRCObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IDENTComplete Object Identification, for Example BE 1000/123 RECAIDENTCHAR50CHAR50
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SWENRSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
SGRNRNumber of Land REBDPRNOCHAR8SGRNRREBDPRNOREBDPRNOREBDPRNO
SGENRNumber of Building REBDBUNOCHAR8SGENRREBDBUNOREBDBUNOREBDBUNO
SMENRNumber of Rental Object REBDRONOCHAR8SMENRREBDRONOREBDRONOREBDRONO
RECNNRContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
SNKSLService Charge Key RESCSCKEYCHAR4Assigned to domainALPHARESCSCKEYRESCSCKEYRESCSCKEY
SEMPSLSettlement Unit RESCSUIDCHAR5ALPHARESCSUIDRESCSUIDRESCSU
DABRBZKey Date RECAKEYDATEDATS8RECADATE
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
OBJTYPEObject Type RECAOBJTYPECHAR2Assigned to domainJ_OBARTRECAOBJTYPE
AOIDENTIdentification of Architectural Object REBDAOIDCHAR30REBDAOIDREBDAOIDREBDAONO
OBJTEXTObject Description RECADESCRIPTIONCHAR60RECAXLDESCRIPTION
ROTYPERental Object Type REBDROTYPECHAR2REBDROTYPEREBDROTYPE
SNUNRUsage Type of Rental Object REBDUSAGETYPENUMC4Assigned to domainSNUNRREBDUSAGETYPEREBDUSAGETYPE
RECNTYPEContract Type RECNCONTRACTTYPECHAR4Assigned to domainSMVARTRECNTYPERECNCONTRACTTYPE
MIGOBJNRMigrated Object REISMIGOBJNRCHAR22Assigned to domainJ_OBJNR
VALTYPEValue Type (RE-Specific) RECOVALUETYPECHAR2RECOVALUETYPE
COSTELEMENTCost Element RECOCOSTELEMENTCHAR10Assigned to domainALPHAKSTAR
DCINDICATORDebit/Credit Indicator RERADCINDICATORCHAR1RERADCINDICATOR
XCOSTELEMENTGeneral Name KTEXTCHAR20TEXT20
HIERNAME1Set Name SETNAMENEWCHAR24SETNAMEGSE
XHIERNAME1Short description of a set SETTEXTCHAR40TEXT40
HIERNAME2Set Name SETNAMENEWCHAR24SETNAMEGSE
XHIERNAME2Short description of a set SETTEXTCHAR40TEXT40
HIERNAME3Set Name SETNAMENEWCHAR24SETNAMEGSE
XHIERNAME3Short description of a set SETTEXTCHAR40TEXT40
HIERNAME4Set Name SETNAMENEWCHAR24SETNAMEGSE
XHIERNAME4Short description of a set SETTEXTCHAR40TEXT40
HIERNAME5Set Name SETNAMENEWCHAR24SETNAMEGSE
XHIERNAME5Short description of a set SETTEXTCHAR40TEXT40
.INCLU-BL1 0
AMT001BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT002BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT003BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT004BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT005BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT006BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT007BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT008BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT009BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT010BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT011BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT012BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT013BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT014BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT015BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMT016BL1Amount RECOAMOUNTCURR15(2) RECACURR
CURRENCYBL1Currency Key WAERSCUKY5Assigned to domainWAERSFWS
AMTQ1BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ2BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ3BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ4BL1Amount RECOAMOUNTCURR15(2) RECACURR
AMTSUMBL1Amount RECOAMOUNTCURR15(2) RECACURR
.INCLU-BL2 0
AMT001BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT002BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT003BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT004BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT005BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT006BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT007BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT008BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT009BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT010BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT011BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT012BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT013BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT014BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT015BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMT016BL2Amount RECOAMOUNTCURR15(2) RECACURR
CURRENCYBL2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
AMTQ1BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ2BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ3BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMTQ4BL2Amount RECOAMOUNTCURR15(2) RECACURR
AMTSUMBL2Amount RECOAMOUNTCURR15(2) RECACURR
.INCLU-CMP 0
AMT001CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT002CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT003CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT004CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT005CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT006CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT007CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT008CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT009CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT010CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT011CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT012CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT013CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT014CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT015CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMT016CMPAmount RECOAMOUNTCURR15(2) RECACURR
CURRENCYCMPCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
AMTQ1CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMTQ2CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMTQ3CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMTQ4CMPAmount RECOAMOUNTCURR15(2) RECACURR
AMTSUMCMPAmount RECOAMOUNTCURR15(2) RECACURR
DIFFPER001Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER002Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER003Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER004Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER005Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER006Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER007Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER008Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER009Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER010Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER011Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER012Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER013Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER014Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER015Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFPER016Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFQ1Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFQ2Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFQ3Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFQ4Variance in Percent REISDIFFPERCENTDEC7(2) RECADECV52
DIFFSUMVariance in Percent REISDIFFPERCENTDEC7(2) RECADECV52

Key field Non-key field



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

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

How to access SAP table REIS_SQ_CODATA_PER_CMP

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