config guide

EHP4 for SAP ERP 6.0

December 2010

English

Profitability Analysis (168)

SAP AGDietmar-Hopp-Allee 1669190 WalldorfGermany

Building Block Configuration Guide

SAP Best Practices Profitability Analysis (168): Configuration Guide

Copyright

© 2010 SAP AG. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems, Inc.

JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, Clear Enterprise, SAP BusinessObjects Explorer, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP France in the United States and in other countries.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

© SAP AG of 351


Icons

Icon Meaning

Caution

Example

Note

Recommendation

Syntax

External Process

Business Process Alternative/Decision Choice

Typographic Conventions

Type Style Description

Example text Words or characters that appear on the screen. These include field names, screen titles, pushbuttons as well as menu names, paths and options.

Cross-references to other documentation.

Example text Emphasized words or phrases in body text, titles of graphics and tables.

EXAMPLE TEXT Names of elements in the system. These include report names, program names, Transaction codes, table names, and individual key words of a programming language, when surrounded by body text, for example, SELECT and INCLUDE.

Example text Screen output. This includes file and directory names and their paths, messages, source code, names of variables and parameters as well as names of installation, upgrade and database tools.

EXAMPLE TEXT Keys on the keyboard, for example, function keys (such as F2) or the ENTER key.

Example text Exact user entry. These are words or characters that you enter in the system exactly as they appear in the documentation.

<Example text> Variable user entry. Pointed brackets indicate that you replace these words and characters with appropriate entries.

© SAP AG of 351


Contents

1 Purpose .................................................................................................................................. 6

2 Preparation ............................................................................................................................ 6

2.1 Prerequisites ................................................................................................................... 6

3 Configuration .......................................................................................................................... 6

3.1 Structures ........................................................................................................................ 6

3.1.1 Creating Operating Concern (Enterprise Structure) .................................................. 6

3.1.2 Maintaining Characteristics – Transfer from SAP Table ........................................... 9

3.1.3 Maintaining User-Defined Characteristics ............................................................... 15

3.1.4 Maintaining Value Fields ......................................................................................... 18

3.1.5 Creating Operating Concern ................................................................................... 24

3.1.6 Setting Operating Concern ...................................................................................... 27

3.1.7 Assigning Controlling Area to Operating Concern ................................................... 33

3.2 Derivation & Valuation ................................................................................................... 37

3.2.1 Derivation ................................................................................................................ 37

3.2.2 Valuation ................................................................................................................. 38

3.3 Planning ........................................................................................................................ 92

3.3.1 Maintaining Versions ............................................................................................... 92

3.3.2 Plan Settlement: Receiving Version in CO-PA ...................................................... 104

3.3.3 Maintaining Revaluation Keys ............................................................................... 110

3.3.4 Defining Planning Layout ...................................................................................... 116

3.3.5 Defining Planning Levels ...................................................................................... 125

3.3.6 Defining Planning Packages ................................................................................. 137

3.3.7 Defining Planning Methods (Parameter Set) ......................................................... 143

3.3.8 Creating Plan Assessment .................................................................................... 152

3.4 Flows of Actual Values ................................................................................................ 200

3.4.1 Transfer of Billing Documents ............................................................................... 200

3.4.2 Order and Project Settlement ................................................................................ 212

3.4.3 Direct posting from FI/MM ..................................................................................... 239

3.4.4 Settlement of Production Variances ...................................................................... 260

3.4.5 Transfer of Overhead ............................................................................................ 275

3.4.6 Activating Profitability Analysis .............................................................................. 323

3.5 Information System ...................................................................................................... 329

3.5.1 Defining Variables for Reports .............................................................................. 329

3.5.2 Defining Forms for Profitability Reports ................................................................ 335

3.5.3 Creating Profitability Report .................................................................................. 343

4 Troubleshooting in CO-PA ................................................................................................. 351

4.1 General Troubleshooting – Regenerating the Operating Concern ............................... 351

© SAP AG of 351


Profitability Analysis

1 PurposeThis configuration guide provides the information that you need to manually set up configuration of this building block.

If you do not want to configure manually and prefer to use an automated installation process using BC sets and other tools, refer to the installation guide for this building block.

2 Preparation

2.1 PrerequisitesBefore you start installing this building block, you must install prerequisite building blocks. For more information, see the building block prerequisite matrix (Prerequisites_Matrix_[xx]_EN_SG.xls; the placeholder [xx] depends on the SAP Best Practices version you use, for example, BL refers to the SAP Best Practices Baseline Package: Prerequisites_Matrix_BL_EN_SG.xls). This document can be found on the SAP Best Practices documentation DVD in the folder: \BL_SG\Documentation\.

3 Configuration

3.1 Structures

3.1.1 Creating Operating Concern (Enterprise Structure)

Procedure

1. Access the activity using one of the following navigation options:

© SAP AG of 351


Transaction code SM30 (enter table name V_TKEB2 and choose Maintain.)

© SAP AG of 351


IMG menu Enterprise Structure → Definition → Controlling → Create Operating Concern

© SAP AG of 351


2. On the Change View “Define Operating Concern”: Overview screen, choose New Entries.

3. In the Operating concern field, enter your Operating concern (for example 10SG).

4. In the Name of operating concern field, enter Best Practices.

5. Choose Save.

3.1.2 Maintaining Characteristics – Transfer from SAP Table

Procedure


© SAP AG of 351


Transaction code KEA5

© SAP AG of 351


IMG menu Controlling Profitability Analysis Structures Define Operating Concern Maintain Characteristics

© SAP AG of 351


2. On the Edit Characteristic: Start screen:

