cancel
Showing results for 
Search instead for 
Did you mean: 

BI & ECC data not matching after currency conversion

pruthvi_r
Contributor
0 Kudos

Hi All,

I am using currency conversion in one of the report. when i reconcile the report with ECC there is some difference in converted amount. BI & ECC Amount are not matching.

my cube contains only 0FISCPER (Fiscal year / period) time characteristic and the conversion type is based on:

Exchange Rate type: M

Variable time reference: Beginning of period

Standard Object: 0FISCPER

Please help.

Regards,

Pruthvi R

Accepted Solutions (0)

Answers (2)

Answers (2)

anindya_bose
Active Contributor
0 Kudos

Hi Pruthvi

Check the TCURR table in BW and ECC for Exchange Rate M and Source and Target currency.

Compare the factor you get in ECC and BI on the first day of your chosen period.

If these two table has discrepancy just update the Exchange Rates from RSA1->Source system->Right Click

Regards

Anindya

Former Member
0 Kudos

Hi,

The difference amount could be because of exchange rate mis-match.

In ECC conversion happens based on exchange rate as on that date, however in the scenario mentioned conversion happens based on exchange rate as on start of the fiscal period, hence the difference.

You may try following option ,

Take amount in foreign currency into account and capture that value in BW instead of taking amount in LC and then converting it.

Hope that helps.

Regards

Mr Kapadia

*Assigning points is the way to say thanks.**