Archive SOFFCONT1 Table using SARA

[yo_muhammad]

In the past few months, we have observed that our SOFFCONT1 Table is growing rapidly, and it is now almost 334 GB, we want to reduce the size of this table without deleting any data and without moving it to the content server. Even after reading several notes and KBA we were unable to find any viable solution for reducing the size of this table.

Our Question is, is there any way to archive this table content using SARA or any other effective way? And how could we find out about the content of this table and compress them?

Please if possible share all possible solutions, so that we can go through all of them and find the best one to achieve our goal.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

[CharlesFeng]

Hi,

Have you checked KBA 1634908 - Reduce the number of entries of table SOFFCONT1?
If not yet, you may refer to it and hope you could find some helpful information.

Best regards,
Charles

[jmodaal]

Hello,

in the SAP standard there seems to be no possibility to archive the data of this table. You can use transaction DB15 to check archiving objects related to a table (none for SOFFCONT1).

SAP offers the Archive Development Kit for enabling customers to implement archiving of own tables. I don't have experience with it, but maybe you should give it a try to check whether content of the table SOFFCONT1 can be archived with some own development.

Kind regards

Jan