SAP SAPLFDBA_DOCUMENT_ITEM TR-LO: Item of Open Items List (List Tool) Table data and field list

SAPLFDBA_DOCUMENT_ITEM 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 "TR-LO: Item of Open Items List (List Tool)" 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_SAPLFDBA_DOCUMENT_ITEM TYPE SAPLFDBA_DOCUMENT_ITEM.

The SAPLFDBA_DOCUMENT_ITEM table consists of various fields, each holding specific information or linking keys about TR-LO: Item of Open Items List (List Tool) data available in SAP. These include BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (Contract Number), VBEWA (Flow Type)... 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. .

SAPLFDBA_DOCUMENT_ITEM structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP SAPLFDBA_DOCUMENT_ITEM structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SAPLFDBA_DOCUMENT_ITEM table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MARKEDCheckbox XFELDCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SARCHIVArchiving Category Indicator SARCHIVCHAR1SARCHIVARC
RANLContract Number RANLCHAR13ALPHARANLRAN
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
VBEWA_TXTChar 20 CHAR20CHAR20CHAR20
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZTFollow-On Document Type REBZTCHAR1REBZT
ZLSPRPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
SGTXTItem Text SGTXTCHAR50TEXT50
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
ZUONRAssignment Number DZUONRCHAR18ZUONR
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ

Key field Non-key field



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

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

How to access SAP table SAPLFDBA_DOCUMENT_ITEM

Within an ECC or HANA version of SAP you can also view further information about SAPLFDBA_DOCUMENT_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).