SAP Knowledge Base Article - Public

3645480 - Error "Value *** is too big, max. 4 No place." when uploading exchange rate by BYOR data option - SAP S/4HANA Cloud Public Edition

Symptom

  • Error "Value *** is too big, max. 4 No place.".
  • Unable to upload exchange rate by BYOR data option.
  • Due to the restriction of field length of ratio.

Environment

SAP S/4HANA Cloud Public Edition.

 

Reproducing the Issue

  1. Attempt to load the currency exchange rate values into S/4HANA Cloud Public Edition.
  2. Observe that the system only accepts rate entries with 4 decimal places, negating the opportunity to add rates requiring higher precision.

Cause

The FX rate table has limitations on numeric values, restricting entries to 4-digit numbers with 5 decimal places.

Resolution

Use the SSCUI "Define Translation Ratios for Currency Translation" (ID: 102568) to update the SAP currency translation ratio and enlarge the data transfer scale.

For example, for the currency pair USD/VEF (1:13173921):

  1. Adjust the uploading value in the file to 13173921.
  2. Maintain the SAP currency translation ratio for it with the value 1:10000.
  3. When uploading the value '1' for USD/VEF, it will represent 1 USD = 10000 * 1 VEF.
  4. Adjust the value in the uploading file to 1317.3921, which will represent 1 USD = 1317.3921 * 10000 VEF.

Evaluate this workaround method carefully for each currency pair, especially for those not provided with standard translation ratios by SAP.

See Also

Refer to KBA 3450053 - How To Maintain Currency Translation Ratios.

Keywords

Exchange rate table, 4 decimal places, sap s/4hana cloud public edition, fx rate limitation, currency translation ratio, define translation ratios, numeric limitation, usd sle exchange rate, 1:10000 ratio, penalty exposure, SSCUI 102568, Define Translation Ratios for Currency Translation. , KBA , FIN-FSCM-TRM-BF-2CL , Basic Functions (Public Cloud) , BC-SRV-BSF-CUR-2CL , Currency translation / Expiring currencies (Public Cloud) , Known Error

Product

SAP S/4HANA Cloud Public Edition all versions