SAP ABAP Table SACCTRACE (Formatted Data for Each Trace Record)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-PA (Application Component) Performance Analysis (Transaction ST05)
     ⤷ SQLTACC (Package) Accessible Performance Trace

Basic Data

Table Category	INTTAB	Structure
Structure	SACCTRACE	Table Relationship Diagram
Short Description	Formatted Data for Each Trace Record

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	.INCLUDE	☐				0	0	Extended Field Catalog for Accessible Trace List
2	TRANS_ID	☐	SQLTTRANID	CHAR32	CHAR	32	0	Transaction GUID
3	TCODE	☐	SQLTTCODE	TCODE	CHAR	20	0	Transaction Code for Performance Trace Analysis	*
4	PID	☐	SQLTPID	CHAR2	CHAR	2	0	Work Process Number for Performance Trace Analysis
5	PTYPE	☐	SQLTPTYPE	WPTYP	CHAR	3	0	Work Process Type for Performance Trace Analysis
6	CLIENT	☐	SQLTCLIEN	MANDT	CLNT	3	0	Client in which performance trace is evaluated	*
7	USER_L	☐	SQLTUSER	AS4USER	CHAR	12	0	User name for performance trace evaluation
8	DATE	☐	SACCDATE	SYDATS	DATS	8	0	Recording Date of Trace Record
9	TIME	☐	SQLTTIMECH	CHAR12	CHAR	12	0	Execution time for SQL trace
10	DURATION	☐	SACCDURA	SACCDURAD	DEC	16	0	Execution Time of an SQL Statement
11	MODULE	☐	SQLTPROG	CHAR40	CHAR	40	0	Name of program that triggered SQL statement
12	TABNAME	☐	SQLTTABLE	SQLTAS4TAB	CHAR	30	0	Object used in trace statement
13	OPERATION	☐	SQLTOPER	CHAR7	CHAR	7	0	Executed Operation
14	CURS	☐	SQLTCURS	CHAR4	CHAR	4	0	Cursor Number for the Logged SQL Statement
15	ARRAYSIZE	☐	SQLTASIZE	INT4	INT4	10	0	Array
16	NO_OF_ROWS	☐	SQLTREC	INT4	INT4	10	0	Number of records
17	SQL_RC	☐	SQLTRC	INT4	INT4	10	0	Return Code for Logged SQL Statement
18	CON_NAME	☐	SQLTCON_N	CHAR5	CHAR	5	0	Logical database connection name -> DBCON-CON_NAME
19	CON_ID	☐	SACCCONID	CHAR9	CHAR	9	0	Database Connection ID
20	STATSTRWVAR	☐	SACCSTATWVAR	SACCSTRING	STRG	0	0	Statement String with Replaced Placeholders
21	TRACE_TYPE	☐	SACCTRACETYPE	SACCTRACETYPED	CHAR	1	0	Trace Record Type
22	TRECNUMBER	☐	SACCTRECNUMBER		INT4	10	0	Trace Record Number
23	EPP_ROOT_ID	☐	SACC_EPP_ROOT_ID		CHAR	32	0	EPP Root ID
24	EPP_CONNECTION_ID	☐	SACC_EPP_CONN_ID		CHAR	32	0	EPP Connection ID
25	EPP_CONNECTION_COUNTER	☐	SACC_EPP_CONN_CNT		INT4	10	0	EPP Connection Counter
26	STATSTR	☐	SACCSTAT	SACCSTRING	STRG	0	0	Statement String with Placeholders
27	VARSTR	☐	SACCVAR	SACCSTRING	STRG	0	0	Variable String from the Trace Record
28	OFFSTID	☐	SACCOFFSTID		INT4	10	0	Offset of Statement IDs in Trace Record
29	LSTATSTR	☐	SACCLSTATSTR	SACCLSTATSTRD	INT4	10	0	Length of the Statement String with Placeholders
30	NVAR	☐	SACCLVARSTR	SACCLVARSTRD	INT4	10	0	Number of Variables in Variable String
31	PSEC	☐	STA_TIMERE	STAT_TIMI0	INT4	10	0	Time value in raw statistics record
32	LINKNUMBER	☐	SACCLINKNUMBER		INT4	10	0	Link Number for Detail Records
33	LINE_COLOR	☐	SACCCOLOR	CHAR4	CHAR	4	0	Grid ALV Line Color
34	COLOR_DEF	☐	SACCCOLOR	CHAR4	CHAR	4	0	Grid ALV Line Color

History

Last changed by/on	SAP	20130604
SAP Release Created in	700