Skip to Content

Background:

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.

SPRO setting

Step by Step Procedure – Maintain Translation Ratios:

  1. Go to transaction code OBBS, you can see existing ratios maintained 

  2. Click on “New Entries” to maintain new ratios. You have different options to change, copy and delete existing Translation ratios.

    Crete New Entries

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

    Maintain Ratio

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

    Maintain Entries

  5. After that click on “Transport” option from toolbar to create Transport Request. Include in the Request that you have created and press save.

  6. This will include the entry in Transport Request that is created. The message can be seen at the bottom of the screen.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply