Dynamic Currency translation changes in SAP HANA
Objective:- how to change the currency using dynamic filter (while run time)
Users will expect while executing the views currency will change ex- all USD values change to EUR or EUR to USD
Kodanda Pani K.V is a SAP HANA consultant currently working with Accenture Pvt Ltd (Bangalore/INDIA). He has over 5 years of experience in various BW/BO/HANA implementation / Support Projects.
Business scenarios: – Retail company has head quarter in Europe countries but there business different countries USA, IN, JAPAN, CHINA
All the sales information will store VABK table and i had work with VABK table for currency translation
Prerequisite: Before doing currency translation make sure all the below tables has to present in respective schema.
Step by step procedure
Make sure VABK and TCUR* tables extract from ECC to HANA system using BODS or SLT system.
Created the analytical view using VABK table
Below screen will appear and check the data foundation in VBAK table
In VABK table has huge data i put filter only EUR currency and applied fitter WAERK (document currency)
Data foundation view for VBAK table below fields
Created one calculated columns (Target currency) and two input parameters (currency and date)
Define Date input variable
Name – date
Values – FORMAT (NOW (),’YYYYYMMDD’) – SQL syntax will give current date
Symantec type – date
Data type- DATE
ZCURRENCY input variable
Name – ZCURRENCY
Label – ZCURRENCY
Parameter type – column
Reference – WAERK
Created calculated column target currency (Target currency)then passing the two input variable in calculated column field
Target currency field
Source Currency: Source currency can be either a fixed currency or it can refer to document currency field of our table/view.
Target Currency: Target currency can be any fixed currency or it can refer to any currency field of your analytic view or you can decide target currency at run time using Input parameter.
Exchange Type: Exchange Type is one of key in the exchange rate table (TCURR) against which rates for conversion are maintained. You can select a fixed value or can decide its value at run time using Input parameter.
Name – TARGET_CURRENCY
Label – Target currency
Data type – decimal (10, 2)
Column type – Measure
Expression editor – used the measure values ‘NETWR’ – Net value on Sales document
Click on semantics option then below screen will appear
Semantic type – Amount with currency code
Then click on enable for conversion
Currency – TARGET _CURRENCY _CURRENCY (browse and choose the option)
Target currency – ZCURRENCY (Input variable) (browses and chooses the option)
Exchange type – M
Conversion date – DATE (browse and choose the option) – it will give current date
Schema of currency conversion – browses and chooses the schema ex – ZPHANI1
Generate results currency column – target_currency_currency (browse and choose the option)
Upon conversion failures – Fail
Save and activate the view and execute the view
select the view -> right click -> data preview
Below variable prompt will ask for target currency and date.
We can change the dynamically target currency as per the business requirements
Report output for currency translation with below fields
Now can see all EUR values are converted into USD currency
Note: – All TCUR* table all dates exchanges rates should available in the system
Thanks and Regards,