Workflow data tables

[Bijay Shrestha]

I'm also struggling to write a report the way that our users want. By =
using SAP_WAPI_GET_HEADER I could get all the necessary data that I need =
but I couldn't find Wapi to get data from SWWLOGHIST type of data.
 
Basically, my users want me to calculate all the time differences =
between each function name within one step (WI). I did read from the =
SWWLOGHIST table, but it's difficult to sort them and tell the order. =
Also what does the field "LOGCOUNT" means in that table?
 
Thanks.
 
Bijay Shrestha
Ph: (763) 764-2201
Pager: (612) 661-2772
Email: Bijay.Shrestha at genmills.com
"WebFlow gets the right information to the right people at the right =
time!"
 
 
-----Original Message-----
From: Dart, Jocelyn [mailto:jocelyn.dart at sap.com]
Sent: Wednesday, November 12, 2003 12:22 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Workflow data tables
 
 
Shayam,
Please use the WAPIs - i.e. function modules prefixed with SAP_WAPI.
Avoid directly accessing tables.
You should be able to get the information you need from there.
Also SWI1 is an adminstration report only. This is NOT a good report to =
give to users.
 
A better report for users is to use Generic Object Services or SWI6.
 
Any of these would give you a picture of workflows related to the same =
object, e.g. for the same product.
 
There's an article in the latest SAP HR Expert magazine on how to set up =
generic object services - the
example is for HR but the procedure is the same for most transactions - =
you just need to identify the
correct business object type to use, e.g. if product =3D material =
number, then you could use generic object
services from transaction MM03 using object type BUS1001006.
Regards,
        Jocelyn Dart
Consultant (SRM, EBP, Workflow)
and co-author of the book
"Practical Workflow for SAP"
SAP Australia
email: jocelyn.dart at sap.com
phone: +61 412 390 267
fax:   +61 2 9935 4880
 
 
 
 
 
-----Original Message-----
From: Shayam Agrawal [mailto:shayamagrawal at lycos.com]
Sent: Wednesday,12 November 2003 5:02 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Workflow data tables
 
 
Hi All,
Good day to all,
 
Can somebody please let me know in which tables the work flow data is =
stored with respect to work item details and elapsed time etc as can be =
seen using transaction SWI1.
We need to develop a custom drill down report which will have =
information on 3 workflows running in parrellel for one product.
 
Also please let us know if there is any transaction which can be used to =
navigate from one workflow to another workflow.
The txn SWI1 is a good report as per client needs but the navigation =
from one workflow to another is not satisfactory.
 
Thanks and regards
Shayam Agrawal
 
 
 
____________________________________________________________
Enter now for a chance to win a 42" Plasma Television!
http://ad.doubleclick.net/clk;6413623;3807821;f?http://mocda1.com/1/c/563=
632/113422/313631/313631
AOL users go here: =
http://ad.doubleclick.net/clk;6413623;3807821;f?http://mocda1.com/1/c/563=
632/113422/313631/313631
This offer applies to U.S. Residents Only