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 inmind that you can cause inconsistencies if you convert currencies in theR/3 system and use this program to convert them again in BW. Wetherefore recommend that after converting the currency to EURO in yourR/3 systems, you load the data into BW again.
The current version of the program also converts InfoObjects with fixedcurrency units.
Data stored in the ODS or IDoc is not converted by this program.
Composite SAP Note 120420 deals with the general topic of euroconversion. This SAP Note explains, for example, how you maintain thecurrency exchange rates for the euro.
Maintain the euro exchange rate in BW, or if you have already maintainedit in your R/3 system, load the currency exchange rate into BW. Do thisin the Administrator Workbench, by choosing the source system tab pageand right-clicking the appropriate source system to select the transferexchange rate option.
After you have maintained or loaded the euro exchange rate, you can callprogram RSEURO.
The following information describes the program and how you work withit:
The procedure for converting to euros involves two steps. In the firststep, you select the key figures and InfoCubes that you want to convert;in the second step, a background process is started to convert theInfoCubes.
1. Step:
In the first step, you specify the InfoCubes and key figures that youwant to convert. This involves two tasks. You select key figures and youselect InfoCubes. For each InfoCube, you first have to specify which keyfigures from this InfoCube you want to convert to euro (menu option KeyFigures -> Select).
You can then choose Data Targets - Select from the menu to explicitlyselect, from the InfoCubes for which key figures are to be converted,InfoCubes that are to be converted when the batch process is called bychoosing Conversion - Execute Batch from the menu.
You proceed in a similar way for fixed currencies. If a fixed currencyis assigned to an InfoObject, all InfoCubes for this InfoObject thatcontain the InfoObject with the fixed currency also have to be convertedwhen you convert to euro. You cannot convert these InfoCubes separately.Choose Key Figures -> Fixed Currencies and select the InfoObjects thatyou later want to convert to euro. Under the InfoObjects, all InfoCubesin which this InfoObject occurs are listed. If a key figure with fixedcurrencies is used in an InfoCube and as an attribute of anotherInfoObject, the values of the attribute for the InfoObject are notconverted. However, the currency is displayed in euro after theconversion. To prevent inconsistencies, the values of the attribute haveto be converted to euro manually.
Key figures that have currencies as master data attributes cannot beconverted by this program; only key figures in InfoCubes and PSA can beconverted.
With fixed currencies, you then select the InfoObjects that you want toconvert 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 thelist.
For each InfoCube, all key figures that reference a currency unitInfoObject are listed. For each InfoCube, you specify which key figuresyou later want to convert to euro by selecting the checkbox for therelevant key figures.
Save your entries. When the program is called again, the entries thathave already been done are displayed as already selected.
In the status column, you can see whether a key figure is: not yetconverted ( ), partially converted (1), or completely converted (2).
Select the checkbox again to deselect selected key figures. You cannotdeselect key figures that are already completely converted (2).
If more than one key figure references the same unit InfoObject in anInfoCube, either all or none of the key figures have to be converted toeuro. The key figures are listed for each InfoCube and are grouped bythe unit InfoObject. If you have not selected all the key figures thatreference the same unit InfoObject, when you save or press ENTER, youwill be asked whether you want to select or deselect all key figures.
When you save your entries, you can return to your old entries byrestarting program RSEURO.
To convert the key figures in an InfoCube to euro, you must perform thisstep (Key Figures -> Select). You can then perform the second step bychoosing InfoCubes -> Select in the menu.
Menu option Key Figures -> Fixed Currencies:
On this screen, you can select key figures to which a fixed currency isassigned. Under each key figure, all InfoCubes that contain the keyfigure are displayed. For InfoObjects of this type, all InfoCubes thatuse this InfoObject have to be converted together. You cannot performseparate conversions in separate background processes. When all theaffected InfoCubes have been successfully converted, the fixed currencyof the InfoObject is set to EURO.
Menu option Data Targets -> Select InfoCubes:
The system displays all the InfoCubes for which key figures have beenselected for conversion (see step Key Figures -> Select). For eachInfoCube, only those key figures that were selected for conversion aredisplayed. InfoCubes that have already been converted are not displayed.To display these InfoCubes, choose Data Targets -> Display Convertedfrom the menu.
If the conversion of an InfoCube terminates before it completes, theInfoCube has status 1 - partially converted. InfoCubes with this statusare already selected and cannot be deselected. The next time theInfoCube is converted, the system restarts the conversion from the pointat which it had terminated.
Select the InfoCubes that you want to convert to euro the next time thebackground process is called.
InfoCubes that have already been selected are displayed as previouslyselected.
If you do not want to convert any of these InfoCubes yet, you candeselect them.
Your entries are retained when you save. Before you choose Conversion ->Execute Batch, you must save your entries. When the background processis 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 wereselected for conversion in the Key Figures -> Fixed Currencies step (seesection Key Figures -> Fixed Currencies). Under each key figure, all theInfoCubes that contain the key figure are displayed. InfoObjects with afixed currency that have already been converted are not displayed. Todisplay these InfoObjects, choose Data Targets -> Display Converted fromthe menu.
After the key figures with fixed currencies have been converted, thequeries 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 keyfigures.
Menu option Data Targets -> Display Converted
The system displays all InfoCubes that have already been converted. Theconverted key figures are listed for each InfoCube. The status indicateswhether the conversion was successful (status = 2) or only partiallysuccessful (status = 1).
2. Step:
Menu option Conversion -> Execute Batch
After you complete the steps to select key figures and InfoCubes, youcan start the background process to convert the selected InfoCubes.Choose Conversion -> Execute Batch.
The program that performs the actual conversion of key figures in thedatabase is RS_EURO_CONVERTER. This program reads the InfoCubes and keyfigures that are to be converted from table RSEURO. The table is filledby program RSEURO.
The program first calculates the currency exchange rate using tablesTCURR and TCURX. It is assumed that the exchange rates in table TCURRare maintained with the KURSTYP 'EURO' and that 'EUR' is used as thecurrency 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 tobe modified in the program code if the system setting is different.
For performance reasons, the secondary index of the unit dimension isdeleted from the fact table before the actual conversion. It isautomatically created again when the conversion has finishedsuccessfully.
For data consistency reasons, all aggregates in the fact table aredeactivated. Aggregates are not converted to euro because this canproduce different results in reporting due to rounding differences,depending on whether the system reads directly from the fact table orfrom the aggregate. Since it can take a while to rebuild the aggregates,depending on number and size, they are not automatically reconstructedafter conversion; reconstruction has to be scheduled separately.
During the actual conversion, the system runs through the entire facttable once and converts the affected key figures in accordance with theexchange rates. Records are only converted if they have a currency fromone of the accession countries to the monetary union; records with otherunits are not changed. If there is an overflow when a key figure isconverted, the complete record is not converted.
To prevent an overflow of rollback segments in the database, theconverted records are 'committed' at regular intervals. However, thefact table status is guaranteed to be consistent at all times. If aconversion run fails, the InfoCube can be rescheduled for conversion;when the program is called again, only those records that were notchanged by an earlier run are converted.
Menu option Conversion -> Log
A log is written when the background process is executed. You can viewthe log by choosing Conversion -> Log. Enter the name of the executinguser and restrict the dates accordingly.