Skip to Content

What is the use of CO-PA? And how it is different from Generic Extraction?

What is the use of CO-PA Extraction? And how it is different from Generic Extraction?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 26, 2018 at 05:49 PM

    See, if this helps. Lengthy, but works.

    Introduction to CO-PA:

    • Controlling Profitability Analysis evaluates the profitability of an organization by strategic business units.
    • Apart of daily transactions, it captures the details of various discounts, expenses, promotions and thus gives the organization actual profit details. It helps to analyze the market trends & make better decisions.
    • Organizations can also submit their different forecasts or targets for various organizational units for various periods in CO-PA.
    • This helps the organization to compare the plan & actual sales done so that the performance of different business units can be analyzed in better way and they can take the necessary steps for corrections.

    Types of Profitability Analysis

    We have 2 types of PA:

    • Costing-based Profitability. is the form of profitability analysis that groups costs and revenues according to value fields and costing-based valuation approaches.

    This type of Profitability Analysis is primarily designed to let you analyze profit quickly for the purpose of sales management. Its main features are, firstly, the use of value fields to group cost and revenue elements, and, secondly, automatic calculation of anticipated or accrual data (valuation). The advantage of this method is that data is always up-to-date and therefore provides an effective instrument for controlling sales.

    • Account-based Profitability. is a form of profitability analysis organized in accounts and using an account based valuation approach.

    This type of Profitability Analysis enables you to reconcile cost and financial accounting at any time using accounts. In contrast to costing-based Profitability Analysis, this type uses cost and revenue elements, which gives you a unified structure for all of accounting.

    The system posts all revenues and costs to both Financial Accounting and Profitability Analysis at the same time and using the same valuation method. This means that the cost of sales is posted to Profitability Analysis at the point of goods issue.

    What is Operating Concern?

    Operating concern which constitutes, combination of characteristics (Customer, Product, Company, Controlling, Controlling Area, etc) & Value fields (Sales Qty, Gross sales, Discounts, Expenses, Net sales, Trade Promotions, Coupons etc) to analyze its profitability.


    Characteristics are the criteria in Profitability Analysis (CO.PA) according to which you can analyze your operating results and perform differentiated sales and profit planning.

    You create characteristics in Customizing under Structures _ Operating Concern _ Maintain


    Value fields:

    Value fields are only required in costing-based Profitability Analysis. These are the fields that contain the currency amounts and quantities that you want to analyze in CO.PA. They

    represent the structure of your costs and revenues. You create Value fields in Customizing under Structures _ Operating Concern _ Maintain Value fields.

    Prerequisites for creating OC:

    1. Create Company Code (SPRO->Enterprise Structure-> Definition-> financial accounting-> check company code).
    2. Create Controlling area (SPRO->Enterprise Structure-> Definition-> Controlling-> Maintain controlling area).
    3. Crate Operating concern in KEA0.

      1. Creation of Cost Element Group in KAH1
      2. Assign the cost element group under a value field in KEI2
    4. Assign Company code to Controlling area in T-code OX19.
    5. Assign Controlling area to Operating Concern in T-code KEKK.

    Note: All the above settings were maintained by FI Consultants.

    How To Create Operating Concern:

    Go to transaction SPRO, Controlling.> Profitability analysis .> Structures .> Define Operating Concern .> Maintain Operating Concern. Or KEA0 is the direct T-code.

    Note: Once the Operating concern is created, these tables CE1XXXX, CE2XXXX, CE3XXXX and CE4XXXX are created automatically in the back-end which can be seen in SE11.

    Database Tables used for CO-PA Model:

    The CO-PA Model is basically based on following 4 tables (once the Operating concern is created, these tables are created automatically).

    CE1XXXX, CE2XXXX, CE3XXXX and CE4XXXX – Here “XXXX” denotes operating concern, specific to organization.

    CE1XXXX: This Table contains Actual transaction data in detail level. Daily transactions, Invoices are captured in this table.

    CE2XXXX: This Table contains Plan/Target line item data. All planned data, different estimates are stored in this table.

    CE3XXXX: This table holds Segment level data. This is set up between the segment table and the line items.

    CE4XXXX: This is the segment table, which is located at a higher level. It is used to assign segment numbers to each combination of characteristic values.

    So, when the line items (CE1 & CE2) are posted, the segment table (CE4) and segment level (CE3) is updated.

    About CO-PA Data source:

    Basically for CO-PA, no standard SAP delivered data sources are available, CO-PA is totally client specific, means based on the client requirement we are going to create CO.PA data source on the client specified operating concern (Specified Characteristics & Value fields).

    • Transaction to create CO-PA Data source-KEBO
    • CO-PA Data source name should start with 1_CO_PA<XXXX>(i.e. XXXX=Your Description) ,name can be maximum of 19 character length
    • CO-PA data source cannot be enhanced. If we have to add/delete fields from data source operating concern has to be modified with the addition/deletion of fields.

    Some points to be noted regarding Delta:

    • When this CO.PA data is getting extracted in BW in delta mode data is always read from Line item tables (CE1 or CE2).
    • An extraction from the segment level, that is, from the combination of the tables CE3/CE4, is only performed for Full Updates if no line item characteristics are selected.
    • Generic Delta in COPA is based on Time stamp, while creating CO.PA data source it will be generated automatically.
    • Once the' INIT' is successful, you will have to maintain minimum of 1/2 hrs time before you schedule the delta load (This is called “safety delta”).
    • Half an hour was chosen as the safety delta to overcome any time differences between the clocks on the different application servers.
    • Doesn’t use the delta queue. CO-PA delta is based on timestamp, which is updated after each delta extraction &reads delta from the CO-PA tables directly.



    eftkt.jpeg (71.7 kB)
    646hw.jpeg (81.2 kB)
    Add comment
    10|10000 characters needed characters exceeded