Skip to Content

Currency Conversion at Query Level

Hi Friends,

I have to do currency conversion for the sales data from USD to INR at Query Level

We are geeting exchange Rate for the each Record with feild called Exchange Rate.

I have to Multiply the Value "Condition Value" with the exchange Rate Felid Value.

Is there any standard Conversion key which fulfill my need.

If not How can i do this............

Thanks&Regards

Anand

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2009 at 03:14 PM

    Hi

    Since you have a unique scenario where you dont want to choose the currency conversion type I would suggest you add a new amount in your DSO or cube. This amount should be defined using a routine to calculate your base amount with the exchange rate and you can hardcode the target currency as INR or USD as required.

    This does pose the issue of cube or DSO reload, we had the same situation in one of our requirement and we followed this approach. I hope this helps.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2009 at 11:33 AM

    hi,

    if you are getting the exchange rate to convert USD to INR in a separate field you can directly multiply the USD value with exchange rate and get the the value in INR.

    I think in this case you do not need currency translation type.

    Regards,

    Rk.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2009 at 11:24 AM

    Hi,

    I am not sure if there is a standard currency conversion type for this.

    You can create one in T-Code RSCUR and make use of it in the query.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2009 at 11:28 AM

    Hi,

    Why not go for a very simple way of solving this problem. create a CKF with these two values multiplied.

    regards,

    Sree.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2009 at 07:38 PM

    Instead of attempting to calculate the conversion of USD to INR, can you instead use the conversion process in BEx Query Designer?

    1) Click on Condition Value Key Figure in query.

    2) Click on the Conversions tab in the Key Figure Properties.

    3) Make Conversion Type whichever is most appropriate conversion method for your scenario.

    4) Change Target Currency to Indian Rupees (a Variable could be created for this if there is a chance that the end customer would want to convert to something other than INR).

    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.