topic SAP SQL Query Generator in Application Development and Automation Discussions

SAP SQL Query Generator

Former Member — Tue, 26 Feb 2008 06:10:51 GMT

Hi Gali and Experts!!

I am working on ECC 6.0 and have worked on 4.X version too. I was wondering if within SAP do we have any SQL Generator which will automatically generate the SQL query? We create views, we do lot of joins on the tables and we write n number of sql queries, so is there a provision that whenever we generate a view or any other data object we can have access to the underlying SQL query that is being generated at backend. Of course, it must be generating the SQL query behind the scenes....This can be done in Peoplesoft. Please let me know.

Thanks,

~Sid

Re: SAP SQL Query Generator

Former Member — Wed, 27 Feb 2008 11:13:33 GMT

Check some thing like ABAP Query.

but you will not be able to access the actual query beneath.

Re: SAP SQL Query Generator

Former Member — Wed, 27 Feb 2008 12:34:48 GMT

Thanks ! That was helpful!!

Re: SAP SQL Query Generator

Former Member — Wed, 27 Feb 2008 12:39:15 GMT

Sq02 and SQ01 and SQVi also where you can create query

regards

Shiva

Re: SAP SQL Query Generator

Former Member — Thu, 28 Feb 2008 09:48:31 GMT

well..what about table joins....in query viewer....anyways thanks for the input...

~Sid