Planning is a key tool available in Profitability Analysis (COPA), which is widely used to plan for annual forecast for Profitability Plans and track the actuals against the planned figures.  Planning in Profitability Analysis allows to plan Sales, revenue and profitability data in any selected profitability segments.  The planning data can be displayed in various ways, depending on business demands. It is not a standalone component. It can not only send data to other applications but it can also receive planning data from those applications. It is also not limited by any specific time frame. The planning can be done more than one fiscal year at one or on a rolling basis. The data can also be planned by posting periods or calendar weeks. It is also possible to create and store planning data in different plan versions.

 

The planning framework is the main working environment for sales and profit planning. It contains all possible settings for building the planning framework. The planning can be carried out from this framework screen. MS Excel can be used as a planning screen for planning data in the SAP system. The planning framework allows for planning with or without MS Excel. The various ways in which manual planning can be executed are as under:

 

  • Planning without Excel
  • Planning with Excel integrated in SAP Interface
  • Planning with offline planning in Excel and
    uploading data into the SAP system

 

The first step in COPA planning is the planning framework. It contains the elements like Planning Level, Planning Package, Planning Method and parameter set.  The configuration transaction for creation of planning framework is KEPM.  The first step is to set the Operating Concern.

PIC1.png

PIC2.png

 

 

 

The next step is to create a planning level. Planning level is used to determine the level at which the planning is required to be done using the characteristics. In the transaction code KEPM, right click on Planning Level.

PIC1.png

 

 

Now enter the planning level and description of the same.

 

PIC2.png

 

 

Now right click on the Planning Level created to add the characteristics needed for planning

PIC3.png

PIC4.png

 

 

 

The characteristic values are specified in a planning package.  Right click on the planning level and click on “Create Planning Package”.

 

PIC5.png

 

 

 

Specify the name and description of the planning package.

PIC6.png

 

 

 

Enter the values which can be defaulted.

PIC1.png

 

 

The status of the planning package would be in Red. Double click on the status and change it to the required status

 

PIC2.png

 

 

The next important step is the definition of planning method. The planning method is a function with which the planning data can be
entered and changed. The planning method can be manual or automatic. The automatic planning allows to copy and revaluate actual or planning data for a large number of profitability segments at once. On the other hand, the manual planning method allows you to define the planning screens as per requirement at any degree of detail.

 

PIC3.png

 

 

The next step in the planning process is the creation of the parameter set. It contains all the settings required for execution of planning
method. Right click on “Enter Planning Data” and than click on “Create Parameter Set”

 

PIC4.png

 

 

Enter the parameter set name and description

PIC5.png

 

 

In the next screen, enter the required details like planning layout, currency etc. and Save it. This would create the parameter set.

PIC6.png

 

 

There is a checkbox for integration with excel. This check box must be ticked as Active, if integration with excel is required. If this is
not ticked, the excel integration will not work with COPA planning framework. The next step is to define the planning layout. The planning layout will
determine how the screens will look like when the planning data is entered and which fields would appear on the screen. The planning layout can be
created/modified using transaction code KE15 or KE16 or through the parameter set by click on “Create” icon.

 

PIC7.png

 

 

Enter the layout description, name and choose the Characteristics as Header and Lead Columns as required.

 

PIC8.png

 

 

Choose the value fields that are needed and save

PIC9.png

PIC10.png

 

 

Check if the layout meets the requirements. This can be done in transaction code KE15 or KE16

 

PIC1.png

PIC2.png

 

 

Other options for editing are available

PIC3.png

PIC4.png

 

 

The planning framework is now complete and we can now execute planning

 

Planning without Excel Integration

 

 

Ensure that Integrated Excel check box is not ticked in the parameter set in transaction code KEPM

 

PIC5.png

 

 

Double click on the parameter “SET1”. This would open the planning screen

 

PIC7.png

 

 

 

 

Now enter the planned values and save

 

PIC8.png

 

 

 

You can check the posting in KE25 or use the path in the menu path as under:

PIC9.png

PIC10.png

 

 

