Need Simple Method to Scan Container Values

[Breslavets Sergey]

also: SAP_WAPI_WORKITEMS_TO_OBJECT if you wanna query from a program.

________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Joanne Johnson
Sent: Monday, August 28, 2006 3:19 PM
To: sap-wug at mit.edu
Subject: Need Simple Method to Scan Container Values


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/75c74a39/attachment.htm