Automation of Exchange Rate Feed-in SAP

[former_member626394]

The exchange rate is the most essential financial need to operate any global enterprise.

(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

Prerequisites:-

- 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.

-B. Prerequisites (SAP system has access to the internet)

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

Depending upon business needs, feed providers will be selected and they will provide their URL with unique credentials to connected to their server.

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

Define Currencies 

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

SPRO>Financial Supply Chain Management > Cash Management > DataFeed > Translation Table >  Define Currencies ( Fill the DataSource created in Step #1)> New Entry

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 Run

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.