Planning with Integrated Excel

 

 

Excel is integrated in the standard SAP planning screen. The checkbox should be ticked in the transaction code KEPM

 

PIC1.png

 

 

Now double click on the parameter set to open the excel based planning screen

PIC2.png

 

 

Once Macros are enabled, embedded excel screen opens in SAP Interface

 

PIC3.png

PIC4.png

 

 

Once the planned data has been entered, save the planned data

 

PIC5.png

 

 

Planning with Excel Upload

 

 

Ensure that the Integrated Excel checkbox is ticked in the Parameter set. Double click on the same and go to Excel Integrated planning
screen. Enable the macros. In the planning screen go to Setting and click on Formatting

 

PIC6.png

 

 

 

This will generate a file description as shown below

PIC7.png

PIC8.png

 

 

Now click on “Save File Description”

PIC9.png

 

 

Now click on “Save Excel Layout” to save the Excel worksheet in the SAP System

PIC10.png

 

 

Now click on “Generic file” to enter a generic file name. This name must consist of a string of characters (upper case), an asterisk (*), and the file suffix “.TXT” (example: PLAN*.TXT). When you later upload Excel files into the SAP System, this generic file name links the  file on your local PC to the file description.                                                                                                     

 

 

PIC11.png

 

 

After this save the overall planning as shown below:

 

 

PIC12.png

PIC13.png

 

 

In the excel planning screen, do file “Save as” to save the Excel Planning Layout for future use :

 

PIC14.png

 

 

Example the excel layout is saved as “PLAN1”  on your Local computer. Once the file is saved on the local computer, it is not required to come again to KEPM and execute all the steps for generate of the excel template. Just use the saved excel file, enter the planned data as TXT and upload the same using transaction code KE13N

 

PIC15.png

 

 

 

Save the file in TXT format

 

PIC16.png

                                 

 

 

Go to KE13N or use the path as below:

 

PIC17.png

PIC18.png

 

 

You can check the planned data in KE25.

To report this post you need to login first.

35 Comments

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

  1. Muhammad Usman Raza

    This is really very informative. thanks

    but what if we have a change in plan, Copa planning cant change the characteristics after save, is there any solution for that, please share

    (0) 
  2. Manish A

    Hi,

    I am trying to double click on the parameter set after having saved the layout, the system is giving the message that “No plan data exists for the specified general data selection”

    Kindly help

    Manish

    (0) 
  3. ram mohan

    Thank you very much for your document.  Can you guide me how to automatically derive COGS and Sales value in planning.

    (0) 
  4. Cristian Zick

    Estimados, buenas tardes.


    Muy buena la explicación.


    me gustaría aprovechar este comentario para hacer una consulta.

    Consulta, necesito planificar en 2 monedas en PA.

    tengo la SOC PA en USD y la CO en CLP.

    cuando planifico en USD en la SOC PA ingresa los valores en CLP.

    si planifico 3 USD en la KE25 muestra los 3 multiplicados por el tipo de cambio.

    Ejemplo:

    ingreso 3 USD y el tipo de cambio es 540 clp en PA me registra 1.620 CLP.

    en ninguna parte me deja registro que planifique en USD.

    como puedo saber eso.

    Saludo.

    CristianZick

    (0) 
  5. Andreas Doms

    Thanks a lot for this.

    I am getting a message Maintain number range for planning record type B” and can not continue with saving the plan values.

    Can anybody help?

    Thanks,

    Andreas

    (0) 
    1. Seif El Hajjem

      I think that you have to check your planning layout Tcode KE15

      Then choose Edit -> Gen. data selection -> Gen. data selection and choose B for record type

      hope that do the job.

      Best Regards,

      Seif

      (0) 
  6. Jegan Solai

    Hi,

    I have followed the steps which you have given and it works excellent.

    But now I am facing a small concern I am not able to edit the period of posting.

    All my docuemnts are getting posted in 001.2016. I am not able to change the period.

    Can u please help me how to change the period/year?

     

    Thanks,

    Divya Gunasekaran.

    (0) 

Leave a Reply