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.
Download and Understand more about this in this Whitepaper (PDF).
If you like this post, you may as well like these too:
- 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...
- 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)...
- 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...
- Conversion Strategy in HR The Data Transfer Toolbox has been developed to facilitate the process of converting organizational, employee and payroll data from legacy system to SAP, quickly and accurately. The conversion strategy, incorporated...
- 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...
















Leave a Reply