Symptom
- The xxx/xxx exchange rate for the date MM/DD/YYYY is incorrect from Refinitiv data option.
- The Refinitiv data option offers four property options: ASK, BID, MID, CLOSE, none of which match the rate provided by the XXX Bank.
Environment
SAP S/4HANA Cloud Public Edition.
Reproducing the Issue
- Run the application "Request Historical Market Data - Datafeed".
- Verify the rate fetched by the system.
- Compare the fetched rate with the expected rate from XXX Bank.
Cause
- There is a portion that requires accuracy down to the minute because exchange rates themselves fluctuate, which can lead to discrepancies.
- It is also possible that the target bank uses a data source other than Refinitiv data option, which can also result in discrepancies.
Resolution
- Confirm the specific time period for which the target bank provides the target rate.
- Identify which property option (ASK, BID, MID, CLOSE) corresponds to the rate provided by the target bank.
- Adjust the system configuration to align with the correct property option and time period.
If the rate still does not match, use the BYOR (Bring Your Own Rate) data option to upload the rate from your end.
See Also
Refer to: Refinitiv Data Option for supported property ID for each currency pair.
Refer to: Set Up Connectivity | Help Portal for set up connectivity between S/4HANA Public Cloud and BYOR data option.
Keywords
Exchange rate, historical market data, property ID, ASK, BID, MID, CLOSE, datafeed, SAP S/4HANA Cloud Public Edition, treasury management, rate retrieval, external bank. , KBA , FIN-FSCM-TRM-BF-2CL , Basic Functions (Public Cloud) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public