SAP /SDF/ORATABINFO table - Oracle table information details in SAP


SAP /SDF/ORATABINFO table summary

Object Name: /SDF/ORATABINFO
Dictionary Type: Structure
Description: Oracle table information


Field list for /SDF/ORATABINFO table on an S/4 SAP system

Details
/SDF/ORATABINFO-TABLE_OWNER table field - Table owner

Description: Table owner
Field Name: TABLE_OWNER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_OWNER

/SDF/ORATABINFO-TABLE_NAME table field - Table Name

Description: Table Name
Field Name: TABLE_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_NAME

/SDF/ORATABINFO-NUM_ROWS table field - Number of Rows

Description: Number of Rows
Field Name: NUM_ROWS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_ROWS

/SDF/ORATABINFO-BLOCKS table field - Blocks used

Description: Blocks used
Field Name: BLOCKS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKS

/SDF/ORATABINFO-EMPTY_BLKS table field - Empty Blocks

Description: Empty Blocks
Field Name: EMPTY_BLKS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPTY_BLKS

/SDF/ORATABINFO-AVG_SPACE table field - Average Space

Description: Average Space
Field Name: AVG_SPACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_SPACE

/SDF/ORATABINFO-CHAIN_CNT table field - Chain Count

Description: Chain Count
Field Name: CHAIN_CNT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHAIN_CNT

/SDF/ORATABINFO-AVG_ROW_LN table field - Average row length

Description: Average row length
Field Name: AVG_ROW_LN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_ROW_LN

/SDF/ORATABINFO-SAMPL_SIZE table field - Sample Size

Description: Sample Size
Field Name: SAMPL_SIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAMPL_SIZE

/SDF/ORATABINFO-LAST_ANALY table field - Last Update Statistic

Description: Last Update Statistic
Field Name: LAST_ANALY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ANALY

/SDF/ORATABINFO-LAST_CHANG table field - Last change in SAP DDIC

Description: Last change in SAP DDIC
Field Name: LAST_CHANG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_CHANG

/SDF/ORATABINFO-BUFF_TYPE table field - Type of buffering of Table

Description: Type of buffering of Table
Field Name: BUFF_TYPE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFF_TYPE

/SDF/ORATABINFO-TABLESPACE_NAME table field - Name of the tablespace

Description: Name of the tablespace
Field Name: TABLESPACE_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLESPACE_NAME

/SDF/ORATABINFO-IOT_NAME table field - Name of the indexed table

Description: Name of the indexed table
Field Name: IOT_NAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOT_NAME

