SAP Knowledge Base Article - Public

3088680 - No value in field Reference 1 in app Display Line Items in General Ledger

Symptom

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.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  1. Go to app Display Line Items in General Ledger
  2. Specify the input parameters
  3. Click on Go
  4. Reference 1 does not contain value at the output
  5. Select the Journal Entry and navigate to app Manage Journal Entries
  6. Reference 1 displays value

Cause

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.

Resolution

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.

See Also

Creating Data Source Extensions

Keywords

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 , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem

Product

SAP S/4HANA Cloud all versions