BACK

Two ways to reduce the size of the SOFFCONT1 table in SAP

datavard sap housekeeping best practices

SOFFCONT1 table grows quickly in SAP landscapes and often gets into the top 10 largest tables in the system (TIP: check the list of largest tables in DB02 transaction). This table belongs to SOC3 and contains SAP Business Workplace/SAPoffice Documents attachments. The size of SOFFCONT1 depends significantly on how these types of documents / attachments are used in the system and how they are stored. If an external storage is not used, the SAP stores the office attachments in SOFFCONT1 table. That’s why it grows so quickly. To stop it from getting bigger, SAP recommends using an external storage system (e.g. archive storage). SOFFCONT1 is one of many SAP tables that contain temporary data, that is data that lose value quickly after its creation. Often these tables grow rapidly because data is not handled properly after serving its purpose.

Even 6 out of 10 biggest SAP tables may not be generating business value. The below example is an SAP Early Watch output that shows Top 10 tables based on total size. Six out of them (highlighted) could be significantly smaller if regular housekeeping was in place.

A proper SAP housekeeping must be in place to keep the amount of this data under control.

 

top 10 sap tables based on total size SOFFCONT1 table

 

How to keep the SOFFCONT1 table size under control?

There are two ways how to keep this table small.  First and recommended option is to store attachments and access them from the external storage. It is not possible to archive SOFFCONT1 data records with an existing standard archiving object. Instead the document’s content (e.g. Microsoft or PDF attachments) should be stored in an external content server. The storage in a database table is just the default setting. Moving attachments from table SOFFCONT1 to an external storage system is only possible through a modification. For more information, see SAP Notes 389366 (SAP R/3 4.6B – SAP Web AS 6.10) and 445057 (SAP R/3 4.6B – SAP Web AS 6.10). To allow content server option you should define a new storage category in transaction SKPR08 pointing to the new or existing external content server. As of that moment, new documents will be stored in the content server and existing documents in the system will be kept in SOFFCONT1. Check the SAP note 389366 for migrating existing data from SOFFCONT1 to content server.

Second option, a less effective one, is to delete documents from a folder (with or without attachments). Please note, only the references between the folder and the documents are deleted initially. The content of the document remains in the database, including the header data and the send logs. This data can be physically deleted from the database (e.g. SOFFCONT1) using program RSBCS_REORG (Note 966854).

 

data growth in sap tables SOFFCONT1 how to reduce the size

Two options to handle data growth in SOFFCONT1 (BCS attachments)

Best practices for housekeeping SAP systems

Regular SAP housekeeping is essential, but according to our research covering over 300 SAP BW systems, only a low percentage of organizations are housekeeping their SAP systems to the fullest extent. In the blog “7 housekeeping hurdles” we have identified the main reasons why these activities are not done to their full extent.

To summarize, housekeeping SAP systems is an important task that often doesn’t get the attention it deserves. It is important to clean up the data automatically, which not only reduces the overall effort, but also improves system performance and lowers storage costs.

It is best to start with analyzing your systems data volumeProper analysis helps with identifying quick wins as well as building a solid platform for kick starting system housekeeping practices.

Find out more about OutBoard Housekeeping the holistic solution to clean up no-value data from SAP landscapes.

Interested to see how data management of temporary SAP data can help you to travel lightweight to HANA? Then please read the blog article by DATAVARD´s OutBoard Product Manager Jan Meszaros on the eursap’s BlogSAP Housekeeping – How much of your SAP (HANA) data is valuable?“

One comment on “Two ways to reduce the size of the SOFFCONT1 table in SAP

Leave a Reply

Your email address will not be published. Required fields are marked *