Data Element list used by SAP ABAP Table ALSTATITEM (Statistical Data About Individual SAP Tables + Host + RC)
SAP ABAP Table
ALSTATITEM (Statistical Data About Individual SAP Tables + Host + RC) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | BUFMODE | Buffer mode of an SAP table | ||
| 2 | DELCNT | No. of DELETE attempts | ||
| 3 | DELFAIL | No. of failed DELETE attempts | ||
| 4 | DIRCNT | Number of DIRECT READs | ||
| 5 | DIRFAIL | Number of Failed DIRECT READs | ||
| 6 | EXECCNT | No of SQL EXECUTEs | ||
| 7 | EXECCNT | No of SQL EXECUTEs | ||
| 8 | EXECCNT | No of SQL EXECUTEs | ||
| 9 | FETCHCNT | No. of SQL FETCHes | ||
| 10 | FETCHCNT | No. of SQL FETCHes | ||
| 11 | FETCHCNT | No. of SQL FETCHes | ||
| 12 | GENREGIONS | No. of generic regions of a buffered table | ||
| 13 | INSCNT | No. of INSERT attempts | ||
| 14 | INSFAIL | No. of failed INSERT attempts | ||
| 15 | MSNAME | Server Name | ||
| 16 | OPENCNT | No. of SQL OPENs | ||
| 17 | OPENCNT | No. of SQL OPENs | ||
| 18 | OPENCNT | No. of SQL OPENs | ||
| 19 | OP_DUR | Operation duration | ||
| 20 | OP_DUR | Operation duration | ||
| 21 | OP_DUR | Operation duration | ||
| 22 | OP_DUR | Operation duration | ||
| 23 | OP_DUR | Operation duration | ||
| 24 | OP_DUR | Operation duration | ||
| 25 | PBUFDIR | No. of direct hits in the buffer | ||
| 26 | PBUFRECS | No. of buffered records for an object | ||
| 27 | PBUFRECSMX | Maximum no. of buffered records for an object | ||
| 28 | PBUFRESET | No. of buffer resets | ||
| 29 | PBUFSEQ | No. of sequential buffer accesses | ||
| 30 | PBUFSIZE | Size of the buffer for an object | ||
| 31 | PBUFSIZEMX | Maximum buffer size for an object | ||
| 32 | PBUFSTATE | Status of the table in the table buffer | ||
| 33 | PREPCNT | No. of SQL PREPAREs | ||
| 34 | PREPCNT | No. of SQL PREPAREs | ||
| 35 | PREPCNT | No. of SQL PREPAREs | ||
| 36 | PREPCNT | No. of SQL PREPAREs | ||
| 37 | PREPCNT | No. of SQL PREPAREs | ||
| 38 | PREPCNT | No. of SQL PREPAREs | ||
| 39 | ROWCNT | No. of tuples affected in a table | ||
| 40 | ROWCNT | No. of tuples affected in a table | ||
| 41 | ROWCNT | No. of tuples affected in a table | ||
| 42 | ROWCNT | No. of tuples affected in a table | ||
| 43 | ROWCNT | No. of tuples affected in a table | ||
| 44 | SEQCNT | No. of SEQUENTIAL READs | ||
| 45 | SEQ_SCAN | No. of records read with seq. acess | ||
| 46 | SQLACCESSD | Flag: Table processed via EXEC SQL? | ||
| 47 | SQLTABLE | Name of Pool/Cluster in the Database | ||
| 48 | SYSUBRC | Return Code | ||
| 49 | TABNAME | Table Name | ||
| 50 | TABTYPES | Table type (short text) | ||
| 51 | UPDCNT | No. of UPDATE attempts | ||
| 52 | UPDFAIL | No. of failed update attempts |