Exchange Rates

In WBP

List

Type CodeBW descriptionCurrenciesFrequencyPeriods
CAR1Magnitude Exchange RateTo EUR onlyMonthlyUp to 2020
CAR3Exchange Rate base on CAR1 ref. crcy EURAllMonthlyUp to 2020
MStandard translation at average rateAllDailyUp to last day
ZRH2Exchange Rate base on ZHRO ref. crcy EURAllMonthlyUp to last month
ZRH3Exchange Rate base on ZHRO ZBUD ref. EURAllMonthly 
ZRHOMonthly valuation consolidation rateAllMonthlyUp to year + 
CCumulated average monthly (reporting)To EUR onlyMonthlyUp to last month
ZBUD

ZBUD Monthly reval. for budget (spring)

To EUR onlyMonthlyUp to current month

CAR1 - Magnitude Exchange Rate

Description

CAR1 is the joining of the "un-cumulated" version of the Cumulated Monthly Mean (CMM - Also refered as "YTD Monthly Avg Rate")  AND the PREV (Budget) rates from BFC.

For past months, CAR1 is the un-cumulated CMM and for the future months, it is the PREV rate.

When to use it

Must be used for Profit & Loss accounts (cumulated) and most of balance sheet movement flows.

Source

Business Objects receives the Cumulated Monthly Mean rate (CMM) and the PREV (Budget) rates from BFC and calculates via a program the "un-cumulated" monthly rates and then sends it to BW via flat file.

For details of the calculations in BO :

Technical Details :

In PQ1

Currency Conversion How To

How to check the rates

  1. Go to transaction SE16
  2. Select table TCURR
  3. Enter a Exchange rate type (ZRHO for WC)
  4. Enter a from currency / to currency

Note If there is no rate for a period BW will use the previous one! Using the example above: if I need to convert from USD to EUR with date = 10.02.2009 since there is no rate it will use the January rate

How to check the conversion types

  1. Go to transaction RSCUR
  2. Select a conversion type
  3. You can then check :

How to create and transport currency factor in BW System

How to create a new rate type in BW

Management of the currencies on the WBP System