/SDF/ORATABINF2 SAP (Oracle table information) Structure details
Description: Oracle table information
Related tables to /SDF/ORATABINF2
Access table /SDF/ORATABINF2
Structure field list including key, data, relationships and ABAP select examples
/SDF/ORATABINF2 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Oracle table information" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/SDF/ORATABINF2 TYPE /SDF/ORATABINF2.
The /SDF/ORATABINF2 table consists of various fields, each holding specific information or linking keys about Oracle table information data available in SAP. These include STMT_ID (Statement ID), TABLE_OWNER (Table Owner), TABLE_NAME (Table Name), NUM_ROWS (Number of Rows).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP /SDF/ORATABINF2 structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| ANALY_ID | Analysis ID | 0 | |||||||
| STMT_ID | Statement ID | 0 | |||||||
| TABLE_OWNER | Table Owner | 0 | |||||||
| TABLE_NAME | Table Name | 0 | |||||||
| NUM_ROWS | Number of Rows | 0 | |||||||
| BLOCKS | Blocks used | 0 | |||||||
| EMPTY_BLKS | Empty Blocks | 0 | |||||||
| AVG_SPACE | Average Space | 0 | |||||||
| CHAIN_CNT | Chain Count | 0 | |||||||
| AVG_ROW_LN | Average row length | 0 | |||||||
| SAMPL_SIZE | Sample Size | 0 | |||||||
| LAST_ANALY | Last Update Statistic | 0 | |||||||
| LAST_CHANG | Last change in SAP DDIC | 0 | |||||||
| BUFF_TYPE | Type of buffering of Table | 0 | |||||||
| TABLESPACE_NAME | Name of the tablespace | 0 | |||||||
| IOT_NAME | Name of the indexed table | 0 | |||||||
| STATUS | If a previous DROP TABLE operation failed (valid or UNUSABLE | 0 | |||||||
| PCT_FREE | Minimum Percentage of Free Space in a Block | 0 | |||||||
| LOGGING | Indicates whether changes to the table are logged | 0 | |||||||
| BACKED_UP | Indicates whether the table has been backed up since the las | 0 | |||||||
| AVG_SP_FREL_BLK | Average free space of all blocks on a free list | 0 | |||||||
| NUM_FREL_BLCKS | Number of blocks on the free list | 0 | |||||||
| DEGREE | Number of threads per instance for scanning the table, or DE | 0 | |||||||
| INSTANCES | Number of instances across which the table is to be scanned, | 0 | |||||||
| CACHE | Indicates whether the table is to be cached in the buffer | 0 | |||||||
| TABLE_LOCK | Indicates whether table locking is enabled (ENABLED) | 0 | |||||||
| PARTITIONED | Indicates whether the table is partitioned (YES/NO) | 0 | |||||||
| IOT_TYPE | If the table is indexed | 0 | |||||||
| BUFFER_POOL | Default buffer pool for the table | 0 | |||||||
| ROW_MOVEMENT | Indicates whether partitioned row movement is enabled | 0 | |||||||
| GLOBAL_STATS | Partitioned tables (statistics were collected as a whole ) | 0 | |||||||
| USER_STATS | Entered directly by the user | 0 | |||||||
| TEMPORARY | Indicates whether the table is temporary (Y or N) | 0 | |||||||
| DURATION | Duration of a temporary table (session or transaction) | 0 | |||||||
| SKIP_CORRUPT | Indicates whether Oracle Database ignores blocks marked corr | 0 | |||||||
| DEPENDENCIES | Indicates whether row-level dependency tracking is enabled | 0 | |||||||
| COMPRESSION | Indicates whether table compression is enabled (ENABLED) | 0 | |||||||
| COMPRESS_FOR | Default compression for what kind of operations | 0 | |||||||
| DROPPED | Indicates whether the table has been dropped and is in the r | 0 | |||||||
| CREATED | Timestamp for Creation of Object | 0 | |||||||
| LAST_DDL_TIME | Timestamp for Last Modification from a DDL Command | 0 | |||||||
| STMT_SOURCE | DBA HIST (D) or Cache (C) | 0 | |||||||
| DBA_HIST_B_TS | Start timestamp for statement selection from DBA HIST | 0 | |||||||
| DBA_HIST_E_TS | End timestamp for statement selection from DBA HIST | 0 |
| Key field | Non-key field |
How do I retrieve data from SAP structure /SDF/ORATABINF2 using ABAP code?
As /SDF/ORATABINF2 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SDF/ORATABINF2 as there is no data to select.How to access SAP table /SDF/ORATABINF2
Within an ECC or HANA version of SAP you can also view further information about /SDF/ORATABINF2 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects