WF_BWP_DYN_COLUMN
Madgambler
madgambler at hotmail.com
Fri Jun 18 10:31:23 EDT 2010
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
More information about the SAP-WUG
mailing list