Fixed Source Currency Translation at Query level
I am trying to covert a fixed source currency into a fixed target currency. For this I have created a currency translation type in RSCUR which is having a fixed source currency and fixed target currency.
Now, when I apply that translation type in query designer at keyfigure level, it converts for all records which have exchange rates maintained to target currency.
For instance, I have LTL to EUR maintained and SEK to EUR maintained for an specified rate type say M. Now, both LTL and SEK are converted to EUR.
My requirement is only to have LTL converting to EUR.
Even I noticed, irrespective of the exchange rate types maintained, translation is happening.
For instance, I have Exchange rate type EURO having exchange rates for LTL to EUR. But if give a different translation type other than EURO, its converting LTL to EUR based on exchange rate maintained against exchange rate type EURO.
I am pretty confused, how its actually referring to TCURR table.
Could anyone advice, how to have a fixed source currency work. Even I tried having a variable for determining source currency which has default values of LTL, but still not working.
Thanks in advance and points will be assigned definitely.