SAP Knowledge Base Article - Public

2510961 - Relevant for Withholding Tax Key Figures are Empty in Report

Symptom

In the Monitoring Invoices report (data source SRMIV_B03), you have added the following Key Figures:

  • Gross Amount - Relevant for Withholding Tax
  • Gross Amount in Company Currency - Relevant for Withholding Tax
  • Net Amount - Relevant for Withholding Tax
  • Net Amount in Company Currency - Relevant for Withholding Tax
  • Tax amount - Relevant for Withholding Tax
  • Tax amount in Company Currency - Relevant for Withholding Tax

When executing the report, no data appears in these fields despite Withholding Taxes being used in Supplier Invoices.

Reproducing the Issue

  1. Go to Supplier Invoicing work center.
  2. Go to Reports view.
  3. Find the report Monitoring Invoices.
  4. In the Invoice ID field, enter ABC (ABC represents the Supplier invoice ID).
  5. Click Go.
  6. Click on Settings - Key Figures.
  7. Add the following to the Selected column: Gross Amount - Relevant for Withholding Tax ; Gross Amount in Company Currency - Relevant for Withholding ; Net Amount - Relevant for Withholding Tax ; Net Amount in Company Currency - Relevant for Withholding Tax ; Tax amount - Relevant for Withholding Tax ; Tax amount in Company Currency - Relevant for Withholding Tax.
  8. Click OK.

No data is displayed in these Key Figure fields.

Cause

The fields marked as Relevant for Withholding Tax are restricted on the field determination level. They only display data when the invoice contains the following data:

  • Tax type: 1 - VAT
  • Tax code: 2

This is the standard system behaviour.

Resolution

Only the Supplier invoices using Tax type: 1 - VAT and Tax code: 2 will display data in the Relevant for Withholding Tax fields of a report.

If you wish to have fields displaying Withholding tax, we recommend that you create Custom Key figures.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711