topic Table for Work Item in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156227#M1369398 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P></P><P>I am searching for tables that would give me work items that are un processed. Then find the responsible person who has to take action on that un processed work item.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 15 Oct 2009 10:37:42 GMT Former Member 2009-10-15T10:37:42Z Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156227#M1369398 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P></P><P>I am searching for tables that would give me work items that are un processed. Then find the responsible person who has to take action on that un processed work item.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 15 Oct 2009 10:37:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156227#M1369398 Former Member 2009-10-15T10:37:42Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156228#M1369399 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Could you clarify what kind of effect you say? or previsti example of what you need to do?</P></BODY></HTML> Thu, 15 Oct 2009 10:57:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156228#M1369399 Former Member 2009-10-15T10:57:48Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156229#M1369400 <HTML><HEAD></HEAD><BODY><P>If I understood you correctly toposmotrite table REPOSRC </P><P>but generally one most likely not be enough so that the search here </P><P></P><P></P><P></P><P></P><P> D010S </P><P>DD03L </P><P>FUPARAREF </P><P>D010T </P><P>D020SINF </P><P>D021S </P><P>D022S </P><P>D023S </P><P>DD05S </P><P>D010INC </P><P>DD08L </P><P>DD08T </P><P>D010SINF </P><P>DD12L </P><P>DD12T </P><P>DD16S </P><P>DD17S </P><P>DD20T </P><P>DD21S </P><P>DD23L </P><P>DD23T </P><P>DD24S </P><P>DD25T </P><P>DD29T </P><P>D010TAB </P><P>D010TINF </P><P>D020S </P><P>D020T </P><P>D021T </P><P>D301T </P><P>D345T </P><P>D347T </P><P>DBDIFF </P><P>DBMAPS </P><P>DD01L </P><P>DD01T </P><P>DD02L </P><P>DD02T </P><P>DD03T </P><P>DD04L </P><P>DD04T </P><P>DD06L </P><P>DD06T </P><P>DD07L </P><P>DD07T </P><P>DD09L </P><P>DD20L </P><P>DD25L </P><P>DD26S </P><P>DD27S </P><P>DD28S </P><P>DD29L </P><P>DD30L </P><P>DD30T </P><P>DD31S </P><P>DD32S </P><P>DD33S </P><P>DD35L </P><P>DD36S </P><P>DD40L </P><P>DD40T </P><P>DD42S </P><P>DDTYPES </P><P>DDTYPET </P><P>DDXTF </P><P>DDXTT </P><P>DF03L </P><P>DF03T </P><P>DF04L </P><P>DF04T </P><P>DF06L </P><P>DF06T </P><P>DF07L </P><P>DF07T </P><P>DF08L </P><P>DF08T </P><P>DF10L </P><P>DF10T </P><P>DF11L </P><P>DF11T </P><P>DF12L </P><P>DF12T </P><P>DF13L </P><P>DF13T </P><P>DF14L </P><P>DF14T </P><P>DF15L </P><P>DF15T </P><P>DF16L </P><P>DF16T </P><P>DF30S </P><P>DF34S </P><P>DF40D </P><P>DF41S </P><P>DF42S </P><P>DF43S </P><P>DIAPAR </P><P>DM02L </P><P>DM02S </P><P>DM02T </P><P>DM03S </P><P>DM25L </P><P>DM26L </P><P>DM40L </P><P>DM40T </P><P>DM41S </P><P>DM42S </P><P>DM42T </P><P>DM43T </P><P>DM45L </P><P>DM45T </P><P>DM46S </P><P>DOKHL </P><P>DOKIL </P><P>DSYST </P><P>ENLFDIR </P><P>EUDB </P><P>EUGUITEXT </P><P>EUOBJ </P><P>EUOBJEDIT </P><P>EUOBJT </P><P>FUNCT </P><P>IADB2 </P><P>IADB6 </P><P>IAINF </P><P>IAMSS </P><P>IAORA </P><P>IASYB </P><P>IGDB2 </P><P>IGORA </P><P>LDBA </P><P>LDBB </P><P>LDBD </P><P>LDBH </P><P>LDBN </P><P>LDBNT </P><P>LDBQUAN </P><P>LDBT </P><P>MACID </P><P>MACOB </P><P>MCUSREXITS</P><P>NOTRA </P><P>RODIR </P><P>RSMPTEXTS </P><P>SEOCLASS </P><P>SEOCLASSDF</P><P>SEOCLASSEX</P><P>SEOCLASSTX</P><P>SEOCOMPO </P><P>SEOCOMPODF</P><P>SEOCOMPOEX</P><P>SEOCOMPOTX</P><P>SEOFRIENDS</P><P>SEOIMPLREL</P><P>SEOMAPATT </P><P>SEOMAPCLS </P><P>SEOMETAREL</P><P>SEOREDEF </P><P>SEOSUBCO </P><P>SEOSUBCODF</P><P>SEOSUBCOTX</P><P>SEOTYPEPLS</P><P>T100 </P><P>T100A </P><P>T100O </P><P>T100T </P><P>T100U </P><P>T100X </P><P>T512CLU </P><P>TCDCOUPLES</P><P>TDCT </P><P>TERCL </P><P>TERCL2 </P><P>TERCL3 </P><P>TERM </P><P>TERM2 </P><P>TERM3 </P><P>TERM4 </P><P>TERM6 </P><P>TERM7 </P><P>TFDIR </P><P>TFM18X </P><P>TFTIT </P><P>TGDB2 </P><P>TGINF </P><P>TGORA </P><P>TITLE </P><P>TLDB </P><P>TLDBT </P><P>TLIBG </P><P>TLIBT </P><P>TMDIR </P><P>TPARA </P><P>TPARAT </P><P>TRBAT </P><P>TRDIRT </P><P>TRESC </P><P>TRMSG </P><P>TSDB6 </P><P>TSINF </P><P>TSORA </P><P>TSPDD </P><P>TSTC </P><P>TSTCA </P><P>TSTCC </P><P>TSTCP </P><P>TSTCT </P><P>TSTC_SM </P><P>TSTC_SRT </P><P>TTREE </P><P>TTREEI </P><P>TTREEN </P><P>TTREEP </P><P>TTREET </P><P>TTREE_APPL</P><P>TTREE_FLNK</P><P>USOBT </P><P>WBACTIONS </P><P>WBACTIONST</P><P>WBEXTTYPES</P><P>WBOBJTYPES</P><P>WBOBJTYPT </P><P>WBREGISTRY</P><P>WBTOOLTYPE</P><P>DOKCLU</P><P></P><P>)))))</P><P></P><P>Edited by: DAV_999 on Oct 15, 2009 1:25 PM</P><P></P><P>Edited by: DAV_999 on Oct 15, 2009 1:26 PM</P><P></P><P>Edited by: DAV_999 on Oct 15, 2009 1:27 PM</P></BODY></HTML> Thu, 15 Oct 2009 11:25:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156229#M1369400 Former Member 2009-10-15T11:25:39Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156230#M1369401 <HTML><HEAD></HEAD><BODY><P>An example can be :-</P><P></P><P>An emplyee has an approval task which he has not completed in his SAP inbox. I need to find this employee and the task. Please let me know which tables do I need to refer?</P></BODY></HTML> Thu, 15 Oct 2009 11:43:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156230#M1369401 Former Member 2009-10-15T11:43:09Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156231#M1369402 <HTML><HEAD></HEAD><BODY><P>Can u please explain what that reply was???????</P></BODY></HTML> Thu, 15 Oct 2009 12:06:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156231#M1369402 Former Member 2009-10-15T12:06:46Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156232#M1369403 <HTML><HEAD></HEAD><BODY><P>Please refer the below mentioned tables </P><P></P><P>SWWWIHEAD</P><P>SWW_CONT Workflow Runtime: Work Item Data Container</P><P>SWW_CONTOB Workflow Runtime: Work Item Data Container (Only</P><P>SWW_WI2OBJ Workflow Runtime: Relation of Work Item to Objec</P><P>SWWDHSTEXT Workflow: Status Texts for Work Item Deadline St</P><P>SWWEI Workflow Runtime: Work Items of Type E (Event It</P><P>SWWLOGHIST Workflow Runtime: History of a Work Item</P><P>SWWSTATEXT Workflow: Status Texts for Work Item Status</P><P>SWWSTATUS Workflow: Properties of a Work Item Status</P><P>SWWTYPTEXT Workflow: Type Texts for Work Item Types</P><P>SWWUSERWI Current Work Items Assigned to a User</P><P>SWWWIAGENT Workflow Runtime: Agents for Execution of a Work</P><P>SWWWIDEADL Workflow Runtime: Deadline Data for Work Items</P><P>SWWWIDH Workflow Runtime: Deadline Monitoring of Work It</P><P></P><P>Please let me know in case you need any help.</P><P>Regards,</P><P>Nabheet Madan</P></BODY></HTML> Thu, 15 Oct 2009 12:47:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156232#M1369403 nabheetscn 2009-10-15T12:47:31Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156233#M1369404 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You should be able to accopmlish this with t-code SWI1. On selection screen set Type = W, Status = READY, SELECTED, STARTED, ERROR and adjust Date and Time to your liking. </P><P></P><P>If you are really set on knowing the tables, start with SWWWIHEAD. Selection criteria is similar to what I described for t-code SWI1. The agent IDs will be in column WI_AAGENT only if work item has an actual agent. For work items w/o actual agent you need to join SWWWIHEAD w/ SWWORGTASK. That may not cover all situations but it should get you started.</P><P></P><P>Regards,</P><P>TXHughes</P></BODY></HTML> Mon, 19 Oct 2009 21:58:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156233#M1369404 Former Member 2009-10-19T21:58:05Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156234#M1369405 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>May I ask if there's a table storing the different steps of a work item? Besides the swwloghist?</P><P></P><P>Thanks.</P><P>Regards,</P><P>C.</P></BODY></HTML> Wed, 28 Oct 2009 16:57:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156234#M1369405 Former Member 2009-10-28T16:57:06Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156235#M1369406 <HTML><HEAD></HEAD><BODY><P>None</P></BODY></HTML> Wed, 09 Dec 2009 09:32:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156235#M1369406 Former Member 2009-12-09T09:32:08Z Re: Table for Work Item https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156236#M1369407 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>As per your reqirement to need to create program in which you need to fetch the status of WI from the table "SWWWIHEAD" by passing status and task id. Then using the FM "SWW_WI_CONTAINER_READ" read the workflow container to get the required details like to will get the approver name for suppose.Now send the reminder mail to him,</P><P></P><P></P><P>Please close the thread,if solved</P><P>Regards,</P><P>Aditya</P></BODY></HTML> Wed, 09 Dec 2009 09:39:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-for-work-item/m-p/6156236#M1369407 Former Member 2009-12-09T09:39:08Z