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