Data Element list used by SAP ABAP Table DB2TBDETL (Detailed Information on a Table from the DB2 Catalog)
SAP ABAP Table 
DB2TBDETL (Detailed Information on a Table from the DB2 Catalog) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2ALTEDTS | Time of most recent ALTER statement on the object | |
| 2 | Data Element |
DB2CARDF | Total number of rows in the table | |
| 3 | Data Element |
DB2COLCNT | Number of columns in the table or view | |
| 4 | Data Element |
DB2CREADTS | Time when the CREATE statement was executed | |
| 5 | Data Element |
DB2CREATOR | DB2 creator name | |
| 6 | Data Element |
DB2DBNAME | Database name | |
| 7 | Data Element |
DB2KEYCOLS | Number of columns in the table's primary key | |
| 8 | Data Element |
DB2NPAGES | Number of pages on which rows of the table appear | |
| 9 | Data Element |
DB2PCTRCMP | Percentage of rows compressed within the total no. of rows | |
| 10 | Data Element |
DB2RECLENS | Maximum length (in bytes) of any record in the table | |
| 11 | Data Element |
DB2STATSTM | Date and time of last RUNSTATS | |
| 12 | Data Element |
DB2TABNAME | DB2 table name | |
| 13 | Data Element |
DB2TBSIZE | Size of the table in KB | |
| 14 | Data Element |
DB2TBSTATU | Status of the table | |
| 15 | Data Element |
DB2TBTYPE | Type of object | |
| 16 | Data Element |
DB2TSNAME | Name of the tablespace |
