# 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

10|10000 characters needed characters exceeded

### Related questions

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.

10|10000 characters needed characters exceeded
• 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.

10|10000 characters needed characters exceeded
• 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

10|10000 characters needed characters exceeded
• 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.

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

10|10000 characters needed characters exceeded
• Former Member Anand K

Hi Reddy,

I am facing the same issue. Were you able to get a solution and if so what was it. Pls provide help.

Thanks,

Jainu