Query about POWL_D10 report

[SAPSupport]

What is the impact of running POWL_D10 and why only entries in table POWL_ACT_QUERY with REFRESH_DATE are deleted, remaining entries are not?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello,

Based on your query: "What is the impact of running POWL_D10 and why only entries in table POWL_ACT_QUERY with REFRESH_DATE are deleted, remaining entries are not?" 

Running the POWL_D10 report in SAP involves a few straightforward steps. This report is used to clean up expired or obsolete entries in the Personal Object Worklist (POWL) tables, specifically targeting entries with outdated REFRESH_DATE values to improve system performance and manage database sizes. efficiently.

Furthermore, POWL_D10 is used to deleted the derived queries, and pre set criterias, so that  if any changes in the query settings or there any issues then this report will help to refactor query.

for details on the report please refer https://wiki.scn.sap.com/wiki/display/WDABAP/POWL+Reports

Best Regards,

SAP Technical Support