Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

one Currency to Multiple Currency conversion while Saving budget data

Hi

I need help on currency conversion

my requirement is Users enter Budget data based on selections ENTITY, and "LC(Local currency).

If they enter data in LC then corresponding ENTITY:CURRENCY is taken as Local currency and in Exchange Rate table corresponding exchange rate values need to convert.

Ex:

IN ENTITY DIMENSION

ENTITY : 2200, Currency: SGD

In Rate Model

Category    inputcurrcy     rateentity     rateid     signdata

BUDGET       SGD                CNY          BUD        0.777

BUDGET       SGD                 EUR         BUD        1.7575

BUDGET       SGD                 GLOBAL   BUD       0.656

now user enters budget data in SGD then SGD value need to convert into CNY, EUR and GLOBAL.

this can be dynamic but not hardcoded

I wrote script logic, but it is not working while saving data, my input schedule script logic is in "DEFAULT.LGF"

I hardcoded for GLOBAL then it is working fine, now I want all currencies then script logic is not working

*SELECT(%RT%,"[ID]",INPUTCURRENCY, "[REPORTING]='Y'")

*LOOKUP RATE-BUD

*DIM CATEGORY=BUDGET

*DIM RATEID=BUD

*DIM SOURCECURR:INPUTCURRENCY=ENTITY.CURRENCY

//*DIM TIME=%TIME

*FOR %CUR%=%RT%

*DIM %CUR%:RATEENTITY="%CUR%"

*NEXT

*ENDLOOKUP

*WHEN CURRENCY

*IS LC

*WHEN CATEGORY

*IS BUDGET

*WHEN REVENUE

*IS ASP

*FOR %LOOP_CUR%=%RT%

     *REC(EXPRESSION=%VALUE%

     *LOOKUP(%CUR%),CURRENCY=%CUR%)

*NEXT

*ENDWHEN

*ENDWHEN

*ENDWHEN

I tried for BADI also but couldn't get, can anyone please help me in this regard for multiple currency conversion from one Local Currency

Regards

Silu

Former Member
Not what you were looking for? View more on this topic or Ask a question