Custom material workflow report

[priyank dev]

hi gayathiri,
                 Try in wf-syst table..you may get some idea.If you know WF
id, try in wf-hdr/wf-syst.Hope it may help you.


On 10/29/09, Gayathri Shivakumar <Gayathri.Shivakumar at us.yazaki.com> wrote:
>
>  Hi experts,
>
>
>
> I have been tasked with giving information to the ABAP team to generate a
> report to track workflow for material. I have a custom workflow developed
> for material flow. The format for the report is :
>
>
>
> * *
>
> * *
>
> * *
>
> *Material Planner Task 1*
>
> *SAP Part Number*
>
> *Plant Code*
>
> *Plant Specific Material Status*
>
> *Owners*
>
> *Date/Time Task Received*
>
> *Date/Time Task Completed*
>
> *Elapsed Time*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> F0000000002
>
> 1112
>
> 40
>
> xxxx
> xxxx
> xxxx
>
> 1/1/2009, 2:00pm
>
> 1/2/2009, 8:32am
>
> 0 Days
> 18 hours
> 32 Minutes
>
> F0000000001
>
> 1234
>
> 20
>
> xxxx
> xxxx
>
> 1/1/2009, 2:00pm
>
> 1/2/2009, 9:32am
>
> 0 Days
> 19 hours
> 32 Minutes
>
> F0000000001
>
> 4567
>
> 30
>
> xxxx
>
> 1/1/2009, 2:00pm
>
> 1/2/2009, 10:32am
>
> 0 Days
> 20 hours
> 32 Minutes
>
> F0000000001
>
> 3456
>
> 10
>
> xxxx
> xxxx
> xxxx
>
> 1/1/2009, 2:00pm
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Ave. Completion Time
>
> 0 Days
> 19 hours
> 32 Minutes
>
>
>
>
>
>
>
>
>
>
>
>
>
> We have looked at standard reports and they do not meet the requirements of
> the customer. We are trying to track only one particular task in the
> workflow. To get the required data we are looking at workflow tables SWW_WI2OBJ
> and function modules SWW_WI_FIND_DEPENDANT_WIS. Since each material is
> extended to several plants we are seeing several entries. I am particularly
> not able to find the starting workitem id to track down the rest.
>
>
>
> I would like to know if there are other specific tables that I need to look
> at. Where are the container variables of the workflow template stored ?
>
>
>
> *Thanks and Regards.*
>
>
>
> *Gayathri Shivakumar*
>
>
>
>
> *Yazaki North America, Inc. - Confidentiality & Security Notice*
> ------------------------------
> This email is intended only for the person or entity to which it is
> addressed and may contain confidential, proprietary and/or privileged
> material. Any review, distribution, reliance on, or other use of this
> information by persons or entities other than the intended recipient is
> prohibited. If you receive this message in error, please immediately notify
> the sender and delete it and all copies of it from your system.
>
> Visitors are prohibited from taking pictures or video at anytime in YNA or
> its affiliated company facilities unless prior authorization is obtained
> from facilities management.
>
> Thank you.
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>


-- 
Adios,
PRIYANK DEV PATIL
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20091029/de52b93a/attachment.htm