1. Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
  2. Suggest New Category

What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?

Question Posted / sumeet patil

Answer Posted / sumeet patil

Performing an SQL Trace:

Access transaction ST05. From the initial screen, click the check box for SQL trace, under the trace requests, click Trace on.

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

Come back to ST05 screen, under Trace requests, click Trace off.

Click List trace to view the trace of the current statement.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of secondary indexes?

552

What are the difference between pool tables and transparent tables?

629

what are the main technical differences between oracle and sap? it would be more helpful to me if get this answer...

1534

When a function module is activated syntax checking is performed automatically. State yes or no. : abap modularization

613

Can you print decimals in type n?

565




– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required:  Sales Org  Delivery type  Sales document type Optional:  Planned Goods movement date  Option to choose E-Mail  E-mail Address  Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields,  Success/Error (S/E)  Sales Document number  Delivery number  New Debit memo request number  Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS

5526

What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?

1167

Did you create primary index?

546

What is get cursor field?

881

What does the extract statement do in extract datasets? : abap modularization

561

What is the BAPI_CUSTMATINFO_GETDETAILM used for? what is the input and output of this bapi.

2858

Select query optimisation

898

What is tcode se16?

601

Workbench request are client dependent or client independent

557

How we can give authorization on the fields of table control in a dialog-programming?

1847