In app Display Line Items in General Ledger, the Reference 1 field at the output is not displaying the value. The field is however populated with value on navigating into the journal entry.
SAP S/4HANA Cloud
Reproducing the Issue
- Go to app Display Line Items in General Ledger
- Specify the input parameters
- Click on Go
- Reference 1 does not contain value at the output
- Select the Journal Entry and navigate to app Manage Journal Entries
- Reference 1 displays value
The Data Source Extension (DSE) uses the association to AccountingDocument to expose the field Reference 1 from the header table (C_JournalEntryItemBrowserResult.AccountingDocument.Reference1InDocumentHeader). However, for the specific document, the underlying database table entries does not contain the value for Reference 1. The referenced value is persisted on item level only. That's why the reporting application cannot show them. It is seen in app Manage Journal Entries, when navigating on item level.
The appropriate source for reading the Reference 1 and Reference 2 values is AccountingDocumentItem. The field 'Reference 1 ID By Business Partner' needs to be added from the item table via DSE (C_JournalEntryItemBrowserResult.AccountingDocumentItem.Reference1IDByBusinessPartner). This field then needs to be added to the table display in the app Display Line Items in General Ledger.
Data Source Extension, FI-FIO-GL-IS, S4_PC, Display Line Items in General Ledger, Reference 1, Manage Journal Entries, Reference 1 ID By Business Partner, AccountingDocumentItem, AccountingDocument , KBA , FI-FIO-GL-IS , Reporting Apps , Problem