Currency conversion for specific day

[#1]

Hi guys,

I´m using the currency conversion for the day when the query is executed.

In the table TCURR are values for example like that:

1.1.2011 USD 1.3211 to 1 EUR

1.12.2010 USD 1.2222 to 1 EUR

1.11.2010 USD 1.11111 to 1 EUR

.

.

.

When I´m selecting in the query (selection mask) the month January 2011 the currency conversion is ok and the currency rate from 1.1.2011 is selected.

When I´m selecting in the query (selection mask) the month November 2010 also the currency rate from 1.1.2011 is selected. I expected the rate from 1.11.2010 because the November 2010 was selected in query selection mask.

How can I do the settings for the query that for each month wich was selected the corresponding currency rate from TCURR is selected correct?

Is there some easy solution?

Thank you in advance for your answers!

Regards

[Former Member]

Are you sure this is the business requirement? Typically SO and PO transactions in SAP have a Price Date which is the date used for calculating exchange rates for a particular transaction.

We are calculating the currency conversions in the backend DSO's and Infocubes using the fixed pricing date and storing it in custom keyfigures and then just using the custom keyfigures in the query.

We noticed performance impacts when we used currency translation in the query.

MP.

[Former Member]

>

> Are you sure this is the business requirement? Typically SO and PO transactions in SAP have a Price Date which is the date used for calculating exchange rates for a particular transaction. 
> We are calculating the currency conversions in the backend DSO's and Infocubes using the fixed pricing date and storing it in custom keyfigures and then just using the custom keyfigures in the query. 
> We noticed performance impacts when we used currency translation in the query. 
> 
> MP.

Unfortunately in this case/project are no specific business requirements. Not only for currency conversion. Because the currency conversion can be done in various areas (DSO, Query ...) I thought I will be more flexible doing the conversion in query. Also the data amount is large but not exremly large and in addition to this the query selection of the clients will be very specific so that the performance will be fine. I assume that.

Do you have some examples or step-by-step guides for currency conversion in DSO or InfoCubes?

Thank you!