Conversion is the function used to convert the amount in one source currency to another target currency specified by the user.
Conversion is done by using the functions of SAP HANA database. Therefore, it is imperative that a few database tables like TCURV, TCURX, TCURN, TCURR and TCURF are maintained with the appropriate data to be used by these SAP HANA functions. The function works with dates currently.
On the Convert page, select the input function ID that will be used as source data.
Choose the fields that will have to be used by setting the appropriate field category.
Go to the Convert roadmap step.
Set the Conversion type.
Set the Schema name. Schema is the SAP HANA artifact that contains the other tables necessary for currency conversion along with the source data.
Set the Exchange Rate Type.
Set the Source Unit field. This will contain all currency fields from the input function in the first roadmap step.
Set the Target Unit field.
Set the Date field. The list of all date fields from the input function will be provided as options for this field.
Scenario: Currency Conversion
Company Code |
Value Date |
Base: Converted Premium |
Currency Key |
---|---|---|---|
CC01 |
01.01.2001 |
100050 |
EUR |
CC02 |
01.01.2001 |
100054 |
EUR |
Target Currency |
USD |
Source Currency |
Source Field |
The appropriate schema that contains the data of the conversion tables is chosen and the value date field is chosen from the source as the Date field
Company Code |
Value Date |
Base: Converted Premium |
Currency Key |
---|---|---|---|
CC01 |
01.01.2001 |
9554.70 |
USD |
CC02 |
01.01.2001 |
9450.76 |
USD |