topic Re: Get ABAP code for joins ( quick view ) created using SQVI in Application Development and Automation Discussions

Get ABAP code for joins ( quick view ) created using SQVI

Former Member — Thu, 02 Dec 2010 06:42:56 GMT

Hi Friends,

Is there a way to get ABAP code i.e., select query with join , for quick view which we have created using transation code SQVI.

Kindly let me know if there is a way to do so.

Regards,

Dep

Re: Get ABAP code for joins ( quick view ) created using SQVI

Sm1tje — Thu, 02 Dec 2010 06:45:13 GMT

just like any other report, on the selection screen (op your query upon executing it) choose system->status in the menu and there you go.

Re: Get ABAP code for joins ( quick view ) created using SQVI

Former Member — Tue, 07 Dec 2010 05:16:54 GMT

Any other.

Re: Get ABAP code for joins ( quick view ) created using SQVI

Former Member — Tue, 07 Dec 2010 05:55:56 GMT

In SQVI give the tables and execute after giving selection from the list

in the selection screen go to syastem ->status -> program.

you find the select query.

regards

Prabhu Shanmugham

Re: Get ABAP code for joins ( quick view ) created using SQVI

Sm1tje — Tue, 07 Dec 2010 06:09:39 GMT

Execute your query in SQVI and open a new session in SE38. Via get parameter, the name of your report is given. Just like any other report, you can display it and have a look at the code.

BTW: The name of the report (SE38) will also contain the pattern with the name of your query which you can use in SE38 via SEARCH (example: enter <queryname> and search in SE38).

Re: Get ABAP code for joins ( quick view ) created using SQVI

Former Member — Fri, 10 Dec 2010 11:16:46 GMT

Hi Micky,

I got the ABAP code but what I was looking for was the select query with join so that I can copy form there and use that in my other report.

Regards,

Dep

Re: Get ABAP code for joins ( quick view ) created using SQVI

tushar_shukla — Fri, 10 Dec 2010 21:09:56 GMT

You will find the inner join query inside the called function module of generated report name. Check the first function module under START-OF-SELECTION and search for JOIN keyword.

I hope you have already found the report name. You can get that through menu option

QuickView -> Additional functions -> Display report name

Re: Get ABAP code for joins ( quick view ) created using SQVI

Former Member — Sat, 11 Dec 2010 14:15:16 GMT

Hi,

Go to

SQVI or SQ01(Query Transaction) - > Query -> More functions -> Display report name.