topic Re: SAP Reports in Application Development and Automation Discussions

SAP Reports

former_member260745 — Thu, 03 Jul 2014 20:56:19 GMT

Hi,

We have many queries in SAP that have not been used for long time. I would like to delete them based on when it was ran last time by whom in ECC system. SQ01 is one option to find but is there a better way to do this type of clean up.

Appreciate for your support..

Regards

Re: SAP Reports

former_member202771 — Fri, 04 Jul 2014 02:45:52 GMT

Hi Arjun,

Check tables AQL*. these could help.

Thanks,

Anil

Re: SAP Reports

former_member260745 — Tue, 08 Jul 2014 13:46:36 GMT

Anil,

Thanks for the response but those tables does not provide when and by whom queries ran last time.

Regards

Arjun

Re: SAP Reports

RaymondGiuseppi — Tue, 08 Jul 2014 14:10:32 GMT

(Easy part) First link query list (from AQLQCAT) with generated reports using RSAQ_REPORT_NAME in a LOOP.

(Harder part) Then use FM SAPWL_WORKLOAD_GET_STATISTIC (table parameter returned APPLICATION_STATISTIC) to get last usage of reports. (Background job suggested...)

(Easy again) then match the two extractions.

Regards,

Raymond