a. Choose All Characteristics.

b. Choose Change.

3. In the Caution: You are processing cross-client data structures dialog box, choose Continue.

4. On the Change Characteristic: Overview screen, choose Create.

5. In the Creat Char: Assignment dialog box:

a. Choose the Transfer from SAP table option.

b. In the Table field, enter PAPARTNER.

c. Choose Create.

6. In the Reference table dialog box, choose the KUNWE field and choose Confirm.

7. In the Warning dialog box, choose Enter.

8. In the Save Inspite of Warnings dialog box, choose OK.

9. On the Change Characteristic: Overview screen:

a. Choose Save.

b. Choose KUNWE and choose Activate.

10. Repeat the steps above to create the following characteristics:

© SAP AG of 351


Characteristic Table

KUNRE PAPARTNER

VRTNR PAPARTNER

PAPH1 MVKE

PAPH2 MVKE

PAPH3 MVKE

BESKZ MARC

© SAP AG of 351


PSTYV VBAP

© SAP AG of 351


3.1.3 Maintaining User-Defined Characteristics

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Structures Define Operating Concern Maintain Characteristics

© SAP AG of 351


2. On the Edit Characteristic: Start screen:

a. Choose All Characteristics.

b. Choose Change.

3. In the Caution: You are processing cross-client data structures dialog box, choose Continue.

4. On the Change Characteristic: Overview screen, choose Create.

5. In the Creat Char: Assignment dialog box:

a. Choose the User defined radio button.

b. Enter WWCST in the Char. field.

c. Choose the Without value maint. radio button

d. Choose Create.

6. On the Create Char. WWCST screen:

a. Enter Country Ship-to in the Description field.

b. Enter CST in the Short text field.

c. Enter Country Ship-to in the Heading field.

d. Enter CHAR 3 in the Data type/length field.

e. Choose Save.

7. On the Change Characteristic: Overview screen:

a Choose Save.

b Choose WWCST and choose Activate.

3.1.4 Maintaining Value Fields

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Structures Define Operating Concern Maintain Value Fields

© SAP AG of 351


2. On the Edit Value Fields: Start screen:

a Choose All value fields radio button.

b Choose Change .

3. Accept the info message.

4. On the Change Value Fields: Overview screen, choose Create. Make the following entries, save and activate each value field:

© SAP AG of 351


Value Field Description Amount Quantity

VVFGS Free Goods X

VVMAT Material Costs X

VVMEP Material external Procurement X

VVLCV Labor Costs variable X

VVMCV Manufact. costs variable X

VVOCV Overhead costs variable X

VVLCF Labor Costs fix X

VVMCF Manufact. costs fix X

VVOCF Overhead costs fix X

VVIPV Input Price Variance X

VVIQV Input Quantity Var. X

VVRES Resource usage var. X

VVREM Remaining input var. X

VVLSV Lot Size Variance X

VVMPV Mixed-Price Variance X

VVOPV Output Price Var. X

VVRVA Remaining Variance X

VVSCR Scrap X

VVMSK Marketing X

VVRDC R&D X

VVN10 Non Operating Income X

VVN20 Non Operating Expens X

VVN30 Taxes X

VV910 Rev. for Exp/Travel X

VV950 Travel expenses X

VV970 Costs third party X

© SAP AG of 351


Value Field Description Amount Quantity

VVY01 CO-Bypass Mat. Costs X

© SAP AG of 351


3.1.5 Creating Operating Concern

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Structures Define Operating Concern Maintain Operating Concern

© SAP AG of 351


2. On the Maintain operating Concern screen:

a Enter your Operating concern (for example 10SG) in the Operating Concern field.

b Choose Create.

c Confirm the dialog box.

d In the Description field, enter the description for the Operating Concern.

e For Type of Profitability Analysis choose Costing-based.

f Choose Save.

g Choose Create data structure.

3. On the Create Data Structure: Characteristic Screen:

a Choose the following characteristics and transfer them from the Transfer from pane to the Data structure pane by choosing the left arrow button:

BESKZ, KDGRP, KUNRE, KUNWE, LAND1, PAPH1, PAPH2, PAPH3, PSTYV, VKBUR, VRTNR, WWCST

b Choose the Value fields tab page.

c To transfer the following fields from the Copy from box to the Data structure box, choose the field and choose the left arrow button:

ABSMG, ERLOS, KWKDRB, KWMARB, MRABA, KWMKPR, VVFGS, RABAT, KWSKTO, VVMAT, VVMEP, VVLCV, VVMCV, VVOCV, VVLCF, VVMCF, VVOCF, VVIPV, VVIQV, VVRES, VVREM, VVLSV, VVMPV, VVOPV, VVRVA, VVSCR, VWGK, VTRGK, VVMSK, VVRDC, VVN10, VVN20, VVN30, VRPRS, VV910, VV950, VV970, KWBONI, VVY01

d Choose Activate.

e Choose Back.

4. In the Generate Environment dialog box, choose Yes to generate the Operating Concern Environment.

5. On the Maintain operating Concern screen:

a Choose the Attributes tab page.

b Choose Change.

c In the Operating concern currency field, enter your Currency (for example SGD).

d In the Fiscal Year Variant field, enter K4.

e Choose Save.

f Choose the Environment tab page.

g Activate the client-specific part.

6. To confirm the activation, go to transaction KEA0. Enter your Operating concern (for example 10SG) for operating concern and choose Enter.

7. Choose the Environment tab page and make sure that client-specific and cross-client activation indicators are green.

3.1.6 Setting Operating Concern

Procedure


© SAP AG of 351


Transaction code KEBD

