Data Element list used by SAP ABAP Table CTABSTAT (Statistical data on individual SAP tables (kernel))
SAP ABAP Table
CTABSTAT (Statistical data on individual SAP tables (kernel)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | BYPASSBUF | Table read with BYPASSING BUFFER (checked tables only) | ||
| 2 | DBSTATSQLT | Name of the pool or cluster | ||
| 3 | DBSTATTABN | Table name | ||
| 4 | DELCNT | No. of DELETE attempts | ||
| 5 | DELFAIL | No. of failed DELETE attempts | ||
| 6 | DIRCNT | Number of DIRECT READs | ||
| 7 | DIRFAIL | Number of Failed DIRECT READs | ||
| 8 | EXECCNT | No of SQL EXECUTEs | ||
| 9 | EXECCNT | No of SQL EXECUTEs | ||
| 10 | EXECCNT | No of SQL EXECUTEs | ||
| 11 | FETCHCNT | No. of SQL FETCHes | ||
| 12 | FETCHCNT | No. of SQL FETCHes | ||
| 13 | FETCHCNT | No. of SQL FETCHes | ||
| 14 | GENREGIONS | No. of generic regions of a buffered table | ||
| 15 | INSCNT | No. of INSERT attempts | ||
| 16 | INSFAIL | No. of failed INSERT attempts | ||
| 17 | OPENCNT | No. of SQL OPENs | ||
| 18 | OPENCNT | No. of SQL OPENs | ||
| 19 | OPENCNT | No. of SQL OPENs | ||
| 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 | OP_DUR | Operation duration | ||
| 26 | PBUFDIR | No. of direct hits in the buffer | ||
| 27 | PBUFRECS | No. of buffered records for an object | ||
| 28 | PBUFRECSMX | Maximum no. of buffered records for an object | ||
| 29 | PBUFRESET | No. of buffer resets | ||
| 30 | PBUFSEQ | No. of sequential buffer accesses | ||
| 31 | PBUFSIZE | Size of the buffer for an object | ||
| 32 | PBUFSIZEMX | Maximum buffer size for an object | ||
| 33 | PBUFSTATE | Status of the table in the table buffer | ||
| 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 | PREPCNT | No. of SQL PREPAREs | ||
| 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 | ROWCNT | No. of tuples affected in a table | ||
| 45 | SEQCNT | No. of SEQUENTIAL READs | ||
| 46 | SEQ_FAIL | Number of unsuccessful SEQUENTIAL READs | ||
| 47 | SEQ_SCAN | No. of records read with seq. acess | ||
| 48 | SQLACCESSD | Flag: Table processed via EXEC SQL? | ||
| 49 | TABTYPES | Table type (short text) | ||
| 50 | UPDCNT | No. of UPDATE attempts | ||
| 51 | UPDFAIL | No. of failed update attempts |