Most organizations operate in multiple currencies but will usually want to report in a single currency. Once we load data to SAP HANA Cloud database the individual transactions are often stored in mixed currencies. SAP HANA Cloud calculation views can convert currencies during run-time.
Even if the reporting tool is able to convert currencies, you should always consider implementing currency conversion in the calculation view to ensure high-performance, as the conversion in SAP HANA Cloud is processed completely in-memory. Also, by defining the conversion rules in the calculation view you ensure consistency across reports that use the same calculation view as you define the rules only once and not in each report.
The key elements provided by SAP HANA Cloud are:
A set of tables to store master data about currencies, exchange rate types, and the exchange rate values.
A semantic typeAmount with Currency which you set for the measure you want to convert.
Calculation view settings to define, for each measure, how the conversion should be processed (which rate and conversion dates should be applied, where to find the source and target currency).
Standard SAP Currency Conversion Tables
|TCURV||Exchange rate types for currency translation|
|TCURX||Decimal places in currencies|
These tables exist in most SAP systems (in particular, SAP Business Suite and SAP S/4HANA).
To enable currency conversion in SAP HANA Cloud, these tables must be available in the SAP HANA Cloud database. The tables are not provided by SAP HANA Cloud by default and you must provide them and update them yourself using any of the data provisioning tools.