Skip to Content
0
Former Member
Jul 06, 2006 at 10:15 AM

Synchronizing Currency Rates between SAP R/3 and SAP BW

89 Views

Hi guys.

I have a question on synchronizing currency rates between SAP R/3 and SAP BW.

The following details might help you to understand my situation:

<b>[SAP R/3]</b>

Document Date: 09.02.2006

Report Date : 06.07.2006

Amount : 100.00 USD

Amount in LC : 380.00 MYR

<b>[SAP BW]</b>

Document Date: 09.02.2006

Report Date : 06.07.2006

Amount : 100.00 USD

Amount in LC : 350.00 MYR

As you can see today's (Report Date : 06.07.2006) report in SAP R/3 would produce 380.00 MYR where as it is 350 MYR in SAP BW.

So how do I synchorize the currency rate and amount in SAP BW with SAP R/3?

P/S: I am using <b>Currency Translation > Currency Conversion Key > Average Rate for Current Date</b> in my SAP BW's Amount properties.