Skip to Content
0
Former Member
Sep 14, 2007 at 07:52 PM

User Logic for Conversion Type Instead of Hard coding in query.

30 Views

Hello , Good response from SDN but thats all standard which I know. Please help me to resolve the problem as stated below. SDN friends are always best help.

Requirement: User will select the Target Currency; Will select the Exchange Rate like Monthly Avg 002M. Now there has to be a variable in Conversion which tells the logic to pick Conversion Type ZVHGR if Exchange Rate = 002M, but if Exchange Rate = 001, then Conversion Type ZVHMR.

<u><b>

Approach to solve abo</b></u>ve

1. I have created a Currency Translation Type " FiscperConversion" "ZVHGR" now this has Exchange Rate Type from Variable "ZVARN" (Which is a variable single value manual input on 0RTYPE Infoobject for exchange rate.)

2. Now Currency Tab: Target Currency is selected from Variable placed in the Report. ZRPVAR.

3. Now the Variable Time Reference is used. Standard Infoobject 0FISCPER

which is beginning of period.

Now all the above is done. Let go to the query and For Value of kEYFIGURE "Audit Balance" in Conversion Tab Conversion Type is specified is "FiscperConversion" ZVHGR"same as above and thats it. But the problem is here user want a variable that user can select the Conversion Type Instead of Hard coding.

<b>Please suggest how to create this variable for Conversion Type and specify in query designer since In Conversion Tab this is not allowed to have variable.</b>

Please help me very soon

Thanks

Soniya Kapoor

null