SAP ABAP Table ALSTATITEM (Statistical Data About Individual SAP Tables + Host + RC)

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	ALSTATITEM	Table Relationship Diagram
Short Description	Statistical Data About Individual SAP Tables + Host + RC

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

History

Last changed by/on	SAP	20130604
SAP Release Created in