© SAP AG of 351


IMG menu Controlling Profitability Analysis Structures Set Operating Concern

© SAP AG of 351


2. On the Set Operating Concern screen, enter the necessary data.

© SAP AG of 351


Field name Description User action and values Comment

Operating concern Your Operating concern (for example 10SG)

© SAP AG of 351


Type of Profit. Analysis

costing-based

© SAP AG of 351


3. Choose Enter.

3.1.7 Assigning Controlling Area to Operating Concern

UseThe purpose of this activity is to allocate the controlling areas that you want to be able to analyze together in Profitability Analysis to an operating concern.

Procedure


© SAP AG of 351


Transaction code SPRO

© SAP AG of 351


IMG menu Enterprise Structure Assignment Controlling Assign controlling area to operating concern

© SAP AG of 351


2. On the Change View “Assignment Operating concern CO Area”: Overview screen, make the following entries:

© SAP AG of 351


Field name User action and values

COAr your controlling area (for example 1000)

OpCo your Operating concern (for example 10SG)

3. Choose Save.

3.2 Derivation & Valuation

3.2.1 DerivationIn this step, you set up the derivation of characteristic values. Derivation lets you find values for certain characteristics automatically based on the known values of other characteristics, where these characteristics are logically dependent on one another.

When an operating concern is generated, the system produces a standard derivation strategy containing all known dependencies between characteristics. You can display these by choosing View → Display all steps.

3.2.1.1 Defining Characteristic Derivation

UseThe purpose of this activity is to define the characteristic derivation for the characteristics Item Category Dummy and Intercompany Indicator.

PrerequisitesAll characteristics values have been entered and operating concern has been generated successfully.

Procedure


Transaction code KEDR

IMG menu Controlling Profitability Analysis Master Data Define Characteristic Derivation

2. If the Set Operating Concern dialog box appears, enter your Operating concern (for example 10SG) and choose Enter.

3. On the Characteristic Derivation: Display Strategy screen, choose Display <-> Change.

Ship-to party

4. Choose Create Step.

5. In the Create Step dialog box, choose Move and choose Enter.

6. On the Characteristic Derivation: Change Assignment screen:

a. In Step Description, enter YB01: Ship-To Party.

b. In Source field, enter KNDNR and choose Enter

c. In Target field, enter KUNWE and choose Enter.

d. Choose Save and Back.

Ship-to party → Country Ship-to

© SAP AG of 351


7. Choose Create Step.

8. In the Create Step dialog box, choose Table lookup and choose Enter.

9. In the Enter Table Name dialog box, enter KNA1 and choose Enter.

10. On the Characteristic Derivation: Change Table Lookup screen:

a. Enter YB02: Ship-to party Country Ship-to in the Step description field.

b. In the Source Fields for Table Lookup section, make the following settings (Settings in italics to be entered):

Origin Field Name Name Origin Field Name

KNA1 KUNNR Customer Number 1 CO-PA KNDNR

a. Enter LAND1 in the first Field name field inthe Assignment of Table Fields to Target Fields section.

b. Enter WWCST in the second Field name field in the same line.

c. Choose Save.

d. Choose Back.

3.2.2 Valuation

3.2.2.1 Setting up Conditions and Costing Sheets

3.2.2.1.1 Creating Condition Types and Costing Sheets

UseThe purpose of this activity is to define condition types to use in Profitability Analysis (CO-PA) and CO-PA-specific costing sheets.

Procedure


© SAP AG of 351


Transaction code 8KEV

© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Set Up Conditions and Costing Sheets Create Condition Types and Costing Sheets

© SAP AG of 351


2. On the Pricing: Maintain Condition Type screen, click on Create in Condition types section and enter the necessary data:

© SAP AG of 351



Condition Type YB01

Enter

Description Prices

Access sequence

no value

Prices X set Flag

© SAP AG of 351



Mat.Master – Standard Price

X set Flag

© SAP AG of 351


3. Choose Save.

4. On the Pricing: Maintain Condition Type screen, click on Create in Pricing procedures section and enter the necessary data:

© SAP AG of 351



Pricing procedure

YB1000

© SAP AG of 351


description BP Pricing Procedure for CO-PA

© SAP AG of 351


5. Maintain the following entries:

© SAP AG of 351


Step Cntr CTyp From To Description

© SAP AG of 351


010 10 YB01 000 000 Prices

© SAP AG of 351


6. Choose Save.

3.2.2.1.2 Assigning Value Fields

UseIn this IMG activity, you assign the CO-PA condition types you have defined to the corresponding value fields. This determines which condition types are used to value those value fields.

Procedure


© SAP AG of 351


Transaction code KE45

© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Set Up Conditions and Costing Sheets Assign Value Fields

© SAP AG of 351


2. Make the following entries:

© SAP AG of 351


Op. concern CTyp Name Value fld Description

© SAP AG of 351


Your Operating concern (for example 10SG)

YB01 Prices VVMEPMaterial external Pr

© SAP AG of 351


3. Choose Save.

3.2.2.2 Valuation Strategies

3.2.2.2.1 Defining and Assigning Valuation Strategy

UseThe purpose of this activity is to define valuation strategies and assign them to a point of valuation. The quantities transfered from the invoice are valuated with the costs calculated in the product cost estimate. If a valuation strategy calls for valuation using material costing, the system uses the point of valuation to control which cost estimate is read and how the cost components are assigned to value fields in CO-PA.

Procedure


© SAP AG of 351


Transaction code KE4U

© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Valuation Strategies Define and Assign Valuation Strategy

© SAP AG of 351



Valuation Strategy

© SAP AG of 351


