Reporting on parts of a Worklfow

[Bijay Shrestha]

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.