How to do Currency Conversion on a query

If you need to report on different currencies it may be better to use a Currency Translation type. In this way you don’t have to store the data in multiple currencies and you are not dependant on the exchange rates being loaded before your data load. Here’s how it’s done.

1.                  Run transaction RSCUR.

 

2.                  Enter a description and choose the exchange rate type. The most common type is “M”. This data is stored in table TCURR. Table TCURR is populated from table TCURR in your system. This is done by right clicking on the relevant source system and choosing Transfer Exchange Rates. This can also be scheduled in the process chain.

   

3.                  On the Currency tab select the source and target currencies. You can choose to use a variable to determine the target currency. The user will then be prompted to select a target currency when running the query.

 

4.                  On the Time Ref. tab you can choose the date to be used to determine the exchange rate. There are a number of options available here. When you are done, save the Currency Conversion Type.

5.                  The net step is to use the currency conversion type in your query. In query designer, select the key figure that you would like to apply the conversion to and click on the Conversions tab under Properties. Choose your conversion type from the drop-down under Conversion Type and select the Target Currency if applicable.

 

6.                  Save your query and run it!