ALSTATITEM - Statistical Data About Individual SAP Tables + Host + RC
ALSTATITEM - Statistical Data About Individual SAP Tables + Host + RC
Addresses (Business Address Services)
General Material Data
This documentation is copyright by SAP AG.
Field
Type
Length
Data element
Description
NAME
CHAR
000020
Application Server Instance
RC
INT4
000010
Return Code
UPDCNT
INT4
000010
No. of UPDATE attempts
UPDFAIL
INT4
000010
No. of failed update attempts
DELCNT
INT4
000010
No. of DELETE attempts
DELFAIL
INT4
000010
No. of failed DELETE attempts
INSCNT
INT4
000010
No. of INSERT attempts
INSFAIL
INT4
000010
No. of failed INSERT attempts
DIRCNT
INT4
000010
Number of DIRECT READs
DIRFAIL
INT4
000010
Number of Failed DIRECT READs
SEQCNT
INT4
000010
No. of SEQUENTIAL READs
UPD_PREP
INT4
000010
No. of SQL PREPAREs
UPD_EXEC
INT4
000010
No of SQL EXECUTEs
UPD_ROW
INT4
000010
No. of tuples affected in a table
UPD_DUR
INT4
000010
Operation duration
DEL_PREP
INT4
000010
No. of SQL PREPAREs
DEL_EXEC
INT4
000010
No of SQL EXECUTEs
DEL_ROW
INT4
000010
No. of tuples affected in a table
DEL_DUR
INT4
000010
Operation duration
INS_PREP
INT4
000010
No. of SQL PREPAREs
INS_EXEC
INT4
000010
No of SQL EXECUTEs
INS_ROW
INT4
000010
No. of tuples affected in a table
INS_DUR
INT4
000010
Operation duration
DIR_PREP
INT4
000010
No. of SQL PREPAREs
DIR_OPEN
INT4
000010
No. of SQL OPENs
DIR_FETCH
INT4
000010
No. of SQL FETCHes
DIR_DUR
INT4
000010
Operation duration
SEQ_PREP
INT4
000010
No. of SQL PREPAREs
SEQ_OPEN
INT4
000010
No. of SQL OPENs
SEQ_FETCH
INT4
000010
No. of SQL FETCHes
SEQ_ROW
INT4
000010
No. of tuples affected in a table
SEQ_DUR
INT4
000010
Operation duration
LOAD_PREP
INT4
000010
No. of SQL PREPAREs
LOAD_OPEN
INT4
000010
No. of SQL OPENs
LOAD_FETCH
INT4
000010
No. of SQL FETCHes
LOAD_ROW
INT4
000010
No. of tuples affected in a table
LOAD_DUR
INT4
000010
Operation duration
BUF_RESET
INT4
000010
No. of buffer resets
BUF_SIZE
INT4
000010
Size of the buffer for an object
BUF_SIZEMX
INT4
000010
Maximum buffer size for an object
BUF_RECS
INT4
000010
No. of buffered records for an object
BUF_RECSMX
INT4
000010
Maximum no. of buffered records for an object
BUF_DIR
INT4
000010
No. of direct hits in the buffer
BUF_SEQ
INT4
000010
No. of sequential buffer accesses
REGIONS_N
INT4
000010
No. of generic regions of a buffered table
SEQ_SCAN
INT4
000010
No. of records read with seq. acess
TNAME
CHAR
000030
Table Name
REF
CHAR
000001
Table type (short text)
RNAME
CHAR
000010
Name of Pool/Cluster in the Database
BUF
CHAR
000001
Buffer mode of an SAP table
SQL
CHAR
000001
Flag: Table processed via EXEC SQL?
BUF_STATE
CHAR
000001
Status of the table in the table buffer
This documentation is copyright by SAP AG.
Length: 13804 Date: 20240419 Time: 102724 sap01-206 ( 38 ms )
