Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to find execution time for select statement in a report

0 Kudos
809

Hi,

  i am using below selection statement in my report and i am trying see the execution time only for the select query in se30 how is it possible any one pls post the right solution.

select ebeln

          ebelp

          ardet

          netpr

          menge

          matnr from ekpo into table it_ekpo where ebeln = ekpo~ebeln.

regards

venkata subbareddy

8 REPLIES 8

rajeshkothamasu
Active Participant
0 Kudos
180

Hi,

follow the below procedure

Step 1: Access transaction ST05. From the initial screen, click the check box for SQL trace, under the trace

requests, click Trace on.

Step 2: Run the program containing the SQL query that needs to be analyzed in the SE38 editor.

Step 3: Come back to ST05 screen, underTrace requests, click Trace off.

Step 4: Click List trace to view the trace of the current statement.

hope this will help you

0 Kudos
180

hi rajesh

  

      your answer is good its finding execution exactly thanks for your answer rajesh.

0 Kudos
180

Hi,

if you find an solution for the post. Close the discussion.

former_member183607
Contributor
0 Kudos
180

Hi,

     If you want only execution time then use t-code ST05 - Sql Trace.

Former Member
0 Kudos
180

use st05.

Activate the trace.

Run your program.

deactivate the trace.

Then select display trace.

enter object name as ekpo. execute.

In the menu trace list ->summerize trace list by sql statements.

Here ull see a summerised list.

0 Kudos
180

Hi,

your answer is good its finding execution exactly thanks for your answer rajesh

0 Kudos
180

Hi,

 

   Its god thanks for ur answer.

Thanks 

venkata subbareddy

0 Kudos
180

hi,

your answer is good its finding execution exactly thanks for your answer rajesh