SQ01 Queries usage tool

[Former Member]

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.

[Former Member]

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.

[Ralf]

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

[Former Member]

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