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
Delete time series history I recommend you run reports /SCA/TSDM_TS_HIST_DELETE or /SCA/TSDM_TS_HIST_DELETE_ALL instead.
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