Workflow data tables

[Dart, Jocelyn]

Bijay,
If you have exhausted the SAP_WAPI function modules in your release (4.6c I take it?) then try
the internal API function modules (naming pattern SW*API).
There are some there with "PROTOCOL" in the function module name - these are the function modules that return
workflow log information. Some of these are used to build the summary and graphical logs so the log information is very suitable for creating custom reports.
Play around with the parameters - they give you options for finding active/completed workflows, expanding subflows in the log, etc.
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: Bijay Shrestha [mailto:Bijay.Shrestha at genmills.com]
Sent: Thursday,13 November 2003 8:50 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Workflow data tables
 
 
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 = 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