WF_BWP_DYN_COLUMN

[JANSSENS Koenraad]

I know.. but that’s not really answering my question ☺ and it’s not a viable option here…

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Madgambler
Sent: Friday, June 18, 2010 4:31 PM
To: SAP Workflow Users' Group
Cc: SAP Workflow Users' Group
Subject: Re: WF_BWP_DYN_COLUMN

Simple rule: never, ever use dynamic columns. Your system performance will plummet at high volume.

Avoid at all costs.

Sent from my iPhone

On 18 Jun 2010, at 14:28, JANSSENS Koenraad <Koenraad.JANSSENS at swift.com<mailto:Koenraad.JANSSENS at swift.com>> wrote:
Hi,

Did anyone among you already implement BADI WF_BWP_DYN_COLUMN ?
Can somebody please clarify a bit the possible performance gains here…

I will try to summarize what I know:

The workflow inbox provides 6 dynamic columns which via customizing can display up to 6 values from the task container, making it easier for users to select, prioritise, filter, … workitems.
However this does have its impact on performance.

Now here this BADI is triggered when you display your inbox.. and you get a list of all wi_id’s, their task and the setup done for dynamic columns.  Those values are often attributes of a BOR.
Let’s keep it simple and say that it are all sales order objects (US2032) of which you want for instance the DocumentDate.  Now in order to make the query you will need to read every wi container.

This will return you something like element: SalesOrder value  BUS20320000770044 .  So then you can derive the object id from the value string… and combine all to make one query like

SELECT vbeln audat into table lt_custom_table
FROM VBAK
WHERE vbeln IN lr_vbeln

Is that the advantage?

Best Regards

Koenraad
_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu<mailto:SAP-WUG at mit.edu>
http://mailman.mit.edu/mailman/listinfo/sap-wug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20100621/79d346fa/attachment.htm