SQ3002_DB4 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of SQ3002_DB4 in SAP.
- Table description : iSeries: Created Indexes (Database Monitor)
- Module : BC-DB-DB4
- Parent Module : BC
- Package : STU4
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SQ3002_DB4 Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
SYSID | Name of SAP System | SYSYSID | SYCHAR08 |
IPLTIME | Text field length 14 | CHAR14 | CHAR14 |
QQKEY | iSeries: Key Field (Database Monitor) | QQKEY | QQKEY |
QQKEY2 | iSeries: 2nd Key Field of Database Monitor Files | QQKEY2 | QQDEC150 |
QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | QQTIME |
QQQDTN | iSeries: Query Definition Template Number | QQDTN | QQDEC150 |
QQQDTL | iSeries: Query Definition Template Level | QQDTL | QQDEC150 |
QQMATN | iSeries: Mat. QDT Number (Database Monitor) | QMATN | QQDEC150 |
QQMATL | iSeries: Mat. QDT Level (Database Monitor) | QMATL | QQDEC150 |
QQTLN | iSeries: System Name of Library (Database Monitor) | QQTLN | QQTLN |
QQTFN | iSeries: System Name of Table (Database Monitor) | QTFN | AS4TAB |
QQPTLN | iSeries: System Name of Base Library (Database Monitor) | QQPTLN | QQTLN |
QQPTFN | iSeries: System Name of Base Table (Database Monitor) | QPTFN | AS4TAB |
QQILNM | iSeries: System Name of Index Library (Database Monitor) | QQILNM | QQTLN |
QQIFNM | iSeries: System Name of Index (Database Monitor) | QIFNM | DBINDEX |
QQNTNM | iSeries: System Name of NLSS Table (Database Monitor) | QQNTNM | QQTFN |
QQNLNM | iSeries: System Name of NLSS Library (Database Monitor) | QQNLNM | QQTLN |
QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | QQDEC150 |
QQRIDX | iSeries: Number of Entries in Created Index | QRIDX | QQDEC150 |
QQREST | iSeries: Estimated No. of Selected Rows (Database Monitor) | QREST | QQDEC150 |
QQFKEY | iSeries: Estimated Rows Returned by Key Positioning | QFKEY | QQDEC150 |
QQKSEL | iSeries: Estimated Rows Returned by Key Selection | QKSEL | QQDEC150 |
QQAJN | iSeries: Estimated Number of Joined Rows (Database Monitor) | QAJN | QQDEC150 |
QQJNP | iSeries: Join Position (Database Monitor) | QJNP | QQDEC150 |
QQJNDS | iSeries: Dataspace Number (Database Monitor) | QQJNDS | QQDEC150 |
QQJNMT | iSeries: Join Method (Database Monitor) | QQJNMT | QQC21 |
QQJNTY | iSeries: Join Type (Database Monitor) | QQJNTY | QQC21 |
QQJNOP | iSeries: Join Operator (Database Monitor) | QQJNOP | QQC21 |
QQIDXK | iSeries: No. of Key Fields of Advised Index | QQIDXK | QQDEC150 |
QQEPT | iSeries: Estimated Processing Time (Database Monitor) | QEPT | QQDEC150 |
QQKP | iSeries: Key Positioning (Database Monitor) | QQKP | QQYN |
QQKPN | iSeries: No. of Key Positioning Keys (Database Monitor) | QQKPN | QQDEC150 |
QQKS | iSeries: Key Selection (Database Monitor) | QQKS | QQYN |
QQDSS | iSeries: Dataspace Selection (Database Monitor) | QQDSS | QQYN |
QQIDXA | iSeries: Optimizer Advised Index (Database Monitor) | QQIDXA | QQYN |
QQCST | iSeries: Constraint Used (Y/N) (Database Monitor) | QQCST | QQC11 |
QQCSTN | iSeries: Constraint Name (Database Monitor) | QQCSTN | DBINDEX |
QQRCOD | iSeries: Reason Code (Database Monitor) | QQRCODIDC | QQRCOD |
QQTTIM | iSeries: Time for Index Create (Database Monitor) | QQTTIM | QQDEC150 |
QQIDXD | iSeries: Key Fields for the Advised Index | QQIDXD | QQIDXD |
QQLTLN | iSeries: Library Name (Database Monitor) | QQLTLN | |
QQLTFN | iSeries: Table Name (Database Monitor) | QQLTFN | |
QQLPTL | iSeries: Base Library (Database Monitor) | QQLPTL | |
QQLPTF | iSeries: Base Table (Database Monitor) | QQLPTF | |
QQLILN | iSeries: Index Library (Database Monitor) | QQLILN | |
QQLIFN | iSeries: Index Name (Database Monitor) | QQLIFN | |
QQLNTN | iSeries: NLSS Table (Database Monitor) | QQLNTN | |
QQLNLN | iSeries: NLSS Library (Database Monitor) | QQLNLN | |
QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | QQC11 |
QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | QQC12 |
QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | QQC21 |
QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | QQC22 |
QQI1 | iSeries: Reserved Field (Database Monitor) | QQI1 | QQI1 |
QQI2 | iSeries: Reserved Field (Database Monitor) | QQI2 | QQI2 |
QQC301 | iSeries: Reserved Field (Database Monitor) | QQC301 | QQC301 |
QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | |
QQCRTK_LEN | 2 byte integer (signed) | INT2 | INT2 |
QQCRTK | iSeries: Key Fields of Created Index (Database Monitor) | QQCRTK | QQCHAR1000 |
SQ3002_DB4 related tables
Table | Note |
---|---|
SQ3002_DB4 | iSeries: Created Indexes (Database Monitor) |
SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) |
SQ1000_DB4 | iSeries: SQL Information (Database Monitor) |
SQ1000_RST | iSeries: SQL Information (Database Monitor ) |
SQ3000_DB4 | iSeries: Table Scans (Database Monitor) |
SQ3003_DB4 | iSeries: Sorts (Database Monitor) |
SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) |
SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) |
SQ3008_DB4 | iSeries: Subqueries (Database Monitor) |
SQTEXT_DB4 | iSeries: SQL Statement Text (Database Monitor) |
BBPD_TREX_INDEX | BBP TREX Indexes: Assign Business Object -> TREX Indexes |
STRX_LPIXS | Assignment of Physical Indexes to Logical Indexes |
DBSTATIDB6 | DB6: Statistics for Indexes (Application Monitor) |
CRMD_WR_BRF_EXP | Database Table for Created Web Request Expressions |
AMDS | Effective size of tables and indexes in the database |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP