How Can I Get Text of Workitem Result ?

[Bratzler, Loren]

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.

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:

[cid:image001.png at 01CF49A8.08BED050]

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:

[cid:image002.png at 01CF49A8.C436C1D0]

Is there a table somewhere in the system that I could query with the numeric WI_RESULT and get the text value back?

Loren Bratzler
Norfolk Southern Corporation
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20140327/b51d1405/attachment-0001.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 18567 bytes
Desc: image001.png
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20140327/b51d1405/attachment-0002.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 14085 bytes
Desc: image002.png
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20140327/b51d1405/attachment-0003.png