The exchange rate is the most essential financial need to operate any global enterprise.
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
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
Checking of Datafeed update in SAP ERP
Go to SE16n and put the table name – TCURR
Go to transaction OB08 and can see the exchange rate
Thank you for taking the time to read my first post and I hope you and your loved ones remain safe.
Okumaya devam et...
(above image – 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
Checking of Datafeed update in SAP ERP
Go to SE16n and put the table name – TCURR
Go to transaction OB08 and can see the exchange rate
Thank you for taking the time to read my first post and I hope you and your loved ones remain safe.
Okumaya devam et...