SAP Table DB4_SQ3000
iSeries: Table Scans (Database Monitor)
DB4_SQ3000 (iSeries: Table Scans (Database Monitor)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB4_SQ3000 to other SAP tables.
Source: DB4_SQ3000 (iSeries: Table Scans (Database Monitor))
DB4_SQ3000 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| QQKEY | iSeries: Key Field (Database Monitor) | QQKEY | CHAR | 17 | 0 | |||
| QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | CHAR | 26 | 0 | |||
| QQQDTN | iSeries: Query Definition Template Number | QQDTN | DEC | 15 | 0 | |||
| QQQDTL | iSeries: Query Definition Template Level | QQDTL | DEC | 15 | 0 | |||
| QQMATN | iSeries: Mat. QDT Number (Database Monitor) | QMATN | DEC | 15 | 0 | |||
| QQMATL | iSeries: Mat. QDT Level (Database Monitor) | QMATL | DEC | 15 | 0 | |||
| QQJNP | iSeries: Join Position (Database Monitor) | QJNP | DEC | 15 | 0 | |||
| QQTLN | iSeries: System Name of Library (Database Monitor) | QQTLN | CHAR | 10 | 0 | |||
| QQTFN | iSeries: System Name of Table (Database Monitor) | QTFN | CHAR | 30 | 0 | |||
| QQPTLN | iSeries: System Name of Base Library (Database Monitor) | QQPTLN | CHAR | 10 | 0 | |||
| QQPTFN | iSeries: System Name of Base Table (Database Monitor) | QPTFN | CHAR | 30 | 0 | |||
| QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | DEC | 15 | 0 | |||
| QQREST | iSeries: Estimated No. of Selected Rows (Database Monitor) | QREST | DEC | 15 | 0 | |||
| QQAJN | iSeries: Estimated Number of Joined Rows (Database Monitor) | QAJN | DEC | 15 | 0 | |||
| QQEPT | iSeries: Estimated Processing Time (Database Monitor) | QEPT | DEC | 15 | 0 | |||
| QQJNDS | iSeries: Dataspace Number (Database Monitor) | QQJNDS | DEC | 15 | 0 | |||
| QQJNMT | iSeries: Join Method (Database Monitor) | QQJNMT | CHAR | 2 | 0 | |||
| QQJNTY | iSeries: Join Type (Database Monitor) | QQJNTY | CHAR | 2 | 0 | |||
| QQJNOP | iSeries: Join Operator (Database Monitor) | QQJNOP | CHAR | 2 | 0 | |||
| QQDSS | iSeries: Dataspace Selection (Database Monitor) | QQDSS | CHAR | 1 | 0 | |||
| QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | QQIDXA | CHAR | 1 | 0 | |||
| QQRCOD | iSeries: Reason Code for Table Scan (Database Monitor) | QQRCODTSC | CHAR | 2 | 0 | |||
| QQLTLN | iSeries: Library Name (Database Monitor) | QQLTLN | CHAR | 128 | 0 | |||
| QQLTFN | iSeries: Table Name (Database Monitor) | QQLTFN | CHAR | 128 | 0 | |||
| QQLPTL | iSeries: Base Library (Database Monitor) | QQLPTL | CHAR | 128 | 0 | |||
| QQLPTF | iSeries: Base Table (Database Monitor) | QQLPTF | CHAR | 128 | 0 | |||
| QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | CHAR | 1 | 0 | |||
| QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | CHAR | 1 | 0 | |||
| QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | CHAR | 2 | 0 | |||
| QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | CHAR | 2 | 0 | |||
| QQI1 | iSeries: Reserved Field (Database Monitor) | QQI1 | INT4 | 10 | 0 | |||
| QQI2 | iSeries: Reserved Field (Database Monitor) | QQI2 | INT4 | 10 | 0 | |||
| QQC301 | iSeries: Reserved Field (Database Monitor) | QQC301 | CHAR | 30 | 0 | |||
| QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | CHAR | 30 | 0 | |||
| QQ1000 | CHAR | 1000 | 0 | |||||
| QQIDXD | CHAR | 1000 | 0 | |||||
