Solution : https://service.sap.com/sap/support/notes/573656 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines for archiving and deleting workitems in SAP workflows to optimize performance by reducing table/system load. It specifically advises using the archiving object WORKITEM for completed or cancelled items within transaction SARA, while cautioning against using report RSWWWIDE in production due to its disregard for dependencies. Additional details include changes in archiving post-NW04 upgrade and replacement programs (WORKITEM_WRI and WORKITEM_DEL) for previous archiving routines. For development or testing environments, methods for deleting large quantities of workitems using RSWWWIDE and RSWWHIDE are discussed, alongside recommendations for handling archived data with specific Archive Information Structures.
Key words :
archiving work items workitem standardizations archive information structures, display archived work items specific, extended archive information structure sap_o_2_wi_001, reduce table/system load, archive information structure sap_bo_2_wi_001, archiving work items note 621258, archive information structure sap_o_2_wi_001, archiving badi solution [1] production, review note 1084132 archiving badi, archive information structures
Related Notes :
1098805 | Troubleshooting Tips & Tricks for workflow issues |
1084132 | Archive information structures after upgrade to Release 640 |
1039960 | Archiving WORKITEM: Providing a BAdI |
836092 | BPE-RUN: Archiving/deleting work items |
704016 | Details to include when creating a workflow customer message |
621258 | Archiving WORKITEM standardizations |
547601 | FAQ workflow, runtime environment and troubleshooting |
543371 | Work item archiving: Entry of comment for archive run |
528571 | The list output of the RSWWARCP program is incomplete |
523134 | Missing statistical information with work item archiving |
512943 | Syntax error in the program RSWWARCD |
492347 | Archiving WORKITEM: Table SWW_WI2OBJ |
491474 | Log for the work item delete program is too large |
432084 | Reading archived work items: Performance and memory reqmt. |
182204 | Short dump when archiving work items |
180683 | Workitems in Subworkflows are not deleted |
159065 | Data selection for work item archiving |
153205 | Direct deletion of type C work items |
145291 | Performance of deletion from archive file |
133943 | Update termination when deleting a work item |
126678 | Archiving or deleting work items of type C |
117718 | Large file WF_LOG_000000000000_... created |
117191 | Work item log is not deleted from archiving |
102041 | Number of archived work items constantly decreases |
98407 | Performance workflow |