It is very possible that you may not be from one of the countries which use currency such as USD, Euro ,Pound etc. In this case you can be sure that you will be asked for currency translation during your project implementation.This translation may be from your local currency to USD or Euro and so on. Clients like seeing figures at the reports with $ or € instead of local currency.In this blog we will take a look at the currency translation and during the blog you will see some hyperlinked words which will take you to the site in sap where you can find detailed info about currency translation. Currency translation can be used to translate the key figures with currency fields that exist in the source system in different currencies into a standard currency in the BI system. Currency translation can be done in the different levels depends on you and your requirements and based on translation type. All of these ways have different both advantages and disadvantages.The image below will give you general overview about currency translation and you may have better understanding of the currency translation.As you see in below currency translation can be done in business explorer , update rules and transfer rules level but not much preffered. While in transfer or update rules you may get better performance using function module whereas in query you can have more flexibility if it is provided variable then you may see the currency which you want. You can Use Variables for Currency Conversion in the business explorer level also you may check the OSSnote regarding to variables in currency translation 
Basically what you need for currency translation in BEx is to transfer the exchange rates from your source systems into BI system. To be able to transfer exchange rates from source system you should go to the source systems ( run RSA13 –source systems ) in your BI system then choose the related source system which you want to transfer exchange rate and right click on that source system and select Transfer Exchange Rates then in the coming screen you should select the Exchange Rate Type that you want to transfer and you have an option to transfer exchange rates which date you want to transfer with a Changes since and after these you can simulate the transfer or update exchanges rates and transfer exchange rates again . Transfer exchange rates again option overwrites the rates in TCURR table so you should be careful while using that option. Those transferred exchange rates are stored in TCURR table in your BI system. After you complete transfer of the exchange rate then you can check the rates in that table whether the transfer is successful or not running se11 or se16 transaction entering TCURR as a table name. One more thing you need to do is to define your own currency translation running transaction RSCUR .There you need to create a currency translation and then you should specify your exchange rate type whether is dynamic or not and source currency and target currency should be defined at the second and third tab however finally with selecting time reference and save the currency translation that you created. Now you have a your own currency translation and run one of your query with a BEX that you want to use currency translation and click on the key figure currency translation needed and right click select the properties and then at the bottom of the properties menu select your own currency translation defined earlier and finally save and run the query then you will be able to see your key figure in another currency that clients like seeing. I hope this has been informative for you.
Basically what you need for currency translation in BEx is to transfer the exchange rates from your source systems into BI system. To be able to transfer exchange rates from source system you should go to the source systems ( run RSA13 –source systems ) in your BI system then choose the related source system which you want to transfer exchange rate and right click on that source system and select Transfer Exchange Rates then in the coming screen you should select the Exchange Rate Type that you want to transfer and you have an option to transfer exchange rates which date you want to transfer with a Changes since and after these you can simulate the transfer or update exchanges rates and transfer exchange rates again . Transfer exchange rates again option overwrites the rates in TCURR table so you should be careful while using that option. Those transferred exchange rates are stored in TCURR table in your BI system. After you complete transfer of the exchange rate then you can check the rates in that table whether the transfer is successful or not running se11 or se16 transaction entering TCURR as a table name. One more thing you need to do is to define your own currency translation running transaction RSCUR .There you need to create a currency translation and then you should specify your exchange rate type whether is dynamic or not and source currency and target currency should be defined at the second and third tab however finally with selecting time reference and save the currency translation that you created. Now you have a your own currency translation and run one of your query with a BEX that you want to use currency translation and click on the key figure currency translation needed and right click select the properties and then at the bottom of the properties menu select your own currency translation defined earlier and finally save and run the query then you will be able to see your key figure in another currency that clients like seeing. I hope this has been informative for you.
4 Comments
