Key figures with currency conversion showing weird values.

[Former Member]

Hi Experts,

I have a variable screen,

User can key in Target Currency, and Month.

Say,

(Scenario 1) User keys in Target Currency "MYR", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

2| 3| 5| 7| 0| 0| 0 ...

This is correct.

(Scenario 2) User keys in Target Currency "USD", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

2| 3| 5| 7| 3| 5| 7 ...

This is wrong, should not show figures for month May and onwards.

(Scenario 3) User keys in Target Currency "SGD", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

1| 2| 3| 4| 0| 0| 0 ...

This is correct.

*In the infoprovider, the key figure is tied to currency "MYR".

In developement system, i replicated the exchange rate table, and the problem (Scenario 2) is solved.

In test system, i replicated the exchange rate table, and the problem (Scenario 2) is still there.

I am not sure what is happening here.

Please could you please kindly advise.

Thanks.

Tee

[former_member211907 · Accepted solution]

There appear to be two factors happening here.. one is how you have your query restrictions set up, and the other is the currency translation method that you are using. What results a currency translation provides depends on both the translation key definition AND the availability of a valid currency translation for the appropriate period.

First, review transaction RSCUR and see how your currency translation is defined.

Then review transaction oB08 and see if there is a valid currency conversion factor during the affected time.

Once you're certain all that is correct, review your query and how it is functioning. The fact that you wish to display months for which you do not wish to return data seems to indicate your 0CALMONTH2 restriction is not set up properly.