Currency Conversion functionality is quite common in data modelling and reporting tools and hence SAP Data Warehouse Cloud is no different. SAP has been adding new functionalities/improvements in DWC tenets regularly. One of the recent addition is a new functionality/improvements around Currency Conversion. Please follow below detailed steps to check out my exploration of this functionality in DWC:
Step 1: Set-Up & Import
Legends say, great things in DWC begin with Data Builder and same goes for this functionality as well. I login to DWC to open Data Builder and then click on + Icon to initiate the set-up.
Once I click on it, I get options to select from based on your DWC connection set-up:
In my case I have created a connection between our S/4HANA on-prem system and DWC environment. This has been set-up via Connections functionality in DWC using a DP Agent and is a pre-requisite for using S/4HANA Currency tables and data. One can choose either S/4HANA connectors or the ABAP connector for this purpose. Refer to the official document for further details here.
Following Standard Objects is imported and deployed in the pre-selected workspace:
Once I click on Create button , the standard objects import & deployment starts.
Step 2: Replication & Data Loads
Post deployment, I need to replicate the remote tables:
Post table replication, the Data Flows need to be triggered as well. This will load the data from remote tables to local tables in DWC via Data Flows.
I have used a dummy transaction table (Dummy Data V2) to perform the conversion, sample structure as below:
Source table sample structure
Step 3: Creating View & Calculated Column
Next step is I need to create a view via Data Builder and consume the Dummy Data V2 table as a source. Additionally, I have created an Input Parameter to take in Target Currency as a User Input. Next I need to add a formula node and use below button to create a currency conversion column:
Further I need to fill in the details based on currency conversion needs such as Exchange Rate Type, Reference Date, Error Handling etc. New Values are nothing but the standard views that I have imported in previous steps whereas older values are the direct tables available in S/4HANA system.
Finally I need to deploy and check the data in the newly added column Amount in Target Currency:
Entering AUD as Target Currency:
In conclusion, this is a great addition by SAP as it helps us in having Exchange rate and other relevant tables selected & replicated from our S/4HANA systems thus saving our time and effort in performing currency conversion using the previously shown preliminary method by Mr. San Tran , refer this blog. Now lets see when we can have similar options for UoM Conversion as well, or am I being greedy. 😛
Thanks for reading the blog, feel free to suggestions/discussions in comments.