Ansicht
Dokumentation
RSCURRENCY - Euro Conversion
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up ABAP Short ReferenceThis documentation is copyright by SAP AG.
Description
You use this program to convert currencies in a loaded InfoCube to EURO. It converts the currencies of euro accession countries to EURO. Keep in mind that you can cause inconsistencies if you convert currencies in the R/3 system and use this program to convert them again in BW. We therefore recommend that after converting the currency to EURO in your R/3 systems, you load the data into BW again.
The current version of the program also converts InfoObjects with fixed currency units.
Data stored in the ODS or IDoc is not converted by this program.
Composite SAP Note 120420 deals with the general topic of euro conversion. This SAP Note explains, for example, how you maintain the currency exchange rates for the euro.
Maintain the euro exchange rate in BW, or if you have already maintained it in your R/3 system, load the currency exchange rate into BW. Do this in the Administrator Workbench, by choosing the source system tab page and right-clicking the appropriate source system to select the transfer exchange rate option.
After you have maintained or loaded the euro exchange rate, you can call program RSEURO.
The following information describes the program and how you work with it:
The procedure for converting to euros involves two steps. In the first step, you select the key figures and InfoCubes that you want to convert; in the second step, a background process is started to convert the InfoCubes.
1. Step:
In the first step, you specify the InfoCubes and key figures that you want to convert. This involves two tasks. You select key figures and you select InfoCubes. For each InfoCube, you first have to specify which key figures from this InfoCube you want to convert to euro (menu option Key Figures -> Select).
You can then choose Data Targets - Select from the menu to explicitly select, from the InfoCubes for which key figures are to be converted, InfoCubes that are to be converted when the batch process is called by choosing Conversion - Execute Batch from the menu.
You proceed in a similar way for fixed currencies. If a fixed currency is assigned to an InfoObject, all InfoCubes for this InfoObject that contain the InfoObject with the fixed currency also have to be converted when you convert to euro. You cannot convert these InfoCubes separately. Choose Key Figures -> Fixed Currencies and select the InfoObjects that you later want to convert to euro. Under the InfoObjects, all InfoCubes in which this InfoObject occurs are listed. If a key figure with fixed currencies is used in an InfoCube and as an attribute of another InfoObject, the values of the attribute for the InfoObject are not converted. However, the currency is displayed in euro after the conversion. To prevent inconsistencies, the values of the attribute have to be converted to euro manually.
Key figures that have currencies as master data attributes cannot be converted by this program; only key figures in InfoCubes and PSA can be converted.
With fixed currencies, you then select the InfoObjects that you want to convert in the next background process (by choosing Data Targets - > Select Fixed Currency).
Here is a more detailed description of the two steps:
Key Figures -> Select:
Start program RSEURO.
The system displays all active InfoCubes. InfoCubes that cannot be read, for example, because they are inactive, are displayed at the end of the list.
For each InfoCube, all key figures that reference a currency unit InfoObject are listed. For each InfoCube, you specify which key figures you later want to convert to euro by selecting the checkbox for the relevant key figures.
Save your entries. When the program is called again, the entries that have already been done are displayed as already selected.
In the status column, you can see whether a key figure is: not yet converted ( ), partially converted (1), or completely converted (2).
Select the checkbox again to deselect selected key figures. You cannot deselect key figures that are already completely converted (2).
If more than one key figure references the same unit InfoObject in an InfoCube, either all or none of the key figures have to be converted to euro. The key figures are listed for each InfoCube and are grouped by the unit InfoObject. If you have not selected all the key figures that reference the same unit InfoObject, when you save or press ENTER, you will be asked whether you want to select or deselect all key figures.
When you save your entries, you can return to your old entries by restarting program RSEURO.
To convert the key figures in an InfoCube to euro, you must perform this step (Key Figures -> Select). You can then perform the second step by choosing InfoCubes -> Select in the menu.
Menu option Key Figures -> Fixed Currencies:
On this screen, you can select key figures to which a fixed currency is assigned. Under each key figure, all InfoCubes that contain the key figure are displayed. For InfoObjects of this type, all InfoCubes that use this InfoObject have to be converted together. You cannot perform separate conversions in separate background processes. When all the affected InfoCubes have been successfully converted, the fixed currency of the InfoObject is set to EURO.
Menu option Data Targets -> Select InfoCubes:
The system displays all the InfoCubes for which key figures have been selected for conversion (see step Key Figures -> Select). For each InfoCube, only those key figures that were selected for conversion are displayed. InfoCubes that have already been converted are not displayed. To display these InfoCubes, choose Data Targets -> Display Converted from the menu.
If the conversion of an InfoCube terminates before it completes, the InfoCube has status 1 - partially converted. InfoCubes with this status are already selected and cannot be deselected. The next time the InfoCube is converted, the system restarts the conversion from the point at which it had terminated.
Select the InfoCubes that you want to convert to euro the next time the background process is called.
InfoCubes that have already been selected are displayed as previously selected.
If you do not want to convert any of these InfoCubes yet, you can deselect them.
Your entries are retained when you save. Before you choose Conversion -> Execute Batch, you must save your entries. When the background process is called, it is the saved status that is relevant.
Menu option Data Targets -> Select Fixed Currencies
The system displays all key figures with a fixed currency that were selected for conversion in the Key Figures -> Fixed Currencies step (see section Key Figures -> Fixed Currencies). Under each key figure, all the InfoCubes that contain the key figure are displayed. InfoObjects with a fixed currency that have already been converted are not displayed. To display these InfoObjects, choose Data Targets -> Display Converted from the menu.
After the key figures with fixed currencies have been converted, the queries that contain these key figures must be regenerated.
You do this in transaction RSRT by choosing the Regenerate icon.
Generate all the queries for the InfoCube if they contain the key figures.
Menu option Data Targets -> Display Converted
The system displays all InfoCubes that have already been converted. The converted key figures are listed for each InfoCube. The status indicates whether the conversion was successful (status = 2) or only partially successful (status = 1).
2. Step:
Menu option Conversion -> Execute Batch
After you complete the steps to select key figures and InfoCubes, you can start the background process to convert the selected InfoCubes. Choose Conversion -> Execute Batch.
The program that performs the actual conversion of key figures in the database is RS_EURO_CONVERTER. This program reads the InfoCubes and key figures that are to be converted from table RSEURO. The table is filled by program RSEURO.
The program first calculates the currency exchange rate using tables TCURR and TCURX. It is assumed that the exchange rates in table TCURR are maintained with the KURSTYP 'EURO' and that 'EUR' is used as the currency description for the EURO. Both names are defined as constants (G_C_KURSTYP or G_C_EURO_CHAVL) in program RS_EURO_CONVERTER and have to be modified in the program code if the system setting is different.
For performance reasons, the secondary index of the unit dimension is deleted from the fact table before the actual conversion. It is automatically created again when the conversion has finished successfully.
For data consistency reasons, all aggregates in the fact table are deactivated. Aggregates are not converted to euro because this can produce different results in reporting due to rounding differences, depending on whether the system reads directly from the fact table or from the aggregate. Since it can take a while to rebuild the aggregates, depending on number and size, they are not automatically reconstructed after conversion; reconstruction has to be scheduled separately.
During the actual conversion, the system runs through the entire fact table once and converts the affected key figures in accordance with the exchange rates. Records are only converted if they have a currency from one of the accession countries to the monetary union; records with other units are not changed. If there is an overflow when a key figure is converted, the complete record is not converted.
To prevent an overflow of rollback segments in the database, the converted records are 'committed' at regular intervals. However, the fact table status is guaranteed to be consistent at all times. If a conversion run fails, the InfoCube can be rescheduled for conversion; when the program is called again, only those records that were not changed by an earlier run are converted.
Menu option Conversion -> Log
A log is written when the background process is executed. You can view the log by choosing Conversion -> Log. Enter the name of the executing user and restrict the dates accordingly.
Prerequisites
Report Results
Example
Addresses (Business Address Services) SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 11355 Date: 20240601 Time: 061131 sap01-206 ( 223 ms )
