Planning Area

A planning area as we know is one of the most important areas in Demand Planning. It defines the area where most of the planning activities take place. It groups together both characteristics and key figures under a single domain. 

Planning Book

A planning book is constructed on the information or subset of information maintained in planning area. In planning book, we select the characteristics and key-figures which are required by demand planners to complete their tasks. It determines the outline and layout of interactive planning screen/book.

As per different business requirement, many a times we need to add new key-figures to planning book for different purposes.

In order to add a new key figure to the planning book, we need to first assign it to planning area and then assign to required planning book which is based on this planning area.


Option 1

  During creation of planning area, when time series objects are not created for planning area and it is not initialized, we have option to add SAP standard key figures to our planning area by moving as shown below –


A.JPG

But this option is only available to us only when we are creating planning area from scratch or we need to delete the existing time series objects which will de-initialize the planning area.

Note: – Deleting the time series objects will result in loss of data and it is advisable to avoid this and if needed to take backup of the data to avoid data loss.


Option 2

Other option available to us is to create a new info object (key figure) and then accordingly assign to required planning book.

Below are the steps through which we can accomplish the same:

  1. Navigate to RSA1 -> Info objects -> Right Click on Info object Catalog- > Create Info object


     /wp-content/uploads/2014/01/pic1_376866.jpg

  1. Select APO once we get below pop up –


     B.JPG

3. Enter the values. Once we try to save the info object it will ask for transport. Once assigned we can see the info object is active (Green)


4. Add the newly created key figure to the planning area. Navigate to transaction: /SAPAPO/MSDP_ADMIN (Advanced Planning and Optimization -> Demand Planning -> Environment). Right click on planning area in which key figure is to be added and click on Change Key Figure Settings

Pic2.jpg


5. Add the newly created key figure and hit execute button. (In the new SAP SCM version, we are not required to de initialize the planning area in order to make changes to key figure)


6. New key figure is now available in the planning area and can be seen in the respective planning area


7. Once key-figure is added to the planning area, we need to assign it to the planning book. Navigate to transaction: /SAPAPO/SDP8B (Advanced Planning and Optimization -> Demand Planning -> Environment -> Current Settings -> Define Planning Book)


8. Give the name of Planning book and Data View and Click on Change Button


C.JPG

9. Inside the planning book, navigate to the Key-Figures Tab


D.JPG

10. Here we can assign the key figure to the planning book from planning area (Moving key figures from right to left)


11. Click on Continue button at the bottom and at the end Click on Complete to generate the new planning book

12. Now in Interactive planning book we can see the newly added key-figure. Navigate to transaction : /SAPAPO/SDP94 (Advanced Planning and Optimization -> Demand Planning -> Planning -> Interactive Demand Planning)

 

Hiding the Key- Figure in Planning Book 


Sometimes we require that particular key-figure should not appear in interactive planning book but may be used internally in some macro calculations. In those cases, we have the option to hide the key-figure from planning book.


  1. Navigate to Interactive planning book and switch to Design View. Navigate to transaction : /SAPAPO/SDP94 (Advanced Planning and Optimization -> Demand Planning -> Planning -> Interactive Demand Planning)E.JPG
  2. Right click on the key-figure to be hidden (selected rows -> Hide). Save the planning book

     F.JPG

3. Now the key-figure (Sales Order) will not show in the planning book


4. To unhide the key-figure, open the planning book in design mode, select the complete table ( all the rows & columns), right click -> Manage hidden rows


G.JPG

5. There is another option available to Hide the key-figure from Interactive planning book. In Interactive planning book, select user settings. There is a tab for “Hide Key Figures”. Select the box for Key figure we want to hide. Save and backout.


     H.JPG

     I.JPG

Summary:

Key Figures in planning book contains numerical value (quantity or numerical value) and play a key role to store the values for different business purpose. With changing and evolving business needs, addition of new key figures to capture additional information or to be used in macro calculation is quite common. Once key figure addition is successful in planning area and planning book, if we are saving the data of planning area to BW cube we need to make sure that corresponding key figures appear in Data source of Planning area and then map it to BW cube using DTP.

To report this post you need to login first.

3 Comments

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

  1. Swathi Varagani

    Hi Alok,

    Very useful Document on adding new key figure to planning area and Planning book.

    I have a question here, in the Summary part you have mentioned if we are saving the data of planning area to BW cube we need to make sure that cooresponding key figure apprear in data source of planning area, how to add this new key figure to the already existing data source.

    I have added a new key figure to my planning area and planning book, but i am getting the below error when i tried to check the data source of the planning area.

    Inconsistency between DataSource XXXXX_XXXX_DS and planning area XXX_XXXXXXX_AREA

    Message no. /SAPAPO/TSM364

    Diagnosis

    Inconsistencies have been detected between planning area

    XXX_XXXXXXX_AREAand the DataSource

    XXX_XXXXXXX_AREA These inconsistencies relate to the InfoObjects.

    Please help.

    (0) 
    1. Alok Jaiswal Post author

      Hi Swathi,

      From the error message seems there is some inconsistency between data source and planning area.

      One suggestion is go to planning area MSDP_ADMIN txn and right click the planning area and hit change then click the menu option Extras -> Data extraction tools.

      Choose the Data source and generate the data source. Then Replicate the data source as well.

        This would ensure the new character appear in the Data source in RSA1 transaction in the transformation table.


      Also you can run consistency checks to see if error is being reported.


      Regards,

      Alok

      (0) 
  2. Ada Lv

    Nice documentation. Need to notice if you add new key figure using “Change key figure settings” function, and you transport the change to another system, you’ll get COM error 40034 in the target system.

    (0) 

Leave a Reply