Currency Conversion

[Former Member]

Hi,

Does anyone have a useful document on the concept of Currency Conversions?

Just got an issue from users about their currencies not being latest while consolidating. I've never worked with that before and would appreciate your help.

Thanks

Fran

[Former Member · Accepted solution]

hi fran,

these links might prove useful...

Also have a look at SAP help

http://help.sap.com/saphelp_nw04/helpdata/en/ec/076f3b6c980c3be10000000a11402f/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/462fe790-0201-0010-3ca4-adf...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/287bab90-0201-0010-f48e-cc5...

http://help.sap.com/saphelp_45b/helpdata/en/f8/3a793485231774e10000009b38f83b/applet.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/f1/0a5591e09411d2acb90000e829fbfe/content.htm

Check RRC1 (t-code) as well.

hope it helps...

regards

[Former Member]

Fran,

Also check for docs in www.service.sap.com/bi under infoindex--> currencies.

They deal with handling currecny conversions on query level

-Doodle

[former_member188975]

Hi Fran,

Is the curency conversion taking place at the query level or in the data load process. If in the data load process then my replies in the threads mentioned by Sat will help you to some extent...you will need to see how the process is set up in your system.

If the users are complaining that the rates are not the current ones, then you need to see if there is a job to upload the currencies and rates for conversions from the te R/3 system.

For now you can try to update the currencies in RSA1 > Source Systems > right click on your source system > Transfer Exchange rates.

Hope this helps...

[Former Member]

I know there's a variable for choosing currency type.

I think conversion is being done at query level.

I was also looking for a general overview of how currencies are handled in BW. Couldnt find much on help.sap maybe cuz i dont know how to.

Any tips on how to go about this?

Thanks

Fran

[former_member188975]

Hi Fran,

You can check if and how the conversion is happening at the query level by looking at the Properties of the Key Figures included in your query definition.

You can read a lot of good info about Currency Translation here:

http://help.sap.com/saphelp_nw04/helpdata/en/ec/076f3b6c980c3be10000000a11402f/content.htm

Hope this helps...

[edwin_harpino]

hi Fran,

the exchange rate update from r/3 scheduled regularly ?

rsa1->source system->r/3-right click 'transfer exchange rate' ? or schedule program RSIMPCURR.

also transfer global setting, program RSIMPCUST.

rsa1->source system->r/3-right click 'transfer global setting' checkbox currencies checked.

hope this helps.

[Former Member]

Fran

Have you checked these threads

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/462fe790-0201-0010-3ca4-adf...

Thnaks

Sat