<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Microsoft Sans Serif">
<DIV dir=ltr align=left><SPAN class=340430620-28082006>swi14</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=340430620-28082006></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> sap-wug-bounces@mit.edu
[mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Joanne
Johnson<BR><B>Sent:</B> Monday, August 28, 2006 3:19 PM<BR><B>To:</B>
sap-wug@mit.edu<BR><B>Subject:</B> Need Simple Method to Scan Container
Values<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hello WUG folks,</DIV>
<DIV> </DIV>
<DIV>I am on 4.7 and need the simplest way to find values in a large number of
container in the following situation.</DIV>
<DIV> </DIV>
<DIV>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.)</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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? </DIV>
<DIV> </DIV>
<DIV>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?</DIV>
<DIV> </DIV>
<DIV>Thanks for the help.</DIV>
<DIV> </DIV>
<DIV>Joanne Johnson</DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>