topic Re: Function of DynPro Trace & SQL Trace in Application Development and Automation Discussions

Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:44:35 GMT

Hi,

Could any body let me know the function of

Dynpro trace -ST20.

SQL trace - ST22.

Thanks & Regards,

Irfan Hussain

Re: Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:50:16 GMT

st22 will display the dumps(errors which encountered for a period for a user)

st20 screen trace for a transaction what are the fields used and etc..

st05 is the SQL list trace,it will give info of what are the tables used and what tables getting selected and updated ..

Re: Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:51:25 GMT

you can trace using st20 for report/transaction screens.

vijay

Re: Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:53:12 GMT

for better understanding of st20 see the application help...

 Analyzing screen trace files                                                                                
The report RS_DYNPRO_TRACE (transaction ST20) is a graphical navigation        
  tool for analyzing screen trace files. You can load the trace files            
  directly from the application server or from the local presentation            
  server.                                                                                
For actual navigation, a tree containing the important points of the           
  trace files is displayed. Double-clicking a tree node allows you to go         
  to the corresponding line in the trace file. You can also synchronize          
  the tree with the trace file. Double-clicking a line in the trace file         
  selects the closest node in the navigation tree.                                                                                
The number of important points displayed in the navigation tree is set         
  on the initial screen of the report. This allows you to tailor the tree        
  for problem analysis.                                                                                
The tree also includes some icons that have no related text. These are         
  as follows:                                                                                
o    Activate screen processor                                                                                
o    @8I@ Process screen in background.                                                                                
o    Screen resizing                                                                                
o    Screen compression                                                                                
o    Subscreen hierarchy

Re: Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:55:24 GMT

Hi Irfan,

Functions of SQL trace

The SQL Trace part of the Performance Trace tool allows you to see how the OPEN SQL statements that you use in ABAP programs are converted to standard SQL statements and the parameters with which the embedded SQL statements are passed to the database system.
From the recorded SQL trace you can deduce:

· which SQL statements your application carries out

· which values the system uses for specific database accesses and changes

· how the system translates ABAP OPEN SQL commands (such as SELECT) into standard SQL commands

· where your application positions COMMIT statements

· where your application makes repeated database accesses

· what database accesses or changes occur in the update section of your application

Functions of dynpro trace

This dynpro trace mainly depends on ur screen selection and designing issues,displays etc.

Hopw this helps u,

Regards,

Nagarajan.

Re: Function of DynPro Trace & SQL Trace

Former Member — Mon, 12 Dec 2005 05:55:52 GMT

HI irfan,

Try the following reports

ST20 RS_DYNPRO_TRACEScreen Trace

ST20LC RS_DYNPRO_TRACELayout Check

ST22 RSSHOWRABAX ABAP dump analysis

Hope u get the answer.

Also check this link..

http://help.sap.com/saphelp_nw04/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Regards,

Sakthi.

Message was edited by: sakthivel s