Workitem report reading from container

[Florin Wach]

Hi Shai,

I've also encountered the bad performance on reporting through the workflow/workitem container elements and haven't found a way with a better performance.

For that matter, I usually create a separate Workflow index table and update the content from time to time by the running workflow instance.

The latest solution I'm using it to use WORKFLOW_EXIT and WORKITEM_EXIT, that delivers the workitem-ID and the container, and I use this for updating the index table, which is working great.

With the very best wishes,
   Florin



-------- Original-Nachricht --------
> Datum: Mon, 10 Sep 2012 03:06:58 -0700 (PDT)
> Von: Shai Eyal <shai.eyal at yahoo.com>
> An: sap-wug <sap-wug at mit.edu>
> Betreff: Workitem report reading from container

> Hello everyone,
> Once in a while I face the question is subject and was wandering what
> others are doing.
> I'm creating report that reads info from workitems' containers and some
> other tables (customer master, sales documents, bla bla).
> In order to read workitem container, I use SAP_WAPI_READ_CONTAINER. It
> works OK but it is really not efficient from performances point of view.
> I was looking for a way to read containers of multiple workitems at on
> time, like doing SELECT FOR ALL ENTRIES. 
> I used to work with table SWW_CONT but ever since workflow is set to work
> with XML persistence (which is very useful), container info is not stored
> in SWW_CONT anymore, it seems to be clustered (table SWWCNTP0?).
> 
> Any ideas?
> Thanks in advance,
>  
> 
> Shai Eyal