Val.strat. Name

© SAP AG of 351


YB1 BP Valuation Strategy

© SAP AG of 351


3. Choose Details and make the following entries:

© SAP AG of 351


Operatingconcern

Val. strategy

Sequence Appl.

Costgsheet

Mat. cstg

Qtyfield

your Operating concern (for example 10SG)

YB1 10 X ABSMG

© SAP AG of 351


your Operating concern (for example 10SG)

YB1 20 KE YB1000 ABSMG

© SAP AG of 351


Assignment of Valuation Strategy

© SAP AG of 351


Operating concern

PV Rec.Plan ver.

Val.strat.

your Operating concern (for example 10SG) 01 F YB1

02 F YB1

03 F 1 YB1

03 F 2 YB1

04 F 1 YB1

© SAP AG of 351


Operating concern

PV Rec.Plan ver.

Val.strat.

04 F 2 YB1

© SAP AG of 351


4. Choose Save.

3.2.2.3 Setting up Valuation Using Material Cost Estimate

3.2.2.3.1 Defining Access to Standard Cost Estimates

UseProduct Cost Planning is used to determine the planned cost of goods manufactured for a product. In Profitability Analysis (CO-PA), you can access these material cost estimates to valuate the data in CO-PA. This includes cost estimates both with and without quantity structures.

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Set Up Valuation Using Material Cost Estimate Define Access to Standard Cost Estimates

© SAP AG of 351


2. On the Change View “Costing Key”: Overview screen, choose New Entries.

3. On the New Entries: Details of Added Entries screen, enter the following data:

© SAP AG of 351



Costing key YB1

description BP Standard Cost Estimate

Transf. standard cost estimate

Choose

Costing variant YPC1

Costing version 1

Period indicator Released standard cost estimate matching goods issue date

© SAP AG of 351


Use line item plant as cost est. plant

Choose

© SAP AG of 351


4. Choose Next Entry and enter the following data:

© SAP AG of 351



Costing key YB2

description BP Plan Cost Estimate

Transf. standard cost estimate

Choose

Costing variant YPC2

Costing version 2

Period indicator Material cost estimate matching posting date

© SAP AG of 351


Use line item plant as cost est. plant

Choose

© SAP AG of 351


5. Choose Next Entry and enter the following data:

© SAP AG of 351



Costing key YB3

description BP: Cost estimate sales order

© SAP AG of 351


Transfer sales order cost estimate

Choose

© SAP AG of 351


6. Choose Save.

3.2.2.3.2 Assigning Costing Keys to Material Types

UseThis assignment determines when and for which record type and plan version which product cost estimates are to be read for a specific material type.

Procedure


© SAP AG of 351


Transaction code KE4J

© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Set Up Valuation Using Material Cost Estimate Assign Costing Keys to Material Types

© SAP AG of 351


2. If the Set Operating Concern dialog box appears enter your Operating concern (for example 10SG) then choose Continue.


© SAP AG of 351


PV RecT. Plan ver. Mat.typ Valid to C.key 1 C.key 2

01 F FERT 31.12.9999 YB1 YB3

02 F FERT 31.12.9999 YB1

03 F 1 FERT 31.12.9999 YB2 YB1

03 F 2 FERT 31.12.9999 YB2 YB1

04 F 1 FERT 31.12.9999 YB2 YB1

© SAP AG of 351


04 F 2 FERT 31.12.9999 YB2 YB1

© SAP AG of 351


4. Choose Save.

3.2.2.3.3 Assigning Value Fields

Use The purpose of this activity is to assign the components of a cost component structure from Product Cost Controlling to the value fields of your operating concern.

Procedure


© SAP AG of 351


Transaction code KE4R

© SAP AG of 351


IMG menu Controlling Profitability Analysis Master Data Valuation Set Up Valuation Using Material Cost Estimate Assign Value Fields

© SAP AG of 351


2. In the Determine Work Area: Entry dialog box enter your Operating concern (for example 10SG), cost component structure Y1 and choose Continue.


© SAP AG of 351


PV CCo F/V Fld name 1 Fld name 2

01 101 1 VVMAT VVMAT


01 102 3 VVY01 VVY01

01 103 3 VV970 VV970

01 109 1 VVOCF VVOCF

01 109 2 VVOCV VVOCV

01 201 1 VVLCF VVLCF

01 201 2 VVLCV VVLCV

01 202 1 VVMCF VVMCF

01 202 2 VVMCV VVMCV







01 305 3 VTRGK VTRGK



03 102 3 VVY01 VVY01

03 103 3 VV970 VV970
















04 102 3 VVY01 VVY01

© SAP AG of 351


04 103 3 VV970 VV970














© SAP AG of 351


4. Choose Save.

3.3 Planning

3.3.1 Maintaining Versions

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Planning Initial Steps Maintain Versions

© SAP AG of 351


2. On the General Version Definition screen, mark the line 0 Plan/actual version and double-click Settings in Operating Concern.

3. On the Change View “Settings in Operating Concern”: Details screen, make the following entries, choose Save and Back (2X):

© SAP AG of 351


Version Operating concern

Currency type Exch. Rate Type

Derivation Date

© SAP AG of 351


0 Your Operating concern

B0 M 01.01.2009

© SAP AG of 351


4. On the General Version Definition screen, mark the line 1 Plan Version: Forecast and double-click Settings in Operating Concern.


© SAP AG of 351


Version Operating concern


Derivation Date

© SAP AG of 351



B0 M 01.01.2009

© SAP AG of 351


6. On the General Version Definition screen, mark the line 2 Plan Version: AOP and double-click Settings in Operating Concern.


