SAP ABAP Table DB2_DB02_TAB_GEN (general Data for Tables)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_DB02_TAB_GEN	Table Relationship Diagram
Short Description	general Data for Tables

Delivery and Maintenance

Pool/cluster
Delivery Class
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	BASE_TABLE_NAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
2	BASE_TABLE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
3	DBNAME	☐	DB2DBNAML		CHAR	24	0	DB2 DB Name
4	SPACENAME	☐	DB2TSNAML		CHAR	24	0	DB2 TS Name
5	OBJECT_TYPE	☐	DB2TABTYP	DB2TABTYP	CHAR	1	0	Type of DB2 table
6	SPACE_TYPE	☐	DB2TABTYP	DB2TABTYP	CHAR	1	0	Type of DB2 table
7	NPAGES	☐	DB2NUMPG		DEC	19	0	Number of pages
8	RECLENGTH	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
9	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
10	ALTERTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
11	PCTROWCOMP	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
12	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
13	CARDF	☐	DB2DB02CARDF		DEC	19	0	cardf
14	ENCODING_SCHEME	☐	DB2_ENCODING		CHAR	20	0	DB2 Encoding
15	TAB_TYPE	☐	DB2TABTYPE		CHAR	24	0	Table: Type of object
16	SPACE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name

History

Last changed by/on	SAP	20130604
SAP Release Created in