topic Re: How to transport SQL Query from SQVI Tcode? in Application Development and Automation Discussions

How to transport SQL Query from SQVI Tcode?

Former Member — Mon, 15 Oct 2007 08:47:03 GMT

Dear Friends,

Can any one tell me how to transport SQL Query from <b>SQVI</b> Tcode.

Full Points will be rewarded.

Thanks & Reagrds

Ravi

Re: How to transport SQL Query from SQVI Tcode?

Former Member — Mon, 15 Oct 2007 08:49:34 GMT

Use Program RSAQR3TR

Regards,

Atish

Re: How to transport SQL Query from SQVI Tcode?

Former Member — Mon, 15 Oct 2007 09:24:35 GMT

Dear Atish Sarda,

Thanks for you valuable answer. I gave points.

I tried the program by giving the SQL query name, It is showing "No objects selected".

Can you help me why no objects are selected.

Regards

Ravi

Re: How to transport SQL Query from SQVI Tcode?

Former Member — Mon, 15 Oct 2007 09:39:56 GMT

Hi,

Are you in the right client?

Also check which rado button you selected.

Regards,

Atish

Re: How to transport SQL Query from SQVI Tcode?

Former Member — Mon, 15 Oct 2007 09:40:56 GMT

go to sqvi tool .....

select u r query name ......in the menubar ....quickview....> additianal functions.......>generate program

after doing generate program ....go to again same menu path as i have mentioned above [quickview....> additianal functions.......>display report name it will give the report name of the select query ..........copy the report name and give it abap editor[se38] u will get u r query program......with all authority checks.....

in start of selection event of u r program u will find u r select query.

reward points if helpful

Re: How to transport SQL Query from SQVI Tcode?

Former Member — Thu, 30 Oct 2014 03:03:10 GMT

Hi Ravi ,

Please follow below mentioned path to find the SQL statement corresponding to a SQVI query :-

Transaction SQVI -> Select the SQVI Query -> Quick View (Top left) -> Additional Functions -> Display report Name .

This will give you report name corresponding to SQVI Query. Then goto SE38 give the report name and press F7 .

Usually the first FM call in "start-of-selection" will have the desired SQL statement, so double click on the FM and search for SQL statement .

Thanks

Prateek