SAP BLOG Automation of Exchange Rate Feed-in SAP

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,368
Tepki puanı
7
Puanları
6
The exchange rate is the most essential financial need to operate any global enterprise.

SAP_Exchange_Rate_Feed_Raghavendra_Pandey.jpg


(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

SAP_Exchange_Rate_Feed_Raghavendra_Pandey_SE38.jpg




_Exchange_Rate_Feed_Raghavendra_Pandey_Ping_Status.jpg




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.

xchange_Rate_Feed_Raghavendra_Pandey_Feed_Provider.jpg

After filling the information you will get the connection status as per below.

ate_Feed_Raghavendra_Pandey_Ping_Connection_status.jpg


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

SAP_Exchange_Rate_Feed_Raghavendra_Pandey_Image_01.jpg



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

nge_Rate_Feed_Raghavendra_Pandey_Currency_Define-1.jpg

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

_Feed_Raghavendra_Pandey_Currency_Define_Setting-1.jpg


After execute – We will get below screen with currency market data from the data source

dra_Pandey_Currency_Define_Market_Data_TBD4_Update.jpg


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

_Exchange_Rate_Feed_Raghavendra_Pandey_SE16n_TCURR.jpg


ge_Rate_Feed_Raghavendra_Pandey_SE16n_TCURR_update.jpg



Go to transaction OB08 and can see the exchange rate

P_Exchange_Rate_Feed_Raghavendra_Pandey_SE16n_OB08.jpg



Thank you for taking the time to read my first post and I hope you and your loved ones remain safe.

Okumaya devam et...
 
Üst