SAP ABAP Table CTABSTAT (Statistical data on individual SAP tables (kernel))

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	CTABSTAT	Table Relationship Diagram
Short Description	Statistical data on individual SAP tables (kernel)

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	UPDCNT	☐	UPDCNT	INT4	INT4	10	0	No. of UPDATE attempts
2	UPDFAIL	☐	UPDFAIL	INT4	INT4	10	0	No. of failed update attempts
3	DELCNT	☐	DELCNT	INT4	INT4	10	0	No. of DELETE attempts
4	DELFAIL	☐	DELFAIL	INT4	INT4	10	0	No. of failed DELETE attempts
5	INSCNT	☐	INSCNT	INT4	INT4	10	0	No. of INSERT attempts
6	INSFAIL	☐	INSFAIL	INT4	INT4	10	0	No. of failed INSERT attempts
7	DIRCNT	☐	DIRCNT	INT4	INT4	10	0	Number of DIRECT READs
8	DIRFAIL	☐	DIRFAIL	INT4	INT4	10	0	Number of Failed DIRECT READs
9	SEQCNT	☐	SEQCNT	INT4	INT4	10	0	No. of SEQUENTIAL READs
10	SEQFAIL	☐	SEQ_FAIL	INT4	INT4	10	0	Number of unsuccessful SEQUENTIAL READs
11	UPD_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
12	UPD_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
13	UPD_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
14	UPD_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
15	DEL_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
16	DEL_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
17	DEL_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
18	DEL_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
19	INS_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
20	INS_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
21	INS_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
22	INS_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
23	DIR_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
24	DIR_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
25	DIR_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
26	DIR_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
27	SEQ_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
28	SEQ_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
29	SEQ_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
30	SEQ_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
31	SEQ_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
32	LOAD_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
33	LOAD_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
34	LOAD_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
35	LOAD_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
36	LOAD_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
37	BUF_RESET	☐	PBUFRESET	INT4	INT4	10	0	No. of buffer resets
38	BUF_SIZE	☐	PBUFSIZE	INT4	INT4	10	0	Size of the buffer for an object
39	BUF_SIZEMX	☐	PBUFSIZEMX	INT4	INT4	10	0	Maximum buffer size for an object
40	BUF_RECS	☐	PBUFRECS	INT4	INT4	10	0	No. of buffered records for an object
41	BUF_RECSMX	☐	PBUFRECSMX	INT4	INT4	10	0	Maximum no. of buffered records for an object
42	BUF_DIR	☐	PBUFDIR	INT4	INT4	10	0	No. of direct hits in the buffer
43	BUF_SEQ	☐	PBUFSEQ	INT4	INT4	10	0	No. of sequential buffer accesses
44	REGIONS_N	☐	GENREGIONS	INT4	INT4	10	0	No. of generic regions of a buffered table
45	SEQ_SCAN	☐	SEQ_SCAN	INT4	INT4	10	0	No. of records read with seq. acess
46	BUF_STATE	☐	PBUFSTATE	PBUFSTATE	CHAR	1	0	Status of the table in the table buffer
47	TNAME	☐	DBSTATTABN	AS4TAB	CHAR	30	0	Table name	*
48	REF	☐	TABTYPES	TABTYPESD	CHAR	1	0	Table type (short text)
49	RNAME	☐	DBSTATSQLT	AS4TAB	CHAR	30	0	Name of the pool or cluster	*
50	BYPASSBUF	☐	BYPASSBUF	BYPASSBUF	CHAR	1	0	Table read with BYPASSING BUFFER (checked tables only)
51	SQL	☐	SQLACCESSD	AS4FLAG	CHAR	1	0	Flag: Table processed via EXEC SQL?

History

Last changed by/on	SAP	20130604
SAP Release Created in