Skip to Content
Author's profile photo Former Member

Currency Currency Currency…

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 image 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.

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Rasim,

      This has been really informative. Thanks for the explanations.

      Author's profile photo Former Member
      Former Member
      Hey Buddy,

      Its nice to see your first Blog in SDN, blog is really informative to those who have just started taking up their first BW project,in a short span of 1 year you are able to give a blog and share your knowledge to our fellow collegues...Good Work Rasim..

      Hoping to see a POS Extraction from you....

      Cheers!!!

      Krish...

      Author's profile photo Witalij Rudnicki
      Witalij Rudnicki
      Helo Rasim,
      It is importnat topic, and I am glad you started it.
      I think one thing is confusing in your blog: your picture represents situation from BW 3.5, while transaction RSCUR is from BI 7.0.

      Regards,
      Vitaliy

      Author's profile photo Former Member
      Former Member
      Yes, you are right but  the point is here to give an idea for readers about currency translation in a visual way with that picture.

      Regards,