Skip to Content
author's profile photo Former Member
Former Member

Exchange rate issue - F.01

Hi All,

When financial statement is generated in F.01, my client wants to convert the values to group currency USD.

So we enter USD in the field "display currency" and key date for translation and exchange rate type as M in the tab "special evaluations".

Issue is there is a slight difference in the USD value shown per F.01 after conversion from the company code currency and the value manually calculated by multiplying exch.rate * company code currency.

M rate is saved in the system with 5 decimal places. but the exch.rate used by SAP has more than 5 decimals and there is slight difference in the decimals(as we found out by reverse calculating the P rate).

For eg:

M rate between EUR to USD = 1.32100

Cash accounts in EUR (co.code currency) = 2598.78

cash accounts in USD per F.01 = 3432.09

cash accounts in USD as we calculated = EUR 2598.78 * 1.32100 = 3432.98838

Exchange rate used by SAP = 3432.09 / 2598.78 = 1.32065. (rate updated in TCURR table for the relevant date is 1.32100 and there is no rate in TCURR table that matches the exch.rate picked up F.01 program )

It would be great if any one of you can help me understand why SAP is behaving like this and if there is any way we can sync the exchange rate as updated in TCURR table and the rate picked up by F.01 transaction.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2012 at 07:00 AM

    Why do you want to enter special valuation for group currency.

    You have currency type tab in first screen parameters of F.01

    try entering 30 or whatever suits you, it will automatically show you desired results.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 02, 2012 at 10:33 AM

    If group currency is activated for your company code, then simply select currency type in further selections tab.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.