SAP ABAP Table DB4INDEX_STAT (Index Sizes in the Database)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB4INDEX_STAT	Table Relationship Diagram
Short Description	Index Sizes in 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	DBHOST	☑	SYHOST	HOST_ID	CHAR	32	0	Application Server
2	SCHEMANAME	☑			CHAR	10	0
3	INDNAME	☑	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
4	INDNAME_LONG	☐	DBINDEX_D	DBINDEX	CHAR	18	0	Database index
5	ANDAT	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
6	VWTYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
7	INDSIZE	☐	IBLOCKS_KB	DEC11	DEC	11	0	Total blocks of an index (kb)
8	CRTDATE	☐	DATUM	DATUM	DATS	8	0	Date
9	CRTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
10	SAVDATE	☐	DATUM	DATUM	DATS	8	0	Date
11	SAVTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
12	RSTDATE	☐	DATUM	DATUM	DATS	8	0	Date
13	RSTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
14	INDTABLE	☐	TNAME	AS4TAB	CHAR	30	0	Table name	*
15	INDTABLE_LONG	☐	TNAME	AS4TAB	CHAR	30	0	Table name	*

History

Last changed by/on	SAP	20130604
SAP Release Created in	640