SAP ABAP Table STMTDATA (Data for SCC Download Statement (Oracle))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	STMTDATA	Table Relationship Diagram
Short Description	Data for SCC Download Statement (Oracle)

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	ANALY_ID	☐			CHAR	14	0
2	STMT_ID	☐			CHAR	2	0
3	.INCLUDE	☐				0	0	ST04: SCC Fields
4	SQL_TEXT	☐			CHAR	80	0
5	SHAR_MEM	☐			DEC	30	0
6	PERS_MEM	☐			DEC	30	0
7	RUNTIM_MEM	☐			DEC	30	0
8	SQLSORTS	☐			DEC	30	0
9	LOAD_VERSN	☐			DEC	30	0
10	OPEN_VERSN	☐			DEC	30	0
11	USERS_OPEN	☐			DEC	30	0
12	EXECUTIONS	☐			DEC	30	0
13	USERS_EXEC	☐			DEC	30	0
14	LOADS	☐			DEC	30	0
15	FIRST_LOAD	☐			CHAR	19	0
16	INVALIDATN	☐			INT4	10	0
17	PARSE_CALL	☐			INT4	10	0
18	DISK_READS	☐			DEC	30	0
19	BUFFER_GET	☐			DEC	30	0
20	RECS_PROCE	☐			DEC	30	0
21	ADDRESS	☐			CHAR	16	0
22	HASH_VALUE	☐			DEC	30	0
23	MODULENAME	☐			CHAR	64	0
24	ACTION	☐			CHAR	64	0
25	SHOW	☐			CHAR	1	0
26	INVALID	☐			CHAR	1	0
27	DISKRD_EXC	☐			DEC	30	1
28	BUFGET_EXC	☐			DEC	30	1
29	PARCAL_EXC	☐			DEC	30	1
30	RECPRO_EXC	☐			DEC	30	1
31	BUFGET_ROW	☐			DEC	30	1
32	CPU_TIME	☐			DEC	30	0
33	ELAPS_TIME	☐			DEC	30	0
34	.INCLUDE	☐				0	0	Oracle: SQL Statement and Length
35	STMT_STR	☐			CHAR	4000	0
36	STMT_LN	☐			INT4	10	0
37	.INCLUDE	☐				0	0	Statistical Table Information
38	TABLE_NAME	☐			CHAR	30	0
39	NUM_ROWS	☐			DEC	17	0
40	BLOCKS	☐			DEC	17	0
41	EMPTY_BLKS	☐			DEC	17	0
42	AVG_SPACE	☐			DEC	17	0
43	CHAIN_CNT	☐			DEC	17	0
44	AVG_ROW_LN	☐			DEC	17	0
45	SAMPL_SIZE	☐			INT4	10	0
46	LAST_ANALY	☐			CHAR	14	0
47	LAST_CHANG	☐			CHAR	20	0
48	BUFF_TYPE	☐			CHAR	6	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	50A