You can use currency translation to convert amount key figures with currency fields that exist in the source system in possibly 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
SAP Consulting Notes at a glance:
- 783877 Currency translation: FAQ
- 137626 FAQ: Decimal Places for Currency Codes
- 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) ...
- 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
- How to Customize the Currency Display in a BW Query
- Rounding Effect of Input Ready Key Figure with Currency Translation
- BWonHana: Query performance 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
- Currency Conversion & Rounding - see Rounding: Example II
- Warning Message Brain 380 - No exchange rate from <curreny> to <curreny> and date <date> found
- Key Figures of data Type CURR 'Currency Field'
Guidelines for Error Analysis
- Step-by-step explanation on how exchange rate is derived for a currency pair on table level
- How to check and enable HANA Pushdown for Currency Conversion in BW740
How to Search Related Code Fix
Search for corrections in application component BW-BEX-OT-OLAP-CUR with your BW support package level (for BW/4HANA product the application component is BW4-AE-CORE-CUR).