Currency Translation
You can use currency translation to translate key figures with currency fields that exist in the source system in different currencies into a standard currency in the BW system (the local currency or company currency for example). Another application serves as the currency difference report, where you can compare the actual exchange rates with the exchange rates that were valid on the posting date, thus determining the effect of changes to exchange rates. |
SAP Online Documentation
help.sap.com: Currency Translation
SAP Consulting Notes at a glance:
- 783877 Currency translation: FAQ
- 1240163 Amount too high by factor of 100 for HUF, JPY currencies
- 1998587 Currency Translation in the Executed Query
1176399 Loading amounts to the BW system; decimal places
1962209 Rounding error CONVERT_TO_LOCAL_CURRENCY with FLTP fields
- 2085589 Extending an Amount Key Figure of Currency Type in BW
- 2085929 Virtual Providers & Currency Key Figures
- 2201717 Amount Key Figures only Display Value Number (without Currency or with Wrong Currency Text) in the Query Result
- 667288 Unit or currency for key figures with value 0
- 1715035 Aggregation and mixed units or currencies in BW 7.30
- 2298745 0 with mixed currency or unit as result of multiplication or division
2476282 Incorrect amount decimal in a query built on HCPR using HANA view for currency JPY, HUF
- 2561100 Currency Conversion in CDS Queries - Could not determine valid conversion rate for value(s) ...
Topics
- Overview of important tables used for currency translation
- Function Modules CONVERT_TO_LOCAL_CURRENCY, CONVERT_TO_FOREIGN_CURRENCY and report RCURTEST
- Display Different Decimal Places for Different Currencies or Units in a Query
- Set up the Customizing Currency Display in Query Output
- Rounding Effect of Input Ready Key Figure with Currency Translation
- BWonHana: Query perfomace can be improved when currency conversion is done on Hana database
- Decimal Setting in HCPR on HANA View for Amount Values
- Currency Translation in CDS Views
Guideline for Error Analysis
- Step-by-step explanation on how exchange rate is derived for a currency pair on table level
- Example 1 (simple) - Explanation on how to check and enable HANA Pushdown of Currency Conversion in BW740
- Pushdown Example 1
How to Search Related Code Fix
Just search with component BW-BEX-OT-OLAP-CUR with your BW support package level