cancel
Showing results for 
Search instead for 
Did you mean: 

Table SWWCNTP0

07-20-2010 11:21 AM
3281 views 5 comments
0 Likes
SAP Managed Tags
Subscribe

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!

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Likes

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

Former Member
0 Likes

Hi!

Many thanks for your reply.

Before I archive the workitems I would rather to find out, how can I delete all the finished workflows.

Are there some reports therefore?

Thank you!

regards

Former Member
0 Likes

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

Former Member
0 Likes

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

Former Member
0 Likes

Hi,

I am trying to archive the workitems and the maximum data is in the table SWWCNTP0. How can we retrieve the archived workflows? The system is a dual stack(ABAP+JAVA).

Best Regards,

Ankit Goel