What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?
Answers were Sorted based on User's Feedback
Answer / renuka
SQT Trace is used to analize the performance of select
queries.Transaction code is ST05.
STEPS:
go to ST05
selet Active mode
select Trace on
select application provide the transaction code in command
line like xk01,xd01 like that
now enter the data in application
again go for ST05
select Inacivemode
Trace off
List Trace
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
1.search help is there for table or structure or both? 2.in structure there is no technical attribute, then how will u call data elements/fields into the structure? 3. i want to add/write some code in sap standard program in function module related in badi,then how will u write your code in sap standard Fm in badi? 4.what is kapler badi? 5.what is the use of log text in table technical attributes while creating table? 6.what are the fields i have to take to releae/creat a PO from Pur req? 7. if i have already release po as per the Pur req and vendor supplied the material,then again i want same 100 material,then wt will u do? are u release po again? what are steps u follow for this situation?
Events in Reports?
in lsmw,where u write the code?
6 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
10) How to get Item Header in Sales Order?
How to do sorting in classical report?
In events, start-of-selection is a default event. When we have to use this event explicitly? Why?
What are system fields for secondary lists?
How to Delete an LSMW Projcet, Subproject and Object.
What are the different elements in layout sets?
what is the AT-SELECTION EVENT?
Can I craete a Field without a Data Element ? How
How to create any functions?