Reconciliation is killing me !!!

[Former Member]

Could someone please help me generate a report in R/3 through which I could match my numbers in BW. The Report in BW is based on a Purchasing Cube. But the KF I have to match (CO ACtuals) is a virtual keyfigure taken from an ODS from Controllong side. Now, How do I dig to the bottem of this??? I'm stuck badly on this issue.

[Former Member · Accepted solution]

Look at the infosource feeding your CO ODS and identify the datasources. This enables you to figure out which CO data was extracted from R/3 and you can lookup in your R/3 tables.

[Former Member · Accepted solution]

Ok i've done some R&D. It turns out to be that my numbers in ODS are matching with those of the SAP query that exists. But that KF (Commitments) is being populated through a virtual KF into the Purchasing Cube. But if I compare the R/3 numbers with the Purchasing cube, the numbers dont match.

So does anyone have any suggestion as to what I should check to make sure i'm getting the right data into the cube in the riht way. ???

Thanks in advance

[Former Member · Accepted solution]

Hi,

According to my thinking, you should not validate ODS numbers against BW report (which might be defined on the ODS itself or the cube) because, you would have done some manipulations to the R/3 data in the Transfer rules or Update rules from Data source to the ODS.You are supposed to validate R/3 data against BW data.

Generally speaking, there will be some standard t-codes existing on R/3 for viewing purchasing reports. You should run this report against a BW report and compare the numbers.

I have not worked with Virtual Key Figures before. Is the Virtual Key Figure included in the cube. Check if there is some logic for filling the virtual key figure in the report.

Is there any corresponding field on R/3 for the virtual key figure in the cube. Is there any corresponding Info object for the virtual key figure in the cube.

Thanks.

[Former Member · Accepted solution]

Hi Fran,

This document might give you some good ideas on how to make this process easier for you.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/uuid/7a5ee147-0501...

Cheers! Bill