Clean up SOST Table

[Former Member]

Hi,

We want to clean up SOST (SAPOffice) table for which we have implemented report RSBCS_REORG as per OSS Note 966854. But this report does not read documents from Inbox & Outbox. for which we need to execute another reports RSSOEXDA for ourbox and RSSOMOVE for inbox and again we need to execute the RSBCS_REORG report. This is very time consuming process

Is there any other way by which we can clean the table????

Thanks in Advance.

Dhaval.

[Former Member]

Hi,

We want to clean up SOST (SAPOffice) table for which we have implemented report RSBCS_REORG as per OSS Note 966854. But this report does not read documents from Inbox & Outbox. for which we need to execute another reports RSSOEXDA for ourbox and RSSOMOVE for inbox and again we need to execute the RSBCS_REORG report. This is very time consuming process

Is there any other way by which we can clean the table????

Thanks in Advance.

Dhaval.

[Former Member]

Hi,

have you seen report RSSODELT? It for SAPoffice Administration and Delete All Data for Client.

Attention, a have never used this report, try to see useful some information in SAP OSS about it.

Best regards

[Former Member]

We have seen this report, we dont want to use it. We found lots of notes on OSS and after that we have impemented the letest one. But we are not happy with this report.

Regards,

Dhaval.

[Former Member]

Have you tried using RSSO_DELETE_PRIVATE? I've found this report to be very useful for cleaning up Business Workplace Inbox.

Regards,

Edward

[Former Member]

Cleaning up SOST is not a simple issue - RSBCS_REORG will not delete a lot of entries because of links to other places. There are several things you need to do first:

1. Empty shared Trash folders and delete anything else from shared folders that is no longer needed.

2. Delete documents from user inbox / outbox / folders / etc. Program RSSO_DELETE_PRIVATE lets you do this in bulk by date range

3. Delete documents from Hidden Folders - program RSSODFRE will do this - but before running it make sure you have all OSS notes applied - the performance is 1000 times better.

4. Run RSBCS_REORG to clean up SOST and other tables.

5. There is also a delete fix program from an OSS note that fixes an issue introduced by changes to deletion flags on SOST where deleted records in transaction SOST show up again. You may need to run this also.

There are OSS notes referenced in the program code of these programs, and fix / update OSS notes you should apply before running.

NB: These tables can have millions of records in them to delete - so talk to your Basis people about space for re-do logs etc.

Andrew