SAP ABAP Table SQLRSTA2 (Display Structure for SQL Trace Interpreter)

Hierarchy

☛

SAP_BASIS (Software Component) SAP Basis Component
⤷

BC-CCM-MON (Application Component) Monitoring
⤷

SQLRM (Package) SQL Trace RFC Download

Basic Data

Table Category	INTTAB	Structure
Structure	SQLRSTA2	Table Relationship Diagram
Short Description	Display Structure for SQL Trace Interpreter

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Statistics: Display single record information
2	DATE	STA_DATE_C	STAT_DATEC	DATS	8	0	Date
3	RESPTI	STA_RESPTI	STAT_TIMI0	INT4	10	0	Statistics, Response time for one dialog step
4	DBCALLS	STA_DBCALI	STAT_TIMI0	INT4	10	0	Number of data base requests
5	ENDTI	STA_ENDTIM	UZEIT	TIMS	6	0	Ending time of dialog step
6	CPUTI	STA_CPUTII	SAPWLCTLNG	DEC	15	0	CPU time consumption of dialog step
7	QUEUETI	STA_QUETII	STAT_TIMI0	INT4	10	0	Dispatcher waiting time of dialog step
8	V1SATI	STA_V1STII	STAT_TIMI0	INT4	10	0	Dialog step key for update task
9	WPID	STA_WPID	STAT_HEX_2	RAW	2	0	Number of work process for a dialog step
10	TASKTYPE	STA_TTYPEX	STAT_HEX_1	RAW	1	0	Task type number
11	TABLOAD	STA_TABLD	STAT_HEX_1	RAW	1	0	Table load
12	TCODE	STA_TCODE4	TCODE	CHAR	20	0	Transaction code	*
13	TERMINALID	STA_TERML	STAT_TERML	CHAR	20	0	Terminal ID
14	DYNPRONR	STA_DYNPNO	STAT_DYNPR	CHAR	4	0	Screen number or transaction name
15	REPORT	STA_TCODE	STAT_TCODE	CHAR	40	0	Name of transaction or programm which calls a dialog
16	ACCOUNT	STA_USER	STAT_USER	CHAR	12	0	User or account name using a transaction
17	MANDT	STA_MANDT	STAT_MANDT	CHAR	3	0	Client number
18	ROLLKEY	STA_ROLLKY	STAT_RLKEY	CHAR	8	0	SAP rolling memory address
19	INPUTLEN	STA_TERMSZ	STAT_RLSIZ	INT4	10	0	Size of terminal in/out message
20	OUTPUTLEN	STA_TERMSZ	STAT_RLSIZ	INT4	10	0	Size of terminal in/out message
21	MAXROLL	STA_ROLLSZ	STAT_RLSIZ	INT4	10	0	Size of SAP roll in/out data
22	MAXPAGE	STA_PAGESZ	STAT_RLSIZ	INT4	10	0	New Allocated SAP Paging Memory (KB)
23	ROLLINCNT	STA_RLCNTI	STAT_TIMI0	INT4	10	0	Time for SAP rolling procedure
24	ROLLINTI	STA_RLTIMI	STAT_TIMI0	INT4	10	0	Time for SAP rolling procedure
25	ROLLOUTCNT	STA_RLCNTI	STAT_TIMI0	INT4	10	0	Time for SAP rolling procedure
26	ROLLOUTTI	STA_RLTIMI	STAT_TIMI0	INT4	10	0	Time for SAP rolling procedure
27	ROLLED_OUT	STA_RLOUTT	SAPWLUDC10	DEC	10	0	Time roll context was rolled out
28	LOCKCNT	STA_LKCNTI	STAT_CNTI0	INT4	10	0	Number of semaphore locks during a dialog step
29	LOCKTI	STA_LKTIMI	STAT_TIMI0	INT4	10	0	Time for semaphore locks during dialog step
30	TABNAME1	STA_TABNA	AS4TAB	CHAR	30	0	Name of table accessed	*
31	TAB1DIRCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
32	TAB1SEQCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
33	TAB1UPDCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
34	TABNAME2	STA_TABNA	AS4TAB	CHAR	30	0	Name of table accessed	*
35	TAB2DIRCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
36	TAB2SEQCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
37	TAB2UPDCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
38	TABNAME3	STA_TABNA	AS4TAB	CHAR	30	0	Name of table accessed	*
39	TAB3DIRCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
40	TAB3SEQCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
41	TAB3UPDCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
42	TABNAME4	STA_TABNA	AS4TAB	CHAR	30	0	Name of table accessed	*
43	TAB4DIRCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
44	TAB4SEQCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
45	TAB4UPDCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
46	TABNAME5	STA_TABNA	AS4TAB	CHAR	30	0	Name of table accessed	*
47	TAB5DIRCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
48	TAB5SEQCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
49	TAB5UPDCNT	STA_TBCNTI	STAT_CNTI0	INT4	10	0	Number of table requests
50	READDIRCNT	STA_DRCNTI	STAT_CNTI0	INT4	10	0	Number of direct read accesses on tables
51	READDIRTI	STA_DRTIMI	STAT_TIMI0	INT4	10	0	Time for direct read requests
52	READDIRREC	STA_DRRECI	STAT_CNTI0	INT4	10	0	Number of directly requested records
53	READDIRBUF	STA_DRBUFI	STAT_CNTI0	INT4	10	0	Number of direct buffer reads
54	READSEQCNT	STA_SQCNTI	STAT_CNTI0	INT4	10	0	Number of sequential read requests to tables
55	READSEQTI	STA_SQTIMI	SAPWLCTLNG	DEC	15	0	Time for sequential read requests
56	READSEQREC	STA_SQRECI	STAT_CNTI0	INT4	10	0	Number of sequentially requested records
57	READSEQBUF	STA_SQBUFI	STAT_CNTI0	INT4	10	0	Sequential buffer reads
58	PHYREADCNT	STA_PRCNTI	STAT_CNTI0	INT4	10	0	Number of data base reads
59	INSCNT	STA_INCNTI	STAT_CNTI0	INT4	10	0	Number of insert requests
60	INSTI	STA_INTIMI	STAT_TIMI0	INT4	10	0	Time used for insert requests
61	INSREC	STA_INRECI	STAT_CNTI0	INT4	10	0	Number of records inserted
62	PHYINSCNT	STA_PICNTI	STAT_CNTI0	INT4	10	0	Number of data base insert operations
63	UPDCNT	STA_UPCNTI	STAT_CNTI0	INT4	10	0	Number of updates requested
64	UPDTI	STA_UPTIMI	STAT_TIMI0	INT4	10	0	Time for update requests
65	UPDREC	STA_UPRECI	STAT_CNTI0	INT4	10	0	Number of records requested for update
66	PHYUPDCNT	STA_PUCNTI	STAT_CNTI0	INT4	10	0	Number of database update operations
67	DELCNT	STA_DECNTI	STAT_CNTI0	INT4	10	0	Number of delete requests
68	DELTI	STA_DETIMI	STAT_TIMI0	INT4	10	0	Time for delete requests
69	DELREC	STA_DERECI	STAT_CNTI0	INT4	10	0	Number of records for delete requests
70	PHYDELCNT	STA_PDCNTI	STAT_CNTI0	INT4	10	0	Number of database delete operations
71	COMMITTI	STA_COTIMI	STAT_TIMI0	INT4	10	0	Time for COMMIT WORK
72	GENERATETI	STA_GETIMI	STAT_TIMI0	INT4	10	0	Generating time
73	REPLOADTI	STA_ALTIMI	STAT_TIMI0	INT4	10	0	Report loading time
74	CUALOADTI	STA_CLTIMI	STAT_TIMI0	INT4	10	0	Time for loading CUA objects
75	DYNPLOADTI	STA_DLTIMI	STAT_TIMI0	INT4	10	0	Time for loading screen objects
76	DSQLCNT	STA_BYTESI	STAT_CNTI0	INT4	10	0	Bytes transferred to work process
77	QUECNT	STA_BYTESI	STAT_CNTI0	INT4	10	0	Bytes transferred to work process
78	QUETI	STA_QETIMI	STAT_TIMI0	INT4	10	0	Batch input queue time
79	DDICTI	STA_DDTIMI	STAT_TIMI0	INT4	10	0	Time spent in DDIC interface
80	CPICCNT	STA_CPCNTI	STAT_CNTI0	INT4	10	0	Bytes transferred via CPIC interface
81	CPICTI	STA_CPTIMI	STAT_TIMI0	INT4	10	0	Time spent in RFC and CPIC interface
82	TABLEPOINT	STA_COUNTI	STAT_CNTI0	INT4	10	0	Counter
83	BTCJOBNAME	SAPWLJOBL	CHAR32	CHAR	32	0	SAP Workload: Workload: Job name (long)
84	BTCSTEPNR	STA_STEPNR	CHAR3	CHAR	3	0	Number of step in background processing
85	SYPFKEY	SYPFKEY	GUI_STATUS	CHAR	20	0	GUI Status
86	SYUCOMM	SYUCOMM	SYCHAR70	CHAR	70	0	Function Code
87	TASK	STA_TASK	STAT_TASK1	CHAR	1	0	Task type
88	WP	STA_WP	STAT_CNTI0	INT4	10	0	Work process number
89	CLOCK	STA_TIME	UZEIT	TIMS	6	0	Time
90	DATUM	STA_DATE	DATUM	DATS	8	0	Date of statistics record
91	RSYSTEM	STUNHOST	TEXT32	CHAR	32	0	Host Name
92	MAINMODE	STA_MODE	STAT_CNTI0	INT4	10	0	Mode number of main or sub mode
93	SUBMODE	STA_MODE	STAT_CNTI0	INT4	10	0	Mode number of main or sub mode
94	DISPTI	STA_DISPTI	STAT_TIMP0	DEC	15	0	Time dispatched by the disp+work process
95	READTI	STA_READTI	STAT_TIMP0	DEC	15	0	Read request time
96	CHNGTI	STA_CHNGTI	STAT_TIMP0	DEC	15	0	Time for requested changes
97	DBCALLTI	STA_CALLTI	STAT_TIMP0	DEC	15	0	Time for data base requests
98	ROLLTI	STA_ROLLT2	STAT_TIMP0	DEC	15	0	Time for roll-ins/roll-outs
99	PROCTI	STA_PROCTI	STAT_TIMP0	DEC	15	0	Time processing ABAP/4 statements
100	LOADTI	STA_LOADTI	STAT_TIMP0	DEC	15	0	Loading and generating time
101	SORTNAME	STA_SORTNA	STAT_CHR16	CHAR	16	0	Criterion for sorting the current list
102	CHNGCNT	STA_CHGCNT	STAT_CNTP0	DEC	15	0	Number of changes requested
103	READCNT	STA_REDCNT	STAT_CNTP0	DEC	15	0	Number of reads requested
104	PHYCHNGCNT	STA_PCHCNT	STAT_CNTP0	DEC	15	0	Number of data base changes made
105	PHYREADDIR	STA_PRDCNT	STAT_CNTP0	DEC	15	0	Number of direct read calls to data base
106	PHYCALLS	STA_PHYCNT	STAT_CNTP0	DEC	15	0	Number of total calls made to data base
107	BUFCALLS	STA_BUFCNT	STAT_CNTP0	DEC	15	0	Number of buffer requests
108	RECCNT	STA_RECCNT	STAT_CNTP0	DEC	15	0	Number of records requested
109	AVTDB	STA_AVDBTI	STAT_TIMP1	DEC	15	1	Average time for one DB request
110	AVTREADDIR	STA_AVRDTI	STAT_TIMP1	DEC	15	1	Average time for one direct read request
111	AVTREADSEQ	STA_AVRSTI	STAT_TIMP1	DEC	15	1	Average time for sequential read request
112	AVTUPD	STA_AVUPTI	STAT_TIMP1	DEC	15	1	Average time for one update request
113	AVTINS	STA_AVINTI	STAT_CNTP1	DEC	15	1	Average time for one insert request
114	AVTDEL	STA_AVDETI	STAT_CNTP1	DEC	15	1	Average delete request time
115	BYTES	STA_BYTESP	STAT_CNTP0	DEC	15	0	Bytes requested
116	AVBYTES	STA_AVBYTE	STAT_CNTP1	DEC	15	1	Average transferred bytes (per dialog step)
117	UPDKEY	STA_UPDKEY	CHAR8	CHAR	8	0	Statistical record: Update key
118	MEMSUM	STA_USDBYT		INT4	10	0	Used bytes EM/imode
119	PRIVSUM	STA_PRIVSM		INT4	10	0	Memory used in PRIV mode
120	USEDBYTES	STA_USDBYT		INT4	10	0	Used bytes EM/imode
121	MAXBYTES	STA_MAXBYT		INT4	10	0	Max. bytes (long)
122	MAXBYTESDI	STA_MAXBDI		INT4	10	0	Max. bytes (short) dialog
123	PRIVMODE	STA_PRIVMD	SAPWLRAW1	RAW	1	0	Request in PRIV mode?
124	RESTART	STA_RESTRT	SAPWLRAW1	RAW	1	0	Workprocess restarted?
125	MAXMEM	STA_MEMSUM		INT4	10	0	Total used memory
126	INSTANCE	STUNINST	TEXT39	CHAR	39	0	SAPWL: Workload: Instance Name
127	TRANSID	SAPWLTRID	CHAR32	CHAR	32	0	SAP Workload: Workload: Transaction ID
128	STEPS	STA_STEPS	STAT_CNTP0	DEC	15	0	SAP Workload: Workload: Number of dialog steps
129	BTAORJOB	STA_TATYPE	TEXT3	CHAR	3	0	SAP Workload: Workload: Transaction type job or business
130	ACTION	STA_TANAME	PROGRAMM	CHAR	40	0	SAP Workload: Workload: Tcode & job name or jobstep & report	*
131	PRIVMODCNT	STA_PRIVCT	DEC15	DEC	15	0	SAP Workload: Workload: Private mode counter
132	RESTARTCNT	STA_GUICNT	DEC15	DEC	15	0	SAP Workload: Number of Comm. Steps. Betw. Frontend & Server
133	TIMEINWP	STA_WPTIME	STAT_TIMI0	INT4	10	0	SAP Workload: Workload: Time in work process
134	GUITIME	STA_GUITI	DEC15	DEC	15	0	SAP Workload: Workload: Time spent in GUI & net
135	GUICNT	STA_GUICNT	DEC15	DEC	15	0	SAP Workload: Number of Comm. Steps. Betw. Frontend & Server
136	GUINETTIME	STA_GUINTT	DEC15	DEC	15	0	SAP Workload: Network Time Between GUI and SAP Server
137	DBPROCTI	STA_DBPTI	DEC15	DEC	15	0	SAP Workload: Workload: Time spent for DB-procedures
138	DBPROCCNT	STA_DBPCNT	DEC15	DEC	15	0	SAP Workload: Workload: No. of called DB-procedures
139	SLI_CNT	SWLSLI	DEC15	DEC	15	0	SAP Workload: Source. Load & Interface Data (Bytes)
140	LOADGENTI	STA_LOADTI	STAT_TIMP0	DEC	15	0	Loading and generating time
141	SQLRSTATID	SQLRSTATID	CHAR3	CHAR	3	0	SQLR: Identifier for Statistical Record
142	STARTSTAMP	STARTSTAMP	CHAR12	CHAR	12	0	Start of Statistics Record
143	ENDSTAMP	STARTSTAMP	CHAR12	CHAR	12	0	Start of Statistics Record