SAP ABAP Table SQ3008_DB4 (iSeries: Subqueries (Database Monitor))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
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 | TRANSP | Transparent table |
| Transparent table | SQ3008_DB4 |
Table Relationship Diagram 
|
| Short Description | iSeries: Subqueries (Database Monitor) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| 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 |  SYSID |
SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | SQ1000_DB4 | |
| 2 | IPLTIME |
CHAR14 | CHAR14 | CHAR | 14 | 0 | Text field length 14 | ||
| 3 | QQKEY |
QQKEY | QQKEY | CHAR | 17 | 0 | iSeries: Key Field (Database Monitor) | ||
| 4 | QQKEY2 |
QQKEY2 | QQDEC150 | DEC | 15 | 0 | iSeries: 2nd Key Field of Database Monitor Files | ||
| 5 | QQTIME |
QQTIME | QQTIME | CHAR | 26 | 0 | iSeries: Record Creation Timestamp (Database Monitor) | ||
| 6 | QQQDTN |
QQDTN | QQDEC150 | DEC | 15 | 0 | iSeries: Query Definition Template Number | ||
| 7 | QQQDTL |
QQDTL | QQDEC150 | DEC | 15 | 0 | iSeries: Query Definition Template Level | ||
| 8 | QQMATN |
QMATN | QQDEC150 | DEC | 15 | 0 | iSeries: Mat. QDT Number (Database Monitor) | ||
| 9 | QQMATL |
QMATL | QQDEC150 | DEC | 15 | 0 | iSeries: Mat. QDT Level (Database Monitor) | ||
| 10 | QQORGQ |
QQORGQ | QQDEC150 | DEC | 15 | 0 | iSeries: Original Number of QDTs (Database Monitor) | ||
| 11 | QQMRGQ |
QQMRGQ | QQDEC150 | DEC | 15 | 0 | iSeries: Merged QDTs (Database Monitor) | ||
| 12 | QQC11 |
QQC11 | QQC11 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 13 | QQC12 |
QQC12 | QQC12 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 14 | QQC21 |
QQC21 | QQC21 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 15 | QQC22 |
QQC22 | QQC22 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 16 | QQI1 |
QQI1 | QQI1 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 17 | QQI2 |
QQI2 | QQI2 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 18 | QQC301 |
QQC301 | QQC301 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 19 | QQC302 |
QQC302 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | |||
| 20 | QQ1000 |
QQ1000 | CHAR | 255 | 0 | iSeries: Reserved Field (Database Monitor) |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | SQ3008_DB4 | SYSID |  SQ1000_DB4 |
SYSID |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
