SAP ABAP Table SQLTBASLST (Fields for Performance Trace Lists (Trace and Detailed List))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-PA (Application Component) Performance Analysis (Transaction ST05)
     ⤷ SQLT (Package) Trace for SQL, Enqueue, RFC, Memory

Basic Data

Table Category	INTTAB	Structure
Structure	SQLTBASLST	Table Relationship Diagram
Short Description	Fields for Performance Trace Lists (Trace and Detailed List)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TITLE	☐	SQLTTITLE	CHAR60	CHAR	60	0	Titel of SQL trace list
2	DATE_L	☐	SQLTDATE	SYDATS	DATS	8	0	Date specification for SQL trace
3	TIME	☐	SQLTTIMECH	CHAR12	CHAR	12	0	Execution time for SQL trace
4	DURATION	☐	SQLTDURA	CHAR9	CHAR	9	0	Execution time of an SQL statement
5	PROGRAM_L	☐	SQLTPROG	CHAR40	CHAR	40	0	Name of program that triggered SQL statement
6	TABLE_L	☐	SQLTTABLE	SQLTAS4TAB	CHAR	30	0	Object used in trace statement
7	OPERATION	☐	SQLTOPER	CHAR7	CHAR	7	0	Executed Operation
8	CURS	☐	SQLTCURS	CHAR4	CHAR	4	0	Cursor Number for the Logged SQL Statement
9	ARRAYSIZE	☐	SQLTASIZE	INT4	INT4	10	0	Array
10	RECORDS	☐	SQLTREC	INT4	INT4	10	0	Number of records
11	RETCODE	☐	SQLTRC	INT4	INT4	10	0	Return Code for Logged SQL Statement
12	CON_NAME	☐	SQLTCON_N	CHAR5	CHAR	5	0	Logical database connection name -> DBCON-CON_NAME
13	WPN	☐	SQLTWPN	CHAR2	CHAR	2	0	Number of Work Process in Trace List
14	STATEMENT	☐	SQLTSTAT		CHAR	210	0	SQL statement (formatted)
15	DBREQUEST	☐	SQLTDBREQ	CHAR60	CHAR	60	0	Log record for SQL trace
16	REPORT	☐	SQLTTCODE	TCODE	CHAR	20	0	Transaction Code for Performance Trace Analysis	*
17	PID	☐	SQLTPID	CHAR2	CHAR	2	0	Work Process Number for Performance Trace Analysis
18	PTYPE	☐	SQLTPTYPE	WPTYP	CHAR	3	0	Work Process Type for Performance Trace Analysis
19	CLIENT	☐	SQLTCLIEN	MANDT	CLNT	3	0	Client in which performance trace is evaluated	*
20	USER_L	☐	SQLTUSER	AS4USER	CHAR	12	0	User name for performance trace evaluation
21	TRANS_ID	☐	SQLTTRANID	CHAR32	CHAR	32	0	Transaction GUID
22	VARNAME	☐	SQLTVNAME	CHAR15	CHAR	15	0	Name of variable used in SQL trace record
23	VALUE	☐	SQLTVALUE	CHAR256	CHAR	256	0	Value of variable used in SQL trace record
24	REPORT_TXT	☐	SQLTREPTXT	FDNAME	CHAR	30	0	Description of Report in the Performance Trace Header	*
25	PID_TXT	☐	SQLTPIDTXT	FDNAME	CHAR	30	0	Description of Process ID for Performance Trace Header	*
26	PTYPE_TXT	☐	SQLTPTYTXT	FDNAME	CHAR	30	0	Description of Process Type for Performance Trace Header	*
27	CLIENT_TXT	☐	SQLTCLITXT	FDNAME	CHAR	30	0	Description of Client for Performance Trace Header	*
28	USER_L_TXT	☐	SQLTUSLTXT	FDNAME	CHAR	30	0	Description of User for Performance Trace Header	*
29	TRA_ID_TXT	☐	SQLTRIDTXT	FDNAME	CHAR	30	0	Name of the Trans ID for Performance Trace Header	*

History

Last changed by/on	SAP	20130604
SAP Release Created in