Table/Structure Field list used by SAP ABAP Class CL_DB4_LIST_SYSIXADV (iSeries: SQE Index Advised Information)
SAP ABAP Class 
CL_DB4_LIST_SYSIXADV (iSeries: SQE Index Advised Information) is using
-
Class (30)
-
Data Element (3)
-
Table/Structure Field (89)
-
Function Module (2)
-
Message Class (4)
-
Message Number (5)
-
Class Method (34)
-
Table (27)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | |
| 2 | Table/Structure Field |
ALV_S_FCAT - INTLEN | Internal Length in Bytes | |
| 3 | Table/Structure Field |
ALV_S_FCAT - KEY | ALV control: Key field | |
| 4 | Table/Structure Field |
ALV_S_FCAT - NO_OUT | ALV control: Column is not output | |
| 5 | Table/Structure Field |
ALV_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | |
| 6 | Table/Structure Field |
ALV_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | |
| 7 | Table/Structure Field |
ALV_S_FCAT - COL_POS | ALV control: Output column | |
| 8 | Table/Structure Field |
ALV_S_SORT - DOWN | Single-Character Flag | |
| 9 | Table/Structure Field |
ALV_S_SORT - FIELDNAME | ALV control: Field name of internal table field | |
| 10 | Table/Structure Field |
ALV_S_SORT - SPOS | Sort sequence | |
| 11 | Table/Structure Field |
DB4QQPAR - BOOLIAN | Variable of data type boolian | |
| 12 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 13 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 14 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 15 | Table/Structure Field |
DB4QQPAR - QRESET | iSeries: Flag to indicate reset in ST04 | |
| 16 | Table/Structure Field |
DB4QQPAR - BOOLIAN | Variable of data type boolian | |
| 17 | Table/Structure Field |
DB4QQPAR - BOOLIAN | Variable of data type boolian | |
| 18 | Table/Structure Field |
DB4QQPAR - BOOLIAN | Variable of data type boolian | |
| 19 | Table/Structure Field |
DB4SYSIXADV - KEY_COLS_ADVISED | DB4SYSIXADV-KEY_COLS_ADVISED | |
| 20 | Table/Structure Field |
DB4SYSIXADV - TIMES_ADVISED | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 21 | Table/Structure Field |
DB4SYSIXADV - TABLE_SIZE | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 22 | Table/Structure Field |
DB4SYSIXADV - TABLE_SCHEMA | iSeries: SQL schema name of table or view | |
| 23 | Table/Structure Field |
DB4SYSIXADV - TABLE_NAME | Table name | |
| 24 | Table/Structure Field |
DB4SYSIXADV - RECORD_NUMBER | iSeries: Number of rows / object size | |
| 25 | Table/Structure Field |
DB4SYSIXADV - RECORD_NUMBER | iSeries: Number of rows / object size | |
| 26 | Table/Structure Field |
DB4SYSIXADV - REASON_ADVISED | Character field length 24 | |
| 27 | Table/Structure Field |
DB4SYSIXADV - MTI_CREATED | Natural number | |
| 28 | Table/Structure Field |
DB4SYSIXADV - MOST_EXP_QUERY | Natural number | |
| 29 | Table/Structure Field |
DB4SYSIXADV - LAST_ADVISED | iSeries: Record Creation Timestamp (Database Monitor) | |
| 30 | Table/Structure Field |
DB4SYSIXADV - AVG_QUERY_EST | Natural number | |
| 31 | Table/Structure Field |
DB4SYSIXADV - INDEX_TYPE | Text field length 14 | |
| 32 | Table/Structure Field |
DB4SYSIXADV - AVG_QUERY_EST_MICR | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 33 | Table/Structure Field |
DB4SYSIXADV - PARTITION_NAME | DB2/400: Name of a Table Partition | |
| 34 | Table/Structure Field |
DB4_TIMESTAMP - TIME | DB4_TIMESTAMP-TIME | |
| 35 | Table/Structure Field |
DB4_TIMESTAMP - DATE | DB4_TIMESTAMP-DATE | |
| 36 | Table/Structure Field |
DB6NAVCTRL - CURRSYST | DB6NAVCTRL-CURRSYST | |
| 37 | Table/Structure Field |
DB6NAVCTRL - CURRSYST | DB6NAVCTRL-CURRSYST | |
| 38 | Table/Structure Field |
DB6NAVCTRL - CURRSYST | DB6NAVCTRL-CURRSYST | |
| 39 | Table/Structure Field |
DB6NAVSYST - SCHEMANAME | DB6: Schema Name | |
| 40 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 41 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 42 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 43 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 44 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 45 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 46 | Table/Structure Field |
DB6NAVSYST - DBHOST | DBA Cockpit: Server Name | |
| 47 | Table/Structure Field |
DB6NAVSYST - DBCNAME | Logical name for a database connection | |
| 48 | Table/Structure Field |
DB6NAVSYST - DBREL | DB6: Database Release Level | |
| 49 | Table/Structure Field |
DD02L - TABNAME | Table Name | |
| 50 | Table/Structure Field |
DD02L - TABNAME | Table Name | |
| 51 | Table/Structure Field |
LVC_S_FCAT - NO_OUT | ALV control: Column is not output | |
| 52 | Table/Structure Field |
LVC_S_FCAT - TOOLTIP | ALV control: Tool tip for column header | |
| 53 | Table/Structure Field |
LVC_S_FCAT - SCRTEXT_S | Short Field Label | |
| 54 | Table/Structure Field |
LVC_S_FCAT - SCRTEXT_M | Medium Field Label | |
| 55 | Table/Structure Field |
LVC_S_FCAT - SCRTEXT_L | Long Field Label | |
| 56 | Table/Structure Field |
LVC_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | |
| 57 | Table/Structure Field |
LVC_S_FCAT - KEY | ALV control: Key field | |
| 58 | Table/Structure Field |
LVC_S_FCAT - INTLEN | Internal Length in Bytes | |
| 59 | Table/Structure Field |
LVC_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | |
| 60 | Table/Structure Field |
LVC_S_FCAT - COL_POS | ALV control: Output column | |
| 61 | Table/Structure Field |
LVC_S_FCAT - COLTEXT | ALV control: Column heading | |
| 62 | Table/Structure Field |
LVC_S_L002 - GRID_TITLE | ALV Control: Title bar text | |
| 63 | Table/Structure Field |
LVC_S_L005 - KEYHOT | ALV control: Key columns as hotspot | |
| 64 | Table/Structure Field |
LVC_S_LAYO - GRID_TITLE | ALV Control: Title bar text | |
| 65 | Table/Structure Field |
LVC_S_LAYO - KEYHOT | ALV control: Key columns as hotspot | |
| 66 | Table/Structure Field |
LVC_S_ROID - ROW_ID | Natural number | |
| 67 | Table/Structure Field |
LVC_S_SORT - DOWN | Single-Character Flag | |
| 68 | Table/Structure Field |
LVC_S_SORT - SPOS | Sort sequence | |
| 69 | Table/Structure Field |
LVC_S_SORT - FIELDNAME | ALV control: Field name of internal table field | |
| 70 | Table/Structure Field |
SQIXADVDB4 - MOST_EXP_QUERY | Natural number | |
| 71 | Table/Structure Field |
SQIXADVDB4 - TIMES_ADVISED | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 72 | Table/Structure Field |
SQIXADVDB4 - TABLE_SIZE | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 73 | Table/Structure Field |
SQIXADVDB4 - TABLE_SCHEMA | iSeries: SQL schema name of table or view | |
| 74 | Table/Structure Field |
SQIXADVDB4 - TABLE_NAME | Table name | |
| 75 | Table/Structure Field |
SQIXADVDB4 - REASON_ADVISED | iSeries: Reason Code for Used Index (Database Monitor) | |
| 76 | Table/Structure Field |
SQIXADVDB4 - PARTITION_NAME | DB2/400: Name of a Table Partition | |
| 77 | Table/Structure Field |
SQIXADVDB4 - NLSS_TABLESCHEMA | iSeries: SQL schema name of table or view | |
| 78 | Table/Structure Field |
SQIXADVDB4 - NLSS_TABLENAME | iSeries: iSeries system name of table or view | |
| 79 | Table/Structure Field |
SQIXADVDB4 - MTI_USED | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 80 | Table/Structure Field |
SQIXADVDB4 - MTI_CREATED | Natural number | |
| 81 | Table/Structure Field |
SQIXADVDB4 - LOGICAL_PAGESIZE | Natural number | |
| 82 | Table/Structure Field |
SQIXADVDB4 - LEADING_COL_KEYS | SQIXADVDB4-LEADING_COL_KEYS | |
| 83 | Table/Structure Field |
SQIXADVDB4 - LAST_MTI_USED | iSeries: Record Creation Timestamp (Database Monitor) | |
| 84 | Table/Structure Field |
SQIXADVDB4 - LAST_ADVISED | iSeries: Record Creation Timestamp (Database Monitor) | |
| 85 | Table/Structure Field |
SQIXADVDB4 - KEY_COLS_ADVISED | SQIXADVDB4-KEY_COLS_ADVISED | |
| 86 | Table/Structure Field |
SQIXADVDB4 - INDEX_TYPE | Text field length 14 | |
| 87 | Table/Structure Field |
SQIXADVDB4 - EST_CREATE_TIME | Natural number | |
| 88 | Table/Structure Field |
SQIXADVDB4 - AVG_QUERY_EST_MICR | Alt. Type for INT8 (-9223372036854775808..922337203685476) | |
| 89 | Table/Structure Field |
SQIXADVDB4 - AVG_QUERY_EST | Natural number |
