Currency Translations - source of coversion rates

[Former Member]

Hi.

I am trying to figure out the source of the conversion rates that are used for the different currency keys. Whether they are entered manually or loaded from R/3.

Where would you go to set this up?

Many thanks,

Allan

[Former Member · Accepted solution]

Hi,

the currencies and there conversion rates are loaded from R/3 to BW. For this goto rsa1->sourcesystem, right click on your source system and select 'tranfer global settings' or 'transfer exchange rates'. After successful upload, you'll find the stuff in tables tcur*

regards

Siggi

[Former Member · Accepted solution]

Thanks Siggi.. that answered my question.

Thanks also everyone else for your suggestions.

regards,

Allan

[Former Member]

Hi Allan,

In case of non-SAP systems you need to maintain currency rates in BW in TCURR table. We did it once loading data into ODS and then using ABAP program - into mentioned table.

Best regards,

Eugene

[Former Member]

Currencies are maintained in R/3 either on a daily/average monthly rate. The rate (if you want a daily rate or a rate based on fiscal period) is derived from this basic exchange rate table maintained in R/3. The Tcode in R/3 where the exchange rates are maintained is OB08. Here the rates are uploaded daily/monthly depending on the requirement. The table to view the exchange rates is TCURR.

In BW, you can get the rates uploaded from rsa1 and the path specified in the earlier posting.

[Former Member]

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

Regards