© SAP AG of 351


Version Operating Concern


Derivation Date

© SAP AG of 351



B0 M 01.01.2009

© SAP AG of 351


3.3.2 Plan Settlement: Receiving Version in CO-PA

Procedure


© SAP AG of 351


Transaction code KEPV

© SAP AG of 351


IMG menu Controlling Profitability Analysis Planning Integrated Planning Transfer Cost Center Planning/Process Planning Initial Steps Assign Receiver Plan Version

© SAP AG of 351


2. On the Determine Work Area: Entry dialog box enter controlling area 1000 then choose Continue.


© SAP AG of 351


Vsn Version Description Year Receiver Vers.

0 Plan/actual version 2009 0

1 Plan Version: Forecast 2009 1

2 Plan Version: AOP 2009 2















© SAP AG of 351


4. Choose Save and go back.

3.3.3 Maintaining Revaluation Keys

UseRevaluation keys are necessary to change specified value fields by certain percentages.

Procedure


© SAP AG of 351


Transaction code KEF1

© SAP AG of 351


IMG menu Controlling ® Profitability Analysis ® Planning ® Planning Aids ® Revaluation Key ® Maintain Revaluation Keys

© SAP AG of 351


Rev Name

YB1 Revaluation (05%)

Field Name Name Percentage

ABSMG Sales quantity 5 %

© SAP AG of 351


ERLOS Revenue 5 %

© SAP AG of 351


3. Choose Save.

3.3.4 Defining Planning Layout

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Planning Manual Entry of Planning Data Define Planning Layout Create Planning Layout (Choose Activity screen)

© SAP AG of 351


2. On the Report Painter: Create Planning layout for Sales and Profit Planning screen, enter the necessary data.

© SAP AG of 351



Planning Layout YG100

© SAP AG of 351


Description Plan Sales per Brand

© SAP AG of 351


3. Choose Enter and create the following layout:

© SAP AG of 351


Product Group

Product Customer Revenue Sales quantity

© SAP AG of 351


Characteristic Characteristic Characteristic Value field Value field

© SAP AG of 351


4. Choose Save.

3.3.5 Defining Planning Levels

Procedure


© SAP AG of 351


Transaction code KEPM

© SAP AG of 351


IMG menu Controlling Profitability Analysis Planning Planning Framework Set Up Planning Framework

© SAP AG of 351


2. On the Planning Framework: Overview screen, right click Planning levels and choose Create Planning Level.

3. In the Create Planning Level dialog box:

a. Make the following entries:

© SAP AG of 351



Key YB100

© SAP AG of 351


Description Sales Planning

© SAP AG of 351


b. Choose Enter to continue.

4. On the Planning Framework: Overview screen:

a. Choose the Charact. Tab.

b. Drag the following characteristics from the Characteristic list section and drop them into the Planning level section:

© SAP AG of 351


Description Field name

Company Code BUKRS

Customer KNDNR

Period/year PERIO

Plant WERKS

Procurement BESKZ

ProdHier01-3 PAPH3

Product ARTNR

Record Type VRGAR

Sales Org. VKORG

Unit Sales qty ABSMG_ME

© SAP AG of 351


Version VERSI

© SAP AG of 351


c. Choose the Selection tab and make the following entries:

© SAP AG of 351


Characteristic From

Record Type F

© SAP AG of 351


Unit Sales qty PC

© SAP AG of 351


d. Choose Save.

3.3.6 Defining Planning Packages

Procedure


© SAP AG of 351


2. On the Planning Framework: Overview screen, right click the planning level YB100 Sales Planning and choose Create Planning Package.

3. In the Create Planning Package dialog box:


© SAP AG of 351



Key YB100

© SAP AG of 351



4. On the Planning Framework: Overview screen, choose Save.

3.3.7 Defining Planning Methods (Parameter Set)

Procedure


© SAP AG of 351



a. Expand the Planning level YB100 Sales Planning.

b. Double-click the Planning package YB100 Sales Planning

c. In the Planning methods section, right click Enter planning data and choose Create Parameter Set.

3. On the Parameter Set: Create dialog box:


© SAP AG of 351



Key YB100

© SAP AG of 351




a. Choose the Settings tab.

b. Make the following entries:

© SAP AG of 351



Layout YG100

Currency Your currency SGD

Distribution Key Currency 2

Distribution Key Quantities 2

© SAP AG of 351


Integrated Excel

Active

X

© SAP AG of 351


5. Choose Save to save the entries.

6. Repeat these steps to create Parameter sets for the methods Copy (Enter Period Shift 12), Display Planning Data, Revaluation (Enter Revaluation Key YB1), Valuation (choose Valuation Strategy YB1) and Top-down distribution (Receiver characteristics: Product and Customer, Reference value field Sales quantity, Period Shift 12 and Actual Data).

3.3.8 Creating Plan Assessment

UsePlanned data are transferred through cycles from cost center accounting.

Procedure


© SAP AG of 351


Transaction code KEU7

© SAP AG of 351


IMG menu Controlling Profitability Analysis Planning Integrated Planning Transfer Cost Center Planning/Process Planning Assess Cost Center Costs / Process Costs Define Structure of Cost Center Assessment/Process Cost Assessment Create Plan Assessment (Choose Activity screen)

© SAP AG of 351



3. On the CO-PA Create Plan Assessment Cycle: Initial Screen:

a. Enter YB01 in the Cycle field.

b. Enter 01.01.2009 in the Start Date field.

c. Choose Enter.

4. On the CO-PA Create Plan Assessment Cycle:Header Data view:

o Make the following entries:

© SAP AG of 351



