Reporting on Who Tasks Were Routed To and Who Reserved Them

[Schumacher, Margaret]

Mike,

 

Some functions you might want to use if you don't find an existing
report are

 

RH_MULTIPLE_OBJ_WI_SELECT

SAP_WAPI_WORKITEMS_BY_TASK

SAP_WAPI_GET_WI_AGENTS

SAP_WAPI_READ_CONTAINER

SWI_DURATION_DETERMINE

 

I had to also account for when the user forwarded the task to someone
else by reading the table swwloghist looking for method SWW_WI_FORWARD
and using that as the starting time for computing how long it took the
user to execute.  (Yes I know we shouldn't read the tables directly but
sometimes it's faster then searching for a function).

 

If you have time zone issues I suggest using  

    CONVERT TIME STAMP swwloghist-timestamp
      TIME ZONE sy-zonlo
      INTO DATE p_rec-wi_cd
           TIME p_rec-wi_ct.

 

 

Regards

 

Margaret Schumacher

SAP Technical Team 

Application Solutions & Delivery

Teleflex Medical

2917 Weck Drive

RTP, NC  27709

Phone: 919 361-3945

________________________________

From: Michael McInerney [mailto:michaelm at duke.edu] 
Sent: Friday, July 10, 2009 3:57 PM
To: sap-wug at mit.edu
Subject: Reporting on Who Tasks Were Routed To and Who Reserved Them 

 

We have a need to do some reporting  on workflows in a manner which I
would think would be a somewhat universal requirement.

 

Custom Workflow X has a number of steps, including dialog steps which
are routed to agents for action.

The dialog steps gets assigned to a group of typically 2 or 3 agents for
resolution.

One of the agents will (eventually) reserve and complete the step.  The
process continues...

 

Is there a canned report that might, show me all instances of  Workflow
X that are STARTED and have the following info available in its layout

 

Workflow ID

Date Started   

Elapsed (ie  Today - Sate Started)

 

Task ID

Date Started

Elasped 

List of Agents

 

Reserving Agent (if reserved)

Date Reserved

Elapsed

 

Thanks...   ...Mike 

 

 

 

 

 

 

 

 

Michael K. McInerney
Duke University        Office of Information Technology
334 Blackwell Street, Suite 1103, Durham, NC 27701
(919)684-5371                           michaelm at duke.edu
<mailto:michaelm at duke.edu> 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20090713/db00df2a/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4886 bytes
Desc: image001.jpg
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20090713/db00df2a/attachment.jpg