Skip to end of metadata
Go to start of metadata

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 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) ... 


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 

 SAP Support Troubleshooting Guideline