SAP ABAP Table SQ3004_DB4 (iSeries: Temporary Files (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 | SQ3004_DB4 |
Table Relationship Diagram 
|
| Short Description | iSeries: Temporary Files (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 | QQTLN |
QQTLN | QQTLN | CHAR | 10 | 0 | iSeries: System Name of Library (Database Monitor) | ||
| 11 | QQTFN |
QTFN | AS4TAB | CHAR | 30 | 0 | iSeries: System Name of Table (Database Monitor) | * | |
| 12 | QQTTIM |
QQTTIM_TF | QQDEC150 | DEC | 15 | 0 | iSeries: Create Time of Temporary Table (Database Monitor) | ||
| 13 | QQTMPR |
QTMPR | QQDEC150 | DEC | 15 | 0 | iSeries: Rows in Temporary Table (Database Monitor) | ||
| 14 | QQDFVL |
QQDFVL | QQYN | CHAR | 1 | 0 | iSeries: Default Values in Temp. Table (Database Monitor) | ||
| 15 | QQRCOD |
QQRCODTMF | QQRCOD | CHAR | 2 | 0 | iSeries: Reason Code for Temp. Table (Database Monitor) | ||
| 16 | QQLTLN |
QQLTLN | CHAR | 128 | 0 | iSeries: Library Name (Database Monitor) | |||
| 17 | QQLTFN |
QQLTFN | CHAR | 128 | 0 | iSeries: Table Name (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 | SQ3004_DB4 | SYSID |  SQ1000_DB4 |
SYSID |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
