SAP Workflow Reporting

Reporting on Workflow data is a skill in itself.
In addition to ABAP skills, Workflow reporting requires you to have Workflow skills, knowledge of Workflow technical architecture and tables. Here is an effort to quickly equip you with those skills.


FAQs on Workflow reporting

1. Which is the transaction table of ALL work items?

Answer: SWWWIHEAD is the transaction table of all work items.

This table contains one entry for every work item in the system.

This table also says if the WI is dialog or background, creator of the WI, creation time stamp, and current status of the WI, Parent WI and Top WI.

2. Where will I get Work Item completion date and time? (Complete / Logically deleted)

Answer: Table SWWWIRET. This table will also provide any errors occurred for the Work item. SWWVHEARET is a Joint view of SWWWIHEAD and SWWWIRET.

3. Where can I get different deadline date and time for each work item?

Answer: SWWWIDEADL will give all the deadline dates for each work item.

4. Which table can give me the dialog work items pending with a user?

Answer: SWWUSERWI or use the FM SWN_UWL_GET_WORKLIST

5. Which table can give me the dialog tasks executed by me?

Answer: SWW_OUTBOX or use the FM SWN_UWL_GET_OUTBOX

6. I have a Notification which triggers a workflow. (I use ISR framework). Where can I see the link between Notification number (QMEL) and the workflow?

Answer: Use table SWW_WI2OBJ

7. Where can I see the entire log for work item? I want to see how it was created? (Triggered by an event?), any one changed its container?  Any one changed the deadline? Etc.

Answer: Use table SWWLOGHIST.

8. Is there any table which will provide container of a work item?
 

SWW_CONT - Container Contents for Work Item Data Container
SWW_CONTOB- Container Cont. for Work Item Data Container (Only Business Objects

For the code refer
http://learnhrabap.blogspot.com/2010/09/workflow-how-to-read-multi-line.html

Here are other useful books on SAP Workflow topic.