Show TOC

Trace Parameters in Database Accesses ViewLocate this document in the navigation structure

Here is some information on the trace parameters that are displayed in the Database Accesses tool:

Field Description
Table Name Name of database table, database view, or generated view that is used when the ABAP program in question is run. In addition, you will also find the corresponding entries for DB accesses from ABAP kernel and system events.

SQL Statement Kind of SQL statement from which the database access results.

Access Type Specifies whether access to the database table takes place using the Open SQL or the Native SQL database interface.

Executions Total number of executions of the SQL statement.

Buffered Accesses Total number of buffered accesses. Since non-buffered accesses to buffered tables and views may occur, this number is always <= the number of Executions.
Positions Number of source code positions where the related SQL statement is used to access the corresponding table (view).

Total Time [μs] Total time spent for all executions of the SQL statement in microseconds.

% Total Time Total time of this trace event as a percentage of the total time of the trace file.
Buffer Settings These settings specify whether or not and how the relevant table is buffered - corresponding to the technical settings of the table. If the table is buffered, the type of buffering is specified by one of the following options:
  • Entirely buffered - All records of the table are loaded into the buffer when one record of the table is accessed.
  • Single entries buffered - Only the records of a table that are really accessed are loaded into the buffer.
  • Generically buffered - When a record of the table is accessed, all the records that have the same generic key as this record are loaded into the buffer.
Table Type Specifies whether the table entry is a transparent table, a (standard) view, or a generated view in the ABAP Dictionary.

Short Text Short text that has been entered for the table (view) and is displayed in the Default Language of the ABAP project.

Package ABAP package to which the Dictionary table (view) belongs.