Skip to Content

Profitability Analysis or COPA as it is popularly known enables to evaluate market segments, which can be classified according to products, customers, orders or any combination of these or strategic business units such as sales organizations or business areas with respect to company’s
profits or contribution margin. The aim of the system is to provide sales, marketing, product management and corporate planning departments with the
information to support internal accounting and decision making. An organization can analyze a large number of key figures (viz: Revenue, Production Cost,
Contribution Margin etc) in COPA Reports. These key figures can be value fields stored in the COPA tables or key figures calculated in a Key Figure Scheme
(KFS). A Key figure scheme is a group of formulas that define a number of key figures.

 

 

An example of such a key figure could be:

 

1000                       Revenues

-2000                     Production Costs

3000                       Contribution Margin

-4000                     SG&A Cost

5000                       Net Revenue

 

 

The KFS is assigned to a COPA report. Thus when we run a particular COPA Report, the Key Figures displayed therein will be based on the
KFS assigned to that particular COPA Report. A KFS can also be assigned to a form which is than assigned to a COPA Report. Depending on the requirements, one or more KFS can be assigned to a COPA Report.

 

Creating a Key Figure Scheme

 

The transaction code to create a KFS is KER1.

PIC1.png

 

 

Now click on new entries

PIC2.png

 

 

Enter the KFS and it’s description and save

PIC3.png

 

 

Select the KFS “01” and double click on “Elements of the KFS”

 

PIC4.png

 

 

Now click on “New Entries” to add the elements

PIC5.png

 

 

Create Elements representing the KFS. The elements can be defined using Value fields or already defined elements of the same KFS. In the
illustration, the element 1000 “Revenue” is created using a value field

PIC6.png

 

 

To assign value field to this element, click on Basic Formula.

 

Use the F4 help or PIC7.pngto choose the relevant Value Field.   E.g. Choose 9002 – Revenue.PIC8.pngPIC9.png                                                                     

 

 

For most of the standard value fields, SAP automatically generates the element number. For eg, for value field ERLOS (Revenue), element 9002 has been generated. Element 3000 is created using an already created element/key figure

 

PIC10.png

 

 

Now click on Basic Formula editor and choose element or Press F4. Here you can see the Key Figures/Elements already created.

PIC1.png

PIC2.png

 

 

Choose the elements required in the formula (Eg: Revenue – Prod Cost) (1000-2000)

 

PIC3.png

 

 

Thus the key figure 01 has been created which has three elements as shown below                                                                                                                                                                                                                                                 P1.png

 

 

There are two options to define the formula: Basic Formula and Formula Editor.

 

P2.png

 

 

In the basic formula, one can define simple formula only (addition and subtraction)

 

 

In the formula editor, you can define more complex formulas as shown below

 

P3.png

 

 

 

 

Thus in formula editor there are features such as:

 

Use of multiplication, division etc

– Use of constant value

– Use of Functions like Maximum, Minimum etc

 

 

 

 

P4.png

 

 

Assigning KFS to Report/Form

 

 

To make use of KFS, it needs to be assigned to a form or report so that the data can be viewed and evaluated.

 

The form is created using transaction KE34    P5.png

 

 

Click on any row displayed and than choose on Key Figure Scheme Element as shown below:

 

 

P6.png

System will than display the various Key Figure Schemes created for various purposes. Choose the one which is relevant

P7.png

 

 

Assigning KFS in reports.

 

Create form using transaction code KE31

P8.png

 

 

Choose/Assign the relevant KFS in the report as shown below:

P9.png

 

 

The below figure is an example of a Profitability report using KFS

 

P11.png

 

 

To display an overview list containing all the elements of a KFS and formula stored, click on the overview screen

 

P12.png

P13.png

To report this post you need to login first.

24 Comments

You must be Logged on to comment or reply to a post.

      1. Karthikeyan Ganesan

        Hi Sanil,

        I have gone through many of your documents which you had created in FI.

        This document in CO-PA is EQUALLY Good!!!..

        Keep sharing… and All the best…

        Regards

        Karthikeyan G

        (0) 

Leave a Reply