SAP ABAP Table DBSTATTORA (Actual size of tables on 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	DBSTATTORA	Table Relationship Diagram
Short Description	Actual size of tables on the database

Delivery and Maintenance

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

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	☐	SDBA_UPD	SDBA_UPD	CHAR	14	0	Update Time Stamp
3	VWTYP	☐	AM_VWTYP	AM_VWTYPE	CHAR	2	0	Type of Usage of Table Entry
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	☐	UBLOCKS_KB	DEC11	DEC	11	0	Used blocks of a table in KB
8	EMPBL	☐	EBLOCKS_KB	DEC11	DEC	11	0	Empty blocks of a table in kb
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	HWMBL	☐	HWBLKS_KB	DEC11	DEC	11	0	Empty blocks (kb) above High Water Mark
13	INDBS	☐	BBLOCKS_KB	DEC15	DEC	15	0	Used blocks of an index-Btree (kb)

History

Last changed by/on	SAP	20141013
SAP Release Created in