Tuesday 30 September 2014

POWL Query Refresh

SAP has provided few standard POWL applications such as MANAGER_MSS_INBOX or IBO_INBOX in which the refresh functionality is achieved through the refresh handler's and to achieve the same in custom POWL applications, SAP has given us few options.

All the standard POWL applications use 'POWL_UI_COMP' standard POWL Webdynpro Component and 'POWL' Webdynpro Applictaion. The 'POWL' Webdynpro Application has 'REFRESHA' and 'REFRESHQ' parameters which controls the way in which the queries get refreshed.

 
Let’s have a look at the possible ways of enabling the auto refresh functionality in the custom POWL applications.

1. While assigning the POWL_TYPE to a Query in the transaction 'POWL_QUERY', set the parameter refresh type to 'On Every List Visit'. This will refresh the query every time user access the application irrespective of the user session.

 
2. In the application configuration of custom POWL application, we can set the parameter (REFRESHQ-Refresh the current Query).












3. While assigning the application to a role (PFCG) add a parameter REFRESHQ and set this to 'X'.









4. In the handle action of feeder interface IF_POWL_FEEDER, set the parameter E_DO_REFERSH to 'X'. This will trigger the query refresh after the user has performed some action on POWL list (Approve/Reject/Opening the form etc.).





5. By scheduling a batch job for the custom queries using the report 'POWL_WLOAD' to Refresh POWL Queries.
Note: Suppose we have made some changes to the existing query logic in the feeder class and the query is still displaying the old results then run the report 'POWL_D04' to delete the cached selection criteria for queries.