Reporting on parts of a Worklfow

[Michael Pokraka]

If it's appropriate, SAP_WAPI_WORKITEMS_TO_OBJECT does a nice job of retrieveing all related workitems + their hierarchy info for a workflow - provided the relevant tasks all work with the same object.
Cheers
Mike
 
On Mon, Oct 06, 2003 at 03:48:15PM -0500, Bijay Shrestha wrote:
> Robert,
>
> I'm also working on similar report. I'm getting all fields as much as possible from SWWWIHEAD table. To get the End time and actual processing details withing single task from table SWWLOGHIST. These two tables will be pretty much enough to get all the data for me. I hope it'll work for you too.
>
> Please let me also know if you have any other idea.
>
> Bijay Shrestha
> Ph: (763) 764-2201
> Pager: (612) 661-2772
> Email: Bijay.Shrestha at genmills.com
>
>
> -----Original Message-----
>> From: Aydin, Kemal (Kemal)** CTR ** [mailto:aydink at lucent.com]
> Sent: Monday, October 06, 2003 12:22 PM
> To: SAP-WUG at MITVMA.MIT.EDU
> Subject: Re: Reporting on parts of a Worklfow
>
>
> Robert,
>
> If I understood your question correcty, you looking for the aggregate wait times for some tasks. Here are the tables I used to do a similar task:
>
> SWWWIHEAD : To construct the hierarchy and find the WI numbers ( field WI_ID ) ( you can get the top level from the object and then get the following task numbers using WI_CREATOR field )
>
> SWWWIRET: Then you can find out the end dates for the WI_ID
>
> Then, process the duration times according to the user input.
>
> Here is an example for the SWWWIHEAD:
>
> WI_ID           WI_TYPE         WI_CREATOR
> 000017434260 F           USWWEB_ADM
> 000017434261 B             FLOWITEM  0000174342600000000411000001
> 000017434262 B                   FLOWITEM  0000174342600000000005000001
>
> As you can see WI_CREATOR has 17434260 in the text field for the tasks in the WF.
>
> Thanks,
> Kemal
>
> > -----Original Message-----
> > From: Robert.Verlaat at nuon.com [SMTP:Robert.Verlaat at nuon.com]
> > Sent: Monday, October 06, 2003 9:31 AM
> > To:   SAP-WUG at MITVMA.MIT.EDU
> > Subject:      Re: Reporting on parts of a Worklfow
> >
> > In my situation the first option will be the easyest to implement. Thank for
> > your replayes.
> >
> > Regards,
> >
> > Robert
> >
> > Option 3 seems to me the solutions, but if it is a productieve workflow it
> > won't work for the already performed workflows. You could write an abap
> > getting info from tables SWWWIHEAD and SWPSTEPLOG.
> >
> > Menne
> >
> > -----Original Message-----
> > From: Van der Burg, Jeroen JA SITI-ITPSEE
> > [mailto:jeroen.vanderburg at shell.com]
> > Sent: vrijdag, oktober 03, 2003 16:47
> > To: SAP-WUG at MITVMA.MIT.EDU
> > Subject: Re: Reporting on parts of a Worklfow
> >
> >
> > Just a couple of thoughts (hey, it is Friday afternoon):
> >
> > 1. How about triggering and ending a 'reporting' wf on the side which only
> > consists of a trigger (same as your normal wf) and a wait step (event being
> > published in your current flow after the completion of your fifth step). It
> > seems a bit over the top but will do the trick nicely.
> >
> > 2. Fill a table where you can report on with start date/time and end
> > date/time (custom stuff requiring a custom report so not so nice)
> >
> > 3. Split up your workflow into two parts: main part, which triggers a
> > subflow which contains your first five steps before returning to the rest of
> > your current flow. Allows you to report on the subflow part and on the
> > entire process in one go.
> >
> > Must be a few other options. Anyone having more idea's?
> >
> >
> > Cheerio,
> >
> >
> > Jeroen
> >
> > -----Original Message-----
> > From: robert.verlaat at accenture.com [mailto:robert.verlaat at accenture.com]
> > Sent: 03 October 2003 16:39
> > To: SAP-WUG at MITVMA.MIT.EDU
> > Subject: Reporting on parts of a Worklfow
> >
> >
> > Hello all,
> >
> > I have a requirement for reporting on a part of a Worklfow. More specific:
> > Duration from the start of the Workflow unitil the f.e. fifht Task is
> > executed. There are Foreground Tasks in between. It doesn't seems to be
> > possible with the standard reports(only duration of 1 Task/Workflow).
> > Does anyone has a solution for this?
> >
> > Thanks,
> >
> > Robert Verlaat
> >
> >
> >
> > This message is for the designated recipient only and may contain
> > privileged, proprietary, or otherwise private information.  If you have
> > received it in error, please notify the sender immediately and delete the
> > original.  Any other use of the email by you is prohibited.