<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1255">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4611.1300" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=476084716-25022002>Thanks for the information about the tables - Ronen.
David, thanks for sharing information about your presentation. It
was very informational and will help me create a long
term</SPAN> <SPAN class=476084716-25022002>solution</SPAN><SPAN
class=476084716-25022002>.</SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=476084716-25022002></SPAN><FONT face="Times New Roman"><FONT
size=2><SPAN class=476084716-25022002><FONT face=Arial
color=#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face="Times New Roman"><FONT size=2><SPAN
class=476084716-25022002> </SPAN><STRONG>From:</STRONG>
Ronen@mccann-kb.co.il [mailto:Ronen@mccann-kb.co.il]<BR><B>Sent:</B> Saturday,
February 23, 2002 2:27 PM<BR><B>To:</B>
SAP-WUG@MITVMA.MIT.EDU<BR><B>Subject:</B> Re: Creating a report using workflow
task and workflow log information<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>Hello</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff size=2>What
we did for gathering data from the container is build a simple abap query that
is based on the following tables:</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>SWW_CONT workitem
container</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>SWWWIHEAD workitem header</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff size=2>This
way we can list workitems according to the container contents, a bit
of an up-side-down approach, but worked good for us.</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>Please note that table SWW_CONT can get very large if you have many
workflows in your system</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=038482119-23022002><FONT face=Arial color=#0000ff
size=2>Ronen</FONT></SPAN><SPAN class=038482119-23022002> </SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Mullens
Lolanda - HRMS [mailto:lmullens@hrms.broward.k12.fl.us] <BR><B>Sent:</B>
Friday, February 22, 2002 7:59 PM<BR><B>To:</B>
SAP-WUG@MITVMA.MIT.EDU<BR><B>Subject:</B> Creating a report using workflow
task and workflow log informatio n<BR><BR></FONT></DIV>
<P><FONT face=Arial size=2>I created a copy of ws0100090 workflow reprint.
When I execute swi2_freq and go to the workflow log view(with technical
details) and click on the work item container; I'm able to see detail
information. Can anyone tell me how to create a report giving a task number
and selecting specific information from the container( workflow
log details)? Is the information in a table? Is there an existing
report that would give me this information? Please let me know if this
request is feasible and point me in the right direction. I'm new to
workflow Thanks.</FONT></P></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>