Skip to Content
-1

Currency translation - exchange rate not picked up by BW BEX query

Nov 09, 2016 at 08:36 PM

221

avatar image

Hi Experts,

I have a BI query in which I am performing the conversion from 'amount in document currency' to 'amount in local currency' with exchange rate as on today. I am using currency translation variable with below setting.

  • Exchange rate type = M
  • Source currency from data record
  • Fixed target currency = GBP
  • Fixed time reference = current date

I have transferred all the 'exchange rates' as well as 'global settings for currencies' into my BW system from the source system. When I run the query, I am getting all the records i.e. 'amount in document currency' converted to 'amount in local currency' with 'exchange rate as on today' except one conversion (EUR to GBP). I have checked TCURR table and it has the appropriate conversion rate maintained for this conversion too.

I am getting this error message when I run the query and EUR amount does not get converted in to GBP and gets displayed only in EUR.

  • No exchange rate from EUR to GBP and date MM/DD/YYYY found (currency transl. ZVARIABLE/M)

Can you please help ?

Thanks,

Romil

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers