3735864 - Error "one of the exchange rates is negative or too great" when uploading Indirect Exchange Rates via API-CURRENCYEXCHANGERATE to BTP - SAP S/4HANA Cloud Public Edition

• Error message displayed during upload: "One of the exchange rates is negative or too great".
• The error occurs when indirect quoted exchange rates (for example, represented with '-' or '/') are transferred via API_CURRENCYEXCHANGERATE from S/4HANA Cloud to BTP.

SAP S/4HANA Cloud Public Edition

The issue arises because SAP BTP does not support indirect exchange rate quotations that use the ’-‘ symbol (e.g., AAA:BBB = -1.02). This leads to validation errors or incomplete data processing when such rates are uploaded.

To address this issue, the following workaround is recommended:

1. Convert Indirect Exchange Rates:

Transform all indirect exchange rates to direct exchange rates by taking the reciprocal values. For example:
Convert AAA:BBB = -1.02 to BBB:AAA = 1.02.

2. Prepare Data for SAP BTP Upload:

Ensure that only direct exchange rates are uploaded or transferred to SAP BTP (e.g., BBB:AAA = 1.02).

API-CURRENCYEXCHANGERATE, Indirect Exchange Rate, Negative Exchange Rate, BTP upload error, One of the exchange rates is negative or too great, Hyphen in exchange rate, TRM, Exchange rate import, validation error, exchange rate transformation , KBA , FIN-FSCM-TRM-2CL , Treasury and Risk Management (Public Cloud) , Problem