Issue with Curency Conversion

[Former Member]

Hi all,

We are uploading sales cube (0SD_C03). For billing value we are getting a UK currency 'GBP'. This needs to be converted to 'INR'. Now in R/3 they are using a conversion rate of Rs.77.4698. We need to maintain the same conversion rate value in BW also. How do we do that?

Things that we have tried are:

1. Right click on source system and we have done 'Transfer Exchange Rates' and 'Transfer global settings'.

2. In TCode: SPRO, under SAP IMG Reference, we have set the currency conversion rate.

3. We checked in table 'TCURR' and the rate that we entered through 'SPRO' is maintained in this table.

Has any one tried it? Kindly help us as it is stopping us from completing the project. Thanks in advance.

Best Regards,

Prakash.

[Former Member]

Hi all,

Thanks a lot for the replies.

1. For Ashish Goel - We have checked in TUCRV table for exchange rates and we have the option 'Standard translation at average rate' and that is the one we selected during setting up the currency conversion.

2. For Doodle - In SPRO-->netweaver->general settings->currencies we checked the tables and the currency rate that we had mentioned is available.

3. For A.H.P - When we click on Program->Run program in background under 'Transfer Exchange Rates', we get the option only to Print the job in background. Will that schedule the job in Background?

4. For Bhanu Gupta - The conversion is being done during data load.

We have tried all of these options but still we have some difference in the value between R/3 and BW. Any other steps that might help us solve the issue would be very helpful.

Regards,

Prakash.

[former_member188975]

Hi Prakash,

To set up the job: In the Transfer Exchange Rates screen goto menu > Program > Execute in Background > maintain the output device field and click the green check sign. On the next screen set the scheduling options and save.

In SM37 you can check for a job: RSIMPCURR

Hope this helps...

[Former Member]

Hi Bhanu Gupta,

We have scheduled the job. We need to wait and check the values. Thanks for your input. We will check on this and if we get proper value we shall close this issue. Thanks again.

Best Regards,

Prakash.

[former_member188975]

Hi Prakash,

Where are you doing the conversion...during load on in the query?

[edwin_harpino]

hi Prakash,

do 'Transfer Exchange Rates' should get the changes ..

...

1. Right click on source system and we have done 'Transfer Exchange Rates' and 'Transfer global settings'.

...

you schedule this periodic right ?

in the transfer exchange rates screen, menu program->run program in background.

hope this helps.

[Former Member]

Hi Prakash,

The steps you explained are fine.Also schedule it periodically .This is important to keep R/3 and BW exchange rates synchronized

Check if the R/3 tables have been transfered to bw or not.

SPRO-->netweaver->general settings->currencies and check the tables.

Also in BW you can create currency translation types using RRc1 tcode and use it while reporting in query desinger to get desired currency in the result.

Hope thsi helps

Message was edited by: Doodle

[Former Member]

Check your TCURV table for the exchange rates.