SAP ABAP Table STATS_MAIN_RECORD (Main Statistics Record)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	STATS_MAIN_RECORD	Table Relationship Diagram
Short Description	Main Statistics 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	Main Statistics Record (Display Fields)
2	.INCLUDE	☐				0	0	Main Statistics Record (Key Fields)
3	DATE	☐	PTC_DATE	SYDATS	DATS	8	0	Start Date of Recorded Action
4	TIME	☐	PTC_TIME	CHAR12	CHAR	12	0	Start Time of Recorded Action (hh:mm:ss.ms)
5	INSTANCE	☐	PTC_SERVER_NAME		CHAR	40	0	Instance (= Logical SW Server) Name
6	CLIENT	☐	PTC_CLIENT	MANDT	CLNT	3	0	Client Where Recorded Action was Executed	*
7	USER_NAME	☐	PTC_USER_NAME	UNAME	CHAR	12	0	User Who Executed Recorded Action
8	TERMINAL_ID	☐	STATS_TERMINAL_ID		CHAR	20	0	Terminal ID
9	MAIN_MODE	☐	STATS_MODE_NUMBER		INT4	10	0	Mode Number (Main Mode or Sub Mode)
10	SUB_MODE	☐	STATS_MODE_NUMBER		INT4	10	0	Mode Number (Main Mode or Sub Mode)
11	TRANSACTION_ID	☐	PTC_TRANSACTION_ID		CHAR	32	0	Transaction ID
12	WP_ID	☐	PTC_WP_ID		CHAR	3	0	Work Process ID
13	TASK_TYPE	☐	STATS_TASK_TYPE	STATS_TASK_TYPE_	CHAR	1	0	Task Type
14	TRANSACTION	☐	PTC_TRANSACTION_CODE	TCODE	CHAR	20	0	Transaction Which Triggered Recorded Action	*
15	PROGRAM	☐	PTC_PROGRAM_NAME	PROGNAME	CHAR	40	0	Program Which Triggered Recorded Action
16	SCREEN_NUMBER	☐	STATS_SCREEN_NUMBER		CHAR	4	0	Screen Number
17	GUI_STATUS	☐	SYPFKEY	GUI_STATUS	CHAR	20	0	GUI Status
18	OK_CODE	☐	PTC_COMMAND		CHAR	20	0	Function Code / OK Code
19	.INCLUDE	☐				0	0	Main Statistic Record (Time Related Fields)
20	RESPONSE_TIME	☐	STATS_TIME_RESPONSE	PTC_DURATION	DEC	15	0	Server Response Time [ms]
21	WP_TIME	☐	STATS_TIME_WP	PTC_DURATION	DEC	15	0	Work Process Time [ms]
22	WAIT_TIME	☐	STATS_TIME_WAIT	PTC_DURATION	DEC	15	0	Dispatcher Wait Time [ms]
23	PROCESSING_TIME	☐	STATS_TIME_PROCESSING	PTC_DURATION	DEC	15	0	Processing Time [ms]
24	CPU_TIME	☐	STATS_TIME_CPU	PTC_DURATION	DEC	15	0	CPU Time [ms]
25	PROG_LOAD_TIME	☐	STATS_TIME_LOAD_PROG	PTC_DURATION	DEC	15	0	Load Time [ms] - Programs
26	SCR_LOAD_TIME	☐	STATS_TIME_LOAD_SCR	PTC_DURATION	DEC	15	0	Load Time [ms] - Screens
27	CUA_LOAD_TIME	☐	STATS_TIME_LOAD_CUA	PTC_DURATION	DEC	15	0	Load Time [ms] - CUA
28	LOAD_TIME	☐	STATS_TIME_LOAD	PTC_DURATION	DEC	15	0	Load Time [ms]
29	GEN_TIME	☐	STATS_TIME_GEN	PTC_DURATION	DEC	15	0	Generation Time [ms]
30	LOAD_GEN_TIME	☐	STATS_TIME_LOAD_GEN	PTC_DURATION	DEC	15	0	Load and Generation Time [ms]
31	ROLL_IN_TIME	☐	STATS_TIME_ROLL_IN	PTC_DURATION	DEC	15	0	Roll In Time [ms]
32	ROLL_OUT_TIME	☐	STATS_TIME_ROLL_OUT	PTC_DURATION	DEC	15	0	Roll Out Time [ms]
33	ROLL_WAIT_TIME	☐	STATS_TIME_ROLL_WAIT	PTC_DURATION	DEC	15	0	Roll Wait Time [ms]
34	ROLL_IN_WAIT_TIME	☐	STATS_TIME_ROLL_IN_WAIT	PTC_DURATION	DEC	15	0	Roll In and Wait Time [ms]
35	RFC_CPIC_TIME	☐	STATS_TIME_RFC_CPIC	PTC_DURATION	DEC	15	0	RFC and CPIC Time [ms]
36	GUI_TIME	☐	STATS_TIME_GUI	PTC_DURATION	DEC	15	0	GUI Time [ms]
37	FE_NET_TIME	☐	STATS_TIME_FE_NET	PTC_DURATION	DEC	15	0	Frontend Network Time [ms]
38	DDIC_INTERFACE_TIME	☐	STATS_TIME_DDIC_INTERFACE	PTC_DURATION	DEC	15	0	DDIC Interface Time [ms]
39	BTC_INP_TIME	☐	STATS_TIME_BTC_INP_QUEUE	PTC_DURATION	DEC	15	0	Batch Input Queue Time [ms]
40	.INCLUDE	☐				0	0	Main Statistics Record (DB Related Fields)
41	.INCLUDE	☐				0	0	Statistics Sub Record with DB Related Data
42	DIR_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Request Count - Direct Read Requests
43	SEQ_READ_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Request Count - Sequential Read Requests
44	INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Request Count - Insert Requests
45	UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Request Count - Update Requests
46	DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Request Count - Delete Requests
47	PHYSICAL_READ_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_READ	PTC_COUNT	DEC	12	0	DB Physical Request Count - Read Requests
48	PHYSICAL_INSERT_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Physical Request Count - Insert Requests
49	PHYSICAL_UPDATE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Update Requests
50	PHYSICAL_DELETE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Physical Request Count - Delete Requests
51	DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Row Count - Direct Read Requests
52	SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Row Count - Sequential Read Requests
53	INSERT_ROW_COUNT	☐	STATS_DB_ROW_COUNT_INSERT	PTC_COUNT	DEC	12	0	DB Row Count - Insert Requests
54	UPDATE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_UPDATE	PTC_COUNT	DEC	12	0	DB Row Count - Update Requests
55	DELETE_ROW_COUNT	☐	STATS_DB_ROW_COUNT_DELETE	PTC_COUNT	DEC	12	0	DB Row Count - Delete Requests
56	BUFFER_DIR_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_DIR_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Direct Read Requests
57	BUFFER_SEQ_READ_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_SEQ_READ	PTC_COUNT	DEC	12	0	DB Buffer Row Count - Sequential Read Requests
58	TOTAL_REQUEST_TIME	☐	STATS_DB_TIME_TOTAL	PTC_DURATION	DEC	15	0	DB Request Time [ms] - All Requests
59	DIR_READ_REQUEST_TIME	☐	STATS_DB_TIME_DIR_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Direct Read Requests
60	SEQ_READ_REQUEST_TIME	☐	STATS_DB_TIME_SEQ_READ	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Sequential Read Requests
61	INSERT_REQUEST_TIME	☐	STATS_DB_TIME_INSERT	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Insert Requests
62	UPDATE_REQUEST_TIME	☐	STATS_DB_TIME_UPDATE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Update Requests
63	DELETE_REQUEST_TIME	☐	STATS_DB_TIME_DELETE	PTC_DURATION	DEC	15	0	DB Request Time [ms] - Delete Requests
64	DB_PROCEDURE_CALL_COUNT	☐	STATS_DB_REQ_COUNT_PROC_CALL	PTC_COUNT	DEC	12	0	DB Procedure Call Count
65	DB_PROCEDURE_TIME	☐	STATS_DB_TIME_PROC_CALL	PTC_DURATION	DEC	15	0	DB Procedure Call Time [ms]
66	ENQUEUE_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_ENQUEUE	PTC_COUNT	DEC	12	0	Enqueue Count
67	ENQUEUE_TIME	☐	STATS_DB_TIME_ENQUEUE	PTC_DURATION	DEC	15	0	Enqueue Time [ms]
68	COMMIT_TIME	☐	STATS_DB_TIME_COMMIT	PTC_DURATION	DEC	15	0	Commit Time [ms]
69	TOTAL_REQUEST_COUNT	☐	STATS_DB_REQ_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Request Count - All Requests
70	PHYSICAL_TOTAL_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Physical Request Count - All Requests
71	PHYSICAL_CHANGE_REQUEST_COUNT	☐	STATS_DB_REQ_P_COUNT_CHANGE	PTC_COUNT	DEC	12	0	DB Physical Request Count - All Change Requests
72	TOTAL_ROW_COUNT	☐	STATS_DB_ROW_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Row Count - All Requests
73	BUFFER_TOTAL_ROW_COUNT	☐	STATS_DB_ROW_B_COUNT_TOTAL	PTC_COUNT	DEC	12	0	DB Buffer Row Count - All Requests
74	TOTAL_TIME_PER_ROW	☐	STATS_DB_TIME_TOTAL_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - All Requests
75	DIR_READ_TIME_PER_ROW	☐	STATS_DB_TIME_DIR_READ_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Direct Read Requests
76	SEQ_READ_TIME_PER_ROW	☐	STATS_DB_TIME_SEQ_READ_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Sequential Read Requests
77	INSERT_TIME_PER_ROW	☐	STATS_DB_TIME_INSERT_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Insert Requests
78	UPDATE_TIME_PER_ROW	☐	STATS_DB_TIME_UPDATE_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Update Requests
79	DELETE_TIME_PER_ROW	☐	STATS_DB_TIME_DELETE_AV	PTC_DURATION	DEC	15	0	Average DB Request Time [ms] - Delete Requests
80	.INCLUDE	☐				0	0	Main Statistics Record (Memory Related Fields)
81	TOTAL_MEMORY_CONSUMPTION	☐	STATS_MEMORY_TOTAL	PTC_MEMORY	DEC	15	0	Memory Consumption [kB] - Total
82	ROLL_MEMORY_CONSUMPTION	☐	STATS_MEMORY_ROLL	PTC_MEMORY	DEC	15	0	Memory Consumption [kB] - Roll
83	PAGE_MEMORY_CONSUMPTION	☐	STATS_MEMORY_PAGE	PTC_MEMORY	DEC	15	0	Memory Consumption [kB] - Page
84	MAX_MEMORY_CONSUMPTION_TA	☐	STATS_MEMORY_EXTENDED_MAX_TA	PTC_MEMORY	DEC	15	0	Memory Consumption [KB] - Max. Extended During Transaction
85	MAX_MEMORY_CONSUMPTION_ST	☐	STATS_MEMORY_EXTENDED_MAX_ST	PTC_MEMORY	DEC	15	0	Memory Consumption [KB] - Max. Extended During Step
86	EXTENDED_MEMORY_CONSUMPTION	☐	STATS_MEMORY_EXTENDED	PTC_MEMORY	DEC	15	0	Memory Consumption [kB] - Extended
87	HEAP_MEMORY_CONSUMPTION	☐	STATS_MEMORY_HEAP	PTC_MEMORY	DEC	15	0	Memory Consumption [kB] - Heap
88	.INCLUDE	☐				0	0	Main Statistic Record (Data Transfer Related Fields)
89	APPLICATION_DATA_TRANSFER	☐	STATS_DATA_TRANS_APPL	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - Application
90	USER_DATA_TRANSFER	☐	STATS_DATA_TRANS_USER	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - User
91	SLI_DATA_TRANSFER	☐	STATS_DATA_TRANS_SLI	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - Sources, Loads, Interfaces
92	BTC_INP_DATA_TRANSFER	☐	STATS_DATA_TRANS_BTC_INP	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - Batch Input
93	TERMINAL_IN_MESSAGES	☐	STATS_DATA_TRANS_TERMINAL_IN	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - Terminal In
94	TERMINAL_OUT_MESSAGES	☐	STATS_DATA_TRANS_TERMINAL_OUT	PTC_MEMORY	DEC	15	0	Data Transfer [kB] - Terminal Out
95	.INCLUDE	☐				0	0	Main Statistics Record (Technical Fields)
96	RECORD_NUMBER	☐	PTC_RECORD_NUMBER		INT4	10	0	Running Number of Record
97	LINE_COLOR	☐			CHAR	4	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740