topic Re: How to write your own SQL statement and execute it? in Application Development and Automation Discussions

How to write your own SQL statement and execute it?

Former Member — Thu, 07 Jul 2005 04:20:24 GMT

Hi,

Is there a Transaction Code that could be used to write your own SQL query and execute. The QuickViewer is a graphical query designer and is not flexible for advance query design. You could also write your query in a ABAP program and execute it but this take time.

Pls give me various methods that are available.

Thanks

Kishan

Re: How to write your own SQL statement and execute it?

Former Member — Thu, 07 Jul 2005 04:26:58 GMT

Hi Kishan,

As far as I know, there's no transaction that would let you do it directly.

You have these two options which may be somewhat helpful -

1. ST05 - There's an option to <i>Explain one SQL Request</i>. Through this option you can find out the number of records that will be retrieved and other details. You will not get the resut, however. This transaction will help you write better SQL queries in terma of performance.

2. If you are looking for data from only a single table, you can use the SE16 transaction. You specify the table name and give the conditions.

Regards,

Anand Mandalika.

Re: How to write your own SQL statement and execute it?

andreas_mann3 — Thu, 07 Jul 2005 05:43:17 GMT

Hi Kishan,

try sq01 resp. sq02 and have a look here:

http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb4138455611d189710000e8322d00/frameset.htm

regards Andreas

Re: How to write your own SQL statement and execute it?

Former Member — Thu, 07 Jul 2005 05:53:22 GMT

Hi Kishan,

Would you execute

- a SELECT-Statement, then see the answer from andrea (SQ01 and SQ02)

- a any Statement.

Then see

- EXEC SQL

- use the class CL CL_SQL_STATEMENT. An example is the abap ADBC_DEMO.

Sven

Re: How to write your own SQL statement and execute it?

Former Member — Thu, 07 Jul 2005 06:06:44 GMT

n order to create an ABAP query , one has to do the following.

1. Create an User group.

2. Create a Functional Area

3. Assign the User group to the Functional Area

4. Create the query based on the functional area created.

You can create or execute these, using the transactions below.

SQ01 for Query

SQ02 for Functional Area.

SQ03 for User Group.

First Step is to create a dictionary structure . Include all the fields in this structure that you want to output.

Then create a report program having the following structure .

Report XXX .

TABLES tab . Declare the already created dictionary structure also here.

Parameters x . Define parameters here

Select-Options:…….

DATA :…..

DATA : BEGIN OF itab OCCURS xxx

END OF itab. Structure tab to hold the records to be evaluated.

*<Query_head> This comment must always appear after your data declarations

Code to define the table itab

Loop to retrieve each record and place it in itab.

SELECT,DO, LOOP ,….

If necessary , code to format data

*<Query_body> This comment must always be the last statement in the loop.

End of loop

ENDSELECT , ENDDO, ENDLOOP ,…

Get back to me if u need the document for doing so.

Thanks & Regards,

Judith.

Re: How to write your own SQL statement and execute it?

jayanthi_jayaraman — Thu, 07 Jul 2005 07:24:51 GMT

Hi,

Check this link.

http://www.sappoint.com/abap/ab4query.pdf

Re: How to write your own SQL statement and execute it?

soren_hansen — Wed, 10 Jun 2009 12:03:58 GMT

Use DBACOCKPIT choose Diagnostics and SQL Commands

Re: How to write your own SQL statement and execute it?

ThomasZloch — Wed, 10 Jun 2009 12:29:22 GMT

You waited five years after registration in order to post your first reply to a four year old thread?

I'm puzzled

Thomas