Table/Structure Field list used by SAP ABAP Function Module DB4_TABLE_SCAN_INFO (AS/400: Get table scan info for ST04 Detail Analysis)
SAP ABAP Function Module DB4_TABLE_SCAN_INFO (AS/400: Get table scan info for ST04 Detail Analysis) is using
# Object Type Object Name Object Description Note
     
1 Table/Structure Field  DB4QQPAR - QRESET iSeries: Flag to indicate reset in ST04
2 Table/Structure Field  DB4QQPAR - QRESET iSeries: Flag to indicate reset in ST04 SOURCE VALUE(RESETFLAG) LIKE DB4QQPAR-QRESET DEFAULT SPACE
3 Table/Structure Field  DB4TABLST - QQTFN iSeries: System Name of Table (Database Monitor)
4 Table/Structure Field  DB4TABLST - QQTLN iSeries: System Name of Library (Database Monitor)
5 Table/Structure Field  DB4TSC0100 - QQTLN iSeries: System Name of Library (Database Monitor)
6 Table/Structure Field  DB4TSC0100 - QQTOTR iSeries: Total Rows in Table (Database Monitor)
7 Table/Structure Field  DB4TSC0100 - QQTFN iSeries: System Name of Table (Database Monitor)
8 Table/Structure Field  DB4TSC0100 - QQQRYCNT iSeries: Number of Different Statements (Database Monitor)
9 Table/Structure Field  DB4TSC0100 - QQAVGT iSeries: Average Time (Database Monitor)
10 Table/Structure Field  DB4TSC0100 - QQARSS iSeries: Average Result Set Size (Database Monitor)
11 Table/Structure Field  DB4TSC0200 - QQMINT iSeries: Minimum Time (Database Monitor)
12 Table/Structure Field  DB4TSC0200 - QQPTLN iSeries: System Name of Base Library (Database Monitor)
13 Table/Structure Field  DB4TSC0200 - QQPLIB iSeries: Package/Program Library (Database Monitor)
14 Table/Structure Field  DB4TSC0200 - QQPNAM iSeries: Package/Program Name (Database Monitor)
15 Table/Structure Field  DB4TSC0200 - QQPTFN iSeries: System Name of Base Table (Database Monitor)
16 Table/Structure Field  DB4TSC0200 - QQRCOD iSeries: Reason Code for Table Scan (Database Monitor)
17 Table/Structure Field  DB4TSC0200 - QQSNAM iSeries: Statement Name (Database Monitor)
18 Table/Structure Field  DB4TSC0200 - QQSTTX iSeries: Statement Text (Database Monitor)
19 Table/Structure Field  DB4TSC0200 - QQTFN iSeries: System Name of Table (Database Monitor)
20 Table/Structure Field  DB4TSC0200 - QQTLN iSeries: System Name of Library (Database Monitor)
21 Table/Structure Field  DB4TSC0200 - QQTOTR iSeries: Total Rows in Table (Database Monitor)
22 Table/Structure Field  DB4TSC0200 - QQUSER iSeries: Job User (Database Monitor)
23 Table/Structure Field  DB4TSC0200 - SYSID Name of SAP System
24 Table/Structure Field  DB4TSC0200 - TOTTIME iSeries: Total Time (Database Monitor)
25 Table/Structure Field  DB4TSC0200 - QQMAXT iSeries: Maximum Time (Database Monitor)
26 Table/Structure Field  DB4TSC0200 - QQMETU iSeries: Timest. of Most Expensive Stmt. (Database Monitor)
27 Table/Structure Field  DB4TSC0200 - IPLTIME Text field length 14
28 Table/Structure Field  DB4TSC0200 - QQARSS iSeries: Average Result Set Size (Database Monitor)
29 Table/Structure Field  DB4TSC0200 - QQAVGT iSeries: Average Time (Database Monitor)
30 Table/Structure Field  DB4TSC0200 - QQCNT iSeries: No. of Executions of a Statement (Database Monitor)
31 Table/Structure Field  DB4TSC0200 - QQCTS iSeries: Number of Table Scans (Database Monitor)
32 Table/Structure Field  DB4TSC0200 - QQIDXA iSeries: Optimizer Advised Index (Database Monitor)
33 Table/Structure Field  DB4TSC0200 - QQIDXD iSeries: Definition of Advised Index (Database Monitor)
34 Table/Structure Field  DB4TSC0200 - QQKEY iSeries: Key Field (Database Monitor)
35 Table/Structure Field  DB4TSC0200 - QQLPTF iSeries: Base Table (Database Monitor)
36 Table/Structure Field  DB4TSC0200 - QQLPTL iSeries: Base Library (Database Monitor)
37 Table/Structure Field  DB4TSC0200 - QQLTFN iSeries: Table Name (Database Monitor)
38 Table/Structure Field  DB4TSC0200 - QQLTLN iSeries: Library Name (Database Monitor)
39 Table/Structure Field  DB6NAVSYST - DBCNAME Logical name for a database connection
40 Table/Structure Field  DB6NAVSYST - DBHOST DBA Cockpit: Server Name
41 Table/Structure Field  SQ1000_DB4 - QQARSS iSeries: Average Result Set Size (Database Monitor)
42 Table/Structure Field  SQ1000_DB4 - QQUSER iSeries: Job User (Database Monitor)
43 Table/Structure Field  SQ1000_DB4 - QQSTF iSeries: Statement Function (Database Monitor)
44 Table/Structure Field  SQ1000_DB4 - QQSNAM iSeries: Statement Name (Database Monitor)
45 Table/Structure Field  SQ1000_DB4 - QQPNAM iSeries: Package/Program Name (Database Monitor)
46 Table/Structure Field  SQ1000_DB4 - QQPLIB iSeries: Package/Program Library (Database Monitor)
47 Table/Structure Field  SQ1000_DB4 - QQCTS iSeries: Number of Table Scans (Database Monitor)
48 Table/Structure Field  SQ1000_DB4 - QQCNT iSeries: No. of Executions of a Statement (Database Monitor)
49 Table/Structure Field  SQ1000_DB4 - QQAVGT iSeries: Average Time (Database Monitor)
50 Table/Structure Field  SQ3000_DB4 - QQLTFN iSeries: Table Name (Database Monitor)
51 Table/Structure Field  SQ3000_DB4 - QQLTLN iSeries: Library Name (Database Monitor)
52 Table/Structure Field  SQ3000_DB4 - QQTFN iSeries: System Name of Table (Database Monitor)
53 Table/Structure Field  SQ3000_DB4 - QQTLN iSeries: System Name of Library (Database Monitor)
54 Table/Structure Field  SQ3000_DB4 - QQTOTR iSeries: Total Rows in Table (Database Monitor)
55 Table/Structure Field  SQTEXT_DB4 - QQSTTX_LNG 2 byte integer (signed)
56 Table/Structure Field  SYST - TABIX ABAP System Field: Row Index of Internal Tables