Program or a Report name to find all the objects in a query?

[former_member212236]

Dear People,

Could anyone help me in finding out the program or a report name thorugh which I can find all the objects related to a particular query?

Thanks in Advance!

Regards,

Vinoth V

[Former Member · Accepted solution]

Run the program RSRQ_QUERYDEFINITION in SE38

[former_member189638]

The best option will be goto RSA1 -> Metadata Repository. Select Query and seach for your query. This will give you the details of all the objects associated with your query.

[Former Member]

Hi,

RSRQ_QUERYDEFINITION is a program to give all details about query if you executed it in SE38.

And similarly tcode RSRT1 and RSRT used to execute the queries.

Tcode RSRREPDIR to know the Query execution time and details.

Hope helps out,

Thanks-RK

[former_member182516]

Hi,

SE38 : RSRQ_QUERYDEFINITION -- execute

Enter the Query name and select the output options like Filters,Rows/Columns, Cells,table views, input variables , exceptions and conditions .

From the Additional options you can select the Query proprties ,expand hierarchies

Click on execute .it will display all the info related to Query.

Check the below blog link

[Query details|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14329] [original link is broken] [original link is broken] [original link is broken];

[Former Member]

Hi,

Serach for apprprite table in your system in SE12 tcode by putting RS* and F4.

I hope you will get you required table.

I hope it will help.

Thanks,

S

[former_member212236]

Thanks a lot friends...for the valuable information.

But one more question, Is there anyways to get the output of the "RSRQ_QUERYDEFINITION " report in a Table format, rather than the Tree Structure...

Vinoth V

[Former Member]

It will display in the same way you see in QD (left hand side tree struct) .. It's easier to navigate .. you can't get in table format

You can export to excel and do the changes to your required format!

You can restrict the output by selecting few options like - Filters / Cells / Rows.. etc