Table/Structure Field list used by SAP ABAP Program RSORA00E_REFR_DATA (Include RSORA00E_REFR_DATA FORMs for refreshing all analysis data)
SAP ABAP Program 
RSORA00E_REFR_DATA (Include RSORA00E_REFR_DATA FORMs for refreshing all analysis data) is using
-
Class (1)
-
Data Element (2)
-
Table/Structure Field (150)
-
Function Module (4)
-
Message Class (1)
-
Message Number (1)
-
Class Method (1)
-
Table (7)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
ORA_SNAPSHOT - ORA_SYSDATE_D | Oracle system date of snapshot | |
| 2 | Table/Structure Field |
ORA_SNAPSHOT - ORA_SYSDATE_T | Oracle system time of snapshot | |
| 3 | Table/Structure Field |
ORA_SNAPSHOT - SNAPSHOT_ID | Oracle monitor: snapshot ID | |
| 4 | Table/Structure Field |
ST04N_CHAR - DB_ELAPSED | Elapsed time since db start in sec. | |
| 5 | Table/Structure Field |
ST04N_CHAR - DB_INSTANCE | Name of the current database instance | |
| 6 | Table/Structure Field |
ST04N_CHAR - DB_INST_ID | Instance ID | |
| 7 | Table/Structure Field |
ST04N_CHAR - DB_NODE | Current Database node (host name) | |
| 8 | Table/Structure Field |
ST04N_CHAR - DB_RELEASE | Database release | |
| 9 | Table/Structure Field |
ST04N_CHAR - DB_SNAPDIFF | Seconds between two snapshots | |
| 10 | Table/Structure Field |
ST04N_CHAR - DB_STARTDATE | Startup date of the data base | |
| 11 | Table/Structure Field |
ST04N_CHAR - DB_STARTTIME | Startup time of the DB | |
| 12 | Table/Structure Field |
ST04N_CHAR - DB_STARTUP_TIMESTAMP | Startup timestamp | |
| 13 | Table/Structure Field |
ST04N_CHAR - DB_SYSDATE | System date of the data base | |
| 14 | Table/Structure Field |
ST04N_CHAR - DB_SYSTIME | Time from the db system time stamp | |
| 15 | Table/Structure Field |
ST04N_CHAR - DB_SYS_TIMESTAMP | Current Day and Time from DB system | |
| 16 | Table/Structure Field |
ST04N_DATA - CLL_PARSECNT | Parse count | |
| 17 | Table/Structure Field |
ST04N_DATA - CLL_RDS_PER_UCLL | Logical reads per user call | |
| 18 | Table/Structure Field |
ST04N_DATA - CLL_RECURSIVE | Recursive calls | |
| 19 | Table/Structure Field |
ST04N_DATA - CLL_USERCALLS | User calls | |
| 20 | Table/Structure Field |
ST04N_DATA - CLL_USERCOMM | User commits | |
| 21 | Table/Structure Field |
ST04N_DATA - CLL_USERROLLB | User rollbacks | |
| 22 | Table/Structure Field |
ST04N_DATA - CLL_USR_PER_RCCLL | User calls per recursive call | |
| 23 | Table/Structure Field |
ST04N_DATA - DATABUFFERSIZE | Data buffer size in kB | |
| 24 | Table/Structure Field |
ST04N_DATA - DBUFF_BUSYWAITS | Buffer busy waits | |
| 25 | Table/Structure Field |
ST04N_DATA - DBUFF_LOGREADS | Logical Reads | |
| 26 | Table/Structure Field |
ST04N_DATA - DBUFF_PHYSREADS | Physical reads | |
| 27 | Table/Structure Field |
ST04N_DATA - DBUFF_PHYSWRITES | Physical writes | |
| 28 | Table/Structure Field |
ST04N_DATA - DBUFF_QUALITY | Data buffer quality | |
| 29 | Table/Structure Field |
ST04N_DATA - DBUFF_WAITTIME | Buffer wait time in sec. | |
| 30 | Table/Structure Field |
ST04N_DATA - DB_ELAPSED | Elapsed time since db start in sec. | |
| 31 | Table/Structure Field |
ST04N_DATA - DB_INSTANCE | Name of the current database instance | |
| 32 | Table/Structure Field |
ST04N_DATA - DB_INST_ID | Instance ID | |
| 33 | Table/Structure Field |
ST04N_DATA - DB_NODE | Current Database node (host name) | |
| 34 | Table/Structure Field |
ST04N_DATA - DB_RELEASE | Database release | |
| 35 | Table/Structure Field |
ST04N_DATA - DB_SNAPDIFF | Seconds between two snapshots | |
| 36 | Table/Structure Field |
ST04N_DATA - DB_STARTDATE | Startup date of the data base | |
| 37 | Table/Structure Field |
ST04N_DATA - DB_STARTTIME | Startup time of the DB | |
| 38 | Table/Structure Field |
ST04N_DATA - DB_STARTUP_TIMESTAMP | Startup timestamp | |
| 39 | Table/Structure Field |
ST04N_DATA - DB_SYSDATE | System date of the data base | |
| 40 | Table/Structure Field |
ST04N_DATA - DB_SYSTIME | Time from the db system time stamp | |
| 41 | Table/Structure Field |
ST04N_DATA - DB_SYS_TIMESTAMP | Current Day and Time from DB system | |
| 42 | Table/Structure Field |
ST04N_DATA - IEFF_INMEM_SORT | In-memory sort ratio | |
| 43 | Table/Structure Field |
ST04N_DATA - IEFF_PARSCPUTOTOT | Parse CPU to total CPU ratio | |
| 44 | Table/Structure Field |
ST04N_DATA - IEFF_PARSTOEXEC | Parse to execute ratio | |
| 45 | Table/Structure Field |
ST04N_DATA - IEFF_PTCPU_PTELPS | Parse time CPU to parse time elapsed | |
| 46 | Table/Structure Field |
ST04N_DATA - IEFF_SOFTPARSE | Soft parse ratio | |
| 47 | Table/Structure Field |
ST04N_DATA - LGBF_ALLOFRAT | Allocation fault rate in % | |
| 48 | Table/Structure Field |
ST04N_DATA - LGBF_ALLORETR | Allocation retries | |
| 49 | Table/Structure Field |
ST04N_DATA - LGBF_ENTRIES | Log buffer entries | |
| 50 | Table/Structure Field |
ST04N_DATA - LGBF_LOGFILES | Number of log files | |
| 51 | Table/Structure Field |
ST04N_DATA - LGBF_LOGFUSE | Number of log files in use | |
| 52 | Table/Structure Field |
ST04N_DATA - LGBF_REDLGWT | Redo log wait in sec. | |
| 53 | Table/Structure Field |
ST04N_DATA - LGBF_SIZE | Log buffer size in kB | |
| 54 | Table/Structure Field |
ST04N_DATA - RDLG_LTCHTIM | Latching time in sec. | |
| 55 | Table/Structure Field |
ST04N_DATA - RDLG_MBWRITTEN | Megabytes written | |
| 56 | Table/Structure Field |
ST04N_DATA - RDLG_OSBLCKWRT | OS blocks written | |
| 57 | Table/Structure Field |
ST04N_DATA - RDLG_WRITES | Redo writes | |
| 58 | Table/Structure Field |
ST04N_DATA - RDLG_WRTTIM | Redo write time in sec. | |
| 59 | Table/Structure Field |
ST04N_DATA - SHPL_CAQUAL | DD-cache quality in % | |
| 60 | Table/Structure Field |
ST04N_DATA - SHPL_GETRATIO | SQL area getratio in % | |
| 61 | Table/Structure Field |
ST04N_DATA - SHPL_PINRATIO | SQL area pinratio in % | |
| 62 | Table/Structure Field |
ST04N_DATA - SHPL_RELOADSPINS | SQL area reloads / pins in % | |
| 63 | Table/Structure Field |
ST04N_DATA - SHPL_SIZE | Shared pool size in kB | |
| 64 | Table/Structure Field |
ST04N_DATA - SORT_DISK | Sorts on disk | |
| 65 | Table/Structure Field |
ST04N_DATA - SORT_MEMORY | Sorts in memory | |
| 66 | Table/Structure Field |
ST04N_DATA - SORT_ROWS | Rows sorted | |
| 67 | Table/Structure Field |
ST04N_DATA - SORT_WAEXMULTP | Workarea execution in multipass mode | |
| 68 | Table/Structure Field |
ST04N_DATA - SORT_WAEXONEP | Workarea execution in one pass mode | |
| 69 | Table/Structure Field |
ST04N_DATA - SORT_WAEXOPT | Workarea execution in optimal mode | |
| 70 | Table/Structure Field |
ST04N_DATA - TABSF_FBYCONTROW | Table fetch by continued row | |
| 71 | Table/Structure Field |
ST04N_DATA - TABSF_FBYROWID | Table fetch by rowid | |
| 72 | Table/Structure Field |
ST04N_DATA - TABSF_LGTABSCAN | Long table scans | |
| 73 | Table/Structure Field |
ST04N_DATA - TABSF_SHTABSCAN | Short table scans | |
| 74 | Table/Structure Field |
ST04N_DATA - TIMS_BUSYWT | Busy wait time in seconds | |
| 75 | Table/Structure Field |
ST04N_DATA - TIMS_CPUCOUNT | CPU count / Number of CPUs | |
| 76 | Table/Structure Field |
ST04N_DATA - TIMS_CPUTIME | CPU time used by this session | |
| 77 | Table/Structure Field |
ST04N_DATA - TIMS_CPUUSAGE | CPU usage % | |
| 78 | Table/Structure Field |
ST04N_DATA - TIMS_SESS_BUSY | Session busy % | |
| 79 | Table/Structure Field |
ST04N_DATA - TIMS_TIM_PER_UCLL | Time per user call in msec. | |
| 80 | Table/Structure Field |
ST04N_KYF - CLL_PARSECNT | Parse count | |
| 81 | Table/Structure Field |
ST04N_KYF - CLL_RDS_PER_UCLL | Logical reads per user call | |
| 82 | Table/Structure Field |
ST04N_KYF - CLL_RECURSIVE | Recursive calls | |
| 83 | Table/Structure Field |
ST04N_KYF - CLL_USERCALLS | User calls | |
| 84 | Table/Structure Field |
ST04N_KYF - CLL_USERCOMM | User commits | |
| 85 | Table/Structure Field |
ST04N_KYF - CLL_USERROLLB | User rollbacks | |
| 86 | Table/Structure Field |
ST04N_KYF - CLL_USR_PER_RCCLL | User calls per recursive call | |
| 87 | Table/Structure Field |
ST04N_KYF - DATABUFFERSIZE | Data buffer size in kB | |
| 88 | Table/Structure Field |
ST04N_KYF - DBUFF_BUSYWAITS | Buffer busy waits | |
| 89 | Table/Structure Field |
ST04N_KYF - DBUFF_LOGREADS | Logical Reads | |
| 90 | Table/Structure Field |
ST04N_KYF - DBUFF_PHYSREADS | Physical reads | |
| 91 | Table/Structure Field |
ST04N_KYF - DBUFF_PHYSWRITES | Physical writes | |
| 92 | Table/Structure Field |
ST04N_KYF - DBUFF_QUALITY | Data buffer quality | |
| 93 | Table/Structure Field |
ST04N_KYF - DBUFF_WAITTIME | Buffer wait time in sec. | |
| 94 | Table/Structure Field |
ST04N_KYF - IEFF_INMEM_SORT | In-memory sort ratio | |
| 95 | Table/Structure Field |
ST04N_KYF - IEFF_PARSCPUTOTOT | Parse CPU to total CPU ratio | |
| 96 | Table/Structure Field |
ST04N_KYF - IEFF_PARSTOEXEC | Parse to execute ratio | |
| 97 | Table/Structure Field |
ST04N_KYF - IEFF_PTCPU_PTELPS | Parse time CPU to parse time elapsed | |
| 98 | Table/Structure Field |
ST04N_KYF - IEFF_SOFTPARSE | Soft parse ratio | |
| 99 | Table/Structure Field |
ST04N_KYF - LGBF_ALLOFRAT | Allocation fault rate in % | |
| 100 | Table/Structure Field |
ST04N_KYF - LGBF_ALLORETR | Allocation retries | |
| 101 | Table/Structure Field |
ST04N_KYF - LGBF_ENTRIES | Log buffer entries | |
| 102 | Table/Structure Field |
ST04N_KYF - LGBF_LOGFILES | Number of log files | |
| 103 | Table/Structure Field |
ST04N_KYF - LGBF_LOGFUSE | Number of log files in use | |
| 104 | Table/Structure Field |
ST04N_KYF - LGBF_REDLGWT | Redo log wait in sec. | |
| 105 | Table/Structure Field |
ST04N_KYF - LGBF_SIZE | Log buffer size in kB | |
| 106 | Table/Structure Field |
ST04N_KYF - RDLG_LTCHTIM | Latching time in sec. | |
| 107 | Table/Structure Field |
ST04N_KYF - RDLG_MBWRITTEN | Megabytes written | |
| 108 | Table/Structure Field |
ST04N_KYF - RDLG_OSBLCKWRT | OS blocks written | |
| 109 | Table/Structure Field |
ST04N_KYF - RDLG_WRITES | Redo writes | |
| 110 | Table/Structure Field |
ST04N_KYF - RDLG_WRTTIM | Redo write time in sec. | |
| 111 | Table/Structure Field |
ST04N_KYF - SHPL_CAQUAL | DD-cache quality in % | |
| 112 | Table/Structure Field |
ST04N_KYF - SHPL_GETRATIO | SQL area getratio in % | |
| 113 | Table/Structure Field |
ST04N_KYF - SHPL_PINRATIO | SQL area pinratio in % | |
| 114 | Table/Structure Field |
ST04N_KYF - SHPL_RELOADSPINS | SQL area reloads / pins in % | |
| 115 | Table/Structure Field |
ST04N_KYF - SHPL_SIZE | Shared pool size in kB | |
| 116 | Table/Structure Field |
ST04N_KYF - SORT_DISK | Sorts on disk | |
| 117 | Table/Structure Field |
ST04N_KYF - SORT_MEMORY | Sorts in memory | |
| 118 | Table/Structure Field |
ST04N_KYF - SORT_ROWS | Rows sorted | |
| 119 | Table/Structure Field |
ST04N_KYF - SORT_WAEXMULTP | Workarea execution in multipass mode | |
| 120 | Table/Structure Field |
ST04N_KYF - SORT_WAEXONEP | Workarea execution in one pass mode | |
| 121 | Table/Structure Field |
ST04N_KYF - SORT_WAEXOPT | Workarea execution in optimal mode | |
| 122 | Table/Structure Field |
ST04N_KYF - TABSF_FBYCONTROW | Table fetch by continued row | |
| 123 | Table/Structure Field |
ST04N_KYF - TABSF_FBYROWID | Table fetch by rowid | |
| 124 | Table/Structure Field |
ST04N_KYF - TABSF_LGTABSCAN | Long table scans | |
| 125 | Table/Structure Field |
ST04N_KYF - TABSF_SHTABSCAN | Short table scans | |
| 126 | Table/Structure Field |
ST04N_KYF - TIMS_BUSYWT | Busy wait time in seconds | |
| 127 | Table/Structure Field |
ST04N_KYF - TIMS_CPUCOUNT | CPU count / Number of CPUs | |
| 128 | Table/Structure Field |
ST04N_KYF - TIMS_CPUTIME | CPU time used by this session | |
| 129 | Table/Structure Field |
ST04N_KYF - TIMS_CPUUSAGE | CPU usage % | |
| 130 | Table/Structure Field |
ST04N_KYF - TIMS_SESS_BUSY | Session busy % | |
| 131 | Table/Structure Field |
ST04N_KYF - TIMS_TIM_PER_UCLL | Time per user call in msec. | |
| 132 | Table/Structure Field |
ST04N_LIM - FIELDNAME | Field Name | |
| 133 | Table/Structure Field |
ST04N_LIM - LIMIT_RED | Difference limit in % for displaying a key figure in yellow | |
| 134 | Table/Structure Field |
ST04N_LIM - LIMIT_YELLOW | Difference limit in % for displaying a key figure in yellow | |
| 135 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 136 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 137 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 138 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 139 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 140 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 141 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable | |
| 142 | Table/Structure Field |
T006 - ISOCODE | ISO code for unit of measurement | |
| 143 | Table/Structure Field |
T006 - MSEHI | Unit of Measurement | |
| 144 | Table/Structure Field |
TREEMSNOD - NODE_KEY | Tree Model: Node Key | |
| 145 | Table/Structure Field |
TREEMSNOD - N_IMAGE | Tree Control: Icon / Image | |
| 146 | Table/Structure Field |
TREEMSNODT - NODE_KEY | Tree Model: Node Key | |
| 147 | Table/Structure Field |
TREEMSNODT - N_IMAGE | Tree Control: Icon / Image | |
| 148 | Table/Structure Field |
TREEMSUNO - N_IMAGE | Tree Control: Icon / Image | |
| 149 | Table/Structure Field |
TREEMSUNO - U_N_IMAGE | Flag (X or Blank) | |
| 150 | Table/Structure Field |
TREEMUNOFL - U_N_IMAGE | Flag (X or Blank) |
