Creating Planning Notes

Objective

After completing this lesson, you will be able to create Planning Notes.

Creation of Planning Notes

Planning notes provide a means for different planners to gain business insights, be notified of the reasons for changes in the data, and collaborate more efficiently.

You can use planning notes to record additional business information from different participants in the planning process, not only in the form of numbers, but also as text. Planning notes can be created for key figure values in the SAP Integrated Business Planning, add-in for Microsoft Excel, and in the Planner Workspaces apps. You can use the Manage Planning Notes app to view, delete, and systematically manage planning notes. In that app, you can also create new keywords, rename existing keywords, or delete keywords. Keywords can be used as search criteria in the app and to add information to notes in an effective, standardized way.

In Microsoft Excel UI, planning notes are visualized by a red triangle in the top right corner of the cell.

Planning notes can be enabled for multiple key figures and are visualized as Microsoft Excel comments in the planning view, but are stored in the database and can therefore be shown at any level of aggregation or disaggregation allowed by the respective key figure.

Prerequisites

  • Planning Notes are enabled for the key figure in the configuration
  • You have the necessary permissions to view planning notes
  • You have set the display options in settings or on the Key Figures tab
  • Global configuration parameter New_Query is set to True

Planning View Settings

You can make the following settings for each planning view in the key figures section or for all planning views in settings.

  • Don't Show: No planning notes display
  • Show from this Planning Level Only: Planning notes that were created on the aggregation level of the planning view display
  • Show from All Levels: All planning notes from all levels of aggregation and disaggregation display

Planning notes created on an aggregated level are disaggregated to the base planning level of the respective key figure.

When you create a planning note on a more aggregated level and save the planning view, the planning note is disaggregated to the base planning level of the key figure for which you created it. However, as disaggregating planning notes down from a very aggregated level can result in large amounts of data, please keep the following in mind:

  • The SAP IBP, add-in for Microsoft Excel does not allow the saving of planning notes when the disaggregation of the planning note to the base planning level of the key figure would result in more than 20 million attribute - period level combinations.
  • The maximum number of attribute - period ID - planning note combinations in the database is limited to 2 billion entries per planning area - version - key figure combination.
  • You can edit or delete existing planning notes that you created.
  • You need admin permission to edit or delete planning notes that other users created.

Planning Notes and Microsoft Excel Comments

Planning notes and native Microsoft Excel comments display in the same way, but are different in their functions. Planning notes use the Microsoft Excel comments feature to visualize them in the planning view. However, there are differences in their functionality, so please bear in mind the following:

  • Editing and deleting planning notes using the Microsoft Excel comments function, either through the context menu or the Review tab, is not supported. The SAP IBP, add-in for Microsoft Excel displays a warning message about this when you save your planning view, and the changes you made through the Microsoft Excel comment functionality are lost when the planning view is refreshed.
  • Creating a Microsoft Excel comment in a planning view is also not supported and leads to a warning message. Microsoft Excel comments are not saved in the SAP IBP system and are lost after a planning view refresh.
  • You can use other features of Microsoft Excel comments from the Review tab, such as Previous, Next, Show/Hide Comments, and Show All Comments.

Create Planning Notes

Business users need to be able to document certain changes by entering notes in their planning view. These notes help them collaborate with other planners and document manually entered changes.

Steps

  1. First, your instructor will demonstrate that the Sales Forecast Qty key figure is activated for planning notes.

  2. Create a new view by modifying the planning view from the previous exercise (Favorite: T## Consensus Demand) using the data in the table.

    FieldValue
    Time PeriodMonth

    Period

    Month from current month to current month + 12

    Attributes 

    Product Subfamily 2

    Product ID 2

    TSP Customer ID

    Selected

    Selected

    Selected

    Key Figures 

    Consensus Demand

    Sales Forecast Qty

    Selected

    Selected

    FilterProduct ID IBP##-100
    Planning notesShow from all planning levels
    1. In the Excel UI, log on to the IBP200 planning area.

    2. On the SAP IBP tab, choose Favorites→T## Consensus Demand.

    3. On the SAP IBP tab, choose Edit View → Edit Planning View.

    4. Enter the values from the table above. Note that you can optionally save your filter for future exercises by choosing the "+" icon and giving it a name.

    5. Choose OK to view the results.

  3. Change Sales Forecast Qty for customer ID CU18100001 next month to 5000 and add a planning note.

    1. Locate the row for product ID IBP##-100 and customer ID CU18100001. Choose the key figure value for Sales Forecast Qty in the next month and change it to 5000.

    2. Right-click the value and choose Add Planning Note from the context menu. Enter some text such as Fixed at 5000 per VP of Sales and choose OK.

  4. Point to the cell where you just entered the note, choose the cell, and delete the planning note.

    1. In the Planning View, locate the cell with the red triangle in the corner.

    2. Right-click the cell and choose Show Planning Notes. A message box appears to show the note's administrative information: date, time, and who entered it.

    3. the dialog box, choose the Delete icon to delete the note.

    4. In the Data Input section, choose Save Data.