To 31.12.9999

Text BP Plan Assessment CO-PA

CO Area 1000 (or your CO Area)

TF basis 1 Costing-based Profitability Analysis

© SAP AG of 351


Sender version 2 Plan Version: AOP

© SAP AG of 351


o Choose Attach segment.

5. On the CO-PA Create Plan Assessment Cycle:Segment view:

a. Create the segments according to the following table:

Tab Segment Header:

© SAP AG of 351



Segment Name YB01-1 Stores

Assessment CElem 942200

Fixed value field VVOCF

Val.Fld Var.Cst VVOCV

Sender values, Rule Posted amounts

Sender values, Share in % 100

Receiving tracing factor, Rule Variable portions

Receiving tracing factor, Val.Fld/Key Fig.

5 Revenue

© SAP AG of 351


Receiving tracing factor, Scale Neg. Factors

Standard scaling

© SAP AG of 351


o Tab Senders/Receivers (if the product groups are not implemented, do this step later)

© SAP AG of 351



Sender, Cost Center Group 120

© SAP AG of 351


Receiver, ProdHier01-3 From 00001A000000000000 To 00001ZZZZZZZZZZZZZ

© SAP AG of 351


o Tab Receiver Tracing Factor

© SAP AG of 351



Val.Fld/Key Fig. 5 Revenue

Scale Neg. Factors Standard scaling

Record Type F

Plan/Act. Indic 1

© SAP AG of 351


Reference Versi 2

© SAP AG of 351


o Tab Receiver Weighting Factors

© SAP AG of 351



PH01-3 Factor per 100

00001B000100000001 100

00001B000100000002 100

00001B000100000003 100

00001B000200000001 100

© SAP AG of 351


00001B000200000002 100

© SAP AG of 351


6. Choose Attach segment to create more segments as below:

© SAP AG of 351


Field name Value segment 2

Segment Name YB01-2 Marketing


Fixed value field VVMSK

Val.Fld Var.Cst VVMSK



Receiving tracing factor, Rule Fixed percentages


Receiver, Company Code for example 1000

© SAP AG of 351


Reveiver Tracing Factor, Receivers Portion/percent

100

© SAP AG of 351



Segment Name YB01-3 R&D


Fixed value field VVRDC

Val.Fld Var.Cst VVRDC






© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-4 Admin. Overhead


Fixed value field VWGK

Val.Fld Var.Cst VWGK






© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-5 Sales


Fixed value field VTRGK

Val.Fld Var.Cst VTRGK






© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-6 Quality Management









© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-7 Manufacturing OH









© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-8 Non-Operating Expense


Fixed value field VVN20

Val.Fld Var.Cst VVN20





Sender, Cost Element Group 6200_CE


© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-9 Non-Operating Income






Receiving tracing factor, Rule Fixed portions




© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-10 Taxes










© SAP AG of 351



100

© SAP AG of 351



Segment Name YB01-11 Cash discount


Fixed value field KWBONI

Val.Fld Var.Cst KWBONI




Sender, Cost Center 1801



© SAP AG of 351



100

© SAP AG of 351


7. Choose Save.

3.4 Flows of Actual Values

3.4.1 Transfer of Billing Documents

3.4.1.1 Assigning Value Fields

Procedure


© SAP AG of 351


Transaction code KE4I

© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Transfer of Billing Documents Assign Value Fields → Maintain Assignment of SD Conditions to CO-PA Value Fields (Choose Activity screen)

© SAP AG of 351


2. Make the following entries (XXXX, your Operating concern):

© SAP AG of 351


OpCo CTyp Name Val. fld Description Transfer +/-

XXXX BO05 Hierarchy rebate/mat KWKDRB Customer Discount X

XXXX K004 Material KWMARB Material discount

XXXX K007 Customer Discount KWKDRB Customer Discount

XXXX KP00 Pallet Discount RABAT Other Discounts

XXXX KP02 Mixed Pallet Disc. RABAT Other Discounts

XXXX PI02 Inter-company % ERLOS Revenue

XXXX PR00 Price ERLOS Revenue

XXXX R100 100% discount VVFGS Free Goods

XXXX RB00 Discount (Value) RABAT Other Discounts

XXXX RC00 Quantity Discount MRABA Quantity discount

XXXX SKTO Cash Discount KWSKTO Cash discount

XXXX VPRS Internal price VVMEP Material external Pr

© SAP AG of 351


XXXX YB01 Special Surcharge KWMKPR Promotion

© SAP AG of 351


3.4.1.2 Assigning Quantity Fields

Procedure


© SAP AG of 351


Transaction code KE4M

© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Transfer of Billing Documents Assign Quantity Fields

© SAP AG of 351


Operating Concern SD qty field Name CO-PA qty field Name

© SAP AG of 351


XXXX FKIMG Billed Quantity ABSMG Sales quantity

© SAP AG of 351


3.4.2 Order and Project Settlement

3.4.2.1 Defining PA Transfer Structure for Settlement

Procedure


© SAP AG of 351


Transaction code KEI1

© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Order and Project Settlement Define PA Transfer Structure for Settlement

© SAP AG of 351


PA Text

YH BP PA Transfer Structure HT

YN Services - w/o results anal.

YR R&D Product Line Settlement

YS Services - with results anal.

© SAP AG of 351


YT Overhead Cost Elem. Settlem.

© SAP AG of 351


PA PAA Text

YH 10 BP Revenues

YH 20 BP Costs

YN 00 Revenue

YN 20 Labor Costs

YN 30 Travel Expenses

YN 40 Third Party Costs

YN 50 Sales Deductions

