Skip to Content
Author's profile photo Sanil Bhandari

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.

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

Assigned tags

      24 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Hi Sanil,

      Very good explanation of end-to-end scenario. Appreciate your efforts on forum..

      BR, Srinivas Salpala

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks much Srinivas

      Regards

      Sanil Bhandari

      Author's profile photo Krishna Achanta
      Krishna Achanta

      good explanation,this will makepeople more clear

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks much

      Regards

      Sanil

      Author's profile photo Former Member
      Former Member

      Good one...Thanks for your efforts.

      Best Regards,

      Naresh K.

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks Naresh

      Regards

      Sanil Bhandari

      Author's profile photo Sampat Kumkar
      Sampat Kumkar

      Hello Sanil

      Thanks for sharing the doc and your efforts..

      Regards

      Sampath

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks Sampat

      Regards

      Sanil Bhandari

      Author's profile photo Mariks .
      Mariks .

      Thanks Sanil for sharing useful document.

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks much

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      Its nice Explanation Sanil  thank you for sharing knowledge.

      Regards

      Sada Bandla

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks much

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      HI Sanil,

      Nice document & presentation.  Keep sharing..!

      Regards

      Raj

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks for the encouragement

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      Very nicely detailed and easy to read explanation. Excellent

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks Satish

      Regards

      Sanil Bhandari

      Author's profile photo Pavan Kumar Arvapally
      Pavan Kumar Arvapally

      Hi Sanil,

      Good document....

      Pavan Kumar Arvapally

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks Pavan

      regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      Very good one.

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks much

      Regards

      Sanil Bhandari

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Sanil Bhandari
      Sanil Bhandari
      Blog Post Author

      Thanks so much Karthikeyan. Appreciate your encouragement.

      Thanks & Regards

      Sanil Bhandari

      Author's profile photo pranav kumar
      pranav kumar

      Thanks Sanil sir,

      Such a nice document ..to share..

      i need the same as per our customer Requirement

      Kind regards

      Pranav Kr. Gupta.

      Author's profile photo hasya reddy
      hasya reddy

      Hi Sanil,

      Very Good Explanation

      Regards,
      Hasya