<div dir="ltr"><div><div>Loren,<br><br></div>Try FM SWF_PLOG_GET_LOG_UWL. Look at ET_ACTIONLOG table. <br><br></div>Sudhir<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Mar 28, 2014 at 8:24 AM, Bratzler, Loren <span dir="ltr"><<a href="mailto:loren.bratzler@nscorp.com" target="_blank">loren.bratzler@nscorp.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Rick,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks for the reply. The function module you pointed out gets me close to what I am looking for but not quite. For example, if I run that FM against my test work-item I get these results:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><img src="cid:image003.png@01CF4A62.713EDF70" height="238" width="568"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">The text that this brought back is the text that appears on the user decision buttons.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I realize now that what I am really looking for is the Outcome Name as defined in the Decision Options:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><img src="cid:image001.png@01CF4A62.CF7ED540" height="131" width="746"></span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:blue">Loren </span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:gray"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:gray"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <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>Rick Bakker<br>
<b>Sent:</b> Thursday, March 27, 2014 8:09 PM<br><b>To:</b> SAP Workflow Users' Group<br><b>Subject:</b> Re: How Can I Get Text of Workitem Result ?<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p>
<div><p class="MsoNormal">Hi Loren,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">The text is in table SWD_TEXT but it's probably easier (and better) to go via FM SWU_INTERN_GET_DECISION_TEXT.<u></u><u></u></p>
</div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">regards<u></u><u></u></p></div><div><p class="MsoNormal">Rick Bakker<u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt">
<u></u> <u></u></p><div><p class="MsoNormal">On Fri, Mar 28, 2014 at 3:47 AM, Bratzler, Loren <<a href="mailto:loren.bratzler@nscorp.com" target="_blank">loren.bratzler@nscorp.com</a>> wrote:<u></u><u></u></p><div>
<div>
<p class="MsoNormal">I am exploring the possibilities of creating a custom report where I can pass in a long list of invoices and get back a listing that shows the workflow approval information for each invoice. We want to see who approved the invoice, the date and time of the approval, and the result of the user’s decision.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">I can easily identify the dialog steps from the workflow and I know that I can use SAP_WAPI_READ_CONTAINER to get the WI_RESULT field value as shown here:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><img src="cid:image004.png@01CF4A62.713EDF70" height="316" border="0" width="626"><u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">
But displaying a value of “0001” on the report as the user’s decision is not going to be helpful. I want to be able to translate the numeric decision value to the text value that was assigned in the workflow definition. We want to be able to see the value “APPROVED” as it shows up in the workflow log:<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><img src="cid:image005.png@01CF4A62.713EDF70" height="82" border="0" width="847"><u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">
Is there a table somewhere in the system that I could query with the numeric WI_RESULT and get the text value back?<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:blue">Loren Bratzler</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:gray">Norfolk Southern Corporation</span><u></u><u></u></p></div></div><p class="MsoNormal" style="margin-bottom:12.0pt">
<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><u></u><u></u></p>
</div><p class="MsoNormal"><u></u> <u></u></p></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>