YN 60 Material Costs

YR 10 Total internal order Balance

YS 00 Revenue

YS 10 Revenues Travel Expenses

YS 20 Labor Costs

YS 30 Travel Expenses

YS 40 Third Party Costs

YS 50 Sales Deductions

YS 60 Material Costs

© SAP AG of 351


YT 10 Total internal order Balance

© SAP AG of 351


PA PAA CO Area Cost Element (Group) Source

YH 10 1000 20_CE Costs/revenue

YH 20 1000 YBMF_004 Costs/revenue

YN 00 1000 5100_CE Costs/revenue






YR 10 1000 YB_ALL Costs/revenue

YS 00 1000 YBSP_000 Costs/revenue







© SAP AG of 351


YT 10 1000 YB_ALL Costs/revenue

© SAP AG of 351


PA PAAOperating Concern

Quantity / ValueFixed / variable

Value fld

YH 10 XXXX Value field 3 ERLOS

YH 20 XXXX Value field 3 VRPRS

YN 00 XXXX Value field 3 ERLOS

YN 20 XXXX Value field 3 VVLCV

YN 30 XXXX Value field 3 VV950

YN 40 XXXX Value field 3 VV970

YN 50 XXXX Value field 3 RABAT

YN 60 XXXX Value field 3 VVMAT

YR 10 XXXX Value field 3 VVRDC

YS 00 XXXX Value field 3 ERLOS

YS 10 XXXX Value field 3 VV910

YS 20 XXXX Value field 3 VVLCV



YS 50 XXXX Value field 3 RABAT

YS 60 XXXX Value field 3 VVMAT

© SAP AG of 351


YT 10 XXXX Value field 3 VWGK

© SAP AG of 351


3.4.2.2 Assigning PA Transfer Structure to Settlement Profile

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Order and Project Settlement Assign PA Transfer Structure to Settlement Profile

© SAP AG of 351


2. Choose Settlement profile YB00R1 by double clicking.


© SAP AG of 351



Settlement profile YB00R1

To Be Settled in Full X

Allocation structure YR

PA transfer str. YR

Default object type PSG

Indicators Mark 100%-validation, %-Settlement and Equivalance numbers

Valid Receivers Cost center: Settlement Optional

Profit. Segment: Settlement Optional

Document type SA

Max.no.dist.rls 3

© SAP AG of 351


Residence time 3

© SAP AG of 351


3.4.2.3 Assigning Strategy Sequence to Order Type

UseIn this IMG activity, you assign a strategy sequence for relevant order type. For new orders, the system transfers the strategy sequence to a corresponding order type in the settlement parameters.

Procedure


© SAP AG of 351


Transaction code KSR3_ORC

© SAP AG of 351


IMG menu Controlling → Internal Orders → Actual Postings → Settlement → Automatic Generation of Settlement Rules → Assign Strategy Sequence To Order Type

© SAP AG of 351


2. On Change View “Assignment of Strategy Sequence to the Order Type”: Overview screen, make the following entries:

© SAP AG of 351


Field name Description User actions and values

Comment

Order type Y100 Research and Development

Strat seq. SAP020 Change the standard SAP040

Modifiable 2 Always Overwrite Standard

© SAP AG of 351


Field name Description User actions and values

Comment

Status CRTD Created Standard

© SAP AG of 351


3. Save your entries.

3.4.3 Direct posting from FI/MM

3.4.3.1 Creating Group: Cost Elements

UseCost elements to be assigned in the next step as source of PA structure FI are grouped together.

Procedure1. Access the activity using the following navigation options:

© SAP AG of 351


SAP ECC menu Accounting → Controlling → Cost Element Accounting → Master Data → Cost Element Group → Create

© SAP AG of 351


2. On the Create Cost Element Group: Initial Screen, enter the cost element group YBMF_005 and choose Enter.

3. On the Create Cost Element Group: Structure screen, enter description Scrap and choose Insert Cost Element.

4. Enter the cost elements to be assigned and choose Save.

© SAP AG of 351


Cost Element Group From Value To Value

YBMF_005 500010 500010

YBMF_005 500030 500030

YBMF_005 500050 500050

YBMF_005 500090 500090

YBMF_005 500110 500110

© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Direct Posting from FI/MM Maintain PA Transfer Structure for Direct Postings

© SAP AG of 351


PA PAA Text

FI 10 Personnel costs

FI 20 Raw-/service material consump.

FI 30 Other costs

FI 40 Secondary costs

FI 50 Revenues

© SAP AG of 351


3.4.4 Settlement of Production Variances

3.4.4.1 Defining PA Transfer Structure for Variance Settlement

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Settlement of Production Variances Define PA Transfer Structure for Variance Settlement

© SAP AG of 351


PA PAA Text

Y1 10 Input Price Variance

Y1 20 Input Quantity Variance

Y1 30 Resource-Usage Variance

Y1 40 Remaining Input Variance

Y1 50 Mixed-Price Variance

Y1 60 Output Price Variance

Y1 70 Lot Size Variance

Y1 80 Remaining Variance

© SAP AG of 351


PA PAA CO Area Group name SourceVariance category

Y1 10 1000 YB_ALL Variances on production orders PRIV

Y1 20 1000 YB_ALL Variances on production orders QTYV

Y1 30 1000 YB_ALL Variances on production orders RSUV

Y1 40 1000 YB_ALL Variances on production orders INPV

Y1 50 1000 YB_ALL Variances on production orders MXPV

Y1 60 1000 YB_ALL Variances on production orders OPPV

Y1 70 1000 YB_ALL Variances on production orders LSFV

