topic Re: SQ01 Queries usage tool in Application Development and Automation Discussions

SQ01 Queries usage tool

Former Member — Thu, 17 Sep 2009 10:07:28 GMT

Hi all,

Is there any tool to find out recently used SQ01 Queries.

i.e can we find if any queries are not being used since long.

Re: SQ01 Queries usage tool

Ralf — Mon, 07 Dec 2009 17:41:43 GMT

Hi Vidya,

I am afraid there is no such tool as a one-click solution.

However there are other options that might help you.

1) For example you could check out whether the report is already generated.

To find out the report name for a query go to Query->More functions->Display Report name. If it isn't generated the query was not executed since the last change or system copy if you look in a Test system.

2) Also there are BASIS tools that can show the usage of transactions and reports. Using those you might be able to find out more. Ask your Basis colleagues for more info.

Best,

Ralf

Re: SQ01 Queries usage tool

Former Member — Mon, 07 Dec 2009 18:14:17 GMT

Hi,

you can find the by using the STAD transction..

for every query there is a program behind it is runnung ..it starts with < AQQuery GroupQuery name* >check in TRDir table..

and see the program name which is for Query ..and pass to program in STAD transaction and give date range and see

whether it is used or not..

or by using the FM "SAPWL_STATREC_DIRECT_READ" you can see ..

Regards,

Prabhudas