Skip to Content
0
Former Member
Feb 27, 2009 at 09:00 AM

Using different Currency Translation in Query

21 Views

Hi!

Following situation: i have kyf A (doc curr).

I created to two currency translation types: from doc curr to EUR and from doc curr to stat curr.

The problem is, that many currency conversions (e.g. CAD --> USD) are not available, so that i cannot directly convert from doc to stat curr. First i must convert to EUR and than to stat curr.

Now, i created two restricted kyfs in the query designer. In the first kyf, i'm using the curr. translation to convert from doc curr into EUR. Then i've taken the first restricted kyf into the second kyf and tried to convert it to stat. curr with the other curr. translation type. It doesn't work.

For example:

KYF A (doc curr. = CAD) = 100 CAD --> KYF B (EUR) = 120 EUR --> KYF C (stat. curr. = USD) 100 CAD

It is possible to use two curr. translations one after another? Or must i convert the one kyf (doc --> stat. curr.) directly in the infoprovider using a function module?

Thanks for answers!