/SDF/ORATABINFO-STATUS table field - If a previous DROP TABLE operation failed (valid or UNUSABLE

Description: If a previous DROP TABLE operation failed (valid or UNUSABLE
Field Name: STATUS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

/SDF/ORATABINFO-PCT_FREE table field - Minimum Percentage of Free Space in a Block

Description: Minimum Percentage of Free Space in a Block
Field Name: PCT_FREE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_FREE

/SDF/ORATABINFO-LOGGING table field - Indicates whether changes to the table are logged

Description: Indicates whether changes to the table are logged
Field Name: LOGGING
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGGING

/SDF/ORATABINFO-BACKED_UP table field - Indicates whether the table has been backed up since the las

Description: Indicates whether the table has been backed up since the las
Field Name: BACKED_UP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BACKED_UP

/SDF/ORATABINFO-AVG_SP_FREL_BLK table field - Average free space of all blocks on a free list

Description: Average free space of all blocks on a free list
Field Name: AVG_SP_FREL_BLK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_SP_FREL_BLK

/SDF/ORATABINFO-NUM_FREL_BLCKS table field - Number of blocks on the free list

Description: Number of blocks on the free list
Field Name: NUM_FREL_BLCKS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUM_FREL_BLCKS

/SDF/ORATABINFO-DEGREE table field - Number of threads per instance for scanning the table, or DE

Description: Number of threads per instance for scanning the table, or DE
Field Name: DEGREE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEGREE

/SDF/ORATABINFO-INSTANCES table field - Number of instances across which the table is to be scanned,

Description: Number of instances across which the table is to be scanned,
Field Name: INSTANCES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCES

/SDF/ORATABINFO-CACHE table field - Indicates whether the table is to be cached in the buffer

Description: Indicates whether the table is to be cached in the buffer
Field Name: CACHE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CACHE

/SDF/ORATABINFO-TABLE_LOCK table field - Indicates whether table locking is enabled (ENABLED)

Description: Indicates whether table locking is enabled (ENABLED)
Field Name: TABLE_LOCK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_LOCK

/SDF/ORATABINFO-PARTITIONED table field - Indicates whether the table is partitioned (YES/NO)

Description: Indicates whether the table is partitioned (YES/NO)
Field Name: PARTITIONED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITIONED

/SDF/ORATABINFO-IOT_TYPE table field - If the table is indexed

Description: If the table is indexed
Field Name: IOT_TYPE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOT_TYPE

/SDF/ORATABINFO-BUFFER_POOL table field - Default buffer pool for the table

Description: Default buffer pool for the table
Field Name: BUFFER_POOL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUFFER_POOL

/SDF/ORATABINFO-ROW_MOVEMENT table field - Indicates whether partitioned row movement is enabled

Description: Indicates whether partitioned row movement is enabled
Field Name: ROW_MOVEMENT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROW_MOVEMENT

/SDF/ORATABINFO-GLOBAL_STATS table field - Partitioned tables (statistics were collected as a whole )

Description: Partitioned tables (statistics were collected as a whole )
Field Name: GLOBAL_STATS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLOBAL_STATS

/SDF/ORATABINFO-USER_STATS table field - Entered directly by the user

Description: Entered directly by the user
Field Name: USER_STATS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USER_STATS

/SDF/ORATABINFO-TEMPORARY table field - Indicates whether the table is temporary (Y or N)

Description: Indicates whether the table is temporary (Y or N)
Field Name: TEMPORARY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TEMPORARY

/SDF/ORATABINFO-DURATION table field - Duration of a temporary table (session or transaction)

Description: Duration of a temporary table (session or transaction)
Field Name: DURATION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DURATION

/SDF/ORATABINFO-SKIP_CORRUPT table field - Indicates whether Oracle Database ignores blocks marked corr

Description: Indicates whether Oracle Database ignores blocks marked corr
Field Name: SKIP_CORRUPT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SKIP_CORRUPT

/SDF/ORATABINFO-DEPENDENCIES table field - Indicates whether row-level dependency tracking is enabled

Description: Indicates whether row-level dependency tracking is enabled
Field Name: DEPENDENCIES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPENDENCIES

/SDF/ORATABINFO-COMPRESSION table field - Indicates whether table compression is enabled (ENABLED)

Description: Indicates whether table compression is enabled (ENABLED)
Field Name: COMPRESSION
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPRESSION

/SDF/ORATABINFO-COMPRESS_FOR table field - Default compression for what kind of operations

Description: Default compression for what kind of operations
Field Name: COMPRESS_FOR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMPRESS_FOR

/SDF/ORATABINFO-DROPPED table field - Indicates whether the table has been dropped and is in the r

Description: Indicates whether the table has been dropped and is in the r
Field Name: DROPPED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DROPPED

/SDF/ORATABINFO-CREATED table field - Timestamp for Creation of Object

Description: Timestamp for Creation of Object
Field Name: CREATED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED

/SDF/ORATABINFO-LAST_DDL_TIME table field - Timestamp for Last Modification from a DDL Command

Description: Timestamp for Last Modification from a DDL Command
Field Name: LAST_DDL_TIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_DDL_TIME

/SDF/ORATABINFO-FLASH_CACHE table field - Database Smart Flash Cache hint for table blocks

Description: Database Smart Flash Cache hint for table blocks
Field Name: FLASH_CACHE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLASH_CACHE

/SDF/ORATABINFO-CELL_F_CACHE table field - Cell flash cache hint for table blocks

Description: Cell flash cache hint for table blocks
Field Name: CELL_F_CACHE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CELL_F_CACHE

/SDF/ORATABINFO-SEGMENT_CREATED table field - table segment is created (Yes or No)

Description: table segment is created (Yes or No)
Field Name: SEGMENT_CREATED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_CREATED

/SDF/ORATABINFO-READ_ONLY table field - table IS READ-ONLY (YES) or not (NO)

Description: table IS READ-ONLY (YES) or not (NO)
Field Name: READ_ONLY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READ_ONLY

/SDF/ORATABINFO-ACT_TRACKING table field - Indicates whether Heat Map tracking is enabled on the table

Description: Indicates whether Heat Map tracking is enabled on the table
Field Name: ACT_TRACKING
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACT_TRACKING

/SDF/ORATABINFO-DML_TIMESTAMP table field - Modification time, creation time or both, for Automatic Data

Description: Modification time, creation time or both, for Automatic Data
Field Name: DML_TIMESTAMP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DML_TIMESTAMP

/SDF/ORATABINFO-HAS_IDENTITY table field - Indicates whether the table has an identity column: Y or N

Description: Indicates whether the table has an identity column: Y or N
Field Name: HAS_IDENTITY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HAS_IDENTITY

/SDF/ORATABINFO-CONTAINER_DATA table field - Table contains container-specific data: yes or no

Description: Table contains container-specific data: yes or no
Field Name: CONTAINER_DATA
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTAINER_DATA

/SDF/ORATABINFO-INMEMORY table field - Indicates whether the In-Memory Column Store (IM column stor

Description: Indicates whether the In-Memory Column Store (IM column stor
Field Name: INMEMORY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INMEMORY

/SDF/ORATABINFO-INMEMORY_PRIO table field - Indicates the priority for In-Memory Column Store (IM column

Description: Indicates the priority for In-Memory Column Store (IM column
Field Name: INMEMORY_PRIO
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INMEMORY_PRIO

/SDF/ORATABINFO-INMEMORY_DISTR table field - Indicates how the IM column store is distributed in RAC

Description: Indicates how the IM column store is distributed in RAC
Field Name: INMEMORY_DISTR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INMEMORY_DISTR

/SDF/ORATABINFO-INMEMORY_COMPR table field - Indicates the compression level for the IM column store

Description: Indicates the compression level for the IM column store
Field Name: INMEMORY_COMPR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INMEMORY_COMPR

/SDF/ORATABINFO-INMEMORY_DUPL table field - Duplicate setting for the IM column for Oracle RAC

Description: Duplicate setting for the IM column for Oracle RAC
Field Name: INMEMORY_DUPL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INMEMORY_DUPL


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table