CO-PA Extraction

Posted by on


Operating concern

 Represents an organizational unit in your company for which the sales market has a uniform structure

operating concern contains 4 segment tables.




Segment table for

                      Actulal transaction
                      Planned transaction
                      Charateristcs fields
                      Value fields



Data is transferred to Operating concern from all Transactions.. SD,MM,FI,PP

but not all data is transferred to operating concern... Only data that is relevant for profitability analysis is transferred to Operating concern.. ie. data is transferred to segment tables.


No transaction is getting directly posted to Operating concern... Only a copy of respected module is taken to operating concern..


This is the reason why SAP has not provided us Standard extractors for COPA...

New fields can get added from other modules ... So SAP has provided us only the procedure to create Datasource..


Addition of new fields are called Regeneration...

COPA has two types..

* Cost based
* Account based

Cost based is done mainly in manufacturing and production Industry..

Account based is done in Service Industries...



COPA datasources have 3 mandatory fields..

1     Value type
       Actual         - 10
       Planned      -  20


2     Version
       version of plan


3      Currency, Currency Type
        There are 3 types of currency type.

        operating concern currency
        Transaction currency
        Company currency



If datasource is regenerated , The best practice is to delete datasource and recreate it with same name...
        
      








Tcode KEB0



Choose the operating Concern... In our case We use IDEA... which is used for IDES system





In Tcode space give "=INIT" and press enter





Choose all the fields needed and click on Infocatalog






Copy datasource name and check for data availability in Extraction checker








BW side

Replicate Datasource in BW system









Activate the Datasource




























Now our data is available in BW.. and delta queue is also created....

Take this data to cube creating a DTP and transformation...


Comments

  1. AnonymousSeptember 29, 2013 at 9:42 AM

    Nice document I have seen ever......Thanks a ton..................

    ReplyDelete
    Replies
    1. Mohamed AslamNovember 28, 2013 at 8:01 PM

      thank you
      keep visiting... :)

      Delete
    2. UnknownDecember 11, 2013 at 7:24 AM

      your are awesome dude........it's a perfect blog and i have nerver seen like this.

      please keep maintain.

      Thanks you soooooooooooo much

      Delete
    3. Mohamed AslamDecember 12, 2013 at 10:03 PM

      thanks sunny.......

      Delete
    4. anoopJanuary 6, 2014 at 5:32 AM

      I was searching for some thing like this:) Well explained. Thanks a lot Aslam :)

      Delete
    5. Mohamed AslamMarch 2, 2014 at 9:56 PM

      Thanks anoop

      Delete
    6. harishankarJuly 10, 2017 at 12:03 PM

      thanks

      Delete
  2. UnknownJanuary 28, 2014 at 1:42 AM

    Thanks A lot Aslam !!!! Very good presentation. Well explained. Keep maintain. Thanks.

    ReplyDelete
    Replies
    1. Mohamed AslamMarch 2, 2014 at 9:56 PM

      Will try to maintain... Thank you... :)

      Delete
    2. UnknownMarch 17, 2014 at 9:22 AM

      Hello.Your blog is too good . I am unable to find FI data extraction here.Can you help me in finding it?

      Delete
    3. Mohamed AslamMarch 17, 2014 at 9:24 AM

      http://easy-learn-bw.blogspot.in/2013/07/ecc-extraction.html

      Delete
    4. UnknownJune 5, 2014 at 11:20 AM

      Good one.

      Delete
  3. AnonymousJuly 12, 2014 at 4:40 AM

    Hi Aslam,

    Great to see such a nice document that explains CO-PA extraction so effectively and easily.
    I am new to the CO-PA and this document really helped a lot to get the gist of it. Many thanks !!

    Its my humble request to you, that could you please share your knowledge on CO-PA in more detail (theoretical explanation of basic process involved and their significance) on the same so that it help us to understand and implement it in much more better way.I will be highly grateful.

    ReplyDelete
  4. KarunAugust 24, 2014 at 6:58 AM

    Excellent document Aslam, I've never come across a document which is so well drafted with all useful inputs. Really appreciate your help. Very much useful for all of us. Thanks a ton.

    ReplyDelete
  5. MADHAVANOctober 4, 2014 at 11:46 PM

    You are a Legend !!!Thanks a lot :)

    ReplyDelete
  6. UnknownJune 18, 2015 at 6:29 PM

    Hello Everyone,
    In the COPA Extraction when do we load data from the flat file.

    Thank you very much.

    Regards,
    Kumar

    ReplyDelete
  7. UnknownNovember 20, 2016 at 7:44 AM

    Great Docs...Thanks a lot..

    ReplyDelete
  8. UnknownNovember 20, 2016 at 7:45 AM

    Great Docs... Thanks a lot...

    ReplyDelete
  9. VelingtonApril 4, 2021 at 10:38 PM

    Hi,
    Thanks for this info. Is there a way to enable it as real time as its grayed out.
    Regards,
    Velington

    ReplyDelete

Post a Comment