Skip to Content

Concurrent maintenance of exchange rates

December 19, 2013 | 5,950 Views |
 currencypairerp financials;sapexchangerateexchangeratemaintenanceexchangerateowrklistob08tcurf
Follow

It is a very common requirement in any business which deal with sales and purchase in different currencies to have proper exchange rates to determine the local currency amount with respect to different foreign currencies they deal with. SAP has provided an option to maintain the exchange rates (T-code OB08) for different exchange rate types for different purposes.

E.g.: Rate type M is used for monthly average rates

        Rate type BUD is used for budget rates

Different terminologies used in this concept:

Exchange rate:

Exchange rates are used to find the value of a given currency with respect to other currency.

E.g.: 1 USD = 60 INR

Translation ratio:

Translation ratio is used for 2 purposes.

1. To maintain the alternate exchange rate between a currency pair and exchange rate type. This is used to overwrite the standard rate type M used for regular business transactions.


Eg: As per legal requirements in some countries, they need daily exchange rates for booking day to day transactions. So, to overwrite standard rate type M,

we can assign custom exchange rate types.


2. When the rate between two currencies is too huge, we use translation ratio and maintain the rate. This is to simply the exchange rate calculation.


Eg: Rate between USD and HUF is too high. So we maintain USD:HUF ratio as 1:100


With this setting, calculation happens as below.

Rate maintained between USD and HUF is, 1 USD = 90 HUF. This actially means 1 USD = 90*100 = 9000 HUF


Exchange rate maintenance:


Exchange rates are maintained through t-code OB08 and are stored in table TCURR. It is very important to lock the table entries during exchange rate maintenance as per basic database design principles to avoid any data record access during update. This design causes many issues specially during month end where many users of different countries try to update same table and gets locking error. More over, if the rate maintenance is an automated process say through IDOCs, if someone already keep OB08 open and exchange rate IDOC is processed, it fails due to lock issue.

Exchange rate work list concept can be effectively used here to lock only required entries during exchange rate maintenance.

SPRO path to configure Exchange rate work list.

Capture.JPG

Go to “Define Work list for Exchange rate entry” and create a new entry with proper name, description. Select maintenance interval as per business requirement like daily, weekly, monthly, quarterly etc. This is just an indicator of validity of latest exchange rate. System don’t do any cross validation with this date which using the rate. It simply uses latest available rate.

Enter Tolerance percentage if required. If a value is entered here, system does a comparison with previous available exchange rate and through error if new rate is beyond the tolerance limits.

Capture.JPG

Go to “Assign Exchange rate to the work list.

Here, we assign the currency pairs and exchange rate type combination which comes under the purview of business scenarios. It is suggested to create one exchange rate work list per country and assign all the exchange rate types and currency pairs to be manually maintained to that work list. In below image, I have shown one local exchange rate type and currency pair which is updated on daily basis. Direct/Indirect quotation here determines how the exchange rate value to be used.

Untitled.png

Maintenance of exchange rates:

Go to t-code TCURMNT, double click on the work list you are interested at. In the next screen, we can see all the exchange rates assigned to this work list only.

Capture.JPG

Maintain the valid from date, exchange rate value (Direct/Indirect rate as defined in earlier configuration) and save the entry. In this screen, we can see date of last rate change and what was the old rate as well.

Keep this screen open in change mode, ask another user to try to update another exchange rate work list or you can try with your ID itself. That person/you should be able to change the values in second list. This kind of concurrent maintenance is not possible through OB08. If one user logs in to OB08, no one else would be able to enter into change mode. Also, it is quite difficult to filter the required rates to be updated from OB08 as this displays all the exchange rates in the system.

Advantages of this solution:

1. This solution approach is very simple and flexible.

2. Users are allowed to see  only the rates they are allowed to maintain.

3. Concurrent maintenance of different rates for different countries are possible.

4. Don’t cause locking issues for other users.

5. Authorization can be controlled at exchange rate work list level. So, no chances of accidental update of other rates than the required ones.

Disadvantages of OB08 approach:

1. Causes locking issues. This is so true during critical times like month end where multiple users try to update exchange rates.

2.Tough to filter the required rates.

3. Chance of accidentally updating unintentional rates as all the rates are accessible from OB08.

Authorizations required:

Object: S_EXCHRATE activity 01,02,03 for exchange rate work list. If you can’t save the entries, please check with BASIS team to get required authorization.

Your feed back and comments are most welcome 🙂 .

Thanks,

V V


To report this post you need to login first.

41 Comments

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

  17. Former Member

    Hello Vinod,

    We are planning to implement SAP in Venezuela. And what I have been told that because of some legal reason, they use 3 different exchange rate. Do you have any insight at a very high level, how does SAP manages such situation?

    By the way, thanks for the great article you posted. Very nice job !

    Thanks,

    Dipankar Biswas

    (0) 
    1. Former Member Post author

      Hello,

      You can create 3 exchange rate types for this. But, you have ask your business, which kind of transactions use which rate.

      eg: day to day transactions, use rate type 1

           for budgeting, use rate type 2

      If the requirement is for specific pair of currencies, you can use alternate exchange rate type.

      Thanks,

      V V

      (0) 
  18. Arvind Pereira

    Hi Vinod,

    Thanks for sharing. When i try to share with any person, I get the message that am not connected to that person, i would really like to share this paper but i need to add people to my account i guess.

    Regards

    Arvind Leo Pereira

    (0) 
  21. Former Member

    Vinod,

    Firstly thank you for the very insightful article.

    We have a requirement to use the ‘P” rate in all our transactions as our client wants the exchange rate to the frozen for a year.

    However when I maintain the ‘P’ rate in the customer master and use that customer in a sales order, I’m facing pricing errors (Bases price is on the order but its erroring out). when I try this with M rate, I see its working fine.

    Can you share some insights on how to effectively use ‘P’ rate? Please note that I tried this after maintaining P rate conversions in OB08.

    Thanks in advance,

    Vishak

    (0) 

Leave a Reply