This SAP run-time analysis tools (Transaction code SE30) allows the ABAP/4 programmer to trace the tables used by the SAP dialog/reports programs. In the Analyze button, you can see four more buttons like:-
Hit List
- Displays the execution time of each statement in the program.
Tables
- Displays the tables accessed during run time.
Group hit list
- Displays the execution time of all the statements and grouping them based on the type of command. e.g. performs, SQL and internal tables used.
Hierarchy
- Displays the execution time of each statement in the actual order in which were executed. Uses indentation to indicate the level of nesting of statements within subroutines.
Any tables use by the transaction or program can be easily trace with the runtime analysis tools.
Go to transaction SE30
Type in the transaction code you want to analyze
4.6x
- In the Restriction section: select the TMP -> Temporary variant
- lick the Change button
- Click the Duratn/type
- Select None for Aggregation
- Save the variant and execute again
- After finishing the process, click back to SE30
- Use F3 to move back to the initial screen of SE30
- Click the Analyze Button
- Click Goto -> Object-centered hit list -> Database tables
3.0x
- Click Execute
- After finishing the process, click back to SE30
- Click the Analyze Button
- Click the Table Button
After retrieving the table names, you can check the raw data with transaction SE16 – Data Browser or SE11 – Dictionary.
For example, if you want to display the data for MSEG – Material Document table
- Transaction SE16
- Type in MSEG for Table name and click execute.
- Data Browser will display the default selection for you to display data. If you did not change the default and click execute the data browser will display the first 500 records.
- Click Settings to change the List formats, User parameters and Fields for selection.
- In 4.6x, you can use SE16N.
- Transaction SE11 or SE12 (4.6x)
- Type in MSEG for Object name and click the Display button.
- Click Utilities -> Table contents for the default selection screen. If you did not change the default and click execute, the Dictionary will display the first 500 record.
- Click Settings to change the List formats, User parameters and Fields for selection.
- Transaction SE17
- Type in the Table Name, put in the Selection value, put a ‘X’ in the Output column to display the data field and put in the Sort number from 01..99 (if you want to sort).