Upload exchange rates automatically in SAP

This post explains how to upload the exchange rates of transaction OB08 and table TCURR automatically in SAP from the European Central Bank (ECB).

Companies that are required to use the exchange rates published by the European Central Bank (ECB) can use the Upload Exchange Rates from European Central Bank (ECB) transaction RFIMPECB.

Prerequisites

To upload the exchange rates automatically in SAP, you must make settings in SPRO > ABAP Platform > General Settings > Currencies as follows:

1. In the Check Currency Codes Customizing activity, you must enter all the currencies that occur in your business transactions by specifying the currency code, ISO code, and an alternative key for each entry.
2. In the Define Translation Ratios for Currency Translation Customizing activity, you must enter translation ratios for currency translation. You enter these ratios for each exchange rate type and currency pair.
   • The ECB publishes the exchange rates in 1:1 ratio, so we recommend that you enter the 1:1 translation ratio for each exchange rate type and currency pair.

3. In the Define Standard Quotation for Exchange Rates Customizing activity, you must define indirect quotation as the standard quotation for the exchange rate.

Configuration of RFC to connect with the ECB

Go to transaction SM59 and create the follow RFC Connection Type G:

• RFC Destination: ECB
• Connection type: G – HTTP Connection to External Server
• Host: www.ecb.europa.eu
• Path Prefix: /stats/eurofxref/eurofxref-hist-90d.xml?dd68a89343fe57464d9749f08f22354a

• SSL: Active
• SSL Certificate: ANONYM SSL Client (Anonymous)

Are you finding it useful? Help for more content!

Configuration of SSL Certificate

Download the last (29-NOV-2023) RootCA trust anchor certificate from https://web.entrust.com/root-certificates/entrust_ec1_ca.cer to your local workstation / PC.

Go to transaction STRUST to upload and add the above trust anchor certificate to “SSL client (Anonymous)” folder. Click in the folder and then click the “Import Certificate” button under “Certificate” section:

Select the certificate saved in your local workstation / PC.

Upload Exchange Rates from European Central Bank (ECB)

To upload the exchange rates automatically in SAP, go to transaction RFIMPECB and enter data as follows:

• In the Date in Data Source field, enter the date whose exchange rates you want to import into the system.
• If you are required to use the exchange rates that are published for the day you entered in the Date in Data Source field only as of the following day (for example, as of 21.12.2012), select the Valid as of Next Day checkbox.
• In the From Currency field, enter all the currencies whose exchange rates you want to use for currency translation to the target currency that you enter in the To Currency field.
• In the Variance in Percent field, enter the value of the exchange rate differences in percentage that you allow before the report uploads the new exchange rates.
• When you select the Test Run checkbox to execute the report in test or simulation mode, the exchange rates will not be imported.
• In the Data Source group box, enter the RFC connection.
  • If you have downloaded the XML file that contains the required exchange rates for the given date to an application or local server, enter the path to the application/local server and the name of the XML file.

Once you enter all the information described above, save as variant and schedule a job.

Troubleshooting & useful information

1. If you experience connection errors, review SAP Note 1286897 (Import of Exchange Rates from ECB) to ensure that nothing has changed on the European Central Bank side regarding connections and certificates.
2. The reference rates are usually updated at around 16:00 CET every working day, except on TARGET closing days.
3. You can check the currencies available on the website of the European Central Bank (ECB).

Did you find it useful? Help for more content!