Workitem report reading from container

[Mike Gambier]

...Aaaaaand that's why we still (mostly) rely on the old Structure Persistence profile option in our WF Definitions; so that SWW_CONT and SWW_CONTOB are forced to be used instead.

Trying to write reports on large systems  to scan cluster tables will drive you nuts. And expecting the WAPI to be efficient when you know the underlying database is clustered is optimistic at best.

Mike GT

Sent from my iPhone

On 10 Sep 2012, at 12:52, "Florin Wach" <florin.wach at gmx.net> wrote:

> 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
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug