Show TOC

Process documentationProcessing Master Data Queues in Supply Network Planning (SNP) Locate this document in the navigation structure

 

Master data in Supply Network Planning (SNP) is used to assign master data combinations in SAP Advanced Planning and Optimization (SAP APO) to planning objects used in SNP planning (for example, the valid location, product, and resource combinations). SNP master data queues and SNP master data queue management processes keep track of the changes in APO master data and update SNP master data when requested by planning applications.

Master data queue processing events in Supply Network Planning occur at many points in the SNP planning process, for example, when the planner enters interactive planning, loads a master data selection, or starts a planning run.

Prerequisites

You have initialized at least one planning version for at least one SNP planning area.

Note Note

The term SNP planning area refers to a planning area using one of the SNP standard master planning object structures 9ASNPBAS or 9ASNPSA.

End of the note.

To use time series you need an SNP planning area that contains time series key figures. For more information, see Planning Area Administration.

Process

SNP Master Data Update

This graphic is explained in the accompanying text.

  1. APO Master Data Change

    If there is a change in the master data of SAP Advanced Planning and Optimization (SAP APO), the system sends a change notification to SNP, where the changes are lined up in the SNP level one queue (table /SAPAPO/TSQUEUE). The system automatically performs change notification and registration and immediately after the master data change.

  2. SNP Queue Update

    The system updates SNP queue during planning area initialization, at the start of SNP interactive planning or any other SNP planning application.

    The SNP queue update deletes the entries in the level one queue and by processing them creates entries in the level two queues (in table /SAPAPO/TSQMLO). Entries in level two queues are more detailed than entries in level one queue, and they also describe the required changes in SNP master data.

    By default the queue update is executed in a background process to speed up the startup of interactive planning. You can change the runtime behavior of queue update in Customizing for Advanced Planning and Optimization under   Supply Chain Planning   Supply Network Planning (SNP)   Basic Settings   Maintain Global SNP Settings   Change the runtime behavior in the TS: Que. Proc. field.

    You can also run the queue update process manually with the /SAPAPO/TS_LCM_QUEUE_UPDATE report

  3. SNP Master Data Update

    At the start of an SNP application (for example, SNP heuristic), the system updates SNP master data based on the entries of the level two queue. SNP master data update is also performed as a part of planning area initialization or at the start of SNP planning applications. SNP interactive planning performs the master data update when you load a selection to the shuffler.

  4. Delta Initialization of Planning Areas

    The system updates the time series whenever planning area initialization is carried out. For more information, see Delta Initialization of Planning Areas.

The following error messages may occur during planning:

  • E207(/SAPAPO/TSM) No liveCache anchor found

  • E020(/SAPAPO/OM_TS) Time series does not exist

  • E219(/SAPAPO/TSM) Invalid data status

  • E230(/SAPAPO/TSM) No plannable characteristic combinations available

  • E001(/SAPAPO/SDP_MD) Planning object could not be determined

  • E085(/SAPAPO/SDP) Error reading data - planning book cannot be processed

In most cases, errors occur because the time series objects are not updated before planning with planning area initialization. If you run planning area initialization and it does not solve the error, run the following consistency checks:

  • Consistency check for the time series network

    On the SAP Easy Access screen, choose   Advanced Planning and Optimization   Supply Network Planning   Environment   Current Settings   Time Series Administration   Consistency Check of Time Series Network   (transaction /SAPAPO/TSCONS).

  • liveCache consistency check

    On the SAP Easy Access screen, choose   Advanced Planning and Optimization   APO Administration   liveCache/LCA Routines   Tools   liveCache Consistency Check   (transaction /SAPAPO/OM17).

For more information, see SAP Help Portal at   http://help.sap.com   SAP Business Suite   SAP Supply Chain Management   SAP SCM 7.0   Application Help   SAP Supply Chain Management (SCM)   SAP Advanced Planning and Optimization (SAP APO)   Demand Planning   Demand Planning Process   Planning Area Administration   Planning Area   Editing Planning Areas and Additional Functions   Consistency Checks for Planning Areas   and SAP Note 577038.

Performance Optimization

The performance of SNP master data management processes affects the performance of all SNP planning applications. You can optimize SNP master data management in the following ways:

  • Master data changes

    Changing master data too frequently affects the performance of SNP master data update processes negatively. Therefore, we recommend that you release master data changes periodically, for example, on a daily basis, and followed by delta initialization of planning areas.

  • Regular planning area initialization

    If you use SNP planning areas with time series key figures, initialize the planning areas regularly to keep the liveCache time series up-to-date and to reduce the number of entries in level two master data queues. Initialize planning areas for all previously initialized planning versions.

  • De-initialization of unused planning versions

    If there are planning versions that you do not use anymore, you should de-initialize them to decrease the data load on SNP master data update processes, especially the number of entries in level two master data queues.

Monitoring SNP Master Data Queue Update in the Computing Center Management System (CCMS)

As of SCM 7.0 there are monitoring entries available in CCMS to monitor the status of SNP master data queues. You can monitor the runtime of queue update process, the number of entries in each queue, the number of entries belonging to a specific planning area and planning version combination, and the time spent since the last initialization of a planning area.

To monitor SNP master data queue update, complete the steps below:

  1. To call the CCMS, on the SAP Easy Access screen, choose   Advanced Planning and Optimization   APO Administration   Integration   Monitor   CCMS Monitor Sets  .

  2. To call the APO monitor set, choose   SAP SCM Monitor Templates   APO Monitor   SNP Monitor   in the CCMS hierarchy tree.

  3. Choose SNP Monitor in the CCMS hierarchy tree.

    You can navigate to individual monitors grouped by system and client by opening the corresponding nodes of the hierarchy tree. Choose node   SNP Monitor clnt. x   SNP Master Data and Timeseries  .

  4. The monitoring entries are grouped to 3 monitoring objects:

    1. SNP MD queue lev. 1

      Contains the number of entries in the level one queue and the runtime of the last queue update

    2. SNP MD queue lev. 2

      Contains the number of entries in each level two queue

    3. SNP Time Series

      Contains the number of corresponding entries in the level two queues for each initialized SNP planning area and planning version combination, as well as the time spent since the last initialization

  5. The colors of the entries help you to recognize problems at the highest level. For more information about the color legend, see Display Types and Views of the Alert Monitor.

  6. You analyze the problems and can go directly to the relevant transaction to receive more details or to rectify a problem.

For more information about the CCMS, see SAP APO Monitoring with CCMS.

More Information

For more information about planning area functions and planning area initialization, see SAP Help Portal at   http://help.sap.com   SAP Business Suite   SAP Supply Chain Management   SAP SCM 7.0   Application Help   SAP Supply Chain Management (SCM)   SAP Advanced Planning and Optimization (SAP APO)   Demand Planning   Demand Planning Process   Planning Area Administration   Planning Area   Planning Area Functions in S&DP Administration   Initializing Planning Areas in Background Jobs  .

For more information about data storage, see SAP Help Portal at   http://help.sap.com   SAP Business Suite   SAP Supply Chain Management   SAP SCM 7.0   Application Help   SAP Supply Chain Management (SCM)   SAP Advanced Planning and Optimization (SAP APO)   Supply Network Planning   Planning Area Administration   Saving Data in DP and SNP  .