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
- Attempt to load the currency exchange rate values into S/4HANA Cloud Public Edition.
- 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):
- Adjust the uploading value in the file to 13173921.
- Maintain the SAP currency translation ratio for it with the value 1:10000.
- When uploading the value '1' for USD/VEF, it will represent 1 USD = 10000 * 1 VEF.
- 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
SAP Knowledge Base Article - Public