Reporting Features for SAP

[Kisloff, Philip B]

Hi Jake,
 
I don't think there are any "out-of-the-box" report for your needs, as the standard reports are generally devoid of any context, with just raw times per workitem and user ID. To get around this problem I set up reporting in the Workflow Information System. In 6.40 there is also an option to make each workflow step export summary data to BW, and there was a blog in SDN a while back.
 
I have only experience with WIS. This tool is going to be deprecated, but was still available in 6.40. It is not an ideal solution, because it only reports completed workflows, but for statistical reporting of performance or workload (think catching idle approvers who always let their inbox deadlines slip for someone else to deal with) it does the job.
 
Phil
 
 

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu]On Behalf Of ronenf at paz.co.il
Sent: 15 April 2007 11:43
To: SAP Workflow Users' Group
Subject: RE: Reporting Features for SAP


Hi,
 
I understand your feelings.... 
What I did was to set up a few simple abap queries that look at table SWWUSERWI together with the rest of the relevant WF tables. 
There are only ~43 tables that begin with SWW* so it is not complicated to find the right ones. 
This way you can quite easily get a few reports that show you the workitems assigned to a user even when the status of the workitem is "ready"
 
Good luck & best regards,
Ronen

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Schmidt, Jake (SN)
Sent: Saturday, April 14, 2007 11:28 PM
To: sap-wug at mit.edu
Subject: Reporting Features for SAP


Greetings,
 
I'm struggling to find SAP delivered reports formatted the way I'd like.  It seems that SWIA is one of the few reports that can be exported to a spreadsheet and contains loads of information that can be modified via columns.  Am I missing something?  Most of the other reports spit out a list of work item IDs that I must double click, then I can hit the log button.  What other reporting features are out there if any?
Also work items that come to...the WF Initiator show up in these reports as Not Reserved.  This is maddening since it is only sitting in one persons inbox.  My users' managers are used to being able to view what their employees are working on.  I'd like to find some reporting feature that a manager can enter in his org or a list of user IDs to see all work items in work or ready for those users.  SWI5 gets you close, but if the user hasn't started working the work item it is defaulted to not reserved.  So a manager would see a list of different tasks under a heading of not reserved.  He'd have to double click and open it...then click the log button...then hit the agent button.  Ugh.  
 
Appreciate any help you can offer in finding reports for users not just an administrator.
 
Jake Schmidt
Spirit AeroSystems
Workflow Developer

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20070416/68d69ae5/attachment.htm