Table/Structure Field list used by SAP ABAP Program RSORATAB (DB02 (Oracle): Tables and Indexes: Detailed Analysis (Report))
SAP ABAP Program 
RSORATAB (DB02 (Oracle): Tables and Indexes: Detailed Analysis (Report)) is using
-
Table/Structure Field (128)
-
Function Module (7)
-
Message Class (1)
-
Message Number (6)
-
Program (7)
-
Table (15)
-
Transaction Code (15)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
COLUMNS_ST - COLUMN_ID | sequence number of the column as created | |
| 2 | Table/Structure Field |
COLUMNS_ST - COLUMN_N | Column name | |
| 3 | Table/Structure Field |
COLUMNS_ST - DATA_DEF | default value for the column | |
| 4 | Table/Structure Field |
COLUMNS_ST - DATA_LENG | length of the column in bytes | |
| 5 | Table/Structure Field |
COLUMNS_ST - DATA_PREC | length: decimal digits (number) or binary | |
| 6 | Table/Structure Field |
COLUMNS_ST - DATA_SCALE | decimal places | |
| 7 | Table/Structure Field |
COLUMNS_ST - DATA_TYPE | datatype of the column | |
| 8 | Table/Structure Field |
COLUMNS_ST - DEF_LENGTH | length of default value for the column | |
| 9 | Table/Structure Field |
COLUMNS_ST - DENSITY | density of the column | |
| 10 | Table/Structure Field |
COLUMNS_ST - HIGH_VALUE | the high value in the column | |
| 11 | Table/Structure Field |
COLUMNS_ST - LAST_ANAL | date of the most recent analysis | |
| 12 | Table/Structure Field |
COLUMNS_ST - LOW_VALUE | the low value in the column | |
| 13 | Table/Structure Field |
COLUMNS_ST - NULLABLE | does column allow null values? | |
| 14 | Table/Structure Field |
COLUMNS_ST - NUM_BUCKET | Number of buckets in histogram | |
| 15 | Table/Structure Field |
COLUMNS_ST - NUM_DISTIN | number of distinct values in the column | |
| 16 | Table/Structure Field |
COLUMNS_ST - NUM_NULLS | number of nulls in the column | |
| 17 | Table/Structure Field |
COLUMNS_ST - SAMP_SIZE | sample size used in analyzing this column | |
| 18 | Table/Structure Field |
DBRELEASE - DBRELEASE | Database release | |
| 19 | Table/Structure Field |
DBSTATIORA - ANDAT | Update Time Stamp | |
| 20 | Table/Structure Field |
DBSTATIORA - INDBL | Total blocks of an index (kb) | |
| 21 | Table/Structure Field |
DBSTATIORA - INDBS | Used blocks of an index-Btree (kb) | |
| 22 | Table/Structure Field |
DBSTATIORA - INDDE | Deleted index blocks (kb) | |
| 23 | Table/Structure Field |
DBSTATIORA - INDRU | Really used index blocks (kb) | |
| 24 | Table/Structure Field |
DBSTATTORA - AFREE | Avg. freespace in a used data base block | |
| 25 | Table/Structure Field |
DBSTATTORA - AMETH | Analysis Method for Collecting Statistics | |
| 26 | Table/Structure Field |
DBSTATTORA - ANDAT | Update Time Stamp | |
| 27 | Table/Structure Field |
DBSTATTORA - AROWL | Average row length (Oracle result) | |
| 28 | Table/Structure Field |
DBSTATTORA - CHAIN | Number of rows requiring block chaining | |
| 29 | Table/Structure Field |
DBSTATTORA - EMPBL | Empty blocks of a table in kb | |
| 30 | Table/Structure Field |
DBSTATTORA - HWMBL | Empty blocks (kb) above High Water Mark | |
| 31 | Table/Structure Field |
DBSTATTORA - INDBS | Used blocks of an index-Btree (kb) | |
| 32 | Table/Structure Field |
DBSTATTORA - NROWS | Number of rows in a table | |
| 33 | Table/Structure Field |
DBSTATTORA - OCCBL | Used blocks of a table in KB | |
| 34 | Table/Structure Field |
DBSTATTORA - OPTIO | Sample Size for Collection of Statistics | |
| 35 | Table/Structure Field |
DBSTATTORA - VWTYP | Type of Usage of Table Entry | |
| 36 | Table/Structure Field |
DD03V - FIELDNAME | Field Name | |
| 37 | Table/Structure Field |
DD03V - INTLEN | Internal Length in Bytes | |
| 38 | Table/Structure Field |
DD03V - INTTYPE | ABAP data type (C,D,N,...) | |
| 39 | Table/Structure Field |
DD03V - KEYFLAG | Identifies a key field of a table | |
| 40 | Table/Structure Field |
DOKHL - OBJECT | Documentation Object | |
| 41 | Table/Structure Field |
EXTENTS_ST - BLOCKS | Size of the extent in ORACLE blocks | |
| 42 | Table/Structure Field |
EXTENTS_ST - BLOCK_ID | Starting block number of the extent | |
| 43 | Table/Structure Field |
EXTENTS_ST - EXTENT_ID | Extent number in the segment | |
| 44 | Table/Structure Field |
EXTENTS_ST - FILE_ID | Name of the file containing the extent | |
| 45 | Table/Structure Field |
EXTENTS_ST - KBYTES | Size of the extent in bytes | |
| 46 | Table/Structure Field |
INDEXES_ST - AVG_DATA_B | Average number of data blocks per key | |
| 47 | Table/Structure Field |
INDEXES_ST - AVG_LEAF_B | Average number of leaf blocks per key | |
| 48 | Table/Structure Field |
INDEXES_ST - BLEVEL | B tree level | |
| 49 | Table/Structure Field |
INDEXES_ST - CLUST_FACT | Clustering factor | |
| 50 | Table/Structure Field |
INDEXES_ST - DIST_KEYS | Number of distinct keys in index | |
| 51 | Table/Structure Field |
INDEXES_ST - FREELISTS | Number of process freelists allocated | |
| 52 | Table/Structure Field |
INDEXES_ST - FREE_GROUP | Number of freelist groups allocated | |
| 53 | Table/Structure Field |
INDEXES_ST - INI_TRANS | INI_TRANS | |
| 54 | Table/Structure Field |
INDEXES_ST - LEAF_BLKS | Number of leaf blocks in index | |
| 55 | Table/Structure Field |
INDEXES_ST - MAX_TRANS | MAX_TRANS | |
| 56 | Table/Structure Field |
INDEXES_ST - PCT_FREE | PCT_FREE | |
| 57 | Table/Structure Field |
INDEXES_ST - STATUS | Index Status | |
| 58 | Table/Structure Field |
INDEXES_ST - UNIQUENESS | Uniqueness | |
| 59 | Table/Structure Field |
INDEX_STAT - BLKS_GETS | Expected number of consistent mode block gets per row | |
| 60 | Table/Structure Field |
INDEX_STAT - BLOCKS | Number of blocks | |
| 61 | Table/Structure Field |
INDEX_STAT - BR_BLKS | number of branch blocks in the b-tree | |
| 62 | Table/Structure Field |
INDEX_STAT - BR_BLK_LEN | usable space in a branch block | |
| 63 | Table/Structure Field |
INDEX_STAT - BR_ROWS | number of branch rows | |
| 64 | Table/Structure Field |
INDEX_STAT - BR_ROW_LEN | sum of the lengths of all the branch blocks | |
| 65 | Table/Structure Field |
INDEX_STAT - BTREE_SPAC | total space currently allocated in the b-tree | |
| 66 | Table/Structure Field |
INDEX_STAT - DATUM | Date | |
| 67 | Table/Structure Field |
INDEX_STAT - DEL_LF_LEN | total length of all deleted rows in the index | |
| 68 | Table/Structure Field |
INDEX_STAT - DEL_LF_ROW | number of deleted leaf rows in the index | |
| 69 | Table/Structure Field |
INDEX_STAT - DIST_KEYS | Number of distinct keys in index | |
| 70 | Table/Structure Field |
INDEX_STAT - HEIGHT | height of the b-tree | |
| 71 | Table/Structure Field |
INDEX_STAT - LF_BLKS | number of leaf blocks in the b-tree | |
| 72 | Table/Structure Field |
INDEX_STAT - LF_BLK_LEN | number of leaf blocks in the b-tree | |
| 73 | Table/Structure Field |
INDEX_STAT - LF_ROWS | number of leaf rows (values in the index) | |
| 74 | Table/Structure Field |
INDEX_STAT - LF_ROW_LEN | sum of the lengths of all the branch blocks | |
| 75 | Table/Structure Field |
INDEX_STAT - PCT_USED | PCT_USED | |
| 76 | Table/Structure Field |
INDEX_STAT - REP_KEYS | how many times the most repeated key is repeated | |
| 77 | Table/Structure Field |
INDEX_STAT - ROWS_PER_K | average number of rows per distinct key | |
| 78 | Table/Structure Field |
INDEX_STAT - USED_SPACE | total space that is currently being used | |
| 79 | Table/Structure Field |
INDEX_STAT - UZEIT | Time | |
| 80 | Table/Structure Field |
ORACLE_RELEASE - R1 | Oracle release number | |
| 81 | Table/Structure Field |
ORACLE_RELEASE - R2 | Oracle release number | |
| 82 | Table/Structure Field |
SEGMENTS_F - BLOCKS | Number of blocks | |
| 83 | Table/Structure Field |
SEGMENTS_F - COMPRES | SEGMENTS_F-COMPRES | |
| 84 | Table/Structure Field |
SEGMENTS_F - EXTENTS | Current number of extents | |
| 85 | Table/Structure Field |
SEGMENTS_F - HEADERFILE | HEADER_FILE | |
| 86 | Table/Structure Field |
SEGMENTS_F - HEADER_BLK | HEADER_BLOCK | |
| 87 | Table/Structure Field |
SEGMENTS_F - INIT_EXT | Initial extents (dba_segments) | |
| 88 | Table/Structure Field |
SEGMENTS_F - KBYTES | KB | |
| 89 | Table/Structure Field |
SEGMENTS_F - MAX_EXTENT | Current MaxExtent size | |
| 90 | Table/Structure Field |
SEGMENTS_F - MIN_EXTENT | Current MaxExtent size | |
| 91 | Table/Structure Field |
SEGMENTS_F - NEXTEXTENT | Current size of next extent | |
| 92 | Table/Structure Field |
SEGMENTS_F - OWNER | Owner | |
| 93 | Table/Structure Field |
SEGMENTS_F - PCT_INC | Percent increase (dba_segments) | |
| 94 | Table/Structure Field |
SEGMENTS_F - ROOT | SEGMENTS_F-ROOT | |
| 95 | Table/Structure Field |
SEGMENTS_F - SN | Object: Name of table or index | |
| 96 | Table/Structure Field |
SEGMENTS_F - S_TYPE | Type of database object | |
| 97 | Table/Structure Field |
SEGMENTS_F - TS | Name of tablespace | |
| 98 | Table/Structure Field |
SEGMENTS_S - OWNER | Owner | |
| 99 | Table/Structure Field |
SYST - CPAGE | ABAP System Field: Current Page Number of List | |
| 100 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 101 | Table/Structure Field |
SYST - INDEX | ABAP System Field: Loop Index | |
| 102 | Table/Structure Field |
SYST - LSIND | ABAP System Field: Current List Level | |
| 103 | Table/Structure Field |
SYST - STACO | ABAP System Field: First List Column Displayed | |
| 104 | Table/Structure Field |
SYST - STARO | ABAP System Field: Top List Row Displayed | |
| 105 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 106 | Table/Structure Field |
SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | |
| 107 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server | |
| 108 | Table/Structure Field |
SYST - VLINE | ABAP System Field: Vertical Line for List | |
| 109 | Table/Structure Field |
TABLES_STR - AVG_ROW_LN | AVERAGE ROW LENGTH | |
| 110 | Table/Structure Field |
TABLES_STR - AVG_SPACE | AVERAGE SPACE | |
| 111 | Table/Structure Field |
TABLES_STR - BLOCKS | Size of the extent in ORACLE blocks | |
| 112 | Table/Structure Field |
TABLES_STR - CACHE | CACHE | |
| 113 | Table/Structure Field |
TABLES_STR - CHAIN_CNT | CHAIN COUNT | |
| 114 | Table/Structure Field |
TABLES_STR - CLUST_NAME | Name of the cluster, if any, to which the table belongs | |
| 115 | Table/Structure Field |
TABLES_STR - DEGREE | DEGREE (parallel query option) | |
| 116 | Table/Structure Field |
TABLES_STR - EMPTY_BLKS | EMPTY BLOCKS | |
| 117 | Table/Structure Field |
TABLES_STR - FREELISTS | Number of process freelists allocated | |
| 118 | Table/Structure Field |
TABLES_STR - FREE_GROUP | Number of freelist groups allocated | |
| 119 | Table/Structure Field |
TABLES_STR - INI_TRANS | INI_TRANS | |
| 120 | Table/Structure Field |
TABLES_STR - INSTANCES | INSTANCES (parallel query option) | |
| 121 | Table/Structure Field |
TABLES_STR - MAX_TRANS | MAX_TRANS | |
| 122 | Table/Structure Field |
TABLES_STR - NUM_ROWS | NUMBER OF ROWS | |
| 123 | Table/Structure Field |
TABLES_STR - PCT_FREE | PCT_FREE | |
| 124 | Table/Structure Field |
TABLES_STR - PCT_USED | PCT_USED | |
| 125 | Table/Structure Field |
TABLES_STR - TABLE_LOCK | Table locking enabled or disabled? | |
| 126 | Table/Structure Field |
TBTCO - DELANFREP | Job deletion indicator after processing | |
| 127 | Table/Structure Field |
TBTCO - JOBCOUNT | Job ID | |
| 128 | Table/Structure Field |
TST04HELP - FLAG | General Flag |
