Hello!
We have implemented SAP ERP with Workflow management.
The main problem seems to be the growth of the database.
We have detected that table SWWCNTP0 has been growing up to 40 GB.
Question:
How can we optimize this table in order to delete some old items?
Which report can be used here?
Thank you very much!
Request clarification before answering.
Hi,
The answer is SAP data archiving. There is a standard archiving object WORKITEM that can be used for archiving workflow data. Get yourself familiar with data archiving and transaction SARA.
Regards,
Karri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The answer is still the same. Data archiving is basically deleting (and of course you might also store the archived files somewhere permanently) finished workflows/items. I would really investigate your workflow scenarios before just starting to execute the archiving - your workflows might (and probably will) contain some business critical data, that you cannot just delete.
Regards,
Karri
PS. There is no standard report (other than the archiving one). Well, there is a report for deleting work items, but I will not even mention the name of it, since it is not recommended to be used - unless you are 100% sure about what you are actually doing and what are the consequences.
Edited by: Karri Kemppi on Jul 20, 2010 4:48 PM
Hi Holger,
To expand more on Karri's response about archiving workitems, I would recommend checking out SAP's Data Management Guide out on http://service.sap.com/ilm. This manual contains detailed information on how to control the growth of workitem tables (as well as many others) using data archiving.
Hope this helps.
Best Regards,
Karin Tillotson
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.