REIS_RA_DOC_ITEM_L SAP (Item List) Structure details

Dictionary Type: Structure
Description: Item List




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




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

REIS_RA_DOC_ITEM_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 "Item List" 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_RA_DOC_ITEM_L TYPE REIS_RA_DOC_ITEM_L.

The REIS_RA_DOC_ITEM_L table consists of various fields, each holding specific information or linking keys about Item List data available in SAP. These include DOCITEMID (Coded Key of FI Document Item for RE Internal Use), CUSTOMER (Customer Number), OIACCOUNTTYPE (Account Type), OIACCOUNT (Open Item Account).. 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_RA_DOC_ITEM_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
STATUS_ICONLine Item Status RERASTATUSICONCHAR137RECAICON
DOCITEMIDCoded Key of FI Document Item for RE Internal Use RERADOCITEMIDCHAR30RERADOCITEMID
CUSTOMERCustomer Number RERACUSTOMERNOCHAR10ALPHARERAPARTNERNOKUNC_KUNNR
OIACCOUNTTYPEAccount Type RERAOIACCOUNTTYPECHAR1RERAOIACCOUNTTYPE
OIACCOUNTOpen Item Account RERAOIACCOUNTCHAR20RERAOIACCOUNT
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CONTRACTContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
OBJNRCALCObject Number for Calculation RECDOBJNRCALCCHAR22Assigned to domainJ_OBJNRONR
FISCALYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PSTNGPERIODPosting Period RERAPSTNGPERIODNUMC2RERAFISCALPERIOD
PROCESSIDProcess Identification -> Accounting Reference Number RECAPROCESSIDCHAR16RECAPROCESSID
PSTNGPROCEDUREPosting Procedure RERAPROCEDURECHAR4Assigned to domainRERAPROCEDURE
REFDOCIDReference Key of Document RERAREFDOCIDCHAR20CHAR20
REFITEMNOReference to Other Item Number of Document RERAREFITEMNONUMC10POSNR_ACC
LOGSYSTEMLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
CONDTYPECondition Type RECDCONDTYPECHAR4Assigned to domainALPHARECDCONDTYPE
ISADVANCEPAYMENTCondition Is Advance Payment Condition RECDADVANCEPAYMENTCHAR1RECABOOL
FLOWTYPEFlow Type RECDFLOWTYPECHAR4Assigned to domainALPHARECDFLOWTYPE
PSTNGDATEPosting Date RERAPSTNGDATEDATS8RECADATE
CLEARINGDATEClearing Date RERACLRNGDATEDATS8RECADATE
CLRDOCIDReference Key of Clearing Document RERACLRDOCIDCHAR20CHAR20
DOCDATEDocument Date RERADOCDATEDATS8RECADATE
BLINEDATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
DCDEBITAMOUNTDebit Amount in Local Currency RERADCDEBITAMOUNTCURR15(2) RECACURR
DCCREDITAMOUNTCredit Amount in Local Currency RERADCCREDITAMOUNTCURR15(2) RECACURR
DCBALANCEBalance in Local Currency RERADCBALANCECURR15(2) RECACURR
TAXAMOUNTTax Amount in Local Currency RERADCTAXAMOUNTCURR15(2) RECACURR
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
TCDEBITAMOUNTDebit Amount in Document Currency (Transaction Currency) RERATCDEBITAMOUNTCURR15(2) RECACURR
TCCREDITAMOUNTCredit Amount in Document Currency (Transaction Currency) RERATCCREDITAMOUNTCURR15(2) RECACURR
TCBALANCEBalance in Document Currency (Transaction Currency) RERATCBALANCECURR15(2) RECACURR
TCTAXAMOUNTTax Amount in Document Currency (Transaction Currency) RERATCTAXAMOUNTCURR15(2) RECACURR
TCCURRKEYDocument Currency (Transaction Currency) RERATCCURRKEYCUKY5Assigned to domainWAERS
FCDEBITAMOUNTDebit Amount in Condition Currency RERAFCDEBITAMOUNTCURR15(2) RECACURR
FCCREDITAMOUNTCredit Amount in Condition Currency RERAFCCREDITAMOUNTCURR15(2) RECACURR
FCBALANCEBalance in Condition Currency RERAFCBALANCECURR15(2) RECACURR
FCTAXAMOUNTTax Amount in Condition Currency RERAFCTAXAMOUNTCURR15(2) RECACURR
FCCURRKEYCondition Currency RERAFCCURRKEYCUKY5Assigned to domainWAERS
TAXTYPETax Type RERATAXTYPECHAR4Assigned to domainRERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20Assigned to domainRERATAXGROUP
CLEARINGSTATUSClearing status RERACLEARINGSTATUSCHAR2CHAR02
XMACCTSHEETITEMName of Contract Account Sheet Item RERAXLACCTSHEETITEMCHAR60RECAXLDESCRIPTION
XMACCTSHEETHDRName from Document Header RERAXLACCTSHEETHDRCHAR60RECAXLDESCRIPTION
OBJ_TYPEReference Transaction AWTYPCHAR5Assigned to domainAWTYP
OBJ_KEYReference Key AWKEYCHAR20AWKEY
DUNNBLOCKDunning Block RERADUNNBLOCKCHAR4CHAR4
DUNNKEYDunning Keys RERADUNNKEYCHAR4CHAR4
DUNNDATELast dunned on MADATDATS8DATUM
DUNNLEVELDunning Level RERADUNNLEVELNUMC1MAHNS
DUNNAREADunning Area RERADUNNAREACHAR4CHAR4
PYMTMETHPayment Method RERAPYMTMETHCHAR4CHAR4
PYMTTERMTerms of Payment Key RERAPYMTTERMCHAR4ZTERM
PYMTBLOCKPayment block key RERAPYMTBLOCKCHAR4CHAR4SPE
XPYMTBLOCKExplanation of the Reason for Payment Block TEXTL_008CHAR20TEXT20
NETDTDue Date for Net Payment NETDTDATS8DATUM
CALCFROMStart of Calculation Period DBERVONDATS8DATUM
CALCTOEnd of Calculation Period DBERBISDATS8DATUM
REVIDIndicator for Reversed Documents RERAREVIDCHAR1RERAREVID
DOCTYPEDocument Type RERADOCTYPECHAR2Assigned to domainBLART
TAXAMTINDETERMINABLENot Possible to Determine Unique Tax Amount RERATAXAMTINDETERMINABLECHAR1RECABOOL
SPLGINDSpecial G/L Indicator RERASPLGINDCHAR1
TAXRATETax Rate RERATAXRATEDEC7(3) PRZ43V
TAXDATEDate of Tax Calculation RERATAXDATEDATS8RECADATE
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
HOUSEBKIDKey for House Bank RERAHOUSEBKIDCHAR15CHAR15
HOUSEBKACCKey for House Bank Account RERAHOUSEBKACCCHAR15CHAR15
BANKDETAILIDBank Details ID RERABANKDETAILIDCHAR15CHAR15
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTRATEExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
POSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
CTDATEREQPlanned Translation Date RECACTDATEREQDATS8DATS
CTDATEACTActual Translation Date RECACTDATEACTDATS8DATS
EXTREF1External Reference 1 (Line Item) RERAEXTREF1CHAR60
EXTREF2External Reference 2 (Line Item) RERAEXTREF2CHAR60
EXTREF3External Reference 3 (Line Item) RERAEXTREF3CHAR60
EXTREF4External Reference 4 (Line Item) RERAEXTREF4CHAR60
INVREFNUMBERNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
INVREFYEARFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
INVREFITEMLine Item in the Relevant Invoice REBZZNUMC3BUZEI
SEPAMNDIDSEPA Mandate: Unique Reference to Mandate per Vendor RETMSEPAMNDIDCHAR35RETMSEPAMNDID
SEPARECCRDIDSEPA Mandate: Creditor ID RETMSEPARECCRDIDCHAR35RETMSEPACRDID
XCONDTYPEMName of Condition Type RECDXCONDTYPEMCHAR20TEXT20
XFLOWTYPEName of Flow Type RECDXFLOWTYPECHAR30TEXT30
XTAXTYPEName of Tax Type RERAXMTAXTYPECHAR30RECAXMDESCRIPTION
XTAXGROUPName of Tax Group RERAXMTAXGROUPCHAR30RECAXMDESCRIPTION
IDENTCALCComplete Object Identification, for Example BE 1000/123 RECAIDENTCHAR50CHAR50
PROCESSTITLEProcess Name RECAPROCESSTITLECHAR30RECAXMDESCRIPTION
XDUNNBLOCKReason for dunning block text TEXT1_040TCHAR50TEXT50
XDUNNKEYName of Dunning Key RERAXDUNNKEYCHAR60RECAXLDESCRIPTION
XDUNNAREAName of Dunning Area RERAXDUNNAREACHAR60RECAXLDESCRIPTION
XPYMTMETHName of Payment Method in Language of the Country TEXT1_042ZCHAR30TEXT30
XPYMTTERMOwn Explanation of Term of Payment TEXT1_052CHAR50TEXT50
XREVIDIndicator for Reversed Documents RERAXMREVIDCHAR30RECAXMDESCRIPTION
FIRSTNAMEFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
LASTNAMELast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
BIRTHNAMEName at birth of business partner BU_BIRTHNMCHAR40BU_NAME
MIDDLENAMEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
SECONDNAMEOther Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4TSAD2AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4TSAD2AD_TITLE1
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4TSAD5AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4TSAD4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4TSAD4AD_PREFIX
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
NAMCOUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
SEXSex of business partner (person) BU_SEXIDCHAR1BU_SEXID
BIRTHPLACEBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
BIRTHDATEDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDATEDate of death of business partner BU_DEATHDTDATS8DATUM
MARITALSTATUSMarital Status of Business Partner BU_MARSTCHAR1TB027BU_MARST
CORRESPONDLANGUAGEBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1T002ISOLASPRAS
CORRESPONDLANGUAGEISO2-Character SAP Language Code LAISOCHAR2LAISO
FULLNAMEFull Name BU_NAME1TXCHAR80TEXT80
EMPLOYERName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
OCCUPATIONOccupation/group BU_JOBGRCHAR4Assigned to domainBU_JOBGR
NATIONALITYNationality BU_NATIOCHAR3Assigned to domainLAND1
NATIONALITYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
COUNTRYORIGINCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3Assigned to domainLAND1
NAME1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGALFORMBP: Legal form of organization BU_LEGENTYCHAR2TB019BU_LEGENTYH_TB019
INDUSTRYSECTORIndustry sector BU_INDSECTCHAR10TB023BU_INDSECTH_TB023
FOUNDATIONDATEDate organization founded BU_FOUND_DATDATS8DATUM
LIQUIDATIONDATELiquidation date of organization BU_LIQUID_DATDATS8
LOC_NO_1International location number (part 1) BBBNRNUMC7NUM07
LOC_NO_2International location number (Part 2) BBSNRNUMC5NUM05
CHK_DIGITCheck digit for the international location number BUBKZNUMC1NUM01
LEGALORGLegal Entity of Organization BU_LEGAL_ORGCHAR2Assigned to domainBU_LEGAL_ORG
XPARTNERCompact Display of Address REBPXADDRESSCHAR80REBPXADDRESS
SWENRSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
SGRNRNumber of Land REBDPRNOCHAR8SGRNRREBDPRNOREBDPRNOREBDPRNO
SGENRNumber of Building REBDBUNOCHAR8SGENRREBDBUNOREBDBUNOREBDBUNO
SMENRNumber of Rental Object REBDRONOCHAR8SMENRREBDRONOREBDRONOREBDRONO
OBJTYPEObject Type RECAOBJTYPECHAR2Assigned to domainJ_OBARTRECAOBJTYPE
.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_CNCUKY5TCURCWAERSFWS
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
BENOITEMBusiness Entity Number for Line Item REISRABENOITEMCHAR8Assigned to domainSWENRREBDBENO
CHECKBOXGeneral Yes/No Field RECABOOLCHAR1RECABOOL
ICO_DUENet Due Date Symbol ICO_DUECHAR34ICON_34_2
ROLEBusiness Partner: Role REBPROLECHAR6Assigned to domainBU_ROLE
XROLEName of Business Partner Role REBPXROLECHAR30RECAXMDESCRIPTION

Key field Non-key field



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

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

How to access SAP table REIS_RA_DOC_ITEM_L

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