1 / 28

Confidential

CO-PA Accelerator On HANA Workshop Basic introduction to CO-PA. Confidential. CO-PA accelerator Purpose of basic introduction. This introduction is meant for consultants with no prior CO-PA application experience . Application consultants still need to gather more knowledge by

ayala
Download Presentation

Confidential

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CO-PA Accelerator On HANA Workshop • Basic introduction to CO-PA Confidential

  2. CO-PA accelerator Purpose of basic introduction • This introductionismeantforconsultantswithnoprior CO-PA applicationexperience. • Applicationconsultants still needtogathermoreknowledgeby • CO-PA trainingcourses • Practicalprojectexperiencewith SAP ERP andits Controlling modules • Technical consultantsmayusethisintroductiontoknowwhattheapplicationisabout.

  3. CO-PA in ERP: provides highly integrated Profitability Analysis for customer-defined product-market segments Settlement of production variances Financial Accounting Production Sales ProfitabilityAnalysis Billing doc. MM SD PP CO-PA Product Costing Cost of goods manufactured CO-PC Cost allocation Cost center assessment FI-GL CO-OM Overhead Management Order settlement Direct postings from Financial Accounting

  4. Organisational Units in SAP ERP Operating concern - Controlling area - Company code Op.concern 0001 Op. concern 0002 C.area 0001 C.area 0002 C.area 0003 C.code 01 C.code 02 C.code 99 C.code 03 In account-based it is only possible to report on each controlling area separately !

  5. CO-PA characteristics define the market segments product customer company code billing type business area controlling area division sales organization distribution channel plant Fixed characteristics plus up to 50 user-defined characteristics

  6. ERP CO-PADB CO-PA value fields for quantities & currencies SD FI CO-PC CO-OM Cost centers Orders Processes Productcosting Posting to a G/L account Billingdocument Quant. Rev. Sls ded. CGMV CGMF Overhead Characteristics Value fields ( in costing based CO-PA ) Customers define up to 200 value fields / operating concern

  7. CO-PA in a Nutshell : Creating the line-items CO-PA derivation of characteristics SD MM FI CO • master data derivation • derivation rule / derivation structure • user-exits P-100 DE 1000 02 V-100 Market information CO-PA reporting CO-PA characteristics CO-PA valuation • product costing • conditions and costing sheets • user-exit Revenue -- Costs ------------- Profit 750,00 120,00 40,00 27,00 9,71 CO-PA value fields ( in costing based CO-PA )

  8. market SD CO- PA P1 P2 P3 Sales revenue Sales deductions Sales overhead Customer service Sales result after service Manufacturing costs Production variances R & D costs Operating result 130 20 10 5 95 60 5 15 15 150 15 10 5 120 90 10 10 10 150 20 5 5 120 100 5 25 -10 CO-PA in a Nutshell: Reporting on Market Segments Company Billing document for a customer group for a distribution channel P3 P2 P1 Profitability Analysis CO-PA Cost of Sales Accounting Sales revenue - Sales deductions - Cost of sales CO-PA reporting is based on value fields and key figures ( key figures are calculated on the basis of value fields ) = Operating profit

  9. Profitability Analysis by Market Segments Product Customer Region Sales office Business Unit Reporting Dimensions Sales Quantity Sales Revenue Customer discount Sales commission Direct sales costs Net revenue Direct material costs Variable production costs Contribution margin I Material overhead Fixed production costs Contribution margin II Variances Contribution margin III Overhead costs Operating profit Determine and analyze the profitability of market segments Revenue $$ Profit Cost Loss Time CO-PA reporting is based on value fields and key figures ( key figures are calculated on the basis of value fields )

  10. Costing based CO-PA Account based CO-PA CO-PA in a Nutshell : Reporting Currencies Operating Concern currency Company Code currency Transaction currency Company Codecurrency Controlling Areacurrency Account-based CO-PA not (yet) supportedbyaccelerator Available Currencies

  11. Important CO-PA data base tables Costing based CO-PA Account-based CO-PA CE1xxxx CE2xxxx CE3xxxx CE4xxxx CEST1 CEST2 CEST3 CEST4 Actual line-items Planning line-items Object level CO-PA Object table CO-PA COEP COEJ COSP, COSS CE4xxxx Account-based CO-PA not (yet) supportedbyaccelerator xxxx = name of the operating concern CE(1-4)xxxx = generated data base tables CEST(1-4) = template structures

  12. CO-PA table structures: CE1 / CE3 / CE4 • CO-PA data structures are generated • CO-PA characteristics (fixed + up to 50 user defined) and value fields (up to 200) are user-defined ! CE1xxxx: CO-PA line items ( actual data ) PAOBJNR period posting date characteristics value fields CE3xxxx: CO-PA object level ( summarization data ) PAOBJNR period value fields CE4xxxx: CO-PA object table ( definition of market segments ) PAOBJNR characteristics

  13. CO-PA table structures: CE3 / CE4 CE4xxxx object table segment table dimension table characteristics CE3xxxx PERIO value fields profitability segment number PAOBJNR The connection between CO-PA characteristics (CE4xxxx) and CO-PA transaction data (CE3xxxx) fact table object level segment level

  14. CO-PA characteristics: CE1 / CE4 (1/2) segment-level characteristics non segment-level characteristics See TA: KEQ3 Profitability Segment (PAOBJNR) 4711 P-100 DE 1000 01 NORTH 4 CE1xxxx All(!) CO-PA characteristics are stored in table CE1xxxx (‚asposted‘) CO-PA characteristics • fixed characteristics ( see TA: KEA0 ) • + user defined characteristics • SAP fields from reference table • created from scratch by user ( WWxyz ) CE4xxxx 4711 P-100 DE 1000 01 Profitability Segment (PAOBJNR) only segment level characteristics are stored in table CE4xxxx (‘according to current structure’)

  15. CO-PA characteristics: CE1 / CE4 (2/2) segment-level characteristics as posted ( according to CE1xxxx ) CE1xxxx 4711 P-100 DE 1000 01 NORTH 4 After a realignment run on table CE4xxxx the customer group has changed from 01 to 02 CE4xxxx 4711 P-100 DE 1000 02 PAOBJNR segment-level characteristics after realignment according to new structure ( according to CE4xxxx )

  16. CO-PA segment-level characteristics • Regular CO-PA reporting is done on the basis of segment-level characteristics • Segment-level characteristics can be defined separately for costing based CO-PA and account-based CO-PA ( see TA KEQ3 ) • Realignment changes definition of profitability segments, regular CO-PA reporting accesses new / realigned definitions only • Non-segment-level characteristics can be displayed in line-item reports of costing based CO-PA( in costing based CO-PA it is also possible to do reporting based on line-items; in line-item reports all characteristics are available )

  17. CO-PA characteristics: Realignment • Changes the Definition of Profitability Segments • Reporting accesses the New Definitions only CE4XXXX CE4XXXX Prof.seg. Region Cust.no. Prof.seg. Region Customer 1 2 NORTH NORTH 47114717 1 NORTH 4711 2 4717 WEST NORTH WEST REGION NORTH REGION 4711 4717 Customer 4711 4717 Customer

  18. CO-PA characteristics: User defined characteristics from reference tables + generated ones Reference tables: All key-fields of the reference tables are fixed characteristics in every operating concern! Customer master data: KNA1customer KNB1 customer company code KNVV customer sales organization distribution channel division Material master data:MARAmaterial MARC material plant MVKE material sales organization distribution channel Sales document data: VBAK sales document header data VBAP sales document item data VBKD sales document business data Reference structures: PAPARTNER CO-PA field catalog + User defined characteristics WWxyz without reference to the SAP DDIC ( i.e. with CO-PA generated check tables T25xx and text tables )

  19. CO-PA Multi Dimensional Reporting • CO-PA reporting is based on value fields and key figures ( key figures are calculated on the basis of value fields ) • Costing based CO-PA reports take data either from CE3/CE4 or from CE1/Ce2 line-item tables Customer group REGION North South East Profitability Analysis 01 02 03 Report CO-PA Cost of Sales Accounting Sales revenue A B C - Sales deductions - Cost of sales Division = Operating profit

  20. CO-PA Multi Dimensional Reporting Lead column: nameof characteristic Lead column:Attribute "City" All attributes

  21. CO-PA Reporting: Summarization levels   Segmentlevel (CE3 / CE4) Summarization levels Reports Deltaline items ( CE1 / CE2 )

  22. CO-PA Reporting: Summarization Levels Define level in TA KEDV Catalog K81 CE4 CE3 Initial build using RKETRERU K81 CE1 CE2 Update using RKETRERU

  23. Basic Concepts of CO-PA – Costing based CO-PA Characteristics Values Sales Region North Product Prod1 Product Group Electronics Customer Cust1 Customer Grp Wholesale State Illinois Sales Rep Miller REGION CUST. GRP. PROD. GROUP Profitability segment Value Fields Revenue Discounts COGS Revenues 800 Discounts 100 COGS 650

  24. Basic Concepts of CO-PA – Account-Based CO-PA Account-based CO-PA not (yet) supportedbyaccelerator Characteristics Values Sales Region North Product Prod1 Product Group Electronics Customer Cust1 Customer Grp Wholesale State Illinois Sales Rep Miller REGION CUST. GRP. PROD. GROUP Profitability segment Accounts 800000 820000 400000 800000 ( Revenue ) 800 820000 ( Discount ) 100 400000 ( Cost ) 650

  25. CO-PA Reporting: Reading data from CE3/CE4 Query Object table Object level (1) (3) CE4 CE3 PAOBJNR characteristics (2) (5) "Join" PAOBJNR PERIO value fields (4) How CO-PA reporting retrieves the data! characteristics value fields (6) CO-PA report data

  26. CO-PA Reporting: Stacks of Summarization Levels Summarization Level 000001: PLIKZ GJAHR PERIO VERSI VRGAR Summarization Level 000002: PLIKZ GJAHR PERIO VERSI VRGAR Category Summarization Level 000003: PLIKZ GJAHR PERIO VERSI VRGAR Category Class Summarization Level 000004: PLIKZ GJAHR PERIO VERSI VRGAR Category Class Brand

  27. Sources of Value Fields ( costing based CO-PA ) Quantity SD Sales Revenues Billing Document Sales Deductions Cost of Goods Sold CO-PC Cost Estimates ( from Product Cost Planning and Material Ledger ) Variable Cost of Goods Mfd Fixed Cost of Goods Mfd FI Bonuses General Ledger Posting Freight Costs Cost Center Order Process Sales and Administration Costs CO-OM Marketing Costs Variances WBS Element Network Operation PS Research & Development Costs CO-PC-OBJ Production Order Production Variances CO-PA Estimated Discounts Additional Costs Estimated Bonuses

  28. CO-PA: Transfer of Overhead Costs - Overview CO- OM Admin. costs Assessment Cost center Field service hours Value fields Direct/indirect activity allocation Marketing campaign Order/Project Settlement CO- PA CO- ABC Assessment of process costs Customer care Indirect activity allocation Process Special deliveries Template allocation

More Related