SAP Knowledge Base Article - Public

3155716 - Data in the Column Supplier Tax ID in the Report 'Withholding Tax Items' is Not Shown as Your Expectation


You are checking the data of Supplier tax ID in the report 'Withholding Tax Items'. However, the data is not shown as your expectation.


SAP Business ByDesign

Reproducing the Issue

  1. Go to Tax Management Work Center.
  2. Go to Reports View.
  3. Find and open report: Withholding Tax Items.
  4. Enter below values: Company ABC, Tax Country/Region XX, Supplier HIJ.(ABC stands for the Company ID, XX stands for Country/Region, HIJ stands for the Supplier ID)
  5. Click Apply
  6. Add field Supplier Tax ID to the report.
  7. You can see, for supplier HIJ, the Supplier Tax ID is YYYYYYYYYY.

To check the tax number you maintained for the suppliers:

  1. Go to Payables Workcenter.
  2. Go to Suppliers View.
  3. Find and open Supplier HIJ
  4. Go to Tab Financial data, sub tab Tax Data.
  5. You can see for Country/Region XX, there are two lines:
  • Country/ Region XX, Tax Type DD, Tax Number YYYYYYYYYY.
  • Country/ Region XX, Tax Type EE, Tax Number XXXXXXXXXX.

You expect the system to pick XXXXXXXXXX in the report 'Withholding Tax Items'.


This report only picks first tax number if multiple are maintained in the supplier's master data.


The workaround is:

  1. Remove the undesired tax number in the supplier financial data.
  2. Run the report and download the needful reports.
  3. Maintain the tax number again. 


Withholding Tax Items. Supplier Tax ID. Incorrect. Unexpected. , KBA , SRD-FIN-GLO-TAX , GLO - Tax Declaration , Product Enhancement


SAP Business ByDesign all versions