It is necessary to maintain translation ratios for currency conversion when we load data from different source systems for staging. Each translation ratio is maintained to define a bank buying and selling rate and an average rate for the translation of foreign currency amounts. The average rate is used for foreign currency translation, and the buying and selling rates for the valuation of foreign currency amounts.
Before maintaining the ratio, it is necessary check if source currency and target currency is maintained in BI system either in Customizing settings “SPRO” or in Currency Codes table TCURC.
The Translation Ratios are saved in Conversion Factors table i.e. TCURF.
Step by Step Procedure – Maintain Translation Ratios:
Go to transaction code OBBS, you can see existing ratios maintained
Click on “New Entries” to maintain new ratios. You have different options to change, copy and delete existing Translation ratios.
You can maintain new Translation Ratio withdetails like Exchange Rate Type, From Currency, To Currency, Ratio (from), Ratio (to) and Alternative exchange rate type. The Alternative exchange rate types are used to process currency translations for certain currency pair combinations from a given date using a different exchange rate type. Save the entries.
Go back and select the new entries to transport. You can select the entries by clicking on “Position” and enter the values in pop up window.
After that click on “Transport” option from toolbar to create Transport Request. Include in the Request that you have created and press save.
This will include the entry in Transport Request that is created. The message can be seen at the bottom of the screen.