soffcont1table deletion notes

Upload: menuselect

Post on 18-Oct-2015

28 views

Category:

Documents


0 download

DESCRIPTION

soffcont1 table deletion notes.

TRANSCRIPT

Some background to the issue that you are experiencing:-

The records in table SOFFCONT1 (where attachment data is stored) will be deleted when you have deleted the reference to these attachments and run the port RSBCS _REORG. So to speak, the normal clean-up report, where all information in SAPoff ice tables will be reorganized, will also delete the records from table SOFFCONT 1.

So, if the attachments in SOFFCONT1 still remains after execution of report RSBC S_REORG (please execute twice and run with DB change) there is only one explanat ion:

A reference to this attachment still exists !!!

So, before an attachment is deleted you have to delete the main document, where the attachment is connected to, from every recipients inbox, also, the document have to be deleted from the outbox folder of the sender and all trash folders. W hen using the report RSSODLIN the document is not placed into the trash, but if a user has deleted the document by hand, it has been placed into the trash by de fault. In addition, if the document has been send by a batch or system user maybe a ref erence has been placed in the dark folder and this reference prevents the attach ment from being deleted.

So this is the reason why report RSBCS_REORG only reduces table SOFFCONT1 by 10% .

So the "real" solution to your problem would be to refer to SAP Note "904711 - S APoffice: Where are documents physically stored?" -> "The document is stored usi ng the knowledge provider".

In TA OAC0, there is a Content Repository, SOFFDB, which is Database storage for SAPOffice documents. Since it is not recommended to change the customizing of s hipped repositories, because documents stored in that repository before will be unaccessable after your change.

Therefore you may consider to create a new category (TA OACT) along with a new R epository (TA OAC0). In TA SKPR08 you can register the new category to be used b y class SOFFPHIO.

Hope this helps

Michael