SAP Knowledge Base Article - Public

3621065 - JP_WHT_WHITERETURN - aggregation key is not displaying correctly

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

  1. Run Statutory Reports ID:F1515.
  2. Set parameters as below:
    • Company code: XYZ
    • Reporting year: 2025
    • Report name: JP_WHT_WHITERETURN Japan Withholding Tax -  White Returns
    • Click in Go.
  3. Choose the Japan Withholding Tax - White Returns (Submission Due Date 01/31/2026).
  4. Choose the run No.X.
  5. Click the TXT or PDF file from Legal Reporting section, There are several data for different BPs.
  6. 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

Product

SAP S/4HANA Cloud Public Edition all versions