Drill down functionality in SQ00 queries

[Former Member]

Hi Experts,

I want your help to activate drill down functionality in SQ00 reports.

Means in the report, if there is Sales Order, I want to double click on SO number and system should take me to VA03 screen.

I am working on ECC system.

Please help.

Regards,

Praveen

[Former Member · Accepted solution]

Praveen,

It depends upon the query and the structure of the destination transaction. It doesn't always work for all queries. Try this:

1.  SQ00 select query

2.  Goto > Report Assignment.

3.  Select the Red Plus ("Insert Row") Icon at the bottom of the popup

4. At the bottom of the new popup, select 'Other Report type'

5.  Select 'TR' Transaction

6.  Enter the transaction code (VA03)

7.  OK (Green check) > Save > then save the query.

Best Regards,

DB49

[Former Member · Accepted solution]

Thanks a lot for quick and perfect reply..

[moazzam_ali]

I did this too but it only works if Query area is standard. It is not working in global query area. Why is it so? Is this functionality only for standard query area? Please update although the thread is closed.

[Former Member]

MoazzaM,

I don't know the answer to your questions.  I never create any queries except in the 'Standard' area.

Best Regards,

DB49

[moazzam_ali]

How you transport your standard area Query report from DEV to PRD server? Standard area report can not be transported. They are are created directly on PRD.

[Former Member]

MoazzaM,

I don't recall ever having a problem with transports of Queries and Infosets.

Are you using the standard Transport Query Tool RSAQR3TR?

Best regards,

DB49

[moazzam_ali]

YEs im using this tool to transport but it was not transporting query created standard area. Then i copied it to global and this tool  RSAQR3TR allowed to transport it.

[Former Member]

MoassaM,

As I said, I have never had any problems transporting Queries/Infosets.  I don't know why you are having a problem.  Maybe you should speak to your basis people....

You can also use download > upload with this tool, and bypass Transport altogether, if you can't make transport work to your satisfaction.

Best Regards,

DB49

[moazzam_ali]

Thanks man. I will check it again.

[Shiva_Ram]

I recommend closing the thread here and posting the query in ABAP forum to get response.

Regards,