SAP ABAP Table ODBSTATITM (Statistical data for individual SAP Tables (f. Rel. < 3.0))

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	ODBSTATITM	Table Relationship Diagram
Short Description	Statistical data for individual SAP Tables (f. Rel. < 3.0)

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	TNAME	☐	TABNAME	AS4TAB	CHAR	30	0	Table Name	*
2	REF	☐	TABTYPES	TABTYPESD	CHAR	1	0	Table type (short text)
3	RNAME	☐	SQLTABLE	SQLTABLE	CHAR	10	0	Name of Pool/Cluster in the Database	*
4	BUF	☐	BUFMODE	BUFMODED	CHAR	1	0	Buffer mode of an SAP table
5	SQL	☐	SQLACCESSD	AS4FLAG	CHAR	1	0	Flag: Table processed via EXEC SQL?
6	FILL1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
7	UPDCNT	☐	UPDCNT	INT4	INT4	10	0	No. of UPDATE attempts
8	UPDFAIL	☐	UPDFAIL	INT4	INT4	10	0	No. of failed update attempts
9	DELCNT	☐	DELCNT	INT4	INT4	10	0	No. of DELETE attempts
10	DELFAIL	☐	DELFAIL	INT4	INT4	10	0	No. of failed DELETE attempts
11	INSCNT	☐	INSCNT	INT4	INT4	10	0	No. of INSERT attempts
12	INSFAIL	☐	INSFAIL	INT4	INT4	10	0	No. of failed INSERT attempts
13	DIRCNT	☐	DIRCNT	INT4	INT4	10	0	Number of DIRECT READs
14	DIRFAIL	☐	DIRFAIL	INT4	INT4	10	0	Number of Failed DIRECT READs
15	SEQCNT	☐	SEQCNT	INT4	INT4	10	0	No. of SEQUENTIAL READs
16	UPD_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
17	UPD_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
18	UPD_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
19	UPD_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
20	DEL_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
21	DEL_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
22	DEL_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
23	DEL_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
24	INS_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
25	INS_EXEC	☐	EXECCNT	INT4	INT4	10	0	No of SQL EXECUTEs
26	INS_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
27	INS_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
28	DIR_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
29	DIR_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
30	DIR_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
31	DIR_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
32	SEQ_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
33	SEQ_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
34	SEQ_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
35	SEQ_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
36	SEQ_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
37	UNUSED1	☐	INT4	INT4	INT4	10	0	Natural number
38	UNUSED2	☐	INT4	INT4	INT4	10	0	Natural number
39	UNUSED3	☐	INT4	INT4	INT4	10	0	Natural number
40	UNUSED4	☐	INT4	INT4	INT4	10	0	Natural number
41	FILL2	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
42	LOAD_PREP	☐	PREPCNT	INT4	INT4	10	0	No. of SQL PREPAREs
43	LOAD_OPEN	☐	OPENCNT	INT4	INT4	10	0	No. of SQL OPENs
44	LOAD_FETCH	☐	FETCHCNT	INT4	INT4	10	0	No. of SQL FETCHes
45	LOAD_ROW	☐	ROWCNT	INT4	INT4	10	0	No. of tuples affected in a table
46	LOAD_DUR	☐	OP_DUR	INT4	INT4	10	0	Operation duration
47	BUF_STATE	☐	PBUFSTATE	PBUFSTATE	CHAR	1	0	Status of the table in the table buffer
48	FILL3	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
49	BUF_RESET	☐	PBUFRESET	INT4	INT4	10	0	No. of buffer resets
50	BUF_SIZE	☐	PBUFSIZE	INT4	INT4	10	0	Size of the buffer for an object
51	BUF_SIZEMX	☐	PBUFSIZEMX	INT4	INT4	10	0	Maximum buffer size for an object
52	BUF_RECS	☐	PBUFRECS	INT4	INT4	10	0	No. of buffered records for an object
53	BUF_RECSMX	☐	PBUFRECSMX	INT4	INT4	10	0	Maximum no. of buffered records for an object
54	BUF_DIR	☐	PBUFDIR	INT4	INT4	10	0	No. of direct hits in the buffer
55	BUF_SEQ	☐	PBUFSEQ	INT4	INT4	10	0	No. of sequential buffer accesses
56	BUDIR	☐	INT4	INT4	INT4	10	0	Natural number
57	BUSEQ	☐	INT4	INT4	INT4	10	0	Natural number

History

Last changed by/on	SAP	20130604
SAP Release Created in