Symptom
The field "Reporting Ctry/Reg" (EGMLD) is not available in the View Settings of the Manage Supplier Line Items app and cannot be added as a column. The field is required to identify supplier invoices where this value is missing, for statutory reporting compliance purposes.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Manage Supplier Line Items app.
- Click the View Settings button to add a new column.
- Search for "Reporting Ctry/Reg" or EGMLD.
- Observe that the field is not available.
Cause
The field "Reporting Ctry/Reg" (EGMLD) is not persisted in the database. It is only used in the input screen to derive and persist two other fields: DelivOfGoodsDestCountry (EGBLD) and DelivOfGoodsOriginCountry (EGLLD). These derived fields are not supported by the Manage Supplier Line Items and Manage Customer Line Items apps as of now.
Resolution
There are two options:
-
If this functionality is required for the business scenario, a feature request can be raised through the Customer Influence portal. For guidance on submitting a feature request, refer to KBA 2963059 - How to Submit Feature Requests for SAP S/4HANA Cloud Public Edition - SAP for Me.
-
As a workaround, a Custom Analytical Query can be created based on the data source "Operational Journal Entry Item - Cube (I_OPERATIONALACCTGDOCCUBE)" to filter on the fields DelivOfGoodsDestCountry (EGBLD) and VATRegistration (STCEG). For assistance with creating a Custom Analytical Query, contact the local SAP consulting team.
Keywords
Reporting Ctry/Reg, EGMLD, Manage Supplier Line Items, Manage Customer Line Items, DelivOfGoodsDestCountry, EGBLD, DelivOfGoodsOriginCountry, EGLLD, View Settings, statutory reporting, Custom Analytical Query, I_OPERATIONALACCTGDOCCUBE , KBA , FI-FIO-AP-IS-2CL , Reporting Apps: Public Cloud , Problem
SAP Knowledge Base Article - Public