Custom report to know the workflow approval status

[Ibrahim Khan]

Hi Schumacher,
  Thanks a lot for this idea. I will try to implement this and let you know.

Regards,
Ikhan

2008/8/28 Schumacher, Margaret <mschumacher at teleflexmedical.com>

>  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?).
>
>   * get the tasks that qualify from selections
>     call function 'SAP_WAPI_WORKITEMS_BY_TASK'
>       exporting
>         time                     = ls_time
>         selection_status_variant = p_ss_var "<- closed tasks so you
> can see the results
>       tables
>         task_filter              = lt_tasks  "<- prefill with the tasks to
> look for
>         worklist                 = lt_worklist.
>
>     * for each entry need to read container info
>   loop at lt_worklist assigning <lfs_wihdr>.
>
>     refresh: lt_cntr, lt_borobj, lt_allobj.
>     call function 'SAP_WAPI_READ_CONTAINER'
>       exporting
>         workitem_id              = <lfs_wihdr>-wi_id
>       tables
>         simple_container         = lt_cntr
>         subcontainer_bor_objects = lt_borobj
>         subcontainer_all_objects = lt_allobj.
>
> *   Determine the object of the wf task and set keys
>     loop at lt_cntr assigning <lfs_cntr>.
>       if <lfs_cntr>-element = '_WI_RESULT' or <lfs_cntr>-element =
> 'APPRDESC'.
>         gs_tbl-wi_result = <lfs_cntr>-value.
>       endif.
>
> ...
> 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.
>
> 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:
>   * For completed tasks get who and when the task was completed.
> * Date isn't returned by the WAPI so we have to read it.  Option
> * to read the table SWWLOGHIST exists but there are more entries
> * then reading header table.
>   if not lt_worklist[] is initial.
>
>     select wi_id wi_aed wi_aagent from swwwihead
>       into table lt_loghist
>       for all entries in lt_worklist
>       where wi_id = lt_worklist-wi_id.
>
>     sort lt_loghist by wi_id.
>
> *   need to get the wf initiator
>     select
>  wi_id wi_aagent wi_text wi_cd wi_ct wi_stat wi_rh_task wi_chckwi
>        from swwwihead
>        into table lt_wf
>        for all entries in lt_worklist
>        where wi_id = lt_worklist-wi_chckwi.
>
>     sort lt_wf by wi_id.
>
>     "for subflows get the parent wf initiator
>     loop at lt_wf assigning <lfs_wf> where wi_chckwi <> ' '.
>       select single wi_aagent from  swwwihead into <lfs_wf>-wi_aagent
>         where wi_id = <lfs_wf>-wi_chckwi.
>     endloop.
>
>   endif.
>
>
> Regards
>
>
>
> Margaret Schumacher
>
>
>  ------------------------------
> *From:* Mike Pokraka [mailto:wug at workflowconnections.com]
> *Sent:* Thursday, August 21, 2008 3:47 AM
> *To:* 'SAP Workflow Users' Group'
> *Subject:* RE: Custom report to know the workflow approval status
>
>  Please AVOID accessing tables directly if you have an alternative. Use FM
> SAP_WAPI_WORKITEMS_TO_OBJECT.
>
>
>
>
>
> *From:* sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] *On
> Behalf Of *Ibrahim Khan
> *Sent:* 21 August 2008 06:31
> *To:* SAP Workflow Users' Group
> *Subject:* Re: Custom report to know the workflow approval status
>
>
>
> I am working on the Appropriation Request workflow for PS.
> The information is not stored in standard tables because the approvers are
> dynamic and selected while creating the Appropriation request.
> In this case I need to explore the workflow related tables to create this
> custom report.
>
> On Thu, Aug 21, 2008 at 11:58 AM, Rahul Shukla <rahul_ariean at yahoo.com>
> wrote:
>
> 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.
>
> You may need to join ur custom tables too to get the next level of
> approvers , if you are maintaing there.
>
> Regards,
> Rahul
> Something that can't be re-cycled is Wasted Time.
>
>
> --- On Thu, 8/21/08, Ibrahim Khan <ikhansap at gmail.com> wrote:
>
> > From: Ibrahim Khan <ikhansap at gmail.com>
> > Subject: Custom report to know the workflow approval status
> > To: "SAP Workflow Users' Group" <SAP-WUG at mit.edu>
> > Date: Thursday, August 21, 2008, 8:44 AM
>
> > Hi Friends,
> > For one of my custom workflow the client needs a custom
> > report to know the
> > approval status. This custom workflow will be a multilevel
> > approval and they
> > want to know the status based on the object key(document
> > number) like who
> > has approved it at what time, who else has to approve etc
> > which standard
> > workflow tables can be used for this? Please advice.
>
> > _______________________________________________
> > SAP-WUG mailing list
> > SAP-WUG at mit.edu
> > http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20080828/5af6e881/attachment.htm