How to find in which queries some currency conversion type is used

[jonathanzhang2]

Hi,

The currency conversion type can be set in the properties of the columns of the query in the query designer.

I would like to know how to find in which queries some currency conversion type is used. That's to say, I need to know all the queries name in which some currency conversion type is used.

Many Thanks

Jean

[Former Member]

hi Jean,

I saw the following join conditions online.. jus check if any of them help u.

RSZELTDIR ELTUID = RSZCOMPDIR COMPUID

RSZELTDIR OBJVERS = RSZCOMPDIR OBJVERS

RSZELTDIR ELTUID = RSZELTXREF SELTUID

RSZELTDIR OBJVERS = RSZELTXREF OBJVERS

RSZCOMPDIR COMPUID = RSZELTTXT ELTUID

RSZCOMPDIR OBJVERS = RSZELTTXT OBJVERS

RSZELTDIR ELTUID = RSRREPDIR COMPUID

RSZELTDIR OBJVERS = RSRREPDIR OBJVERS

RSRREPDIR COMPUID = RSZELTTXT ELTUID

RSRREPDIR OBJVERS = RSZELTTXT OBJVERS

RSZELTDIR ELTUID = RSZELTTXT ELTUID

RSZELTDIR OBJVERS = RSZELTTXT OBJVERS

All the best !!

Regards

Aparna

[jonathanzhang2]

Hi Aparna,

I tried all the join conditions above. but cannot get it.

Do you have other solution?

Many Thanks

Jean

[Former Member]

Hi Jean

Try table RSRREPDIR

COMPUID -- as ELTUID

COMPID-- might be the MAPNAME...

Hope it works for u..I am not sure though

All the best !!

Regards

Aparna

[jonathanzhang2]

Hi Aparna,

I tried. unfortunately, table RSRREPDIR didn't work.

Do you have any suggestion.

Many Thanks

Jean

[Former Member]

Hi,

goto table: RSZELTPROP here give the CTTNM = name of the currency conversion type

for each of the ELTUID that is given in the result you have to find the tech name of the query which u can find from

RSZELTDIR where field MAPNAME is the technical name for query.

All the best !!

Regards

Aparna

[jonathanzhang2]

Hi Aparna,

Thank you very much for your information.

As you instruct, In table RSZELTPROP, I get the ELTUID successfully.

But when I used ELTUID in table RSZELTDIR, the filed MAPNAME is blank.

And the field TXTLG is Volume in PC YTD##Plan.

By the field DEFTP equals SEL, I realized this conversion type is used in restricted key figure(selection).

By the info above(TXTLG: Volume in PC YTD##Plan. DEFTP: SEL), how can I get to know for which restricted key figure in which queries the conversion type is used?

Many Thanks

Jean