- SAP Managed Tags
Dear All,
With this blog i am trying to showcase how can we automatically replicate the exchange rate from S/4 HANA to Ariba Strategic Sourcing Suite.
There has been always a challenge to replicate the exchange rate and keep both system in sync when you are only using strategic sourcing suite realm. The standard Program ARBCIG_MASTER_DATA_EXPORT gives you an option to replicate the currency conversion for Solution Procure to Pay and Procure to Order and then it gets synchronized to upstream through an ICM Parameter enablement Application.AQS.EnableCurrencyConversionRateSetSync .
But this option doesn't appear when we select sourcing and contract as a solution in standard program
Procure to Pay
Procure to Order
Sourcing and Contracts
Customer often keeps complaining about the desynchronization of exchange rate as they don't update it regularly in Ariba Upstream which is a manual process. It can be said that Bidding currency in Sourcing Event and the Order currency always differs because Bidding currency is fetch from Ariba and Order Currency will be fetch from S/4 HANA if you are creating a PO in S/4 HANA through an Integration from Ariba sourcing.
The committee who opens the Bids in Sourcing Event has finalized a supplier to award with bidding currency other than their base currency. In that case, the price which is finalized in sourcing event should be same for that item when PO in created in S/4 HANA. for the big value projects even a slight variance in exchange can bring the price variance. This breaks the compliance.
I am sure different customers must have figured out their own ways to replicate exchange rate. However, we will try to see how can we achieve it through one of the approach.
Steps to Achieve this requirement:
1) Create a Z custom program by copying the standard program ARBCIG_MASTER_DATA_EXPORT and change the logic such that when we select Sourcing and Contracts as a solution , the Currencyconversion master data check option is available.
2) If we understand the standard program and try to replicate the supported master data for e.g. plant it can be seen from the xml of MasterDataReplication_Async_Out payload in SRT_MONI that the program uses Parameter name as "event" and parameter value as "Import External System Master data" and operation as "Load and Delete"
However when we use the same logic for Z program , the integration will fail as "Import External System Master data" doesn't support currencyconversion csv file
3)To understand which csv file support currency conversion, lets download data dictionary This gives us a little hint on what parameter values we should pass in our Z program. In the data dictionary we could see that Import Master Data Batch Pull supports currency conversion csv
4) The z program logic should be written in such a way that it passes Parameter value as " Import Master data batch" and operation as "Load" and only data carrying currenyconversion.csv file should be passed. the standard program logic sends schema.csv file along with currency conversion. that part of logic should be removed.
5) Now it is understood that, master data data replication happens through direct connectivity. The program reads the master data and creates a csv file in directory. From the al11 directory, program pushes the data to CIG by triggering a proxy from S/4 HANA and it reaches CIG and import task pulls the data to Ariba strategic sourcing.
6) Lets try to understand what CSV file format it accepts so that we can send the data from Z program accordingly. From the below snap you can see if we send the data in this format then only the data will get imported successfully.
7) In S/4 HANA we shall create a structure like wise. Now this structure needs to be mapped to Ariba specific value as it has all capital letters.
We will maintain the Ariba specific values in table ARBCIG_FIELDMAP so that the Z program will take the mapping of Ariba values from SAP structure
šNow lets try to run the Z program and see the behavior
Maintain an exchange rate entry S/4 HANA
for eg CAD- SAR Exchange rate 2.7
9) Execute the Z program
Output:
cxml payload in completed status in CIG
Go to Administration-> Import Export and search batch and you will see that it has successfully pulled the currency conversion data from S/4 HANA.
You can also check currencyconversion.csv file to see the latest entry.
Now lets try to create a guided sourcing Event and see if we see the updated exchange rate value under system currency conversion
The exchange rate updated successfully and is now in sync with S/4 system. The Z program can be scheduled as a batch job for a daily frequency. The program logic is written in a way that it keeps checking exchange rate update for last 60 days
Note : For example if your Base currency is SAR, and you maintained the exchange rate for INR to USD then the program will successfully replicate the exchange rate to Ariba strategic sourcing suite and will update the data in currencyconversion.csv file. However, when you create a sourcing event and try to look for the exchange rate INR-> USD it will not display, the system currency conversion will display all exchange rate conversion against your base currency only.
Thank you so much
Cheers!!
Bluesky