<div dir="ltr">Hi Schumacher,<br> Thanks a lot for this idea. I will try to implement this and let you know.<br><br>Regards,<br>Ikhan<br><br><div class="gmail_quote">2008/8/28 Schumacher, Margaret <span dir="ltr"><<a href="mailto:mschumacher@teleflexmedical.com">mschumacher@teleflexmedical.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="purple" link="blue" lang="EN-GB">
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Another FM to try is SAP_WAPI_WORKITEMS_BY_TASK and then
SAP_WAPI_READ_CONTAINER to get the result. If you know up front the
requirement to report on the results I think having Z tables would work
better (but do we ever know all the requirements at the design
phase?). </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div>
<span><span>* get the tasks that qualify from selections</span><br> <span>call</span> <span>function</span> <span>'SAP_WAPI_WORKITEMS_BY_TASK'</span><br> <span>exporting</span><br> <span>time</span> = ls_time<br>
selection_status_variant = p_ss_var<span> "<- closed tasks so you can see the
results</span><br> <span>tables</span><br> task_filter = lt_tasks<span> "<- prefill with the tasks to look
for</span><br> worklist = lt_worklist.</span>
</div>
<div><font face="Courier New" size="2"></font> </div>
<div><font face="Courier New" size="2"><font size="3"><font face="Times New Roman">
</font></font></font>
<span><span>* for each entry need to read container info </span></span></div>
<div><span><span></span> <span>loop</span> <span>at</span> lt_worklist <span>assigning</span> <lfs_wihdr>.<br><br> <span>refresh</span>: lt_cntr, lt_borobj, lt_allobj.<br> <span>call</span> <span>function</span> <span>'SAP_WAPI_READ_CONTAINER'</span><br>
<span>exporting</span><br> workitem_id = <lfs_wihdr>-wi_id<br> <span>tables</span><br> simple_container = lt_cntr<br> subcontainer_bor_objects = lt_borobj<br> subcontainer_all_objects = lt_allobj.<br>
<br><span>* Determine the object of the wf task and set keys</span><br> <span>loop</span> <span>at</span> lt_cntr <span>assigning</span> <lfs_cntr>.<br> <span>if</span> <lfs_cntr>-element = <span>'_WI_RESULT'</span> <span>or</span> </span><span><lfs_cntr>-element = <span>'APPRDESC'</span>. <br>
gs_tbl-wi_result = <lfs_cntr>-<span>value</span>.<br> <span>endif</span>.</span> </div>
<div><font face="Courier New" size="2"></font> </div>
<div><span>...</span></div>
<div><span>I never got a way to interpret the -value to
the defined outcome so I coded the mapping of the result value to a text
description. any feedback on how to get the wf definition text would be
good to know.</span></div>
<div><span></span> </div>
<div><span>Now I know we don't want to read tables
directly but I had to get the Date of execution for the report so I did the
following: </span><span></span><span></span></div>
<div><span><font size="3"><font face="Times New Roman">
</font></font><span><span>* For completed tasks get who and when the task was completed.</span><br><span>* Date isn't returned by the WAPI so we have to read it. Option</span><br><span>* to read the table SWWLOGHIST exists but there are more entries</span><br>
<span>* then reading header table.</span><br> <span>if</span> <span>not</span> lt_worklist[] <span>is</span> <span>initial</span>.<br><br> <span>select</span> wi_id wi_aed wi_aagent <span>from</span> swwwihead<br> <span>into</span> <span>table</span> lt_loghist<br>
<span>for</span> <span>all</span> entries <span>in</span> lt_worklist<br> <span>where</span> wi_id = lt_worklist-wi_id.<br><br> <span>sort</span> lt_loghist <span>by</span> wi_id.<br><br><span>* need to get the wf initiator</span><br>
<span>select</span> wi_id wi_aagent wi_text wi_cd wi_ct wi_stat wi_rh_task wi_chckwi<br> <span>from</span> swwwihead<br> <span>into</span> <span>table</span> lt_wf<br> <span>for</span> <span>all</span> entries <span>in</span> lt_worklist<br>
<span>where</span> wi_id = lt_worklist-wi_chckwi.<br><br> <span>sort</span> lt_wf <span>by</span> wi_id.<br><br> <span>"for subflows get the parent wf initiator</span><br> <span>loop</span> <span>at</span> lt_wf <span>assigning</span> <lfs_wf> <span>where</span> wi_chckwi <> <span>' '</span>.<br>
<span>select</span> <span>single</span> wi_aagent <span>from</span> swwwihead <span>into</span> <lfs_wf>-wi_aagent<br> <span>where</span> wi_id = <lfs_wf>-wi_chckwi.<br> <span>endloop</span>.<br>
<br> <span>endif</span>.</span><font face="Times New Roman" size="3">
</font></span></div>
<div><span></span> </div>
<div align="left">
<p style="margin: 0in 0in 0pt;" align="left"><span style="font-size: 10pt; font-family: Arial;">Regards</span></p>
<p style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; font-family: Arial;"> </span></p>
<p style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; font-family: Arial;">Margaret
Schumacher</span></p>
<p style="margin: 0in 0in 0pt;">
</p><p style="margin: 0in 0in 0pt;"><span style="font-size: 10pt; font-family: Arial;"></span></p></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b> Mike Pokraka
[mailto:<a href="mailto:wug@workflowconnections.com" target="_blank">wug@workflowconnections.com</a>] <br><b>Sent:</b> Thursday, August 21, 2008
3:47 AM<div class="Ih2E3d"><br><b>To:</b> 'SAP Workflow Users' Group'<br></div><b>Subject:</b> RE: Custom
report to know the workflow approval status<br></font><br></div><div><div></div><div class="Wj3C7c">
<div></div>
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Please
AVOID accessing tables directly if you have an alternative. Use FM
SAP_WAPI_WORKITEMS_TO_OBJECT.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US">
<a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a> [mailto:<a href="mailto:sap-wug-bounces@mit.edu" target="_blank">sap-wug-bounces@mit.edu</a>] <b>On Behalf Of
</b>Ibrahim Khan<br><b>Sent:</b> 21 August 2008 06:31<br><b>To:</b> SAP Workflow
Users' Group<br><b>Subject:</b> Re: Custom report to know the workflow approval
status</span></p></div></div>
<p> </p>
<div>
<p style="margin-bottom: 12pt;">I am working on the Appropriation
Request workflow for PS.<br>The information is not stored in standard tables
because the approvers are dynamic and selected while creating the Appropriation
request.<br>In this case I need to explore the workflow related tables to create
this custom report.</p>
<div>
<p>On Thu, Aug 21, 2008 at 11:58 AM, Rahul Shukla <<a href="mailto:rahul_ariean@yahoo.com" target="_blank">rahul_ariean@yahoo.com</a>>
wrote:</p>
<p>Pls go to se12 and search for swww*, there are header and
workitem tables from where based upon ur object name and task names, you can
retrieve such information.<br><br>You may need to join ur custom tables too to
get the next level of approvers , if you are maintaing
there.<br><br>Regards,<br>Rahul<br>Something that can't be re-cycled is Wasted
Time.<br><br><br>--- On Thu, 8/21/08, Ibrahim Khan <<a href="mailto:ikhansap@gmail.com" target="_blank">ikhansap@gmail.com</a>> wrote:<br><br>>
From: Ibrahim Khan <<a href="mailto:ikhansap@gmail.com" target="_blank">ikhansap@gmail.com</a>><br>> Subject:
Custom report to know the workflow approval status<br>> To: "SAP Workflow
Users' Group" <<a href="mailto:SAP-WUG@mit.edu" target="_blank">SAP-WUG@mit.edu</a>><br>> Date: Thursday,
August 21, 2008, 8:44 AM</p>
<div>
<div>
<p>> Hi Friends,<br>> For one of my custom workflow the
client needs a custom<br>> report to know the<br>> approval status. This
custom workflow will be a multilevel<br>> approval and they<br>> want to
know the status based on the object key(document<br>> number) like
who<br>> has approved it at what time, who else has to approve etc<br>>
which standard<br>> workflow tables can be used for this? Please
advice.</p></div></div>
<p>> _______________________________________________<br>>
SAP-WUG mailing list<br>> <a href="mailto:SAP-WUG@mit.edu" target="_blank">SAP-WUG@mit.edu</a><br>> <a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
<br><br><br>_______________________________________________<br>SAP-WUG
mailing list<br><a href="mailto:SAP-WUG@mit.edu" target="_blank">SAP-WUG@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a></p></div>
<p> </p></div></div></div></div></div></div>
<br>_______________________________________________<br>
SAP-WUG mailing list<br>
<a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
<br></blockquote></div><br></div>