Key Figure Scheme in COPA Reports

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.

Now click on new entries

Enter the KFS and it’s description and save

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

Now click on “New Entries” to add the elements

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

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

Use the F4 help or to choose the relevant Value Field.   E.g. Choose 9002 – Revenue.                                                                     

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

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

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

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

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

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

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

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   

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

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

Assigning KFS in reports.

Create form using transaction code KE31

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

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

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