How can I check if a workflow instance for a particular objec t is already in process?

[Weaver, Karen]

I do this by using the following SQL statement:
 
  SELECT SINGLE wi_stat INTO swivobject-wi_stat
    FROM swivobject
   WHERE objtype    = 'ZBUS1010'
     AND objkey     = z_credacctkey
     AND wi_stat    in ('READY','IN PROCESS')
     AND wi_rh_task = 'TS90100013'.
 
If I have a workflow in process or ready status for my business object with
this key, I do not want to trigger another workflow.  Therefore, I do the
SQL check in my check function.
 
-----Original Message-----
From: Torsten Schnorpfeil [mailto:torsten at processflow.de]
Sent: Tuesday, April 15, 2003 12:02 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: How can I check if a workflow instance for a particular object
is already in process?
 
 
Hi guys,
 
here's the questions: I need to figure out if a certain instance of a
workflow with a particular object key is already running. I checked the work
item header table, but it didn't help much. Does anybody know the name of
the table where all the values of a workflow container are stored during
runtime? This would give me the capability to check on this table.
 
OR: Does anybody have another idea how to achieve my purpose?
 
THX!
 
Cheers,
 
Torsten