SAP ABAP Table AMDS (Effective size of tables and indexes in the database)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AMDS	Table Relationship Diagram
Short Description	Effective size of tables and indexes in the database

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TNAME	☑	TNAME	AS4TAB	CHAR	30	0	Table name	*
2	ANDAT	☑	AM_ANDAT	SYDATS	DATS	8	0	Analysis date for application monitor
3	ACTIV	☐	AM_ACTIVS	AM_ACTIVS	CHAR	2	0	Activation flag Application monitor
4	AMETH	☐	AM_AMETH	AM_AMETH	CHAR	4	0	Analysis Method for Collecting Statistics
5	OPTIO	☐	AM_OPTIO	CHAR5	CHAR	5	0	Sample Size for Collection of Statistics
6	NROWS	☐	OROWS	DEC15	DEC	15	0	Number of rows in a table
7	OCCBL	☐	OU_BLOCKS	DEC11	DEC	11	0	Used blocks of an Oracle table
8	EMPBL	☐	OE_BLOCKS	DEC11	DEC	11	0	Empty blocks allocated for an Oracle table
9	AFREE	☐	OAVG_BFREE	INT4	INT4	10	0	Avg. freespace in a used data base block
10	CHAIN	☐	OCHAINED	DEC15	DEC	15	0	Number of rows requiring block chaining
11	AROWL	☐	OAVG_ROW_L	DEC7_S	DEC	7	0	Average row length (Oracle result)
12	INDBL	☐	OIND_ALLBL	DEC11	DEC	11	0	Allocated blocks for an Oracle index
13	INDBS	☐	OBTREE_SPC	DEC15	DEC	15	0	Total space allocated in the B tree (ORACLE)
14	INDUS	☐	OBTREE_USE	DEC15	DEC	15	0	Total space used in B tree (ORACLE)

History

Last changed by/on	SAP	20130604
SAP Release Created in