How to Maintain Exchange Rates in SAP S/4HANA Cloud
You would always need exchange rates in a financial system.
SAP S/4HANA Cloud offers four ways to update your exchange rates in the system going from 100% manual to 100% automation.
- Manual maintenance of exchange rates in the Currency Exchange Rates app
- Upload exchange rates from file via the Import Foreign Exchange Rates app
Import exchange rates via API using the SAP Market Rate Management Service
Import exchange rates directly from external data provider using the SAP Market Rate Management Service
The simplest way to enter exchange rates is through manual entry. You do this in the Currency Exchange Rates app.
Here you can maintain each pair individually. You can either enter the data from an empty screen or copy an existing rate and update the date and exchange rate.
There is no mass maintenance, so if you have many rates you would want to use the file upload.
Upload from File
If you want to upload the exchange rates from file, you first have to download a template which you find here in the app where you would also upload the file. So, go to Import Foreign Exchange Rates.
Via this template you can also upload interest rates, credit spreads, FX volatilities, and other data needed for the treasury management, but here we just want to look at the exchange rates.
How to fill in the template is described here: https://help.sap.com/viewer/0fa84c9d9c634132b7c4abb9ffdd8f06/latest/en-US/d0006e8b046f4758a59384a88259d1cd.html
Here’s how it could look like:
When you then upload it, the system will give you a log showing you whether the upload was successful.
It is easy to set up but requires that you have a manual process to upload the exchange rate table daily. Apart from that it requires manual work daily to keep the exchange rates up-to-date, auditors could have issues with the file interfaces that could potentially be manipulated by other users.
It’s therefore recommended to use the API for exchange rates which is part of the SAP Market Rate Management Services.
Upload via API
If you already have the exchange rates stored centrally inside your company and now want to automatically update S/4HANA Cloud with these rates daily, you should do it via an API.
There is no API directly in SAP S/4HANA Cloud to upload exchange rates, but you can use the SAP Market Rate Management Services, which is integrated with SAP S/4HANA via an SAP managed communication scenario.
This service can receive exchange rates from two types of sources:
- Bring your own data API
- Market data feed from external source
The “Bring your own data API” is used to upload the data from your intel source. The rates will be stored in this app and several other apps and platforms and then read the data from here.
You can then set up a daily job within SAP S/4HANA Cloud to read the exchange rates from the SAP Market Rate Management Services and automatically fill the exchange rate table without any manual intervention.
However, this depends on whether you have an internal source for the exchange rates. Most rates would come from an external provider, like Refinitiv (previously known as Thompson Reuters) or Bloomberg.
Upload FX Rates Directly from Data Provider
With the SAP Market Rate Management Services, you can also load data directly from the market rate provider and truly use this SAP Cloud Platform app as a central platform for distributing FX rates in a compliant and easy way.
This is the easiest and most secure way to get FX data provided directly to SAP S/4HANA Cloud. All you need to do is to configure the required rates and set up a daily job to import the FX rates from the SCP portal.
Currently we offer two sources: Refinitiv and the European Central Bank (ECB). There might be more options in the future. Please note, however, that you can currently use the ECB rates only for testing purposes but not in your production system.
You don’t need a license with the provider as it is included when you subscribe to getting the data from the SAP Market Rate Management Services.
System overview over SAP Market Rates Management Services:
For more information on the exchange rates, check out the SAP Help Portal under:
Currency Exchange Rates
Import Foreign Exchange Rates
In addition, there’s also a Blog about the SAP Market Rates Management with Youtube tutorials about the setup and many relevant links