Skip to Content
0

Program by which we can achieve automation of Workflow cleanup activity

May 16, 2017 at 11:33 AM

39

avatar image

Hi Experts,

Multiple SAP workflows are running for Finance, PMO, QM and IDOC every day, in production. Majority of these are for approvals. These runs create millions of entries in Workflow tables (SWWWIHEAD). The tables are growing exponentially every year occupying lot of storage space and impacting performance. Further, the work items become redundant once the workflows are completed. Hence, the work items needed to be cleaned up as a one-time activity to clear all backlog of completed work items.

so some suggestions how can I achieve this automation. any reusable program

which can help me achieving this?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mike Pokraka May 16, 2017 at 12:24 PM
0

Standard SAP archiving already includes object type WORKITEM to archive workflows. Tx. SARA.

Share
10 |10000 characters needed characters left characters exceeded
Sharmila Yadav May 16, 2017 at 12:56 PM
0

Hi Mike,,

In transaction SARA it includes FI CA: WORK ITEM.

we came across a requirement of doing periodic cleanup of Workflows which are no longer needed in production and thus reduce the space on the database server.so to avoid this manual effort we want to automate this cleanup process.
so looking for some ABAP program by which we can achieve this.

Thanks for response.

Regards,

Sharmila

Share
10 |10000 characters needed characters left characters exceeded
Mike Pokraka May 16, 2017 at 02:41 PM
0

No, object type WORKITEM, nothing to do with FI CA.

Here's an older doco, you should be able to find the one for your version.

https://help.sap.com/saphelp_nw70ehp1/helpdata/en/8d/3e704c462a11d189000000e8323d3a/frameset.htm

Share
10 |10000 characters needed characters left characters exceeded