Need Simple Method to Scan Container Values

[Joanne Johnson]

Hello WUG folks,
 
I am on 4.7 and need the simplest way to find values in a large number of container in the following situation.
 
We create a workflow everytime a certain type of invoice is created, therefore there are hundreds of workflows created every week.  When the invoice (BKPF segment) is created, it is created with a payment block.  The workflow then removes the payment block when it is processed.  However, it is possible that a workflow is never worked leaving both the invoice and the workflow hanging out there.  (The "why" is not important for this question.)
 
We also have a batch process that goes out and writes off the invoices after a certain age.  This basically leaves the workflow as an orphan because the invoice has  it's payment block removed when it is written off.  I would like some method of removing the corresponding workflow when a document is written off.
 
Is there a simple method for me to find the corresponding workflow for a specific BKPF segment?  The BKPF key (company number, document number and fiscal year) are kept in the container of the workflow header and in each workitem.  At the time that the writeoff occurs, I would like to be able to access a table that contains the container values to determine all the workitem id's with this company/docno/fiscyr.  Then using the workitem id, I could then delete the workflow.  Does this sound feasible or is there a better way?  
 
I am unable to determine what the table name is that contains the container values.  Is there some type of index on this container table that would eliminate reading by a tablespace scan?
 
Thanks for the help.
 
Joanne Johnson
 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20060828/370d36ad/attachment.htm