currency conversion

[Former Member]

Hi Gurus,

I have NET VALUE KF stored in the ODS in the document currency. I also have the unit local currency in the ods.....how would you convert those netvalue kf's into local currency when i feed the data into the cube............i.e- if the document currency is in CAD and the local currency is USD, how will i convert the net value into USD

Thank you

[Former Member · Accepted solution]

You can call this function module in the Start Routine of the update rules. eg

Move DATA_PACKAGE-YrAmt to S_AMT_1.

CALL FUNCTION 'RSW_CURRENCY_TRANSLATION'

EXPORTING

I_CTTNM = 'YrCurrConvType'

I_AMOUNT = S_AMT_1

I_SCUR = DATA_PACKAGE-YrSrcCurr

I_TCUR = YrTrgtCurr

I_TIME_IOBJVL = CALMONTH (yrTimeRef)

IMPORTING

E_AMOUNT = ConvertedAmt

E_TCUR = YrTrgtCurr

[Former Member · Accepted solution]

Thanks Paolo, another follow up question, where do i see if the FM exists- i mean which transaction??? is this a standard function module???

Southie

[Former Member · Accepted solution]

It is a standard one; transaction se37

Regards

[Former Member · Accepted solution]

got it, thanks a million