SAP Knowledge Base Article - Public

3580925 - Discrepancy between SSCUI Screen and Downloaded File Values for Payment Transactions

Symptom

  • A discrepancy is observed between the value displayed on the SSCUI and the value in the downloaded data file.
  • The issue specifically pertains to the currency JPY.
  • The value intended to be registered is "123,45 JPY".
  • The value displayed on the screen is "123,45 JPY", while the value in the downloaded data file is "123.45 JPY".

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Access the SSCUI 101045 or 104404
  2. Maintain the amount in the SSCUI for currency JPY.
  3. To export to Excel file follow Menu -> Table view -> Export spreadsheet -> Contents
  4. Check the values in the downloaded excel file.

Cause

The JPY currency doesn't have any decimal value. For currency JPY, only an integer value can be maintained in the amount field, like '12345'.  But all the amount fields in backend tables have the same field type, no matter the currency is 'JPY' or 'USD'. So the amount will be divided by 100 and saved to database in case of 'JPY' currency. That means, the table only stores '123.45' and 'JPY'. When the values maintained in the SSCUI is download to the spreadsheet, actually the raw data from database is being downloaded. This is the reason for the discrepancy. 

Resolution

The values maintained in the SSCUI takes effect during the calculation. The values in the downloaded file can be ignored and the values in the SSCUI should be considered.

Keywords

SSCUI 101045, Bank Determination, Payment Transactions, Discrepancy, Screen Value, Downloaded File Value, JPY, Configuration, TO-BE Setting. , KBA , FI-AP-AP-B-2CL , Payment Progam / Payment transfer (DE, JP, US) (Public Cld) , FI-AP-AP-Q-2CL , Withholding Tax (Calculation) (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions