R/3 Reconciliation

[Former Member]

I'm trying to match BW numbers with R/3 numbers. The field is CO Actuals in my Purchasing cube. I've been trying to dig down to the table level but am having no success. The infosource involved is 0CO_OM_CCA_9. How can I properly match numbers of my BW query...would really appreciate the help.

Fran

[Former Member · Accepted solution]

Hi,

One way of doing it is, check debug option while extracting data in RSA3. You can look for source tables in the code.

0CO_OM_CCA_9: These InfoSources/DataSources select data from the line item table COEP. This enables additional fields (not contained in the COSP and COSS totals tables) to be transferred to the BW.

Look for the information in help.sap.com.

Comparing BW report against r/3 tables is one way of validating data.

The other way is to use R/3 t-codes related to your purpose and compare R/3 reports against BW reports.

Thanks.

[former_member188975]

Hi Fran,

It is not always straightforward to match the numbers between BW reports and R/3 tables. Do you know if there is a corresponding report in R/3? The following link does give information about what data flows from what field and table. It might help:

http://help.sap.com/saphelp_nw04/helpdata/en/8f/d93c00e39d5b4fb6eaa3bf16e6fb09/content.htm

What key figure are you trying to match? Take a look at its definition in the query, like is it Restricted or Calculated.

Hope this helps...

[Former Member]

Bhanu, thanks for the link. There are a couple of ABAP queries that were made by someone but they lack the selection criterion for Document Date. I have to compare my CO Actuals by document date. Any input? or do u need more info so u can give some input ??? thanks

[Former Member]

Hi,

In that case, create a user entry (mandatory) variable for dcument date in the query.

Thanks.

[Former Member]

I do not know how to create that criterion in ABAP report. Could you guide me please ?

[Former Member]

ok i tried to include the Doc Date as a selection field but its not even available to select when I try to do a change query. ABAP query that is. what do I do? FYI, the query is based on an InfoSet . will i have to change the InfoSet to include that field ??

[former_member188975]

The ABAP queries may lack selection by document date, but do they have document date in the output? In that case you could run the BW and R/3 reports for similar selections as much as possible and then look at the details in the report.

Hope this helps...

[Former Member]

no, the abap queries dont have document date in the output. I want them to have doc date but cant figure out how to add it.