REIS_REDOC_CN_L SAP (ALV Reporting: IR Documents for Contract) Structure details

Dictionary Type: Structure
Description: ALV Reporting: IR Documents for Contract




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




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

REIS_REDOC_CN_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: IR Documents for Contract" 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_REDOC_CN_L TYPE REIS_REDOC_CN_L.

The REIS_REDOC_CN_L table consists of various fields, each holding specific information or linking keys about ALV Reporting: IR Documents for Contract data available in SAP. These include MANDTCN (Client), INTRENOCN (Internal Key of Real Estate Object), BUKRSCN (Company Code), RECNNRCN (Contract 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_REDOC_CN_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
.INCLU-CN 0
MANDTCNClient MANDTCLNT3Assigned to domainMANDT
INTRENOCNInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
BUKRSCNCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RECNNRCNContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
OBJNRCNObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IMKEYCNInternal Key of Real Estate Object (FI) RECAIMKEYCHAR8IMKEYIMKEYRECLFXCAIMKEY
CREATIONTYPECNHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFCNEntered by RERFCHAR12SYCHAR12
DERFCNFirst Entered on DERFDATS8DATUM
TERFCNTime of Initial Entry TERFTIMS6TIMES
REHERCNSource of initial entry REHERCHAR10CHAR10
RBEARCNEmployee ID RBEARCHAR12SYCHAR12
DBEARCNLast Edited on DBEARDATS8DATUM
TBEARCNLast Edited at TBEARTIMS6TIMES
RBHERCNEditing Source RBHERCHAR10CHAR10
RESPONSIBLECNPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVECNUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPCNAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
RECNTYPECNContract Type RECNCONTRACTTYPECHAR4TIV26SMVARTRECNTYPERECNCONTRACTTYPE
RECNBEGCNDate of contract start RECNCNBEGDATS8RECADATE
RECNENDABSCNTerm End Date RECNCNENDABSDATS8REDATRECADATEEND
RECNTXTCNContract name RECNTXTCHAR80XTEXT80
RECNDACTIVCNContract activation DAKTVDATS8DATUM
RECNTLAWCNTenancy law SMIETRCHAR5TIV03SMIETR
RECNTXTOLDCNNumber of old contract VVOSMIVECHAR20ALPHAVVOSMIVE
RECNBUKRSCOLLECTCNCompany code of main contract RECNBUKRSCOLLECTCHAR4T001BUKRS
RECNNRCOLLECTCNNumber of Real Estate Main Contract RECNNUMBERCOLLECTCHAR13ALPHARECNNUMBERRECNNR
RECNCNCURRCNCurrency for Contract RECNWAERS_CNCUKY5Assigned to domainWAERSFWS
INDUSTRYCNIndustry BU_IND_SECTORCHAR10Assigned to domainBU_INDSECTOR
SRRELEVANTCNRelevant to Sales RECNSALESRENTRELEVANTCHAR1RECABOOL
DPTARGETTYPECNSecurity Deposit Type RECNDPTYPECHAR4TIVCNDPTYPEALPHARECNDPTYPE
RECNDATCNDate of Contract Conclusion RECNDATDATS8DDAT
RECN2DATCNDate of Second Signature RECN2DATDATS8RECADATE
RECNDPOCNCash Flow Generated Starting On RECDCFSTARTFROMDATS8RECADATE
RECNEND1STCNDate of First Contract End RECNCNEND1STDATS8RECADATE
RECNNOTPERCNContract Notice Per RECNNTPERDATS8RECADATE
RECNNOTRECEIPTCNDate of receipt of notice RECNNTRECEIPTDATS8RECADATE
RECNNOTREASONCNReason for Notice RECNNTREASONNUMC2TIVCNNTRERECNNTREASONRECNNTREASON
RECNDAKTKUCNNotice: Date of Activation RECNNTACTIVATEDONDATS8RECADATE
CFARCHIVEDTOCNDate Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTODATS8RECADATE
CFLOCKEDTOCNDate Until Which the Cash Flow Is Locked RECDCFLOCKEDTODATS8RECADATE
CFPOSTINGFROMCNFirst Posting From RECDCFPOSTINGFROMDATS8RECADATE
BENOCNCNSite That Belongs to Contract RECNBENOCNCHAR8Assigned to domainSWENRREBDBENOREBDBENO
TRANSPOSSFROMCNTransfer of Possession: Start Date RECNTRANSPOSSFROMDATS8RECADATEBEG
TRANSPOSSTOCNTransfer of Possession: End Date RECNTRANSPOSSTODATS8REDATRECADATEEND
HASMULTIASSIGNCNMultiple Assignment of Object to Group Allowed REBDHASMULTIASSIGNCHAR1RECABOOL
POSSDATEFROMCNDate From Which the Object Is Made Available for Use REBDPOSSDATEFROMDATS8RECADATE
POSSDATETOCNDate Up to Which the Object Is Used REBDPOSSDATETODATS8RECADATE
.INCLU--AP 0
SECDEPRELEVANTCNRelevant to Security Deposit REXCESCDRELCHAR1XFELD
NOTADJSDCNCNNo Data Update in Security Deposit Contract REXCESCDNOTADJCHAR1RECABOOL
.INCLU--AP 0
REYCMAJORCNCNCAM Major Contract REYCMAJORCNCHAR13ALPHARECNNUMBER
REYCDEDUCTMEASCNDeduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEASCHAR1RECABOOL
REYCMAJORTNTCNMajor Tenant Contribution Indicator REYCMAJORTNTCHAR1RECABOOL
REYCISSUECREDITCNIssue Credit REYCISSUECREDITCHAR1REYCISSUECREDIT
REYCPOSDATERELCNPossession Date Relevant REYCPOSDATERELCHAR1RECABOOL
XRECNNRCOLCNContract name RECNTXTCHAR80XTEXT80
XBUKRSCNName of Company Code or Company BUTXTCHAR25TEXT25
XRECNTYPECNDescription of type of RE contract type XMVARTMCHAR30XMBEZ
GSBERCNBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRCNProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KOSTLCNCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNRCNOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
XTENANCYLAWCNTenancy law long text XMIETRCHAR50XTEXT50
XCOLLECTCNContract name RECNTXTCHAR80XTEXT80
XAUTHGRPCNDescription of Authorization Group RECAXAUTHGRPCHAR60RECAXLDESCRIPTION
XINDUSTRYCNIndustry Name RECNINDUSTRYCHAR20TEXT20
XTRANSPOSSPERIODCNProductive Holdings: Time Period RECNXTRANSPOSSPERIODCHAR30RECAXMDESCRIPTION
DOCGUIDGUID: Unique Internal Key for RE Document RERADOCGUIDRAW16VIRADOCRECAGUID
ITEMNOAccounting Document Line Item Number POSNR_ACCNUMC10POSNR_ACC
REFITEMNOReference to Other Item Number of Document RERAREFITEMNONUMC10POSNR_ACC
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ITEMTYPEItem Category RERAITEMTYPECHAR2CHAR02
REFDATEReference Date for Settlement DABRBEZDATS8DDAT
PROCESSProcess RECAPROCESSCHAR4Assigned to domainRECAPROCESSRECAPROCESS
PROCESSGUIDGeneric Key of Process RECAPROCESSGUIDRAW16RECAGUID
CLEARINGSTATUSClearing status RERACLEARINGSTATUSCHAR2CHAR02
CLEARNGPROCESSIDProcess Identification -> Accounting Reference Number RECAPROCESSIDCHAR16RECAPROCESSID
PAYEDSTATUSPayment Status RERAPAYEDSTATUSCHAR2CHAR02
DUNNINGSTATUSDunning Status RERADUNNINGSTATUSCHAR2CHAR02
REFGUIDORIGINSource of GUID RERAGUIDORIGINCHAR4CHAR04
REFGUIDReference GUID RERAREFGUIDRAW16RECAGUID
OBJNRAccount Assignment: Object Number RERAOBJNRCHAR22Assigned to domainJ_OBJNR
PFROMStart of Calculation Period DBERVONDATS8DATUM
PTOEnd of Calculation Period DBERBISDATS8DATUM
BLINEDATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ORIGDUEDATEOriginal Due Date RECDORIGDUEDATEDATS8DATUM
CONDTYPECondition Type RECDCONDTYPECHAR4TIVCDCONDTYPEALPHARECDCONDTYPE
ISADVANCEPAYMENTCondition Is Advance Payment Condition RECDADVANCEPAYMENTCHAR1RECABOOL
FLOWTYPEFlow Type RECDFLOWTYPECHAR4TIVCDFLOWTYPEALPHARECDFLOWTYPE
DCINDICATORDebit/Credit Indicator RERADCINDICATORCHAR1RERADCINDICATOR
TAXGROUPIDGroup Indicator for Tax Line Items RERATAXGROUPIDNUMC3NUM03
TAXDATEDate of Tax Calculation RERATAXDATEDATS8RECADATE
TERMNOOATerm Number RETMTERMNOCHAR4ALPHARETMTERMNO
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
ADDOBJNRObject Number for Additional Account Assignment RERAADDOBJNRCHAR22Assigned to domainJ_OBJNR
FUNDFund RERAFUNDCHAR24CHAR24
FUNDSCENTERFunds Center RERAFUNDSCENTERCHAR24CHAR24
COMMITMENTITEMCommitment Item RERACOMMITMENTITEMCHAR24Assigned to domainFMCILFM_FIPEX
FUNCTIONALAREAFunctional Area RERAFUNCTIONALAREACHAR24CHAR24
GRANTNUMBERGrant RERAGRANTNUMBERCHAR24CHAR24
MEASUREProgram in Funds Management RERAMEASURECHAR24CHAR24FM_MEASURE
BUDGETPERIODFM: Budget Period RERABUDGETPERIODCHAR24CHAR24BUDPER
TERMNOPYTerm Number RETMTERMNOCHAR4ALPHARETMTERMNO
CDSPLITNONumber of Condition Split RETMCDSPLITNONUMC4NUMC4
PYMTMETHPayment Method RERAPYMTMETHCHAR4CHAR4
PYMTMETHCRMOPayment Method for Credit Memos RERAPYMTMETHCRMOCHAR4CHAR4
PYMTBLOCKPayment block key RERAPYMTBLOCKCHAR4CHAR4SPE
PYMTTERMTerms of Payment Key RERAPYMTTERMCHAR4ZTERM
HOUSEBKIDKey for House Bank RERAHOUSEBKIDCHAR15CHAR15
HOUSEBKACCKey for House Bank Account RERAHOUSEBKACCCHAR15CHAR15
BANKDETAILIDBank Details ID RERABANKDETAILIDCHAR15CHAR15
NOTETOPAYEENote to Payee RERANOTETOPAYEECHAR25RERANOTETOPAYEE
DUNNAREADunning Area RERADUNNAREACHAR4CHAR4
DUNNKEYDunning Keys RERADUNNKEYCHAR4CHAR4
DUNNBLOCKDunning Block RERADUNNBLOCKCHAR4CHAR4
ACCDETKEYAccount Determination Value RERAACCDETKEYCHAR10Assigned to domainRERAACCDETKEY
TAXTYPETax Type RERATAXTYPECHAR4TIVRATAXTYPERERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20TIVRATAXGROUPRERATAXGROUP
ISGROSSCondition Amount Is Gross Amount RECDISGROSSCHAR1RECABOOL
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNEROBJNRObject Number for Internal Use RETMPARTNEROBJNRCHAR22Assigned to domainJ_OBJNRONR
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
ISCDSPLITCondition Split RETMISCDSPLITCHAR1RECABOOL
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
ISPARTNERBLOCKEDLock of Partner Data in Posting Term RERAISPARTNERBLOCKEDCHAR1RECABOOL
SEPAMNDIDSEPA Mandate: Unique Reference to Mandate per Vendor RETMSEPAMNDIDCHAR35RETMSEPAMNDID
SEPARECCRDIDSEPA Mandate: Creditor ID RETMSEPARECCRDIDCHAR35RETMSEPACRDID
TERMNOWTTerm Number RETMTERMNOCHAR4ALPHARETMTERMNO
ACCTYPEAccount Type RERAACCTYPECHAR1RERAACCTYPE
GLACCSYMBAccount Determination: Account Symbols RERAGLACCSYMBCHAR15Assigned to domainRERAGLACCSYMB
GLACCOUNTGeneral Ledger Account RERAGLACCOUNTCHAR10RERAGLACCOUNT
AMOUNTAmount in Transaction Currency RERAAMOUNTCURR15(2) RECACURR
GROSSAMOUNTGross Amount in Transaction Currency RERAGROSSAMOUNTCURR15(2) RECACURR
NETAMOUNTNet Amount in Transaction Currency RERANETAMOUNTCURR15(2) RECACURR
TAXAMOUNTTax Amount in Transaction Currency RERATAXAMOUNTCURR15(2) RECACURR
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CTLCAMOUNTAmount in Local Currency RECACTLCAMOUNTCURR15(2) RECACURR
CTLCGROSSAMOUNTGross Amount in Local Currency RECACTLCGROSSAMOUNTCURR15(2) RECACURR
CTLCNETAMOUNTNet Amount in Local Currency RECACTLCNETAMOUNTCURR15(2) RECACURR
CTLCTAXAMOUNTTax Amount in Local Currency RECACTLCTAXAMOUNTCURR15(2) RECACURR
CTLCCURRKEYLocal Currency RECACTLCCURRKEYCUKY5Assigned to domainWAERS
CTFCAMOUNTAmount in Foreign Currency RECACTFCAMOUNTCURR15(2) RECACURR
CTFCGROSSAMOUNTGross Amount in Foreign Currency RECACTFCGROSSAMOUNTCURR15(2) RECACURR
CTFCNETAMOUNTNet Amount in Foreign Currency RECACTFCNETAMOUNTCURR15(2) RECACURR
CTFCTAXAMOUNTTax Amount in Foreign Currency RECACTFCTAXAMOUNTCURR15(2) RECACURR
CTFCCURRKEYForeign Currency RECACTFCCURRKEYCUKY5Assigned to domainWAERS
TAXRATETax Rate RERATAXRATEDEC7(3) PRZ43V
EXTTAXCODETax Code of the Accounting System RERATAXCODECHAR5
EXTREF1External Reference 1 (Line Item) RERAEXTREF1CHAR60
EXTREF2External Reference 2 (Line Item) RERAEXTREF2CHAR60
EXTREF3External Reference 3 (Line Item) RERAEXTREF3CHAR60
EXTREF4External Reference 4 (Line Item) RERAEXTREF4CHAR60
.INCLU-HD 0
MANDTHDClient MANDTCLNT3Assigned to domainMANDT
DOCGUIDHDGUID: Unique Internal Key for RE Document RERADOCGUIDRAW16RECAGUID
PSTNGPROCEDUREHDPosting Procedure RERAPROCEDURECHAR4TIVRAPROCEDURERERAPROCEDURE
PROCESSHDProcess RECAPROCESSCHAR4TIVCAPROCESSRECAPROCESSRECAPROCESS
PROCESSGUIDHDGeneric Key of Process RECAPROCESSGUIDRAW16RECAGUID
PROCESSIDHDProcess Identification -> Accounting Reference Number RECAPROCESSIDCHAR16RECAPROCESSID
FISC_YEARHDFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PSTNGPERIODHDPosting Period RERAPSTNGPERIODNUMC2RERAFISCALPERIOD
PSTNGDATEHDPosting Date RERAPSTNGDATEDATS8RECADATE
DOCDATEHDDocument Date RERADOCDATEDATS8RECADATE
ACCSYSTYPEHDType of Accounting System RERAACCSYSTYPECHAR4RERAACCSYSTYPE
REFDOCIDHDReference Key of Document RERAREFDOCIDCHAR20CHAR20
LOGSYSTEMHDLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
REVIDHDIndicator for Reversed Documents RERAREVIDCHAR1RERAREVID
REVDOCGUIDHDGUID: Internal Key for Accompanying Reversal Document RERAREVDOCGUIDRAW16RECAGUID
STATUSHDRE Document Status RERASTATUSCHAR1BSTAT
TAXIDHDTax Exists RERATAXIDCHAR1CHAR1
HASGLACCSYMBHDIndicator: Account Symbol RERAHASGLACCSYMBCHAR1RECABOOL
REFERENCEDOCGUIDHDReference GUID RERAREFGUIDRAW16RECAGUID
RERFHDEntered by RERFCHAR12SYCHAR12
DERFHDFirst Entered on DERFDATS8DATUM
TERFHDTime of Initial Entry TERFTIMS6TIMES
REHERHDSource of initial entry REHERCHAR10CHAR10
RBEARHDEmployee ID RBEARCHAR12SYCHAR12
DBEARHDLast Edited on DBEARDATS8DATUM
TBEARHDLast Edited at TBEARTIMS6TIMES
RBHERHDEditing Source RBHERCHAR10CHAR10
FDELETEHDDeletion Indicator for Archiving RECAARDELETEINDCHAR1RECABOOL
CTRULEHDCurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTRATEHDExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
POSTCDCURRHDPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
CTDATEREQHDPlanned Translation Date RECACTDATEREQDATS8DATS
CTDATEACTHDActual Translation Date RECACTDATEACTDATS8DATS
CTFCCURRKEYHDForeign Currency RECACTFCCURRKEYCUKY5Assigned to domainWAERS
GEN_OBJTYPEObject Type RECAOBJTYPECHAR2Assigned to domainJ_OBARTRECAOBJTYPE
GEN_OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
GEN_CONTRACTObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
GEN_PARTNER1Business Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
GEN_PARTNER2Business Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ALVROWSNumber of Rows REISALVROWSINT25
OBJECTIDObject ID REISOBJECTIDCHAR40
OBJIDENTComplete Object Identification, for Example BE 1000/123 RECAIDENTCHAR50CHAR50
CONDTYPIDENTName of Condition Type RECDXCONDTYPEMCHAR20TEXT20
FLOWTYPIDENTName of Flow Type RECDXFLOWTYPECHAR30TEXT30
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
XPARTNERName/Address of Business Partner REBPXPARTNERCHAR80TEXT80

Key field Non-key field



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

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

How to access SAP table REIS_REDOC_CN_L

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