WF_BWP_DYN_COLUMN

[Madgambler]

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> wrote:

> Hi,
>
>
>
> Did anyone among you already implement BADI WF_BWP_DYN_COLUMN ?
>
> Can somebody please clarify a bit the possible performance gains her 
> e…
>
>
>
> 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 dyn 
> amic columns.  Those values are often attributes of a BOR.
>
> Let’s keep it simple and say that it are all sales order objects (US 
> 2032) 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
> http://mailman.mit.edu/mailman/listinfo/sap-wug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20100618/e6b5b7d0/attachment.htm