SAP Knowledge Base Article - Public

3720965 - DRC Peru - Fiscal ID and Type of Fiscal ID fields are missing in Sales Ledger report

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

  1. Go to Run Statutory reports app.
  2. Run the Peru Sales Ledger report - PE_SALES_LEDGER.
  3. 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

Product

SAP S/4HANA Cloud Public Edition all versions