SAP ABAP Table CTABSTAT_64 (Statistical Data About an Individual SAP Table 64 Bit)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DBI (Application Component) DB-Independent Database Interface
     ⤷ SDB_DBI (Package) General Database Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CTABSTAT_64	Table Relationship Diagram
Short Description	Statistical Data About an Individual SAP Table 64 Bit

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	☐	UPD_CNT_64	ABAP_MSIZE	DEC	20	0	Number of UPDATE Attempts
2	UPDFAIL	☐	UPD_FAIL_64	ABAP_MSIZE	DEC	20	0	Number of Failed UPDATE Attempts
3	DELCNT	☐	DEL_CNT_64	ABAP_MSIZE	DEC	20	0	Number of DELETE Attmempts
4	DELFAIL	☐	DEL_FAIL_64	ABAP_MSIZE	DEC	20	0	Number of Failed DELETE Attempts
5	INSCNT	☐	INS_CNT_64	ABAP_MSIZE	DEC	20	0	Number of INSERT attempts
6	INSFAIL	☐	INS_FAIL_64	ABAP_MSIZE	DEC	20	0	Number of Failed INSERT Attempts
7	MODCNT	☐	MOD_CNT_64	ABAP_MSIZE	DEC	20	0	Number of MODIFY Attempts
8	DIRCNT	☐	DIR_CNT_64	ABAP_MSIZE	DEC	20	0	Number of DIRECT READs
9	DIRFAIL	☐	DIR_FAIL_64	ABAP_MSIZE	DEC	20	0	Number of Failed DIRECT READs
10	SEQCNT	☐	SEQ_CNT_64	ABAP_MSIZE	DEC	20	0	No. of SEQUENTIAL READs
11	SEQFAIL	☐	SEQ_FAIL_64	ABAP_MSIZE	DEC	20	0	Number of Unsuccessful SEQUENTIAL READs
12	UPD_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
13	UPD_EXEC	☐	EXEC_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL EXECUTEs
14	UPD_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
15	UPD_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
16	DEL_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
17	DEL_EXEC	☐	EXEC_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL EXECUTEs
18	DEL_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
19	DEL_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
20	INS_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
21	INS_EXEC	☐	EXEC_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL EXECUTEs
22	INS_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
23	INS_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
24	MOD_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
25	MOD_EXEC	☐	EXEC_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL EXECUTEs
26	MOD_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
27	MOD_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
28	DIR_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
29	DIR_OPEN	☐	OPEN_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL OPENs
30	DIR_FETCH	☐	FETCH_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL FETCHes
31	DIR_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
32	SEQ_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
33	SEQ_OPEN	☐	OPEN_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL OPENs
34	SEQ_FETCH	☐	FETCH_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL FETCHes
35	SEQ_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
36	SEQ_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
37	LOAD_PREP	☐	PREP_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL PREPAREs
38	LOAD_OPEN	☐	OPEN_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL OPENs
39	LOAD_FETCH	☐	FETCH_CNT_64	ABAP_MSIZE	DEC	20	0	Number of SQL FETCHes
40	LOAD_ROW	☐	ROW_CNT_64	ABAP_MSIZE	DEC	20	0	No. of Tuples Affected in a Table
41	LOAD_DUR	☐	OP_DUR_64	ABAP_MSIZE	DEC	20	0	Operation Duration
42	BUF_RESET	☐	BUF_RESET_64	ABAP_MSIZE	DEC	20	0	Number of Buffer Resets
43	BUF_SIZE	☐	BUF_SIZE_64	ABAP_MSIZE	DEC	20	0	Size of the Buffer for an Object
44	BUF_SIZEMX	☐	BUF_SIZEMX_64	ABAP_MSIZE	DEC	20	0	Maximum Buffer Size for an Object
45	BUF_RECS	☐	BUF_RECS_64	ABAP_MSIZE	DEC	20	0	Number of Buffered Records for an Object
46	BUF_RECSMX	☐	BUF_RECSMX_64	ABAP_MSIZE	DEC	20	0	Maximum Number of Buffered Records for an Object
47	BUF_DIR	☐	BUF_DIR_64	ABAP_MSIZE	DEC	20	0	Number of Direct Hits in the Buffer
48	BUF_SEQ	☐	BUF_SEQ_64	ABAP_MSIZE	DEC	20	0	Number of Sequential Buffer Accesses
49	REGIONS_N	☐	GENREGIONS_64	ABAP_MSIZE	DEC	20	0	Number of Generic Regions of a Buffered Table
50	SEQ_SCAN	☐	SEQ_SCAN_64	ABAP_MSIZE	DEC	20	0	Number of Records Read with Sequential Access
51	BUF_STATE	☐	PBUFSTATE	PBUFSTATE	CHAR	1	0	Status of the table in the table buffer
52	TNAME	☐	DBSTATTABN	AS4TAB	CHAR	30	0	Table name	*
53	REF	☐	TABTYPES	TABTYPESD	CHAR	1	0	Table type (short text)
54	RNAME	☐	DBSTATSQLT	AS4TAB	CHAR	30	0	Name of the pool or cluster	*
55	BYPASSBUF	☐	BYPASSBUF	BYPASSBUF	CHAR	1	0	Table read with BYPASSING BUFFER (checked tables only)
56	SQL	☐	SQLACCESSD	AS4FLAG	CHAR	1	0	Flag: Table processed via EXEC SQL?

History

Last changed by/on	SAP	20140117
SAP Release Created in	640