Who's got da work item?????

[Dr. Ulrich Mende]

Hello workflowers,
in some projects I found it useful to read (not write !) the following
workflow runtime tables (all beginning with SWW*):
 
SWWWIHEAD        Workitem header (Type, Task, Status, Father-WI...)
SWWORGTASK     OrgUnits and Users to a WI (  take account of field NO_SEL)
SWWUSERWI        Users to a WI
SWWLOGHIST       Log of WIs History, particulary of forwarding
(SWW_WI_FOREWARD)
SWWOBJCONT     Objecttypes and Keys on WI containers (very usefull for
HR_USD2                Workflow substitutions
 
Using simple ABAP-Selects on these tables you can answer a lot of
interesting questions from outside a workflow,
(in reporting tools), for example:
Who has a WI / object in his inbox?
Has he/she already started it?
Who forewarded the workitem / object?
Did anyone put the WI / object into the resubmission box? When will it come
out again?
Does a user substitute another at the given time? (Can be used for authority
inheritance)
 
It may be also interesting to look at the functions SWW_WI* in the
SWWA-Functionpool (WI-API).
Best regards   Ulrich