SAP BW Currency Conversion using Time Reference to exact day

[burns_sh]

Hi all,

we are on BW4HANA, and I have a Open ODS view flowing into a Composite Provider.

There is a query on the CP, and this has a variable for Display Currency which drives what target currency to convert to.

I have created a conversion type with the attached settings;

0CALDAY is a available and populated for each record in the underlying dataset.

And I have added the conversion details to the Key Figure in the Query;

However when the query is executed, it is converting based on the most recent rate and not the rate for the relevant 0CALDAY???

Am I doing something wrong here?

Basically I want to convert all Net Prices on the report based on the rate for the relevant 0CALDAY (which is many different days) and the Target currency entered as a selection variable.

Any help very much appreciated.

Thanks,

Shane.

[andrea_davoli83]

Dear Shane,

did you solve your issue?
Could you share with me the solution? I'm more or less in the same situation.

Thanks thousand

Andrea

[burns_sh]

Hi Andrea,

unfortunately we couldn't solve the issue, I think it is only impacting conversions in the Open ODS KF's where it only does the conversion based on the most recent date only.

We just use this conversion as it is not too big a pain for us.

Sorry couldn't be more help.

Thanks,

Shane.

[Anand71]

Hi,

is 0CALDAY is added in CP?

MFG,

Anand

[burns_sh]

Hi Anand,

yes the 0CALDAY is in the CP, and each record in the underlying data slice has a 0CALDAY populated.

Thanks,

Shane.

[sdsunny372]

Hi Shane bern,

Currency conversion- Exchange rate table is TCURR.

In general scenario currency update by monthly basis ,not daily basis.

Example :- For current April month ,exchange rate affected from 1st April to 30th April and from 1th May ,it will change.

So based on 0CALDAY ,you may not get currency exchange rate as per current day.

As per my suggestion ,you need to compare month and year and based on that it will fetch records. In your case currency exchange rate is converting based on most recent rates ,which is true and acceptable.

Stay home stay safe 🙂

Best regards,

Sagarkumar Darji

[burns_sh]

Hi Sagarkumar,

many thanks for the reply.

We are using the M Rate which has a exchange rate for each calendar day, so I was thinking using a currency rate type for Exchange Rate Type M, and a variable time reference to exact day should give me the corresponding rate for that day.

Do you know if this is what the Time Reference is supposed to do?

Thanks,

Shane.