Skip to Content
0
Former Member
Oct 26, 2005 at 03:23 AM

Records multiplied by 3 times

126 Views

Matez,

I`m getting my results in SAP BW multiplied by 3 times of my data in SAP R/3.

Okay, pls allow me explain my scenario.

I built a Query <i>SUMMARY OF GROUP FINANCIAL PERFORMANCE (OPERATING COSTS)</i> on InfoCube : <b>0PCA_C01</b>

In my Query, I have 2 Structure's.

<b>ROW Structure</b>... basically contains Selections like Manpower Cost, Building Management, IT Maintainance and so on. This Selections are built by Restricting <b>0ACCOUNT</b> by the Hierarchy from SAP R/3.

<b>COLUMN Structure</b>... basically contains Selections like Current Month, Previous Month , Variance. Here this Selections are restricted on <b>0FISCPER</b>, 0VERSION & 0VTYPE

My Filter contains 0CO_AREA and Key Figure Amount(0ECPCA_K0001).

Now, the results of my query say for Manpower Cost in SAP BW is USD 13595232.96. However, when I check this value based on the Number Range in my SAP R/3 using Transaction KE5Z it is USD 4.531.744,32(which is basically 1/3 on the values displayed in SAP BW)

Please advice the necessary mates!