Use Variables for Currency Conversion in BIW

As of SAP BW 3.5, you will have additional options to create variables for the following components of a currency conversion type:

Exchange rate type: The exchange rate type distinguishes between exchange rates that are valid in the same time frame, for example, the bid rate, ask rate or middle rate. The exchange rate types are stored and can be maintained in a central table (TCURV). Create a variable for the technical InfoObject 0RTYPE.

Target currency: The target currency can either be fixed in the translation type or not selected until the time of translation. Create a variable for the technical InfoObject 0CURRENCY.

Fixed time reference: If the time reference is fixed for a currency translation type, then the point in time for the exchange rate determination is independent of the data. The fixed point in time can either be a fixed key date that is stored in the translation type or can be determined using the system date when executing the currency translation. Create a variable for the technical InfoObject 0DATE.

If you like this post, you may as well like these too:

1. ABAP Programs: Using static variables REPORT ZSOURCE1003.* Calling a form twicePERFORM COUNT.PERFORM COUNT.* Defining a form with a static variableFORM COUNT. STATICS CALLS TYPE I. CALLS = CALLS + 1. WRITE CALLS.ENDFORM.~~~~~ end of post...
2. Unicode Conversion Tips and Tricks for Improving the Conversion Time This document on tips and tricks on Unicode Conversion is meant to improve the conversion time needed for a Unicode conversion. It...
3. ABAP Programs: Simple examples of field conversion REPORT ZSOURCE0702. * Converting to numbers during computationsDATA: NUMBER_1(4) VALUE ’1771′, NUMBER_2(3), RESULT TYPE I. NUMBER_2 = ’005′.RESULT = NUMBER_1 + NUMBER_2.WRITE / RESULT. NUMBER_2 = ‘ 5′.RESULT = NUMBER_1...
4. Maintaining Currency in SAP Currency (the legal means of payment in a country) in SAP is denoted by a 3-character Currency Code, maintained per ISO standards. Example: USD (U.S. Dollars), INR (Indian Rupee), GBP...
5. Parallel Currency in SAP When defining the currencies for a Company Code, it is possible to maintain, for each of these company Codes, two more currencies in addition to the Local Currency. These two...
6. Use variable time references in currency conversions Today, in SAP’s Business Information Warehouse, currency conversion can take place using different parameters defined in a currency translation key (source currency, target currency, exchange rate type and time reference)...
7. SAP BIW Presentations [More] Well, some more BW Presentations:...
8. SAP BIW Basics Tutorial SAP BIW(Business Information Warehouse) or BI (Business Intelligence) now plays a central role in virtually every solution introduced in market by SAP. It facilitates predicting and proper analysis based on...
9. SAP BIW – Upload and Integrate Samples To upload Sales Order data from SAP R/3 to BI using generic DataSources Integrating SAP data (R/3 or BW Data) with the BO-Xcelsius (Business Objects) using BSP SAP BSP +...