on 02-22-2013 2:46 PM
Hi
I need to understand why this table /SCA/TSSA0INVM1 is used in SNC.
The reason being Program for PO CLosure(/SCA/) is taking time because of this table as this table contains 4 lakh entries.
The table does not have index maintained.
also this table is being accessed by Replenishment Order COnfirmation messages(ROC_IN).
I need to put index in the table or Delete entries that are old.
Before doing the same i need to understand the usage of the table. Also how to delete the old data from the table.
regards,
Ankit.
Hello Ankit,
You can delete the required data from timer series using /SCA/TSDMTEST
Regards
Manas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think it depends on how you store your replb. order data, there is a setting wher eyou could chose to store as time series or as order document. Try using these reports to cleanup the data, you should schedule these for all key figures seprate:
/SCA/TSDM_TS_HIST_DELETE
/SCA/TSDM_TS_DELETE
/SCMB/ODM_TRACKING_DATA_DELETE
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.