Automation of Exchange Rate Feed-in SAP
(The above image is created by myself using photo-editing tools)
SAP provides multiple ways to update the exchange rate in SAP ERP and has provided different methods, exchange rate types within SAP to handle exchange rate update.
Exchange Rate Tables in SAP
Exchange rates are updated in table TCURR.
Two common ways to update the exchange rate table TCURR within SAP are,
Methods to update Exchange in SAP
Two ways to update the exchange rate
- Manual Upload – Using SAP T-code OB08
- Automated upload – Using SAP T-code TBD4
Automation of Exchange Rate Feed-in SAP
We have covered the basics, now let’s dive into the topic and prerequisites and setup to connect with feed Provider
– A. Prerequisites (Exchange rate Provider)
We need a third party exchange rate feed, a provider like Refinitiv DataScope, FINISS.
These third-party suppliers can provide feed as per business need and no instruments needed.
Example – Instruments are the pair like EUR to USD is one Instrument.
These third-party suppliers sell these instruments in the package like 125 instruments with X$ amount or All instruments with Y$ amount with frequency per day/hour.
To check the connection to SAPHTTPA and the correct configuration. Execute the program RSHTTP05 using the transaction SE38
Market Data Feed Provider
Setup to connect with feed provider
URL and connection URL can be saved by running program RSHTTP20 from SE38.
After filling the information you will get the connection status as per below.
Data Feed configuration and customizing feed.
As per below, all Market Data feed configuration is getting done under SPRO>Financial Supply Chain Management > Cash Management > DataFeed
Each currency pair has to be configured for the given Datafeed to update the exchange rate. This step is an addition to whatever fundamental has been done in the system at the enterprise level in the path SPRO > NetWeaver > General Settings > Currencies.
Exchange Rate Types in SAP
It’s essential to check which and all exchange rate types per currency need to be updated as each currency will be required to be setup.
Common exchange rate types in SAP are,
Bank Buying Rate (G Type) – This rate type is used for when the bank is buying from Company. For. Exports.
Bank Selling Rate (B Type) – This rate is used when the bank is selling to a company. e.g. Imports
Average Type(M Type) – This is the average exchange rate. F
Path to define currencies for the data source
Each currency has to be defined with correct instruments mapping
Once after configuring each currency setup, we can run the transaction to pull the data from the Datafeed.
Datafeed request for current market data can be run manually by running the transaction TBD4 and filling the information including the data source filled
After execute – We will get below screen with currency market data from the data source
This Transaction TBD4 has to be set as a background job in Tcode -SM37 to run automatically as per business needs. Depending upon the business need this job can be set hourly/daily/monthly.
Checking of Datafeed update in SAP ERP
Go to transaction SE16n and put the table name – TCURR (Exchange Rates)
Go to transaction OB08 (This is the same transaction where you can maintain the rates manually as mentioned above) and can see the exchange rate updated automatically.
Thank you for taking the time to read my post and I hope you and your loved ones remain safe.
Good one and liked it very much.
Do post more such detail work in future as it helps a lot
Keep doing good work.......
Thanks for your post.
I have created all the datafeed customizing and the exchange rates for the currency pairs defined in the translation table are being updated in TCURR table as expected.
However, I have realized that when I run transaction code TBD4 today, TCURR is updated with yesterday date. For instance I run TBD4 on date 25.05.2020 and TCURR is updated with date of 24.05.2020. Please, do you know if it is possible to define the customizing to update TCURR table on the same date of the execution of TBD4?
Thanks in advance,
I see two options to resolve the given scenario you mentioned,
1. You can main the entry date as per your need in the variant which you call via SM36.
2. Ask the feed provided to give you the dates as per your need and same you can update via TBD4 call.
I have tried both options and it has worked.
Nice post! Very interesting!
If you want, you can find further information about this in https://ob08.net/app/Website/?lang=en, since they provide this solution for over 90 countries.
Good one and thanks for real time concept