SAP PROFITABILITY ANALYSIS CONFIGURATION Published by Team of SAP Consultants at SAPTOPJOBS Visit us at www.sap-topjobs.com Copyright 2005@SAPTOPJOBS Alll rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form, or by any means electronic or mechanical including photocopying, recording or any information storage and retrieval system without permission in writing from SAPTOPJOBSTABLE OF CONTENTS INTRODUCTION 1. Structures. 1.1 Maintain aracteristics 6 1.2 Maintain Value fields 17 1.3 Maintain Operating Concern ... eS) 1.4 Set Operating Concern (KEBC) oe 2240 1.5 Assign controlling area to operating concern ... eel 1.6 Define Profitability Segment Characteristics (Segment —Lvl Characteristics) . 42 1.7 Copy Operating Concern including Customizing 45 2. Master Data . 47 2.1 Maintain Characteristics values .. 47 2.2 Define Characteristics Hierarchies 49 2.3 Define Characteristic Derivation. 52 2.4 Define and Assign Valuation Strategy. 66 2.5 Define Keys for Accessing Material Cost Estimates .. 70 2.6 Assign Costing Keys to Any Characteristics .. 73 2.7 Assign Value Fields 83 3. Planning. 85 3.1 Define Number Ranges for Planning Data. 85 3.2 Maintain Versions... 86 3.3 Assign Quantity Fields . seseeeennee seseeeesesses BB 3.4 Set Up Planning Framework... seseeetseese BY 3.5 Assign Characteristic Groups to Plan Cycles 99 3.6 Assign Receiver Plan Version 101 3.7 Define Structure of Cost Center Assessment /Process Cost Assessment me wre LOB 4. Flows of Actual Values. me on wre OE 4.1 Define Number Ranges for Actual Postings ..... 107 4.2 Maintain Value Field Groups . 107 4.3 Assign Value Field Groups for Line Item Screens . -109 4.4 Activate Transfer of Incoming Sales Orders... oi, 4.5 Transfer of Billing Documents .. oA, 4.6 Assign Quantity Fields . «198 4.7 Maintain PA Transfer Structure for Direct Posting FI/MM (KEI2) .114 4.8 Automatic Account Assignment (OKB9). 121 4.9 Define PA Transfer Structure for Variance Settlement. Qi 4.10 Assign PA Transfer Structure to Settlement Profile 138 4.11 Maintain Characteristic Groups ... 134 4.12 Assign Characteristic Groups to Actual Cycles 135 4.13 Assess Cost Center Costs / Process Costs ..... sees 136 4.14 Activate Profitability Analysis ee i 5. Information system...........0.00++ 5 ise, LA 5.1 Define Variables for Reports... wee 144 5.2 Define Forms for Profitability Reports (KE34)... 145 5.3 Create Profitability Report (KE31 . 164 6. Tools .. 172 Page 3 of 36.1 Check Customizing Settings. 6.2 Transport (KE3I) Page 4 of 4INTRODUCTION What is the functionality of the PA module? PA module is the most important module when it comes to analyzing the results of the organization. In this module you basically collect the revenues from the sale order , the costs from the production order, cost center or internal order and analyze their results. The interesting part about this module is that when it collects the costs and revenues it also collects the characteristics associated with the costs and revenues and this is what makes it stand out. So for eg.using PA module you can find out the following: Profit of a certain product Profit of a certain product in a certain region Profit of a certain product in a certain region by a certain customer Profit of a certain product in a certain region by a certain sales person And the list can go on in depth It is one of the most wonderful modules in the SAP. So basically Profitability Analysis (CO-PA) enables you to evaluate market segments which can be classified according to products, customers, orders or any combination of these, or strategic business units (which is a group of product lines) with respect to your company’s profit or contribution margin. The module aims at providing your sales, marketing, product management and corporate planning departments with information to support internal accounting and decision making. We will configure Operating concern 9100 (Organizational structure of CO-PA). Controlling area 9100 will be attached to the operating concern. Company code 9100 will be attached to the controlling area 9100. Sounds confusing read it again . Alright lets get started right away. Page 5 of 5For doing the configuration we use the following path on the SAP application screen:- SAP Menu > Tools > AcceleratedSAP > Customizing > SPRO - Edit Project > $¢ SAP Reference ING Configuration for all the modules will be done here. The above path will not be referred henceforth; we will directly refer to the IMG node. 1. Structures 1.1 Maintain Characteristics IMG > Controlling > Profitability Analysis > Structures > Define operating concern > Maintain Characteristics What are characteristics and Value Fields? In the operating concern two things are basically defined a) Characteristics b) Value Fields Characteristics are nothing but those aspects on which we want to break down the profit logically such as customer, region product, product hierarchy, sales person ete Value Fields are nothing but the values associated with these characteristics Eg Sales, Raw Material Cost, Labour Cost, Overheads etc Once you define the characteristics and value fields the values are updated in the table. So Characteristics are nothing but the analysis dimensions for CO-PA. They define what items or objects the user will be able to analyze. Several essential and obvious characteristics (like "sales organization’," customer", “product”, etc.) are pre-defined automatically for every operating concern; these are known as fixed characteristics. In addition to the fixed characteristics, up to SO non-fixed characteristics can be added to an operating concern. Page 6 of 6These non-fixed characteristics must be added to the field catalog before they can be used to define a new operating concern. Characteristics in the field catalog can be accessed in any client. Characteristics can be categorized according to how and when they are defined: * Copying characteristics from reference tables: You can use characteristics that already exist in other applications when you define your operating concerns. + Characteristics created from scratch: You can create ones which are only required in Profitability Analysis. To derive values for these characteristics, you need to define your own derivation strategy. + Predefined characteristics: In addition to the fixed characteristics, a number of other predefined characteristics are available in the field catalog and can be added to your operating concern if desired. These include the customer group, customer district, country, and others. + Fixed characteristics: A number of fundamental characteristics are automatically predefined in every operating concern. These include the product number, company code, billing type, business area, sales order, and so on, Let us first view the Characteristics delivered by SAP. Update the following: Page 7 of 7Edit Characteristics: Start Page 8 of 8Gg) st 1 CGE OHR DHHA AD OB Display Characteristics: verview @veacaryaaxoa tas ‘us| ‘el “cma fo ‘us| ‘ema “caus ‘tae ‘us| wn rom orcas Benes i Be fed me oe bernaton Des, bua oF Fant rember Pightro. cana] |_forcry Pint tye FinhtTyne cms] oe istered? —ustHeoi ems) loParammmen —— frEoL ore Customer —‘Custitero2 can] _LOPAPARTIER HED joc Custorerrier03 ‘GustHoro3 CHAR] —_10PAPARTIER _—_‘HIEOS ower TATA season TATA sex, Caf) once gap ustgroup HAR] 2k home The characteristic which we want (Bill to party) is not readily available so we need to create them click B Click |O Page 9 of 9bien Named General Data in Customer Master Customer Master (Company Code) Customer Master Sales Data General Material Data Plant Data for Material Sales Data for Materia Attriuutes of CRM Sales That Can be Used in PA Attrinutes of CRM Service that can be used in PA etal fields that can be used in CO-PA WAS (Work Breakdown Structure) Element Master ata Plants/Branches Sales Document: Header Data Sales Document: Item Data Sales Document: Business Data Generated Table for View VIAURKST Page 10 of 10tha, @ With own value maintenance ‘without value maint, Owith reference to existing values Now we will create a user defined characteristic. A user defined characteristic should begin with WW Page 11 of 11Update the following:~ « ix] Banas Create Char. WW007 2D Be te dd) PL D1 Dispiay compound | Asson Check Table IE) Page 12 of 12Click savelldl aa Note now that the check table number, text table, text field, data clement domain has been populated with values automatically. S S505 Fe Page 13 of 13Click on B to activate the characteristic. Click o to create another user define characteristic Business field. Update the following:- Update the short text, heading and data type Page 14 of 14Create Char. Wwoo8 Page 15 of 15Change Char. WWO08 ADGA IDM Note now that the check table number, text table, text field, data element domain has been populated with values automatically. Click w to activate You will get the following message, ignore it. Field KMVKGR has the saue neue as field VKGRP FS@SGMRGo ao 41. 00x Page 16 of 161.2 Maintain Value fields IMG > Controlling > Profitability Analysis > Structures > Define operating concern > Maintain Value Fields Value Fields are nothing but the values associated with the above characteristics. Once you have defined the characteristics in the above manner then you need to determine what are the values you would like to analyse for Eg Sales, Raw Material Cost, Labour Cost, Overheads etc ‘There are some SAP rules for defining value fields which are laid down below: Maintaining Value field in the field catalog:- > All value fields must in the field catalog (here) before they can be used to define a new operating concern. Value fields in the field catalog can be accessed in any client. SAP has some suggested value fields which might be used in a new operating concern. Value fields can also be defined independently (but they should begin with VV..., and should be 4 to 5 characters total) It is not necessary to create value fields for calculated items, such as net sales, contribution margin, etc. These items are normally calculated from the base values stored in the value fields during the report execution progress (to minimize necessary data storage requirements). @ v Page 17 of 17to check the SAP provided value fields Page 18 of 18elelole)clelelslelele)elelelelelelelelsiele |G} O}] @] C) @) OG) 6} 0) c} eo) eo} e)}e} 0} e)¢ We will create our own value fields, therefore click 2 ve Page 19 of 19Click IO to create value field Update the following Update short text Click © to activate the value field. Click O to create another value field Page 20 of 20Create Val. fid V¥003 ABER NEI Click 7 to activate the value field. In the screen below, you will see the status of the value field has become active. Page 21 of 21Similarly create other value fields:- These are the value fields created by us. Page 22 of 22| i | qn | i | i Pe ieu =) Lt Click on Save [ 1.3 Maintain Operating Concern IMG > Controlling > Profitability Analysis > Structures > Define operating concern -> Maintain Operating Concern Operating Concern is the organizational unit in Controlling- Profitability analysis (CO-PA). The operating concern can have 2 approaches:~ 1) Costing based Profitability Analysis — This groups costs and revenues according to value fields and costing based valuation approaches. 2) Account based Profitability Analysis - groups costs and revenues according to accounts and uses an accounting based Page 23 of 23valuation approach. Accounting based Profitability is permanently reconciled with Financial accounting. Costing based Profitability analysis is a powerful approach providing greater analysis capability. In costing based we define operating concern by selecting the characteristic (the one created by us and SAP delivered) and the value fields (created by us) to be used in the data structures. ‘The structure of an operating concern is valid in all clients. The system creates following table in costing base co-pa :~ CE1XXXX (where XXXX is the operating concern code) ~ Actual line item table (CE2XXXX — Plan line item table CE3XXXX - Summary records by profitability segments CE4XXXX - Profitability segment definitions It_is important to note here that no customizing request get generated here. You have to transport the setting through a separate transaction code called as KEI. We will refer specifically wherever customizing requests get generated. This means you do not have to use the program KE3I for some customizing objects. We are configuring the costing based co-pa. Update the following:- Page 24 of 24Maintain Operating Concern DSS Aetons | data structure | Deseniption [iuestrommmyansig 7 [i costing-based GD Accounthased [> create) Status eco Click on create 1 Click ¥) Page 25 of 25Update the following:- 18/€6@ 288/598 Ho) Maintain Operating Concern Co G actions GP beta structure DataStructure a ‘Sample operating concer Description A Group Operating concern ‘Type of Profitability Analysis (JAccounthased Data structure Create, Status > Operating concern currency In costing-based Profitability Analysis, actual data is always updated in the operating concern currency. > Company code currency In addition to the operating concern currency, you have the option of storing all data in the currency of the relevant company code as well. This is required if your organization operates internationally and deals with exchange rates that change daily. It allows you to avoid differences due to different exchange rates and lets you reconcile your CO-PA data directly with FI Profit center valuation You can also store data in both of these currencies valuated from the viewpoint of individual profit centers, ¥ Page 26 of 26Since A grp is based in the Middle cast we select that country’s currency. Further we also select the company code currency so that each company code can have an analysis in it’s own company code currency. Please remember that the company code currency is only to be switched on, if you have a single controlling area and a single operating concern for multiple company codes operating in different countries. Switching on the company code significantly increase your data volume. Fiscal year variant:-The fiscal year variant should match with the controlling area fiscal year variant and the company code fiscal year variant. We select K4 since Company code 9100; controlling area 9100 has the same fiscal year variant. Update the following:- 16) ©6@ S88) 51 Maintain Operating Concem (hl 1 Actions | (GP Data structure || [Cumency types forcosting-basedPromtanlityAnaysis~ ===SSOSOSCSC*C~S* Operating concern currency SAR ‘Company code currency 4 ‘OpConcem ercy,PrCtrvaluation —(] ‘Comp.Code crey,PrCtrvaluation ==) Fiscal year variant ka) 2nd period tpe- Weeks (JAct 2nd per. type (Plan 2nd per. ype Page 27 of 27‘A Group Operating con: Click on Here we need to select the characteristics available, into our operating concern. On the right side are shown available characteristic, you need to select and take it to the left side. Page 28 of 28Edit Data Structure: Characteristic Screen @: GBS?6BR0NeGOn Field catalog sal) tields> [go jo. rebate FB cH inusty SJ RK 3 oistict AKOSTL—_[Costontor [Business proc. Form ofmanuracture tate RP [Customer aroup cMATYP ircrat type rn rand KHCATE jusiness field DEST estnaton tight number al light ype 7 Select the following characteristic from the available characteristic Page 29 of 29field Acro Operating en a tietde> steue | New ia Click | to transfer the characteristic Page 30 of 30Feld catalog cal] fields» [onaractenste [bese [onaracensic___[escnpton Het siomarHion uN ight number a2 stomerHie2 | Ly light type 103 ustomererd3 ett 103, Su 13 to — ee — segment rial grou ifEL jelsen ID ‘foperation 16 location ion (CO) || 8 ? ee _ S| || Similarly select other, which will look like this Page 31 of 31Edit Data Structure: Characteristic Screen @; SOP BOX RCO —— Click Mualdeness Similarly select the value fields into our operating concern. Page 32 of 32Edit Data Structure: Value Field Screen 2:1 @GS47BRX R08 Flot catalog ‘call fields ial Click * to scroll down to next page of value field until you see the value fields created by us such as VVOO1 Sales unit Select these value fields Page 33 of 33Click id Page 34 of 34Edit Data Structure: Value Field Screen @ 1 Be P?SRRR08 Feld catalog eal falas Further select all other value fields created by us Page 35 of 35Field catalog sali tielde> Page 36 of 36Click on Click | ") to activate the data structure Page 37 of 37Edit Data Structure: Characteristic Screen a; ¢aa7ReNagon ‘call field Click Back Here you might get a pop up asking ‘Whether you want to generate the operating concern now’. You can select Yes to generate the operating concern. In case you do not get any pop up, you can generate the operating concern here. Click on Penifonel Page 38 of 38Maintain Operating Concem Page 39 of 39Maintain Operating Concern Remember both the Cross client part and client specific part should show green indicator, which indicator the operating concern environment has been generated successfully. 1.4 Set Operating Concern (KEBC) IMG > Controlling > Profitability Analysis > Structures > Set Operating Concern Here you select the operating concern 9100. All functions that you then execute thereafter and until you logoff will relate to that type of profitability analysis for the specified operating concern. You can click on the save button to store the operating concern 9100 in your user master. From the SAP application side you can call this through transaction code KEBC. Page 40 of 40,1.5 Assign controlling area to operating concern IMG > Enterprise Structure > Assignment > Controlling > Assign controlling area to operating concern We assign the controlling are 9100 to operating concern 9100. => Customizing request generated here Page 41 of 41@) —ss—— si I CGE BNE HHHHE Change View "Assignment Operating concern -> CO Area”: 01 2ZeBBo Click on BB 1.6 Define Profitability Segment Characteristics (Segment -Lvl Characteristics) IMG > Controlling > Profitability Analysis > Structures > Define Profitability Segment Characteristics (Segment-Lvl Characteristics) It is advisable for performance reasons to keep to a minimum the number of profitability segments and therefore summary records required in CO-PA. This can be controlled through the selection of segment-level and non- segment-level characteristics. It is possible to configure the system so that certain characteristics are not used in defining profitability segments. The impact of this is that the values for these non-segment-level characteristics will appear on CO-PA line items, but will not be available for reporting with the CO-PA drill-down reporting tool. For example, it is desirable to have the originating sales order number on each CO-PA line item (CE1) which originated in SD, but it is not desirable to also have a new summary record in CO-PA (CE3) for each new sales order (this would create as many summary records as line items). Thus, when we create a new operating concern, the relevant table is automatically set so that the following characteristics are not used to form the profitability segments: sales order (KAUFN) ~ sales order item (KDPOS) - order (RKAUFNR) - WBS element (PSPNR) + ~ cost object (KSTRG) => Customizing request generated here Page 42 of 42Make EXTWG as costing based Page 43 of 43,Change View "Profitability Segment Characteristics”: Overview Vea BR Similarly make other fields such as business segment and business field as costing based Page 44 of 447) Change View "Profitability Segment Characteristics”: Overview 22BE8B Entry 15 of 25 Click on Save 1.7 Copy Operating Concern including Customizing IMG > Controlling > Profitability Analysis > Structures > Define operating concern > Maintain Value Fields This configuration is important when you want to copy customizing settings from an existing operating concern to a new operating concern. This is very usefull when you are doing rollouts for the same group. This is required where the design implemented is separate controlling area and separate operating concern for each company Page 45 of 45code. You can copy settings from an existing operating concern and make changes required for the new operating concern. Here you specify the source operating concern and the target operating concerns. You can choose whether you want to copy data structures only, customizing settings only or both. ‘These are copied in separate steps: 1) You need to copy the data structures first. In case you want to make some changes to the new operating concern after copying, you should generate the environment. You must enter a target operating concern name that does not yet exist. 2) You can then copy the customizing settings. 10 C@4@/0HR8 ooo AA ¢ SAP R/Z @ Cony Import operating concern,’ Copy operating concer Copy fom, —. +4 Source operating concem B Souace clent 09 | coByto, ‘Target operating concern Target chent Copy Osta Ste Libata structures: Licenerate environment (cross-clent) Page 46 of 462. Master Data 2.1 Maintain Characteristics values IMG > Controlling > Profitability Analysis > Master Data > Characteristic Values > Maintain Characteristic Values Here we maintain the values for the user defined characteristics. Cae 2988 Bf @ Change Characteristic Values | Al characteristics on/off | Operating concern: 9100 A Group Operating concern CE user-defined characteristics Double click PU=i#ss/Semient |) Click on Mw erties Update the following:- Page 47 of 47Click on Save eo Double click ##i#e8) Field 7 B¢6@ BHR HHHD Ah © Change View "Values for Characteristic "Business Field”: Overvi Click on “ewenties Page 48 of 48Click on. 2.2 Define Characteristics Hierarchies IMG > Controlling > Profitability Analysis > Master Data > Characteristic Values > Define Characteristics Hierarchies You. can define hierarchical structures for characteristics in Profitability Analysis (CO-PA) and analyze these structures in the information system. You can for example structure your products or customers in a hierarchy. In our scenario we will create a hierarchy of sales group into sales offices. We are combining sales groups into sales offices. This hierarchy can be used in the reports for analysis purpose. Page 49 of 49Chat. (EI) variant coup 1 @ Brand-SkU Burnes sagent a ms (o_o aeate(chanae | (TI _ostete Select Sales group and update the following:- 8) Do00 BB) ‘Marerchy Processing Oe 2aoe fo Update the following:- Page 50 of 50cite Ma oa update the following:- Hierarchy Processing: Maintain Hierarchy VKGRP ZSG (2D) Sanetorel Di Lowerievel TH) OR samelerel (ER Lower level OF empty rode | sort. text: Sales offices Hierarchy variant 236 seats Cenged oO 280 Sales offices India oO ES Eastern region sales office ag im Oo o = oa = o = oO = o = o = o = o = o — Page 51 of 51Take a drop down by pressing F4 button in each of the field. a 7 SRCMEERER Hierarchy Processing: Maintain Hierarchy VKGRP ZSG @ O sametevel D Lower level O ( sane level IF) Lower lavel | Shore text Sales offices Hierarchy variant 256 statue Chenged ao 28G Seles offices India a ZES Eastern region sales office a [#1 Calcutta 1 g [42 calcutta 2 u [———Ec3 West Bengal 1 g [44 eat Bengal 2 a ‘——C7 Orissa 1 go 293 South region sales office Qa ‘$1 Chennai 1 g st2 Chennai 2 oO C3 Coimbatore a $C4 Madurai a Lies Trtcnt Click on & 2.3 Define Characteristic Derivation IMG > Controlling > Profitability Analysis > Master Data > Define Characteristic Derivation Here you set up the derivation of characteristic values. Derivation lets us find values for certain characteristics automatically based on the known values of other characteristics, where these characteristics are logically dependent on one another. In our scenario we have to make the following derivation strategy. Page 52 of 52The structure of the product lines A grp is as follows: Business Field Business Segment Strategic business unit Thus strategic business unit (SBU) is the lowest level node in the product line structure. The SBU is again a grouping of all similar products. In our scenario the SBU is represented by the field EXTWG (Brand-SKU). This field is available in the basic view of the material master. All the finished products will have in the basic data view updated with the relevant SBU code. We define a derivation rule to derive the Business segment from the SBU. We further define a derivation rule to derive Business field from the Business segment. Thus Profitability reports can be seen at the SBU level, Business segment level and the Business field level. click 2 click 9 Select Derivation rule Page 53 of 53Click Update the following:- Characteristic derivation: Change Structure of Rule Take a drop down in field Name Page 54 of 54Page 55 of 55Characteristic derivation: Change Structure of Rule £ (| Gh | i Martane vates: Take a drop down in name Page 56 of 56Page 57 of 57Characteristic derivation: Change Structure of Rule D. 2 2 | BB mantan nic vates | Derivation of Business segment from EXTWG(Brand sku) Page 58 of 58Characteristic derivation: Change Structure of Rule Definition DB) BD | GB tartan nie vates Derivaton of Business segment from EXTWG(Erand sku) Characteristic derivation: Change Structure of , D| A | GB mantannie vaues Derivation of Business segment from EXTWG(Brand sku) (00 Issue error message if no value found (COTE Maintain entries using vaidity date (1 Optimize access, no from-to values can then be mantained | User-defined step 1D (options, see F1 help) Page 59 of 59ctick on Click on Update the following:- Characteristic derivatio: z [pss [pss [pss [po pT pe ‘yj The field Brand SKU is found in the basic field of the material master MARA which can be seen below. The drop down values for the field Brand-SKU is maintained by Logistics general. Page 60 of 60Besant ofmasue kv RE] Matetel gp 15000 (Old material number Brand SKU (@) Divison 40 Lab fofce Product alocation Prod.hierarchy plant mat! status ‘Vaid from, Cl Assign effect. vals GenitemCatGroup NORM Standard item ctick 5 to create further derivation rule OOK e (o\__ i Controlling > Profitability Analysis > Master Data > Valuation > Valuation Strategies > Define and Assign Valuation Strategy => Customizing request generated here Here we define valuation strategies and assign them to a point of valuation. Since we want to use the material cost estimate for valuation, we will check the material costing field and specify the quantity field. Click | New entries Update the following:- 18 €@@ 68h aaa) New Entries: Overview of Added Entries 2aeeao Double click Gldetats Click | New entries Update the following:- Page 67 of 67click |B Select the followis 15900 5 T iO t 5 I ial 5 | [ a ma of et = 5 — — Double click SlAssgnment of valuation Click on Sw snttis Page 68 of 68Take a drop down in field PV Page 69 of 692.5 Define Keys for Accessing Material Cost Estimates IMG > Controlling > Profitability Analysis > Master Data > Valuation > Set Up Valuation Using Material Cost Estimates > Define Keys for Accessing Material Cost Estimates => Customizing request generated here Product Cost Planning is used to determine the planned cost of goods manufactured for a finished product. In CO-PA, we access these material cost estimate to valuate data in CO-PA. Here we define costing keys to determine which cost estimates from Product cost planning should be used to valuate actual or planning data in CO-PA. Click on | N= enties| Update the following:- Page 70 of 70New Entries: Details of Added Entries yaaa Fou] stvaleod mata Gtdtel © Transf. standard cost estimate OTransfer sales order cost estimate z9PL 1 4 Released standard cost estimate matching goods issu Oest estimate is executed without date (lAdaitive costs Plant used for reading cost estimate (© Use tne Item plant 2s cost est. plant OSpecify cost est, plant: Oo Transfer aux, CC spit Ci Transfer cost estimate in controling area currency Click on |@ Click on “¥®"€5 to create another costing key. Update the following:- Page 71 of 71New Entries: Details of Added Entries gaae © Transf, standard cost estimate: (Transfer sales order cost estimate Gost estimate is executed without date (ladaitive costs Plant used for reading cost estimate © Use line item plant as cost est, plant Specify cost est. plant: CiTransfer aux. CC split Ci Transfer cost estimate in controling area currency Click on a Click on Newenties Update the following:- Page 72 of 72“yP1| Std Valuation lanl © Trasf, standard cost estimate O Transfer sales order cost estimate ‘Costing variant ‘Costing version 1 © Period indicator 3 Materia cost estimate matching pasting date OPeriod/vear > Costing date Cost estimate is executed without date Cladattive costs Plant Used for reading cost estimate: Use Ine item plant as cast est, plant. Osspeaty cost est. plant: CiTransfer aux. CC spit (Transfer cost estmate in controling area currency Click on [BI 2.6 Assign Costing Keys to Any Characteristics IMG > Controlling > Profitability Analysis > Master Data > Valuation > Set Up Valuation Using Material Cost Estimates > Assign Costing Keys to Any Characteristics Page 73 of 73Click on 2 ctick on Select Table look up Update the following:- The following will come automatically Page 74 of 74Take a drop down in the first field ‘Field name’ and select Page 75 of 75(Origin Feld na... Short text veew \Valuation variant for the curent standard cost estimate Valuation vatant for past standard cost estimate Costing version of the future standard cost estimate Casting version ofthe current standard cast estimate Costing version ofthe previous standard cost estimate Corian Group as Subdhision of Cost Element Casting avertead croup Period of future cost estimate Prod of the current cost estate Period of the previous cast estimate: Future fiscal yea IMEEW POATL Fiscal year for curent cost estimate |weew POATW Fecal year of provius cast estate (MEEW EKALR Mater is costed with quantity structure |Meew vpLeR Previous planned price IMEEW MLMAA — Matar ladger activated at mater level MEW MLAST Materia Price Determination: Control MBEW LPLPR Current planned price IMEEW VKSAL Value of Total Valuated Stock at Sales Price MEEW HKMAT — Materiaelated orign |MeEW SPERW Physical inventory Biocking indeator (ucuwienaa nb icicatas foe uclaconh Take a drop down in the second field ‘Field name’ and select GLOBAL WERKS Plant used for reading cast estimate IGLOBAL-2 USERTEMP2 1st temporary feld for determining costing keys |GLOBAL-2 USERTEMP2 2nd temporary fied for determining costing keys |GEOBALS2|USERTEMPS [rd temporary field for determining costing kays |GLOBAL-2 USERTEMP4 4th temporary field for costing key determination |GLORAL-2 USERTEMPS Sth temporary field for costing key determination JGLOBAL-2 USERTEMPS 6th temporary field for costing key determination Page 76 of 76Assign costing keys to any characteristics: Change Table Lookup via Curent pan pete Page 77 of 77Assign costing keys to any characteristics: Change Table Lookup aoe Change valuation type field VRGRAR to usertemp1 Take a drop down in the first field ‘Field name’ and select Page 78 of 78Valuation Class in Previous Period Total valusted stock in previous period Price unit of previous period Value of total valuated stock in previous period \Value based on moving average price (previous period) Standard price in the previous period Moving Average Price/Periadic Unit Price in Previous Period Price Control Indicator in Previous Period Previous planned price Fixed proportion of previous planned price Total vauated stack in year before last ‘Value of total valusted stock in year before last Tota valuated stock in period before last \Vaue of total vauated stock in period before last Date of last physical inventory for untestricted-use stock ‘Valuation based on the batch-spectfic unit of measure UIFO/FIFO-elevant Date as of which the price is vald Page 79 of 79Assign costing keys to any characteristics: Change Table Lookup vigen This will come automatically Page 80 of 80Update the following:- Page 81 of 81Assign costing keys to any characteristics: Change 2\a (HH Manta cule valies Click 1 Clic, HB Mantain rue values ‘Assign costing keys to any characteristics: Change Values PIB BBB) BB AG| Boson © cn/or commcirnwars | Page 82 of 82Evaluate price control indcator from table MBEW 2.7 Assign Value Fields IMG > Controlling > Profitability Analysis > Master Data > Valuation > Set Up Valuation Using Material Cost Estimates > Assign Value Fields => Customizing request generated here Here we assign the cost component structure from Product cost planning to the values fields of our operating concern. Page 83 of 83Take a drop down(press F4) in the field PV 02 Pert revaluation of actual data 5 ‘Manual planning 04 Automatic planning Take a drop down in the field F/V. Raw Materias/@ fr Mfg. cost variable Vol. Var. Prod. CC Mfg. cast fixed Price var. Prod. ord Other Var Prod, Ord Valin stocks Finally the table should like this after updating all entries. Page 84 of 84New Entries: Overview of Added Entries ao 100 29) Cos to Vabe Fels IP¥_|CCo. 1 Adname 2 Fid name 3. 1 material & SFG. O15 OAS (a) Packing Material ros fwroas &) ene tee vos 01s ja Balanies and Wages ywvo19 18 oy overheads 8 ¥¥019 019 D1 6 Depreciation 2 wos ois 2 [Dther costs: b 13 ywvo1s cy Ee [a B iz] Cate) Cel E__Postten,.. matey 1 of 45 Click on @ 3. Planning 3.1 Define Number Ranges for Planning Data IMG > Controlling > Profitability Analysis > Planning> Initial Steps > Define Number Ranges for Planning Data Each planning data posted in CO-PA will generate a planning document. We need to maintain the number range for planning document Update the following:- Page 85 of 85Number ranges for pian line items in pro (2 cows Se Groups | 3.2 Maintain Versions Page 86 of 86IMG > Controlling > Profitability Analysis > Planning Initial Steps > Maintain Versions Here we maintain the plan version required for planning in CO-PA. General Version Definition Click on Yes to transfer the version to operating concern Change the exchange rate type from M to P Page 87 of 87(666 BHR S058) Change View "Settings in operating concern’ Vives BE 2a oo biog stuctire — > Cceneral vrson defi ‘Glsettinas hn opetathg} ‘Dsettinas fr Prot co} © Gicontrotng area sett} Gasetnigs by fal Gibotta version: eu Dsettinas fr Praress retails Gureney type BO Operating concen curency exchate type standard trandatton for cost panning ()Gheck derivation o1.03.2009{8) Chatactarste goun Click 3.3 Assign Quantity Fields IMG > Controlling > Profitability Analysis > Planning> Initial Steps > Assign Quantity Fields => Customizing request generated here A number of quantity fields are defined and used in the SD billing system. In this step you assign these to the corresponding quantity fields in costing-based Profitability Analysis (CO-PA). We assign all the quantity fields we want to transfer from the billing system to costing-based CO-PA. Click on ewontes Page 88 of 883.4 Set Up Planning Framework IMG > Controlling > Profitability Analysis > Planning> Planning Framework-> Set Up Planning Framework The initial screen for setting up and performing planning uses a uniform graphic interface. The architecture of your planning is represented in a tree hierarchy. Here, you work essentially with the following four elements: > Planning levels You use the planning level to determine the level at which planning is to occur. You do this by specifying the characteristics for planning. > Planning packages You specify characteristic values in a planning package. In this way, you determine the market segment for which planning is to take place for a particular period. A planning package can thereby be seen as a Page 89 of 89work package that determines which planning objects are relevant to a specific planner. > Planning methods Planning methods are functions with which planning data can be entered and changed. > Parameter set A parameter set contains all the settings necessary for executing a planning method We want to do a sales plan for a year based on customer, product , Gross sales and sales unit. Click [> Sinise! and right click! Side ean exe! Page 90 of 90so Click Select Click Select = Page 91 of 91Page 92 of 92 HH: ayClick on Display planning level ‘Change planning level Copy planning level Delete planning level Transport planning level ‘Ad hoc planning package Click on “2858 and right click Page 93 of 93Right-click the Enter planning data ® {Enter planning data), Select from the Popup Menu »> Create parameter set Execute method Ad hoc parameter set Coistiay SaerPinautd Page 94 of 94Click the Layout Create [4 button Page 95 of 95,Z91SFLAN Sales lan Click the Value flds |Vall@8") tab button Page 96 of 96[oa] _<[~[# Value fields lvaldif in stocks Vol. Var. Prod. CC Page 97 of 97to open planning package 2006 double click #28) Click © ® Enter planning ¢ Double click ® 291°. “The documert you are opering conkains macros. Some macros ray covksn harnfl viruses. If you ara sure this document is froma trusted sauwee, ck es, IF you are not sure and wark to prevent any macros fren runing, ck NS wee |e] Peven| Page 98 of 98x De Ow Foot font ot He suman eRe OR! BOT er ANU a™ OL C2 ane [es o[PSem|ae we | intent (ss 2 6 [anes 3.5 Assign Characteristic Groups to Plan Cycles IMG > Controlling > Profitability Analysis > Planning Integrated Planning > Transfer Cost Center Planning/Process Planning > Initial Steps > Assign Characteristic Groups to Plan Cycles. => Customizing request generated here Before we can assign characteristic group to plan cycle, we need to create the characteristic group. The characteristic group is created in step 4.11 This step is necessary for assessment cycle maintenance, to determine which characteristics can be used to define the receiver segment. We assign the characteristic group 1 to Plan assessment to COPA. Example: During segment maintenance for a planned assessment cycle, the fields profit center, company code, business segment and sales group should be available for entry. We therefore assign a characteristic group containing these characteristics to the business transaction KSPB (Plan assessment to CO-PA). Page 99 of 998 1B CGE BH HHH Change View "Assign Characteristic Groups to Plan Cycle: VeBEBa (Characteristic group assessment (CCA) @ 18 ¢ (BNR ans Change View "Assign Characteristic Groups to Plan Cy Poa aR click B Page 100 of 100