SAP ABAP Table DBSTATTDB4 (Table 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	DBSTATTDB4	Table Relationship Diagram
Short Description	Table 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	TABNAME	☑	TNAME	AS4TAB	CHAR	30	0	Table name	*
2	ANDAT	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
3	VWTYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
4	TABSIZE	☐	UBLOCKS_KB	DEC11	DEC	11	0	Used blocks of a table in KB
5	CURROWS	☐	OROWS	DEC15	DEC	15	0	Number of rows in a table
6	INDBS	☐	BBLOCKS_KB	DEC15	DEC	15	0	Used blocks of an index-Btree (kb)
7	DLTROWS	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
8	NUMOPEN	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
9	NUMCLOSE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
10	NUMINSERT	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
11	NUMUPDATE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
12	NUMDELETE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
13	NUMLREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
14	NUMPREAD	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
15	NUMCST	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
16	CSTSIZE	☐	DB4_ANZ15	DB4_ANZ15	DEC	15	0	iSeries: Number of rows / object size
17	CRTDATE	☐	DATUM	DATUM	DATS	8	0	Date
18	CRTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
19	SAVDATE	☐	DATUM	DATUM	DATS	8	0	Date
20	SAVTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
21	RSTDATE	☐	DATUM	DATUM	DATS	8	0	Date
22	RSTTIME	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6

History

Last changed by/on	SAP	20130604
SAP Release Created in