Skip to Content
author's profile photo Former Member
Former Member

CO extractor 0CO_OM_OPA_40 does not pull all data from COEP

Dear experts,

We have a requirement to pull cost data for service orders, and I plan to use standard extractor 0CO_OM_OPA_40 (Orders: Actual Costs-Line Items).

I did a initial load in BW, now the problem is: On ECC side the COEP table has 3 million records, but on BW side this datasource only pulled around 1.5 million, which is only half the data of ECC table COEP.

So can anybody let me know if this datasource only extract part of cost data? Or what else issue cause the data volume inconsistency? Or if I am using the wrong datasource?

Any post will be appreciated and thank you all in advance!

Thanks and best regards,

Tim

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2012 at 09:07 PM

    Hi TIm,

    I'm not a CO expert at all but the info on the SAP Help Portal link below seems to indicate that COVP is the main table on the OLTP side for 0CO_OM_OPA_40:

    http://help.sap.com/erp2005_ehp_05/helpdata/en/e8/4140a0299541f488b8998c4c1f1177/frameset.htm

    Certainly more fields of the DataSource use COVP as source than use COEP.

    BTW also check if SAP Note 1704784 - DELTA-INIT does not extract all of the data - is relevant in your case.

    Hope this helps,

    Rgds,

    Colum

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Colum

      Although the CO DataSources use COVP, this is actually a database view of the tables COBK and COEP.

      The 0CO_OM_OPA_40 extractor extracts all record where the object number starts with "OR" representing Orders. I have explained in Tim's other post in more detail.

      Regards

      Derek

      COVP.PNG (23.9 kB)
  • Posted on Nov 22, 2012 at 03:30 AM

    HI Tim

    Reference to your other message: http://scn.sap.com/thread/3264937.

    Regards

    Derek

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.