cancel
Showing results for 
Search instead for 
Did you mean: 

Importance of table /SCA/TSSA0INVM1 in SNC and how to delete entries in the table.

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Ankit,

You can delete the required data from timer series using /SCA/TSDMTEST

Regards

Manas

Former Member
0 Kudos

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