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

currency conversion in the query designer level

Hi

Iam calculating the 'Financial Loss' in the Formula in the query designer.And it comes in SAR(Saudi Riyals).

But i want the 'Financial Loss' in USD in the Query Designer. Because i want the USD Financial Loss to be use in some other calculation.

Please let me know how can we do this one in the query designer. I really appreciate for it .

Regards

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 05, 2007 at 07:28 AM

    Hi,

    Check under properties of key figure. You would find an option of Currency conversion.

    if you do not have conversion to USD, then can maintain using tcode RRC1.

    hope it helps...

    regards,

    raju

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 07:32 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 05, 2007 at 07:45 AM

    Dear Ravi,

    Basically there are 2 ways to do it: routine & query level.

    If query level, you need to maintain it first using tcode RRC1, then you use it in your KF in your query. .

    Routine level,

    You can create new KF in info-provider, then in the update rules routine, you can use this function to convert the currency :

    CONVERT_TO_LOCAL_CURRENCY

    Hopefully it can help you a lot.

    Regards,

    Niel

        • thanks for any points you choose to assign.

        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.