Hello WorkFlow Experts ...
I have been asked to provide reports about WorkFlows that I can email to managers.
I know that there are a number of WorkFlow Admin Tcodes that can be used to pull out small amounts of data but I need to create large reports .... for example ....
Show me all WS90000029 workFlows that have been run from Nov 1 to Nov 30 across the entire organization (WS90000029 is our "Create New Position" workflow). For each instance (and there may be hundreds) please show ....
- Initiator
- Company code of Initiator
- creation date
- effective date
- curent status
- if not completed show agent currently holding the WF
- Org Unit (OM)
- etc.
You see my dilemma? I don't want to manually look for all of this data because it would take me many hours each time I'm asked for a report.
If there is no way to easily gather and download this type of data into an Excel sheet that can be emailed then I'll need to think about a custom report. In that case I'll need to know what tables hold all of this data. Do any of you know the main WF table names?
Thank you in advance for your help .... fingers crossed that someone out there can help.
Dan A