Easiest way to tell if single step task and not a task in WF?

[Sample, Rick]

Sorry, just getting back to this question.



So, bottom line. If SWWWIHEAD-WI_TYPE = 'W' and SWWWIHEAD-WI_CHCKWI = <space> this is a single step task. i.e. not part of a workflow instance. Yes?



I just looked at some old records from 2005 and this ‘looks’ correct because PARENT_ID is <space>.



Is this true for 4..6c AND Ecc6? Meaning, nothing would have changed this do to upgrade?



Thanks much!

Rick



-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Kjetil Kilhavn
Sent: Wednesday, September 12, 2012 06:46
To: sap-wug at mit.edu
Subject: Re: Easiest way to tell if single step task and not a task in WF?



Onsdag 12. september 2012 13.27.20 skrev Kjetil Kilhavn:

> Fredag 7. september 2012 12.53.20 skrev Sample, Rick:

> > Hi all,

> >

> > Doing some archiving, cleanup, etc.

> >

> > Looking for the quickest way to tell if a task is a single step task

> > and NOT part of a WF?

>

> <header>-top_wi_id EQ <header>-wi_id AND <header>-wi_type NE 'F'

An explanation is perhaps needed… My memory served me slightly wrong. It is not TOP_WI_ID I have used to identify these before. Single work items all have initial value in WI_CHCKWI) in my experience.



Your solution (<header>-parent_wi IS INITIAL) will give exactly the same result as far as I know, so it's just a matter of choice depending on which data you have available, if you have data available.

For database selections there is an index on WI_CHCKWI, but none on PARENT_WI.

(There's also an index on TOP_WI_ID, but that is not much help since it has to be equal to another value instead of being a fixed value).



For the record, WFD_ID also seems to be initial for single task work items, but is not indexed.



To sum it up: for selection from DB the best choice should be WI_CHCKWI, and to check available data you have several options.



>

> > If SWWWIHEAD-PARENT_WI = NULL, then this is in fact a simple task?

> > Like an IDOC task, etc.?

> >

> > Rick

--

Kjetil Kilhavn (+47 40220607) - Blue Consulting AS (http://www.bluec.no)



_______________________________________________

SAP-WUG mailing list

SAP-WUG at mit.edu<mailto:SAP-WUG at mit.edu>

http://mailman.mit.edu/mailman/listinfo/sap-wug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20120914/0c0d8fda/attachment-0001.htm