Symptom
The Fiscal ID and Type of Fiscal ID fields are empty in the Peru Sales Ledger report.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Go to Run Statutory reports app.
- Run the Peru Sales Ledger report - PE_SALES_LEDGER.
- Observe that the Fiscal ID and Type of Fiscal ID fields are empty.
Cause
A possible cause of the issue is that the Tax Number maintained is for a country which is different than the Business Partner's country.
Resolution
If the Tax Number maintained is for a country which is different than the BP country maintained, then KNA1 and LFA1 tables would not store tax numbers. Hence, in such scenarios, CDS Views I_CUSTOMER and I_SUPPLIER would return blank values.
See Also
Refer to: KBA 2797772 - S/4HC: How to access Business Partner Tax Number via CDS views.
Keywords
fiscal id, type of fiscal id, peru sales ledger, statutory report tax number, tax number type, kna1 table, business partner master data, PE_SALES_LEDGER_V0, I_Customer, stcdt, stcd1, PE_SALES_LEDGER , KBA , FI-LOC-FI-PE-ACR , Statutory Reporting , Problem
SAP Knowledge Base Article - Public