SAP ABAP Table DB02INFDB4 (Structure for Main Screen of DB02 for iSeries)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB02INFDB4 |
|
| Short Description | Structure for Main Screen of DB02 for iSeries |
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 | |
SYDBSYS | SYCHAR10 | CHAR | 10 | 0 | Central Database System | ||
| 2 | |
FS_A_DATE | SYDATS | DATS | 8 | 0 | Date of analysis of file statistics (tables/indexes) | ||
| 3 | |
FS_A_TIME | SYTIME | TIMS | 6 | 0 | Time of analysis of file statistics (tables/indexes) | ||
| 4 | |
SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | ||
| 5 | |
TAB_CNT | INT4 | INT4 | 10 | 0 | Tables: total number | ||
| 6 | |
CST_CNT | INT4 | INT4 | 10 | 0 | Primary key constraints: total number | ||
| 7 | |
IDX_CNT | INT4 | INT4 | 10 | 0 | Indexes: total number | ||
| 8 | |
TAB_SIZE | DEC15 | DEC | 15 | 0 | Tables: total size (KB) | ||
| 9 | |
CST_SIZE | DEC15 | DEC | 15 | 0 | Primary key constraints: total size (KB) | ||
| 10 | |
IDX_SIZE | DEC15 | DEC | 15 | 0 | Indexes: total size (KB) | ||
| 11 | |
TAB_MIS_DB | INT4 | INT4 | 10 | 0 | Tables: number of tables missing from database | ||
| 12 | |
CST_MIS_DB | INT4 | INT4 | 10 | 0 | Primary keys: number of constraints missing from database | ||
| 13 | |
IDX_MIS_DB | INT4 | INT4 | 10 | 0 | Indexes: number of indexes missing from database | ||
| 14 | |
VIE_MIS_DB | INT4 | INT4 | 10 | 0 | Views: Number of views missing from database | ||
| 15 | |
TAB_MIS_DD | INT4 | INT4 | 10 | 0 | Tables: number of tables not in ABAP Dictionary | ||
| 16 | |
CST_MIS_DD | INT4 | INT4 | 10 | 0 | Primary keys: number of constr. missing from ABAP Dictionary | ||
| 17 | |
IDX_MIS_DD | INT4 | INT4 | 10 | 0 | Indexes: number of indexes missing from ABAP Dictionary | ||
| 18 | |
VIE_MIS_DD | INT4 | INT4 | 10 | 0 | Views: Number of views missing from ABAP Dictionary | ||
| 19 | |
SYS_ASP_P | DEC15_5DB4 | DEC | 15 | 5 | Percentage of system ASP used | ||
| 20 | |
SYS_ASP_S | DEC7_1 | DEC | 10 | 1 | Size of system ASP | ||
| 21 | |
ASP_TOT_S | DEC7_1 | DEC | 10 | 1 | Total ASP size |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |