Currency Conversion at Query Level

[former_member219689]

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

[Former Member · Accepted solution]

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.

[dennis_scoville4]

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

[former_member219689]

Hi Dennis and all,

I have tried the conversion methods at Key figure properties........those are not suitable for me.

As i have to Caluculate conversion value based on the "Exchange Rate" which are coming form each record.

Please suggest suitable solution.................

Thanks&Regards

Anand

[Former Member]

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

[Former Member]

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.

[former_member219689]

Hi,

As you suggested i have tried calculated key figure.

The values are converted............but the Currency unit for the value is not changing. It is Showing the Same USD insted of INR.

please suggest solutions.

Regards

Anand

[Former Member]

Hi,

If you want to get INR in every row beside the value then you need to use the currency translation key, in this case the exchange rate coming in the field will not be used. (Not sure if you can do this)

If you want to use the exchange rate coming in that field, you can simply include the INR in the header of that field and remove the dimention coming in the column by using the formula NODIM.

hope this helps,

Regards,

Rk.

[former_member219689]

Hi,

Even we go for Calculating with Calculation key figure to calculate the Currency Value....it is Summarising the Exchange Rate..........if i have 5 records in the cube..........it is multiplying the exchange value with 5..........if i use this value my Actual value becomes 5 times my Actual expectaions.

Please suggest me a good way to convert my currency to USD to INR

Thanks & Regards

Anand

[Former Member]

Please check this http://help.sap.com/saphelp_nw70/helpdata/en/80/1a682de07211d2acb80000e829fbfe/content.htm

[Former Member]

Hi,

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

regards,

Sree.

[gaurav_kothari]

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