Currency translation using SAP BI

It is very possible that you are from, or working with, a country that doesn't use the USD, Euro, Pound, etc. In this case you will need 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 on reports with $ or € instead of local currency. In this article we will take a look at the currency translation,. You will also see some hyperlinked words that will take you to the help 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 different levels depending on you, your requirements and translation type. All of these levels have different advantages and disadvantages. The image below will give you a general overview about currency translation to give you a better understanding of the currency translation in BI. As you can see, currency translation can be done at the business explorer, update rules and transfer rules level, but these are not preferred. You may get better preformance in transfer or update rules using the function module whereas in query you can have more flexibility; if it i...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SAP tips and best practices Minimizing business disruptions during an SAP upgrade or implementation Retrieving content from an SAP workflow attachment Updating URLs in SAP SRM How to change default settings in SAP SRM What are the benefits of implementing SAP SRM? Increase column width in a transaction screen Updating an RT table entry in SAP HR Payroll -- without the ADDWTE option Is this the quickest way to find a BADI? Adding custom fields for retail product comparisons in SAP BW Improving performance with ABAP Objects in SAP Workflow SAP business intelligence tips Choosing an SAP BI/BW database for InfoCube data Using Infoset to join, move DSO analysis to InfoCube Selecting InfoCubes in SAP BI/BW Business Content How to limit employee access to reports using roles in SAP NetWeaver SAP BI extractors vs. Business Objects for ETL process Adding custom fields for retail product comparisons in SAP BW Top 10 SAP tips of 2007 Retrieve BI data with Web Services Adding special characters in SAP BI How to acquire the runtime information of a data transfer process (DTP) SAP business information warehouse Four things SAP must consider before a Teradata acquisition SAP BW or third-party data warehouses a dilemma for SAP customers Should we install SAP BW on the same server running SAP R/3 4.7? SAP: Don't rush from SAP BEx tools to SAP BusinessObjects SAP shores up SAP NetWeaver BW with Teradata Choosing an SAP BI/BW database for InfoCube data Using Infoset to join, move DSO analysis to InfoCube Selecting InfoCubes in SAP BI/BW Business Content SAP BI roadmap one year later: How's Business Objects working out for SAP BI customers? How to limit employee access to reports using roles in SAP NetWeaver SAP business information warehouse Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary BEx  (SearchSAP.com) Business Information Warehouse  (SearchSAP.com) Enterprise Services Architecture  (SearchSAP.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

s a provided variable then you may see the currency which you want. You can use variables for currency conversion in the business explorer level. You may also 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 the BI system. To be able to transfer exchange rates from the source system, you should go to the source systems (run RSA13 –source systems) in your BI system and choose the related source system which you want to transfer the exchange rate. Then right click on that source system and select transfer exchange rates and 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 by date. You want to transfer with the changes since after this you can simulate the transfer or update exchanges rates and transfer the exchange rates again. The transfer exchange rates again option overwrites the rates in the TCURR table so you should be careful when using that option. Those transferred exchange rates are stored in the TCURR table in your BI system. After you transfer the exchange rate then you can check the rates in that table and whether the transfer is successful or not by running the se11 or se16 transaction and 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 specify your exchange rate type (whether is dynamic or not), source currency and target currency. This should be defined at the second and third tab. Select the time reference and save the currency translation that you created. Now you have a your own currency translation and run one of the queries with a BEx of your choice to use in the currency translation. Then, click on the key figure currency translation needed and right click and select the properties. At the bottom of the properties menu select your own currency translation defined earlier. Finally, save and run the query and you will be able to see your key figure in another currency that every client likes to see.

I hope this has been informative for you.


Rasim Manavoglu has been working in Accenture for more than one year as a Technology Analyst and mainly working on SAP BI and Enterprise Portal Projects.

Want to read more from this author? Click here to read Rasim Manavoglu's Weblog. Click here to read more about Business Intelligence (BI) on the SDN.