topic Re: SQVI Query -> Check the SQL statement? in Application Development and Automation Discussions

SQVI Query -> Check the SQL statement?

Former Member — Fri, 22 Jan 2010 02:35:53 GMT

Hi all,

Does anyone know where / how can I check the source code or SQL SELECT statement of an SQVI query?

Thanks in advance.

sbmel

Re: SQVI Query -> Check the SQL statement?

jmanchester — Fri, 31 Jan 2014 21:17:31 GMT

Did you ever find an answer to this question?

I have the same question myself. In fact, I would like to have the functionality to both check and modify the SQL statement.

Jeremiah

Re: SQVI Query -> Check the SQL statement?

Former Member — Thu, 30 Oct 2014 03:00:45 GMT

Hi Chee/Jeremiah ,

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

Re: SQVI Query -> Check the SQL statement?

former_member187748 — Thu, 30 Oct 2014 03:07:15 GMT

Hi Prateek,

please don't reply to older posts, the person who have posted this question is not still waiting for your replies.

Re: SQVI Query -> Check the SQL statement?

Former Member — Sat, 01 Nov 2014 16:46:59 GMT

Original person might not be waiting for my reply, but this may be helpful for new comers who may still have this query .... anyways nobody answered this & there is no space problem in SCN

Re: SQVI Query -> Check the SQL statement?

jmanchester — Sun, 02 Nov 2014 01:29:02 GMT

Thanks much for the info, Prateek!

Jeremiah

Re: SQVI Query -> Check the SQL statement?

former_member203650 — Thu, 10 Dec 2015 19:59:12 GMT

There is no "statute of limitations" on giving a correct answer to a previously-unanswered question.