Workflow data tables

[Dart, Jocelyn]

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 = 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/563632/113422/313631/313631
AOL users go here: http://ad.doubleclick.net/clk;6413623;3807821;f?http://mocda1.com/1/c/563632/113422/313631/313631
This offer applies to U.S. Residents Only