Custom material workflow report

[Schumacher, Margaret]

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