SAP /SDF/ORA_LARGEST_TABLES table - largest tables details in SAP


SAP /SDF/ORA_LARGEST_TABLES table summary

Object Name: /SDF/ORA_LARGEST_TABLES
Dictionary Type: Structure
Description: largest tables


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

Details
/SDF/ORA_LARGEST_TABLES-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/ORA_LARGEST_TABLES-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/ORA_LARGEST_TABLES-BASIS_TABLE table field - ‘X’ table belongs to basis tables as of note 706478

Description: ‘X’ table belongs to basis tables as of note 706478
Field Name: BASIS_TABLE
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 BASIS_TABLE

/SDF/ORA_LARGEST_TABLES-PARTITION_ENG table field - ‘X’ table can be part. with SAP part engine note 1333328

Description: ‘X’ table can be part. with SAP part engine note 1333328
Field Name: PARTITION_ENG
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 PARTITION_ENG

/SDF/ORA_LARGEST_TABLES-LONG table field - ‘X’ if table contains a LONG or LONG RAW column

Description: ‘X’ if table contains a LONG or LONG RAW column
Field Name: LONG
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 LONG

/SDF/ORA_LARGEST_TABLES-UNIQUE_IND table field - ‘X’ if at least one unique index exists for the table

Description: ‘X’ if at least one unique index exists for the table
Field Name: UNIQUE_IND
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 UNIQUE_IND

/SDF/ORA_LARGEST_TABLES-COMPRESSION table field - 1:!=MustNotComp;2:comp=YesNoBasis3:Indcomp3:lobcomp

Description: 1:!=MustNotComp;2:comp=YesNoBasis3:Indcomp3:lobcomp
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/ORA_LARGEST_TABLES-POSITION table field - Ranking of table

Description: Ranking of table
Field Name: POSITION
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 POSITION

/SDF/ORA_LARGEST_TABLES-COL_NUM table field - Number of table columns

Description: Number of table columns
Field Name: COL_NUM
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 COL_NUM

/SDF/ORA_LARGEST_TABLES-TOTAL_GB table field - Total size in GB (table + indexes + LOB segments)

Description: Total size in GB (table + indexes + LOB segments)
Field Name: TOTAL_GB
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 TOTAL_GB

/SDF/ORA_LARGEST_TABLES-TOTAL_PERC table field - Percentage of overall database size

Description: Percentage of overall database size
Field Name: TOTAL_PERC
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 TOTAL_PERC

/SDF/ORA_LARGEST_TABLES-CUM_PERC table field - Cumulated percentage of the largest tables

Description: Cumulated percentage of the largest tables
Field Name: CUM_PERC
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 CUM_PERC

/SDF/ORA_LARGEST_TABLES-PART_NUM table field - Number of table partitions ('0' if table is not partitioned)

Description: Number of table partitions ('0' if table is not partitioned)
Field Name: PART_NUM
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 PART_NUM

/SDF/ORA_LARGEST_TABLES-TABLE_GB table field - Table size (in GB)

Description: Table size (in GB)
Field Name: TABLE_GB
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_GB

/SDF/ORA_LARGEST_TABLES-TAB_TABLESPACE table field - Tablespace of the table

Description: Tablespace of the table
Field Name: TAB_TABLESPACE
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 TAB_TABLESPACE

/SDF/ORA_LARGEST_TABLES-IND_NUM table field - Number of indexes on the table

Description: Number of indexes on the table
Field Name: IND_NUM
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 IND_NUM

/SDF/ORA_LARGEST_TABLES-INDEX_GB table field - Total size of all table indexes (in GB)

Description: Total size of all table indexes (in GB)
Field Name: INDEX_GB
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 INDEX_GB

/SDF/ORA_LARGEST_TABLES-IND_TABLESPACE table field - Tablespace of the table indexes

Description: Tablespace of the table indexes
Field Name: IND_TABLESPACE
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 IND_TABLESPACE

/SDF/ORA_LARGEST_TABLES-LOBS table field - Type+number of LOB columns B9-BasicFile S9 Secure File

Description: Type+number of LOB columns B9-BasicFile S9 Secure File
Field Name: LOBS
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 LOBS

/SDF/ORA_LARGEST_TABLES-LOB_GB table field - Total size of all table LOB segments (in GB)

Description: Total size of all table LOB segments (in GB)
Field Name: LOB_GB
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 LOB_GB


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table