Workflow logs - Delete or Archive?

[#1]

Hello

The tables SWW_*, SWWWIHEAD, SWWLOGHIST, SWPNODELOG, SWPSTEPLOG are growing rapidly in our system, totalling over 100 GB. We are considering archiving/deleting old work items, i.e. older than three months that are in status completed.

What are the risks in terms of data integrity / auditability when deleting these logs, in other words, do we have to archive the old work items or can we simply dleete them?

Thanks

Wilhelm

[Former Member · Accepted solution]

Hi Wilhelm,

It is generally recommended to archive workitems than to delete.

Refer Note 573656.

Thanks,

Naveen

[surjith_kumar]

Hi,

Check the T.code SARA.

Refer [Link|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/3643cdbb-0601-0010-c89d-c069bc395909].

Regards,

Surjith

[bpawanchand]

My suggestion is better archive the workitems rather than deleting them , make use of the FM WORKITEM_ARCHIVE_OBJECT and read the documentation provided by SAP in SE37