Y1 80 1000 YB_ALL Variances on production orders REMV

© SAP AG of 351



Quantity / Value

Fixed / variable

Value field

Y1 10 XXXX 1 3 VVIPV

Y1 20 XXXX 1 3 VVIQV

Y1 30 XXXX 1 3 VVRES

Y1 40 XXXX 1 3 VVREM

Y1 50 XXXX 1 3 VVMPV

Y1 60 XXXX 1 3 VVOPV

Y1 70 XXXX 1 3 VVLSV

Y1 80 XXXX 1 3 VVRVA

© SAP AG of 351


IMG menu Controlling Profitability Analysis Flows of Actual Values Transfer of Overhead Assess Cost Center Costs / Process Costs Define Structure of Cost Center Assessment / Process Cost Assessment → Create Actual Assessment (Choose Activity screen)

© SAP AG of 351



3. On the CO-PA Create Actual Assessment Cycle: Initial Screen:

a. Enter YB02 in the Cycle field.

b. Enter 01.01.2009 in the Start Date field.

c. Choose Enter.

4. On the CO-PA Create Plan Assessment Cycle:Header Data view:

o Make the following entries:

© SAP AG of 351


o Choose Attach segment.

5. On the CO-PA Create Plan Assessment Cycle:Segment view:

d. Create the segments according to the following table:

Tab Segment Header:

© SAP AG of 351



Segment Name YB02-1 Stores






Receiving tracing factor, Rule Variable portions

Receiving tracing factor, Val.Fld/Key Fig.

5 Revenue

© SAP AG of 351



PH01-3 Factor per 100

00001B000100000001 100

00001B000100000002 100

00001B000100000003 100

00001B000200000001 100

© SAP AG of 351



Segment Name YB02-11 Cash discount


Fixed value field KWBONI

Val.Fld Var.Cst KWBONI




Sender, Cost Center 1801



© SAP AG of 351


IMG menu Controlling Profitability Analysis Information System Report Components Define Variables for Reports

© SAP AG of 351


Type of variable

Variable Name

Replacement type

Field Name

Optional entry

Parameter/selectopt.

Description

Characteristic value &BISGJAHR Entry GJAHR

Required entry Parameters

To Fiscal Year

Characteristic value &VONGJAH

R

Entry

GJAHRRequired entry Parameters

From Fiscal Year

Characteristic value &BISPER

EntryPERDE


To Period

© SAP AG of 351


Type of variable

Variable Name

Replacement type

Field Name

Optional entry

Parameter/selectopt.

Description

Characteristic value &VONPER

EntryPERDE


From Period

© SAP AG of 351


IMG menu Controlling Profitability Analysis Information System Report Components Define Forms Define Forms for Profitability Reports Create Form (Choose Activity screen)

© SAP AG of 351


3. Choose Create.

4. Build up the form with the Report Painter.

Actual data Planning data Diff. Diff.%

Sales quantity

Revenue

Rev. for Exp/Travel

Customer Discount

Material discount

Qty discount

Promotion

Free goods

Discount

Bonuses

Net Sales

Material Costs

Material external Pr

Costs third party

Labor Costs variable

Travel expenses

Manufact. costs vari

Overhead costs varia

CM I

Labor Costs fix

Manufact. costs fix

Overhead costs fix

CM II

Scrap

Variances

CM III

Admin. Overhead

Sales Overhead

Marketing

R&D Cost Center

CM IV

Non Operating Income

Non Operationg Expen

P&L before Tax

Taxes

© SAP AG of 351


Actual data:

Plan/Actual Indicator 0

Planning data:

Plan/Actual Indicator 1

Version variable

Diff.:

Actual data - Plan data

Diff.%:

Diff. / Actual data *100

The key figures are linked directly to the value fields.

Material Costs is calculated by adding Direct Material Cost and CO-Bypass Mat. Costs

Discount is the total of the former discount and promotion values

Variances are calculated by adding all single variance value fields.

Net Sales, CMI, CM II, CM III, CMIV, P&L before Tax, P&L after Tax are calculated by subtracting the former values.

3.5.3 Creating Profitability Report

Procedure


© SAP AG of 351


IMG menu Controlling Profitability Analysis Information System Create Profitability Report Create Profitability Report (Choose Activity screen)

© SAP AG of 351


b. Choose Create in the line Report with Form.

3. In the Characteristics view, choose the following characteristics:

© SAP AG of 351


Plant

4. In the Variables view, maintain the following values:

Variable value Entry at Execution

From Fiscal Year N/A X

To Fiscal Year N/A X

From Period N/A X

To Period N/A X

Version N/A X

5. In the Output Type view, choose Classic drilldown and Basic list: Detail.

6. Choose Save.

4 Troubleshooting in CO-PA

4.1 General Troubleshooting – Regenerating the Operating Concern

UseRegenerating the operating concern is a useful instrument in all kinds of troublesome situations in profitability analysis. While regenerating the operating concern, the system automatically provides for data consistency, which makes it possible to use this instrument of trouble shooting even after transaction data has been created.

Procedure



IMG menu Controlling Profitability Analysis Structures Define Operating Concern Maintain Operating Concern

2. On the Maintain Operating Concern screen, on the Data Structure tab, choose Display <-> Change and confirm the message regarding cross-client settings.

3. In area Data structure, choose Change.

4. On the Edit Data Structure: Characteristics Screen, choose Extras Characteristics Unlock and confirm when the dialog box appears.

5. Choose Save.

6. Choose Activate.

7. Choose Back.

8. Confirm dialog box regarding regeneration of operating concern.

ResultThe operating concern has been regenerated.

© SAP AG of 351