SAP SQL Query Generator

[Former Member]

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

[Former Member]

Check some thing like ABAP Query.

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

[Former Member]

Thanks ! That was helpful!!

[Former Member]

Hi

Sq02 and SQ01 and SQVi also where you can create query

regards

Shiva

[Former Member]

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

~Sid