SAP AMDS table - Effective size of tables and indexes in the database details in SAP


SAP AMDS table summary

Object Name: AMDS
Dictionary Type: Transparent table
Description: Effective size of tables and indexes in the database


Field list for AMDS table on an S/4 SAP system

Details
AMDS-TNAME table field - Table name

Description: Table name
Field Name: TNAME
Data Element: TNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TNAME

AMDS-ANDAT table field - Analysis date for application monitor

Description: Analysis date for application monitor
Field Name: ANDAT
Data Element: AM_ANDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYDATS
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANDAT

AMDS-ACTIV table field - Activation flag Application monitor

Description: Activation flag Application monitor
Field Name: ACTIV
Data Element: AM_ACTIVS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: AM_ACTIVS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACTIV

AMDS-AMETH table field - Analysis Method for Collecting Statistics

Description: Analysis Method for Collecting Statistics
Field Name: AMETH
Data Element: AM_AMETH
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: AM_AMETH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMETH

AMDS-OPTIO table field - Sample Size for Collection of Statistics

Description: Sample Size for Collection of Statistics
Field Name: OPTIO
Data Element: AM_OPTIO
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CHAR5
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTIO

AMDS-NROWS table field - Number of rows in a table

Description: Number of rows in a table
Field Name: NROWS
Data Element: OROWS
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NROWS

AMDS-OCCBL table field - Used blocks of an Oracle table

Description: Used blocks of an Oracle table
Field Name: OCCBL
Data Element: OU_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OCCBL

AMDS-EMPBL table field - Empty blocks allocated for an Oracle table

Description: Empty blocks allocated for an Oracle table
Field Name: EMPBL
Data Element: OE_BLOCKS
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPBL

AMDS-AFREE table field - Avg. freespace in a used data base block

Description: Avg. freespace in a used data base block
Field Name: AFREE
Data Element: OAVG_BFREE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AFREE

AMDS-CHAIN table field - Number of rows requiring block chaining

Description: Number of rows requiring block chaining
Field Name: CHAIN
Data Element: OCHAINED
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHAIN

AMDS-AROWL table field - Average row length (Oracle result)

Description: Average row length (Oracle result)
Field Name: AROWL
Data Element: OAVG_ROW_L
Data Type: DEC
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: DEC7_S
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AROWL

AMDS-INDBL table field - Allocated blocks for an Oracle index

Description: Allocated blocks for an Oracle index
Field Name: INDBL
Data Element: OIND_ALLBL
Data Type: DEC
length (Dec): 11(0)
Check table:
Conversion Routine:
Domain Name: DEC11
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDBL

AMDS-INDBS table field - Total space allocated in the B tree (ORACLE)

Description: Total space allocated in the B tree (ORACLE)
Field Name: INDBS
Data Element: OBTREE_SPC
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDBS

AMDS-INDUS table field - Total space used in B tree (ORACLE)

Description: Total space used in B tree (ORACLE)
Field Name: INDUS
Data Element: OBTREE_USE
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DEC15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDUS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table