Custom material workflow report

[Gayathri Shivakumar]

Thanks for the inputs. I am reviewing these and will let you know if I
have more questions.

Thanks and Regards.
 
Gayathri Shivakumar

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Schumacher, Margaret
Sent: Thursday, October 29, 2009 9:09 AM
To: sap-wug at mit.edu
Subject: RE: Custom material workflow report

To read the container use the function SAP_WAPI_READ_CONTAINER.  If you
need to consider when an item was forwarded to the user who completed it
then the table SWWLOGHIST can give you that. (There may be a SAP_WAPI to
read it but I didn't find it).

* read the log again if item was forwarded the
* starting date/time will be adjusted to the most recent forward
 
form chk_forwarding  changing  p_rec type zfi_w021.

  check not p_rec-wi_forw_by is initial.

  select timestamp from  swwloghist into swwloghist-timestamp
         where  wi_id   = p_rec-wi_id
         and    method  = 'SWW_WI_FORWARD'
         order by timestamp descending.
    convert time stamp swwloghist-timestamp
      time zone sy-zonlo
      into date p_rec-wi_cd
           time p_rec-wi_ct.
    exit.
  endselect.

endform.     

From: "Gayathri Shivakumar" <Gayathri.Shivakumar at us.yazaki.com>
Subject: Custom material workflow report
To: <sap-wug at mit.edu>
Message-ID:
	
<092B2D6C441ED54CAACDCE77A7F547F30358AE9F at CANT-VMSG-002.yazaki.local>
Content-Type: text/plain; charset="us-ascii"

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 :

....
 
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

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug



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.