Table/Structure Field list used by SAP ABAP Program RSXPLORA (Subroutine for ORACLE Explain Functions)
SAP ABAP Program
RSXPLORA (Subroutine for ORACLE Explain Functions) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB6NAVSYST - SCHEMANAME | DB6: Schema Name | ||
| 2 | DBCON - CON_NAME | Logical name for a database connection | ||
| 3 | DBORA_SESSION_PARAM - EVENT | DBORA_SESSION_PARAM-EVENT | ||
| 4 | DBORA_SESSION_PARAM - PARAM | DBORA_SESSION_PARAM-PARAM | ||
| 5 | DBORA_SESSION_PARAM - VALUE | DBORA_SESSION_PARAM-VALUE | ||
| 6 | DBPOPHINT - HINT | Text (length 132) | ||
| 7 | DBPOPHINT - TEXTLINE1 | Text Field | ||
| 8 | DBPOPHINT - TEXTLINE2 | Text Field | ||
| 9 | DD02L - TABNAME | Table Name | ||
| 10 | EXPL_PLAN - FORMAT | Single-Character Flag | ||
| 11 | EXPL_PLAN - LINE | Text (length 132) | ||
| 12 | EXPL_VALUE - TYPE | Version Number Component | ||
| 13 | EXPL_VALUE - VALUE | Text, 255 Characters | ||
| 14 | IND_ORA - AVG_DATA_B | Average number of data blocks per key | ||
| 15 | IND_ORA - AVG_LEAF_B | Average number of leaf blocks per key | ||
| 16 | IND_ORA - BLEVEL | B tree level | ||
| 17 | IND_ORA - CLUST_FACT | Clustering factor | ||
| 18 | IND_ORA - DIST_KEYS | Number of distinct keys in index | ||
| 19 | IND_ORA - INDEX_NAME | Index name | ||
| 20 | IND_ORA - LEAF_BLKS | Number of leaf blocks in index | ||
| 21 | IND_ORA - TABLE_NAME | Table Name | ||
| 22 | IND_ORA - UNIQUENESS | Uniqueness | ||
| 23 | LISTE - ZEILE | char120 | ||
| 24 | ORAEXPLPAR - ADDRESS | Address of statement in the cache | ||
| 25 | ORAEXPLPAR - ASHEVENT | ORAEXPLPAR-ASHEVENT | ||
| 26 | ORAEXPLPAR - ASH_SOURCE | ORAEXPLPAR-ASH_SOURCE | ||
| 27 | ORAEXPLPAR - CHILD_NUMBER | Child Cursor Number | ||
| 28 | ORAEXPLPAR - CON_NAME | Logical name for a database connection | ||
| 29 | ORAEXPLPAR - FLAGS | Field Name | ||
| 30 | ORAEXPLPAR - HASH_VALUE | Hash value of statement | ||
| 31 | ORAEXPLPAR - HIST_BEGIN_TS | Start of the DBA action | ||
| 32 | ORAEXPLPAR - HIST_END_TS | Start of the DBA action | ||
| 33 | ORAEXPLPAR - INST_ID | Oracle Instance ID | ||
| 34 | ORAEXPLPAR - PLAN_HASH_VALUE | ORAEXPLPAR-PLAN_HASH_VALUE | ||
| 35 | ORAEXPLPAR - SQL_ID | ORAEXPLPAR-SQL_ID | ||
| 36 | SEUCOMM - ID | Internal: Node ID | ||
| 37 | SEUCOMM - TEXT | Text/icon/symbol | ||
| 38 | SEUCOMM - TEXT1 | Text/icon/symbol | ||
| 39 | SEUCOMM - TEXT2 | Text/icon/symbol | ||
| 40 | SNODETEXT - COLOR | Color display of a hierarchy node | ||
| 41 | SNODETEXT - HOTSPOT | Single-Character Flag | ||
| 42 | SNODETEXT - HOTSPOT1 | Single-Character Flag | ||
| 43 | SNODETEXT - HOTSPOT2 | Single-Character Flag | ||
| 44 | SNODETEXT - HOTSPOT3 | Single-Character Flag | ||
| 45 | SNODETEXT - HOTSPOT4 | Single-Character Flag | ||
| 46 | SNODETEXT - HOTSPOT5 | Single-Character Flag | ||
| 47 | SNODETEXT - HOTSPOT6 | Single-Character Flag | ||
| 48 | SNODETEXT - HOTSPOT7 | Single-Character Flag | ||
| 49 | SNODETEXT - HOTSPOT8 | Single-Character Flag | ||
| 50 | SNODETEXT - HOTSPOT9 | Single-Character Flag | ||
| 51 | SNODETEXT - INTENSIV | Intensity of display | ||
| 52 | SNODETEXT - MOREINFO | Flage: Additional information about nodes exists | ||
| 53 | SNODETEXT - NAME | Object name | ||
| 54 | SNODETEXT - TCOLOR | Color display of a hierarchy node | ||
| 55 | SNODETEXT - TCOLOR1 | Color display of a hierarchy node | ||
| 56 | SNODETEXT - TCOLOR2 | Color display of a hierarchy node | ||
| 57 | SNODETEXT - TCOLOR3 | Color display of a hierarchy node | ||
| 58 | SNODETEXT - TCOLOR4 | Color display of a hierarchy node | ||
| 59 | SNODETEXT - TCOLOR5 | Color display of a hierarchy node | ||
| 60 | SNODETEXT - TCOLOR6 | Color display of a hierarchy node | ||
| 61 | SNODETEXT - TCOLOR7 | Color display of a hierarchy node | ||
| 62 | SNODETEXT - TCOLOR8 | Color display of a hierarchy node | ||
| 63 | SNODETEXT - TCOLOR9 | Color display of a hierarchy node | ||
| 64 | SNODETEXT - TEXT | Text/icon/symbol | ||
| 65 | SNODETEXT - TEXT1 | Text/icon/symbol | ||
| 66 | SNODETEXT - TEXT2 | Text/icon/symbol | ||
| 67 | SNODETEXT - TEXT3 | Text/icon/symbol | ||
| 68 | SNODETEXT - TEXT4 | Text/icon/symbol | ||
| 69 | SNODETEXT - TEXT5 | Text/icon/symbol | ||
| 70 | SNODETEXT - TEXT6 | Text/icon/symbol | ||
| 71 | SNODETEXT - TEXT7 | Text/icon/symbol | ||
| 72 | SNODETEXT - TEXT8 | Text/icon/symbol | ||
| 73 | SNODETEXT - TEXT9 | Text/icon/symbol | ||
| 74 | SNODETEXT - TINTENSIV | Intensity of display | ||
| 75 | SNODETEXT - TINTENSIV1 | Intensity of display | ||
| 76 | SNODETEXT - TINTENSIV2 | Intensity of display | ||
| 77 | SNODETEXT - TINTENSIV3 | Intensity of display | ||
| 78 | SNODETEXT - TLENGTH | Output length of a hierarchy node | ||
| 79 | SNODETEXT - TLENGTH1 | Output length of a hierarchy node | ||
| 80 | SNODETEXT - TLENGTH2 | Output length of a hierarchy node | ||
| 81 | SNODETEXT - TLENGTH3 | Output length of a hierarchy node | ||
| 82 | SNODETEXT - TLENGTH4 | Output length of a hierarchy node | ||
| 83 | SNODETEXT - TLENGTH5 | Output length of a hierarchy node | ||
| 84 | SNODETEXT - TLENGTH6 | Output length of a hierarchy node | ||
| 85 | SNODETEXT - TLENGTH7 | Output length of a hierarchy node | ||
| 86 | SNODETEXT - TLENGTH8 | Output length of a hierarchy node | ||
| 87 | SNODETEXT - TLENGTH9 | Output length of a hierarchy node | ||
| 88 | SNODETEXT - TLEVEL | Node level | ||
| 89 | STREEATTR - COLOR | Color display of a hierarchy node | ||
| 90 | STREEATTR - HOTSPOT | Single-Character Flag | ||
| 91 | STREEATTR - HOTSPOT1 | Single-Character Flag | ||
| 92 | STREEATTR - HOTSPOT2 | Single-Character Flag | ||
| 93 | STREEATTR - HOTSPOT3 | Single-Character Flag | ||
| 94 | STREEATTR - HOTSPOT4 | Single-Character Flag | ||
| 95 | STREEATTR - HOTSPOT5 | Single-Character Flag | ||
| 96 | STREEATTR - HOTSPOT6 | Single-Character Flag | ||
| 97 | STREEATTR - HOTSPOT7 | Single-Character Flag | ||
| 98 | STREEATTR - HOTSPOT8 | Single-Character Flag | ||
| 99 | STREEATTR - HOTSPOT9 | Single-Character Flag | ||
| 100 | STREEATTR - INTENSIV | Intensity of display | ||
| 101 | STREEATTR - MOREINFO | Flage: Additional information about nodes exists | ||
| 102 | STREEATTR - TCOLOR | Color display of a hierarchy node | ||
| 103 | STREEATTR - TCOLOR1 | Color display of a hierarchy node | ||
| 104 | STREEATTR - TCOLOR2 | Color display of a hierarchy node | ||
| 105 | STREEATTR - TCOLOR3 | Color display of a hierarchy node | ||
| 106 | STREEATTR - TCOLOR4 | Color display of a hierarchy node | ||
| 107 | STREEATTR - TCOLOR5 | Color display of a hierarchy node | ||
| 108 | STREEATTR - TCOLOR6 | Color display of a hierarchy node | ||
| 109 | STREEATTR - TCOLOR7 | Color display of a hierarchy node | ||
| 110 | STREEATTR - TCOLOR8 | Color display of a hierarchy node | ||
| 111 | STREEATTR - TCOLOR9 | Color display of a hierarchy node | ||
| 112 | STREEATTR - TEXT | Text/icon/symbol | ||
| 113 | STREEATTR - TEXT1 | Text/icon/symbol | ||
| 114 | STREEATTR - TEXT2 | Text/icon/symbol | ||
| 115 | STREEATTR - TEXT3 | Text/icon/symbol | ||
| 116 | STREEATTR - TEXT4 | Text/icon/symbol | ||
| 117 | STREEATTR - TEXT5 | Text/icon/symbol | ||
| 118 | STREEATTR - TEXT6 | Text/icon/symbol | ||
| 119 | STREEATTR - TEXT7 | Text/icon/symbol | ||
| 120 | STREEATTR - TEXT8 | Text/icon/symbol | ||
| 121 | STREEATTR - TEXT9 | Text/icon/symbol | ||
| 122 | STREEATTR - TINTENSIV | Intensity of display | ||
| 123 | STREEATTR - TINTENSIV1 | Intensity of display | ||
| 124 | STREEATTR - TINTENSIV2 | Intensity of display | ||
| 125 | STREEATTR - TINTENSIV3 | Intensity of display | ||
| 126 | STREEATTR - TLENGTH | Output length of a hierarchy node | ||
| 127 | STREEATTR - TLENGTH1 | Output length of a hierarchy node | ||
| 128 | STREEATTR - TLENGTH2 | Output length of a hierarchy node | ||
| 129 | STREEATTR - TLENGTH3 | Output length of a hierarchy node | ||
| 130 | STREEATTR - TLENGTH4 | Output length of a hierarchy node | ||
| 131 | STREEATTR - TLENGTH5 | Output length of a hierarchy node | ||
| 132 | STREEATTR - TLENGTH6 | Output length of a hierarchy node | ||
| 133 | STREEATTR - TLENGTH7 | Output length of a hierarchy node | ||
| 134 | STREEATTR - TLENGTH8 | Output length of a hierarchy node | ||
| 135 | STREEATTR - TLENGTH9 | Output length of a hierarchy node | ||
| 136 | STREENODE - ID | Internal: Node ID | ||
| 137 | STREENODE - NAME | Object name | ||
| 138 | STREENODE - TLEVEL | Node level | ||
| 139 | SYST - CPAGE | ABAP System Field: Current Page Number of List | ||
| 140 | SYST - CUCOL | ABAP System Field: Horizontal Cursor Position in PAI | ||
| 141 | SYST - CUROW | ABAP System Field: Vertical Cursor Position in PAI | ||
| 142 | SYST - DBCNT | ABAP System Field: Edited Database Table Rows | ||
| 143 | SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | ||
| 144 | SYST - INDEX | ABAP System Field: Loop Index | ||
| 145 | SYST - LSIND | ABAP System Field: Current List Level | ||
| 146 | SYST - PFKEY | ABAP System Field: Current GUI Status | ||
| 147 | SYST - SROWS | ABAP System Field: Number of Screen Rows | ||
| 148 | SYST - SYSID | ABAP System Field: Name of SAP System | ||
| 149 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 150 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 151 | SYST - VLINE | ABAP System Field: Vertical Line for List | ||
| 152 | TAB_ORA - AVG_ROW_LN | Average row length | ||
| 153 | TAB_ORA - AVG_SPACE | Average space | ||
| 154 | TAB_ORA - BLOCKS | Blocks used | ||
| 155 | TAB_ORA - CHAIN_CNT | Chain count | ||
| 156 | TAB_ORA - EMPTY_BLKS | Empty blocks | ||
| 157 | TAB_ORA - NUM_ROWS | Number of rows | ||
| 158 | TAB_ORA - TABLE_NAME | Table Name | ||
| 159 | TAORA - TABSPACE | Tablespace Name |