Skip to end of metadata
Go to start of metadata

Purpose

Deleting Inconsistent history data which is stored in TSDM level in SPP, which is not possible with normal stocking realignment service.

Overview

 

If we adjust the demand history in the key figure "Demand: Adjusted history" in the transaction /SAPAPO/SPPDMDH.

Once you saved the changed history, it will store in the info provider 9ADEMCRT as well as in TDL Time series ID "TSID_HIST_OVR" in TSDM data source level. 

Any Inconsistent demand history data can be removed executing the Stocking/Destocking data realignment service SPP_PDEM_STOCKING_RLG. It generally remove the data in the Info provider 9ADEMCRT.

In this case, Changed data is saved in the TSDM data source level. The Stocking/Destocking data realignment service SPP_PDEM_STOCKING_RLG, does not delete the data in TSDM level. So these values will be restored again from the TSDM data

Solution

You can delete TSDM level data using transaction /n/SAPAPO/TDL_TS_TEST for the selected data.

If you want to remove TSDM level data in Mass processing use Transaction /n/SCA/TSDM_TS_DELETE.

Delete time series history I recommend you run reports /SCA/TSDM_TS_HIST_DELETE or /SCA/TSDM_TS_HIST_DELETE_ALL instead.

Refer the notes 2567792 &  note 2453011 & 2510607

You would like to delete all key figure and status history data for a particular
key figure of a TS type between 2 dates. In that case /SCA/TSDM_TS_HIST_DELETE_ALL
is the most time efficient deletion report from the mentioned 3 programs.

Report/SCA/TSDM_TS_HIST_DELETE for deleting tables /SCA/KT1SPM and /SCA/ST1SPM and it is working fine.
Checked report /SCA/TSDM_TS_STAT_CLEANUP. It deletes only those internal status entries which have lower clstids than the minimum clstid in the KF table.
No check on locprods during the deletion. This is why the report did not delete any entries from /SCA/IS1SPM.

Report report /SCA/TSDM_TS_STAT_CLEANUP does not delete all expected internal status entries from the DB
Report /SCA/TSDM_TS_STAT_CLEANUP you released in note 2453011

PSM planning service TDL_SPP_COPY_SERVICE_TS for deleting old time sries data.

Service profile can be maintained in transaction /SCMB/TDL_BO_COPY.There is a deletion mode.
Note 2510607 should be implemented as it fixed deletion of internal status data.
Usually it is used for a selection over all location products.
This is the case addressed by the report of note 2453011.
When using /SCA/TSDM_TS_DELETE internal status must be deleted along with key figure data !!!

/SCA/KT1SPM and /SCA/ST1SPM we use the program /SCA/TSDM_TS_HIST_DELETE_ALL and it works fine
Our aim is to delete records also from /SCA/IS1SPM and /SCA/TK1SPM.
Suggested report /SCA/TSDM_TS_DELETE. What is the issue here? - By the way, note 2600733 lets the cleanup ignore initial locids


 

  • No labels