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

[Former Member]

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

[Sm1tje]

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.

[Former Member]

Any other.

[Former Member]

Hi

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

[Sm1tje]

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).

[Former Member]

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

[tushar_shukla]

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

[Former Member]

Hi,

Go to

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

Make sure you have the correct query on the screen to point the report name.

Then go to SE38 and display the report name and check the Joins/Tables/Code.

Hope this helps

Regards

Shiva