Conver type in query properties is wrong

[Former Member]

Hi, gurus here.

In TCURR when the exchange rate type is M, there are just exchange rates records bwtween TRL and USD.

I've defined a conversion type of currency and exchange rate type is also M.

But in query properties, the convert to currency is EUR(should be USD) and TRL.

What's wrong?

Thanks, for your help.

[former_member188080]

Hi,

Normally currency conversion would take the rates which are maintained lastest and what you have defined in the query property.so if it is M so average rate will be take lastest.

So you cvan maintain such rate if there is some different currency being used say Euro,it will fetch the latest rate for currency conversion.

Thanks and regards

Kiran

[Former Member]

Hi, thanks.

But when exchange rate type is M, there is not any EUR data in TCURR.

How could the EUR appear in query properties?

[ravi_chandra3]

Hi niceday,

Can u tell me what is ur source currency and what is the target currency u would like to convert ?

Thanx & Regards,

RaviChandra

[Former Member]

Hi, thanks.

Source currency is TRL.

Target currency is USD.

[ravi_chandra3]

Hi niceday,

I think u can achieve that in the exchange rate tab give the exchange rate type as M and in the currency tab give the the fixed currency as TRL and the target currency as USD. u can get ur desired o/p. Revert back in case of queries.

Thanx & Regards,

RaviChandra

[Former Member]

Yes,that's what I did before.

But in query properties, the convert to currency are TRL and EUR, not TRL and USD.

And sometimes the convert to currency of query properties display nothing.

[former_member209702]

Hi,

Currency translation is based on currency translation types. The business transaction rules of the translation are established in the currency translation type. A combination of various parameters (source and target currency, exchange rate type, time reference for conversion) determines how exchange rate determination is performed for the translation.

The following currency translation types are not available at the runtime of the query.

>>> Inactive translation types

>>> Translation types for which a variable is stored (variable time reference, source currency from variable, target currency from variable, and so on)

>>> Translation types in which an InfoObject is used for determining the source currency or target currency

The available Target Currencies at query prperties level depends on the defined active Currency Translation Types.

Hence, would you please check whether the Currency Translation Type that you have defined in RSCUR is in active version?

If its not, then please activate that.

You can refer following link for furhter details:

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0d5bf96-b19b-2c10-e3b6-e2f12a3de99a?QuickLink=index&overridelayout=true|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0d5bf96-b19b-2c10-e3b6-e2f12a3de99a?QuickLink=index&overridelayout=true]

Regards,

Geetanjali