<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Microsoft Sans Serif">
<DIV>Thanks Sherie,</DIV>
<DIV> </DIV>
<DIV>I already looked at this. It uses Create Date instead of Completion Date. Any other suggestions?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Joanne<BR><BR>>>> MUNDAYSJ@airproducts.com 9/5/2006 1:38:10 PM >>><BR></DIV>
<DIV style="FONT: 10pt Microsoft Sans Serif; COLOR: #000000">
<DIV dir=ltr align=left><SPAN class=992353217-05092006>Joanne,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=992353217-05092006>Have you looked at SWI1? Completion Date is one of the data points available... this may suit their needs.... they can simply run the report and dump to excel. Our users love this report. and it keeps our workflow team out of the business of supplying reports to users.</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=992353217-05092006></SPAN><SPAN class=992353217-05092006>Cheers,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=992353217-05092006>Sherie</SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Joanne Johnson<BR><B>Sent:</B> Tuesday, September 05, 2006 1:26 PM<BR><B>To:</B> sap-wug@mit.edu<BR><B>Subject:</B> How to Determine Workflows Completed by Month<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I am a fairly new workflow developer. My users would like a report of all the workflows of a specific type that have been completed each month. So completion date must be a selection criteria. What's the easiest method of selecting workflows by month? I looked at all the SAP_WAPI function modules and they all need wi_id. </DIV>
<DIV> </DIV>
<DIV>And how would you determine the specific type - - by the workitem task (i.e. WS92000003)? or the Short Text? What's the easiest method of distinguishing these certain workflows from others? </DIV>
<DIV> </DIV>
<DIV>I am using SAP 4.7.</DIV>
<DIV> </DIV>
<DIV>Thanks for the help.</DIV>
<DIV> </DIV>
<DIV>Joanne Johnson</DIV>
<DIV>Jo-Ann Stores, Inc.</DIV></DIV></BODY></HTML>