WF_BWP_DYN_COLUMN
JANSSENS Koenraad
Koenraad.JANSSENS at swift.com
Fri Jun 18 09:28:26 EDT 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20100618/a05590c9/attachment.htm
More information about the SAP-WUG
mailing list