Symptom
There is an issue with the aggregation key when running JP_WHT_WHITERETURN report. Even though no aggregation key has been assigned to the tax code, the report still displays a value in the “Details” column indicating the number of times.
Environment
SAP S/4HANA Cloud Public Edition.
Reproducing the Issue
- Run Statutory Reports ID:F1515.
- Set parameters as below:
- Company code: XYZ
- Reporting year: 2025
- Report name: JP_WHT_WHITERETURN Japan Withholding Tax - White Returns
- Click in Go.
- Choose the Japan Withholding Tax - White Returns (Submission Due Date 01/31/2026).
- Choose the run No.X.
- Click the TXT or PDF file from Legal Reporting section, There are several data for different BPs.
- Check the report data: you can see the description is "3 times".
Resolution
Find below the explanation of the behavior of the Japan White Returns Report based on the selected "Official Withholding Tax Key".
-
When "SUM2" is selected in the Official Withholding Tax Key field of the withholding tax type, the SGTXT field (item text) from the payment document will be displayed in the “Details” field of both the PDF form and the output file.
In this case, aggregation occurs at the level of tax type, tax code, and SGTXT of the payment document.
-
When other than value "SUM2" is selected (including blank value), the number of payment occurrences is displayed under the “Details” field in the form and file.
Here, aggregation is performed at the tax type and tax code level only.
Supplier Payment item text(SGTXT of payment document) Base amount TDS Tax type Tax code
ABC 1 Payment1 10000 100 P1 10
ABC 2 20000 200 P1 10
ABC 3 10000 100 P1 10
ABC. 4 Payment4 10000 100 P2 20
Form output when official tax code key is 'SUM2'
Details Classification Payment amount WHT
Tax code 10 desc Payment1 10000 100
Tax code 10 desc 30000 300
Tax code 20 desc Payment4 10000 100
Form output when official tax code key is 'SUM1'
Details Classification Payment amount WHT
Tax code 10 desc 3 times 40000 400
Tax code 20 desc 1 times 10000 100
Keywords
JP_WHT_WHITERETURN ; SGTXT; SUM;SUM1;SUM2; , KBA , FI-AP-AP-Q1 , Withholding Tax (Reporting) , Problem