Skip to Content
Technical Articles
Author's profile photo Deodutt Dwivedi

New Feature for Currency Conversion in Data Warehouse Cloud

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.

Data%20Builder%20+%20Icon

Data Builder + Icon

Currency%20Conversion%20Function%20in%20Drop%20Down

Currency Conversion Function in Drop Down list of +

Once I click on it, I get options to select from based on your DWC connection set-up:

Manual%2C%20Connection%20based%20options%20are%20available

Manual & Connection based options are available

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.

 

Standard%20Objects%20to%20be%20imported

Standard Object Types to be imported

Following Standard Objects is imported and deployed in the pre-selected workspace:

Standard%20Objects%20to%20be%20imported

Standard Objects to be imported

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:

Remote%20Tables%20for%20Replication

Remote Tables for Replication

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.

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:

 

*****Update**********

Thanks Thomas Bodenmueller-Dodek   for highlighting Business Builder. Currency Conversion functionality can also be leveraged while creating measures in Business Builder -> Analytical Datasets as well.

Pre-requisite is the semantics have to be updated in the Source View to be used, sample as below.

Semantics%20in%20Currency%20Conversion%20Sample%20View

Semantics in Currency Conversion Sample View

Post semantics, I will go to Measures tab in the Analytical Data set and create Converted Measure configuring as per the conversion needs.

Calculated Measure Configuration

*****End of update**********

 

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.

Regards ,

Deo

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Thomas Bodenmueller-Dodek
      Thomas Bodenmueller-Dodek

      Hi Deodutt,

       

      great blog!  I just want to add that the same currency tables/views which you describe step 1&2 are also usable in the Business Builder to create currency depended measures and calculations.

      Best

      Thomas

      Author's profile photo Deodutt Dwivedi
      Deodutt Dwivedi
      Blog Post Author

      Thanks a lot for your pointers, updated it in the end with high level information.

      Regards,

      Deo

      Author's profile photo Sidharth Razdan
      Sidharth Razdan

      Hello Deodutt,

       

      Amazing Blog!

       

      If we want to extract Currency conversion flows from ECC, Do we need to set up SAP ABAP connection?

       

      Regards.

       

      Sid

      Author's profile photo Alberto Simeoni
      Alberto Simeoni

      Hello,

      Anyone knows if is it possible to change the Default table names proposed by DWC in the currency conversion properties ?

      By default the tables proposed are

      TCURX

      TCURR

      etcetera.

       

      But the ones created with the automatic procedure have different technical names (that can not be changed)

      SAP.CURRENCY.VIEW.TCURX

      SAP.CURRENCY.VIEW.TCURR

      Se every time I need to setup a currency conversion I (we) loose 5 minutes to search and set all the tables.
      Is there a way to set the default in currency conversion properties?

      Author's profile photo Deodutt Dwivedi
      Deodutt Dwivedi
      Blog Post Author

      Hi Alberto,

      You can save as the SAP.CURRENCY.VIEW.TCURX  and name it as TCURX, similarly do it for all the 5 views projected as default. This should avoid the rework.

      Save%20As

      Save As Views

       

      Currency%20Conversion%20Renaming

      Currency Conversion Renaming

       

      Regards,

      Deo

       

      Author's profile photo Alberto Simeoni
      Alberto Simeoni

      Thank you for your reply,

      I renamed the tables instead of the views (i believe views are exposed and used by the Business Builder).

      -> next step I need to test them in business builder.

      Thank you again

      Author's profile photo Alberto Simeoni
      Alberto Simeoni

      Hello,

      the solution I take (renaming the tables) is not ok,

      after testing with third party BI client (JDBC connection),

      it fires the error "missing privileges" in TCURX.

      If i go in the open database explorer , tables like TCURX in the schema associated to the space can not be read with data preview.

      In contrast views like SAP.CURRENCY.VIEW.TCURX are visible.

      So I will proceed with your solution by renaming the views that are exposed to consumption by default.

      I'm tring to do a data preview of the database view of a "Perspective" (Business layer)

      with third party BI Tools. The exchange rates are applied in data builder in my case.

       

      Thanks

      Author's profile photo Toni Martin
      Toni Martin

      Hello Deodutt,

       

      Could you give more detail about how to use the currency conversion in business builder? Have you  associated the currency views in the analytical data set?

      Thanks.