SAP ABAP Table SQ3003_DB4 (iSeries: Sorts (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 | SQ3003_DB4 |
Table Relationship Diagram 
|
| Short Description | iSeries: Sorts (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 | QQTTIM |
QQTTIM_SRT | QQDEC150 | DEC | 15 | 0 | iSeries: Sort Time (Database Monitor) | ||
| 11 | QQRSS |
QRSS | QQDEC150 | DEC | 15 | 0 | iSeries: Number of Rows Sorted (Database Monitor) | ||
| 12 | QQSSIZ |
QQSSIZ | QQDEC150 | DEC | 15 | 0 | iSeries: Sort Size (Database Monitor) | ||
| 13 | QQPSIZ |
QQPSIZ | QQDEC150 | DEC | 15 | 0 | iSeries: Pool Size (Database Monitor) | ||
| 14 | QQPID |
QQPID | QQDEC150 | DEC | 15 | 0 | iSeries: Pool ID (Database Monitor) | ||
| 15 | QQIBUF |
QQIBUF | QQDEC150 | DEC | 15 | 0 | iSeries: Internal Buffer (Database Monitor) | ||
| 16 | QQEBUF |
QQEBUF | QQDEC150 | DEC | 15 | 0 | iSeries: External Buffer (Database Monitor) | ||
| 17 | QQRCOD |
QQRCODSRT | QQRCOD | CHAR | 2 | 0 | iSeries: Reason Code (Database Monitor) | ||
| 18 | QQC11 |
QQC11 | QQC11 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 19 | QQC12 |
QQC12 | QQC12 | CHAR | 1 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 20 | QQC21 |
QQC21 | QQC21 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 21 | QQC22 |
QQC22 | QQC22 | CHAR | 2 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 22 | QQI1 |
QQI1 | QQI1 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 23 | QQI2 |
QQI2 | QQI2 | INT4 | 10 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 24 | QQC301 |
QQC301 | QQC301 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | ||
| 25 | QQC302 |
QQC302 | CHAR | 30 | 0 | iSeries: Reserved Field (Database Monitor) | |||
| 26 | 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 | SQ3003_DB4 | SYSID |  SQ1000_DB4 |
SYSID |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
