Skip to Content
avatar image
Former Member

Fixed Source Currency Translation at Query level

Hi Folks,

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.

Best regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 22, 2014 at 11:03 AM

    Hi Folks,

    Could anyone please advise on this.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kitu,

      as far as I know with the currency translation in a query all data records are translated, not only the records of one source currency.

      So If you want to have several currencies in your report, you may not use the curr translation in the query, but you need to create the data records for the currencies which you want to see in the report.

      regards

      Cornelia