SAP SAPLFDBA_DOCUMENT_ITEM_PI TR-LO: Planned Record List (List Tool) Table data and field list

SAPLFDBA_DOCUMENT_ITEM_PI 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: Planned Record 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_PI TYPE SAPLFDBA_DOCUMENT_ITEM_PI.

The SAPLFDBA_DOCUMENT_ITEM_PI table consists of various fields, each holding specific information or linking keys about TR-LO: Planned Record List (List Tool) data available in SAP. These include BUKRS (Company Code), RANL (Contract Number), KUNNR (Customer Numbers), HDN_KUNNR (Main Borrower Customer 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. .

SAPLFDBA_DOCUMENT_ITEM_PI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP SAPLFDBA_DOCUMENT_ITEM_PI 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_PI 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
RANLContract Number RANLCHAR13ALPHARANLRAN
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
HDN_KUNNRMain Borrower Customer Number HDN_KUNNRCHAR10Assigned to domainALPHAKUNNR
XSCHWEBESingle-Character Indicator CHAR1CHAR1CHAR1
SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
XBEWARTName of flow type XBEWARTCHAR30TEXT30
DFAELLDue date/calculation date DFAELLIGDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
BBWHRAmount in position currency BBWHRCURR13(2) WERTV7
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
BHWHRAmount in local currency BHWHRCURR13(2) WERTV7
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
JVORAUSID for planned record reference to an advance payment VVJVORAUSCHAR1KENZX
JEINBEHALTIndicator for withholding of amount during disbursement VVJEINBECHAR1KENZX
SGTXTItem Text SGTXTCHAR50TEXT50
NOTHDNMain borrower indicator VVKZHDNCHAR1XFELD
DTRANSFlow data key: System date VVDTRANSDATS8DATUM
TTRANSTransaction data key: system time VVTTRANSTIMS6UZEIT
NTRANSTransaction data key: Consecutive number VVNTRANSNUMC4NUMC4
SANLFProduct Category SANLFNUMC3Assigned to domainVVSANLF
GSARTProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
SSOLHABDebit/credit indicator VVSSOLHABCHAR1VVSSOLHAB

Key field Non-key field



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

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

How to access SAP table SAPLFDBA_DOCUMENT_ITEM_PI

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

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