Symptom
There are inconsistencies in your system that can cause errors in
interactive Supply Network Planning (SNP), SNP mass processing, and SNP
data extraction. The system may issue the following error messages:
- 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 characteristics combinations available'
- E001(/SAPAPO/SDP_MD) 'Planning object could not be determined'
- E085(/SAPAPO/SDP) 'Error reading data - planning book cannot be processed'
Other Terms
/SAPAPO/TS_LCM_CONS_CHECK, /SAPAPO/TS_LCM_CONS_CHECK_ALL,
/SAPAPO/TS_LCM_REORG_SNP, /SAPAPO/TS_LCM_REORG
/SAPAPO/TS_LCM_REORG_SNP, /SAPAPO/TS_LCM_REORG
Reason and Prerequisites
SNP master data is created in the system for the APO master data.
This enables navigation in SNP interactive planning. The SNP master data
corresponds to the aggregates defined in the SNP planning area and is
saved in the database tables.
Aggregate Database table
9AMALO /SAPAPO/MATLOC
9AMALORE /SAPAPO/MATLORES
9ALORE /SAPAPO/LOCRES
9AMALA /SAPAPO/MATLANE
9AMALARE /SAPAPO/MATLARES
9AMAPR /SAPAPO/MATPPM
9AMARE /SAPAPO/MATRES
9AREPR /SAPAPO/RESPPM
9AACPR /SAPAPO/ACTPPM
9AMALOSA /SAPAPO/MALOSA
9AMALASA /SAPAPO/MALASA
If you create master data in APO or change assignments, you must also create the missing SNP master data or time series. The SNP master data and the time series in the liveCache should normally be updated by the initialization of the planning version (and not by /SAPAPO/TS_LCM_CONS_CHECK).
These master data changes can lead to inconsistencies in one of the following situations:
Aggregate Database table
9AMALO /SAPAPO/MATLOC
9AMALORE /SAPAPO/MATLORES
9ALORE /SAPAPO/LOCRES
9AMALA /SAPAPO/MATLANE
9AMALARE /SAPAPO/MATLARES
9AMAPR /SAPAPO/MATPPM
9AMARE /SAPAPO/MATRES
9AREPR /SAPAPO/RESPPM
9AACPR /SAPAPO/ACTPPM
9AMALOSA /SAPAPO/MALOSA
9AMALASA /SAPAPO/MALASA
If you create master data in APO or change assignments, you must also create the missing SNP master data or time series. The SNP master data and the time series in the liveCache should normally be updated by the initialization of the planning version (and not by /SAPAPO/TS_LCM_CONS_CHECK).
These master data changes can lead to inconsistencies in one of the following situations:
- The version is not initialized, or the initialization job terminates.
- Jobs for changing the master data are terminated.
- This problem is due to a program error.
Solution
Initialize the planning version
Initialize a version that has already been initialized, without first deinitializing it and without changing the initialization period (delta initialization).
Correct inconsistencies
If the inconsistencies were generated by a program termination or a program error, you can correct them using /SAPAPO/TS_LCM_CONS_CHECK.
Correct the cause of the error
If the inconsistencies were generated by a program error, it is necessary to find the cause of the error and remove it. To ensure that SAP Support can find the cause of the error, you need to provide an exact description of the process that resulted in errors:
There are three check programs that you can use for consistency checks in SNP: /SAPAPO/TS_LCM_CONS_CHECK, /SAPAPO/TS_LCM_REORG_SNP and /SAPAPO/TS_LCM_REORG. You can execute the programs in repair mode by setting the "Repair" indicator. You should always block the planning version by setting the "Block planning version" indicator.
Check with /SAPAPO/TS_LCM_CONS_CHECK
This report checks the following for a version of a planning area:
To correct the inconsistencies, you can execute the report in repair mode. For example, you can execute it before the planning run or after a mass change to master data to ensure a consistent status.
Check with /SAPAPO/TS_LCM_REORG_SNP
The report checks whether there is SNP master data for all liveCache anchors for a version of an SNP planning area. This check is required after you have deleted a large amount of master data.
To delete the superfluous liveCache anchors and the related time series in the liveCache, you can run the report in repair mode.
Check with /SAPAPO/TS_LCM_REORG
The report checks for a version for all DP and SNP planning areas whether there are liveCache anchors for all time series in the liveCache. This check is necessary if technical inconsistencies occur after a job was terminated.
To delete the unnecessary time series without liveCache anchors, you can run the report in repair mode.
Sequence of steps:
We recommend that you execute these program steps in the following sequence:
Frequency of execution:
You should monitor the check programs over a sufficiently long period to estimate whether and when exactly they are required. Under normal circumstances, they should be used only to localize errors that create inconsistencies. You should execute the /SAPAPO/TS_LCM_CONS_CHECK program more often than the /SAPAPO/TS_LCM_REORG_SNP program and this more often than the /SAPAPO/TS_LCM_REORG program.
Initialize a version that has already been initialized, without first deinitializing it and without changing the initialization period (delta initialization).
- For planning areas that do not have a time series key figure, it is sufficient to initialize one version.
- For planning areas with time series key figures, you must initialize each version.
Correct inconsistencies
If the inconsistencies were generated by a program termination or a program error, you can correct them using /SAPAPO/TS_LCM_CONS_CHECK.
Correct the cause of the error
If the inconsistencies were generated by a program error, it is necessary to find the cause of the error and remove it. To ensure that SAP Support can find the cause of the error, you need to provide an exact description of the process that resulted in errors:
- Which master data was changed and how?
- Was the planning version initialized?
- You can use the existing check programs to check the consistency of your data for each step: If you know which step led to the error, SAP can analyze your process with a view to providing a correction.
There are three check programs that you can use for consistency checks in SNP: /SAPAPO/TS_LCM_CONS_CHECK, /SAPAPO/TS_LCM_REORG_SNP and /SAPAPO/TS_LCM_REORG. You can execute the programs in repair mode by setting the "Repair" indicator. You should always block the planning version by setting the "Block planning version" indicator.
Check with /SAPAPO/TS_LCM_CONS_CHECK
This report checks the following for a version of a planning area:
- The consistency of the SNP master data.
It checks for all characteristics combinations, whether master data exists (unnecessary characteristics combinations), and whether there is master data without SNP master data (missing characteristics combinations).
Since the SNP master data is version-independent, you only need to execute the master data check for one version of the model.
- The liveCache anchors and time series in the liveCache.
The report checks whether there are liveCache anchors and time series in the liveCache for the time series key figures for all characteristics combinations.
If the 'Check liveCache anchor' indicator is set, the report checks whether the corresponding characteristics combinations exist for all liveCache anchors (only for DP planning areas).
In the case of planning areas with time series, the time series must be checked for each version.
To correct the inconsistencies, you can execute the report in repair mode. For example, you can execute it before the planning run or after a mass change to master data to ensure a consistent status.
- If you have set the "Check SNP master data" indicator, the report creates the missing SNP master data in repair mode and deletes the unnecessary SNP master data. Since the SNP master data is version-independent, you only need to execute the master data check for one version of the model.
- If the planning area has time series key figures, the report deletes the liveCache anchors without SNP master data and the related time series in the liveCache in repair mode.
Check with /SAPAPO/TS_LCM_REORG_SNP
The report checks whether there is SNP master data for all liveCache anchors for a version of an SNP planning area. This check is required after you have deleted a large amount of master data.
To delete the superfluous liveCache anchors and the related time series in the liveCache, you can run the report in repair mode.
Check with /SAPAPO/TS_LCM_REORG
The report checks for a version for all DP and SNP planning areas whether there are liveCache anchors for all time series in the liveCache. This check is necessary if technical inconsistencies occur after a job was terminated.
To delete the unnecessary time series without liveCache anchors, you can run the report in repair mode.
Sequence of steps:
We recommend that you execute these program steps in the following sequence:
- 1. /SAPAPO/TS_LCM_CONS_CHECK
Since superfluous SNP master data is deleted, this program must be executed first.
- 2. /SAPAPO/TS_LCM_REORG_SNP
This program should be executed regularly for SNP planning areas with time series key figures after master data has been deleted in the system.
- 3. /SAPAPO/TS_LCM_REORG
This program should be executed after jobs are terminated to repair any technical inconsistencies in the liveCache.
Frequency of execution:
You should monitor the check programs over a sufficiently long period to estimate whether and when exactly they are required. Under normal circumstances, they should be used only to localize errors that create inconsistencies. You should execute the /SAPAPO/TS_LCM_CONS_CHECK program more often than the /SAPAPO/TS_LCM_REORG_SNP program and this more often than the /SAPAPO/TS_LCM_REORG program.
- /SAPAPO/TS_LCM_CONS_CHECK
Since the SNP master data does not depend on either the planning area or the version, you only have to check the SNP master data for one version of the model. The consistency check is not required after the planning version has been initialized. In the normal process flow, the consistency check should not take place before the planning run, but it can be carried out weekly, for example.
- /SAPAPO/TS_LCM_REORG_SNP
This program should be executed regularly after master data is deleted in the system. How often the program is executed depends on the quantity of deleted master data. You can always execute the program after a large quantity of master data is deleted, on a weekly basis, for example.
- /SAPAPO/TS_LCM_REORG
This program should be executed monthly to check the consistency of the time series in the liveCache.
Header Data
| Released On | 05.06.2009 09:57:53 |
| Release Status | Released for Customer |
| Component | SCM-APO-SNP-BF Basic Functions |
| Priority | Correction with medium priority |
| Category | Consulting |
Validity
This document is not restricted to a software component or software component version
References
This document refers to:
SAP Notes
This document is referenced by:
SAP Notes (6)
No comments:
Post a Comment