6

Upload ECB Rates to SAP

 1 year ago
source link: https://blogs.sap.com/2022/11/21/upload-ecb-rates-to-sap/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
November 21, 2022 1 minute read

Upload ECB Rates to SAP

Hi All,

There are many ways of updating the FX Rates but in many organizations especially in the EuroZone area, this task occurs on a daily basis.

Now, instead of choosing an option which requires a bit of configuration and any possibly connectivity and interfaces, a simple 2-step method is by clicking the ECB site for its FX rates: https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html

and then download to your laptop the XML file provided. There you are able to download either the daily rates or a time series of the latest 90 days.

So, when you enter the ECB site for its FX rates and scroll a bit you will find the Figure 1 and Figure 2 respectively.

Figure1: Daily Rate Section from ECB Site

Daily%20Rates

Figure 2: Time Series Section from ECB Site

Time-Series-1.png

Press save as (wherever in the list) in order to download the xml file, and you can save at your screen a file like the below.

Figure 3: XML Format saved at your laptop

File

Now, let’s go at SAP system and go to transaction code RFIMPECB, fill the default rates (Tip: You can save all default rates to a variant) and choose the Local Workstation:

Figure 4: SAP Window for Uploading FX Rates from ECB

SAP-Rates.png

And press “Execute”. By executing the transaction, the log will be displayed with all the rates inserted into the system. The uploading will update automatically OB08 by inserting the FX Rate EURX, the date and the EUR to other currency rate.

And basically, that’s it !! Simple as that, and you have all FX provided by ECB updated on SAP for posting in FX rates.

I would love to hear any feedback/thoughts and comments from the community and follow me if you’re interested for next blogs.

P.S: All images are taken mine.

Kind Regards,

George Skoulikaris

https://people.sap.com/gskoulikaris


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK