SAP ABAP Table DB2_VIEW_TABLE_DETAILS (DB2: structure for VIEW_DATA of ..._ACTION_DB02_TAB_DETAILS)

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_VIEW_TABLE_DETAILS	Table Relationship Diagram
Short Description	DB2: structure for VIEW_DATA of ..._ACTION_DB02_TAB_DETAILS

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	GENERAL_DATA	☐	DB2_DB02_TAB_GEN		STRU	0	0
2	BASE_TABLE_NAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
3	BASE_TABLE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
4	DBNAME	☐	DB2DBNAML		CHAR	24	0	DB2 DB Name
5	SPACENAME	☐	DB2TSNAML		CHAR	24	0	DB2 TS Name
6	OBJECT_TYPE	☐	DB2TABTYP	DB2TABTYP	CHAR	1	0	Type of DB2 table
7	SPACE_TYPE	☐	DB2TABTYP	DB2TABTYP	CHAR	1	0	Type of DB2 table
8	NPAGES	☐	DB2NUMPG		DEC	19	0	Number of pages
9	RECLENGTH	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
10	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
11	ALTERTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
12	PCTROWCOMP	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
13	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
14	CARDF	☐	DB2DB02CARDF		DEC	19	0	cardf
15	ENCODING_SCHEME	☐	DB2_ENCODING		CHAR	20	0	DB2 Encoding
16	TAB_TYPE	☐	DB2TABTYPE		CHAR	24	0	Table: Type of object
17	SPACE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
18	TAB_DETAILS	☐	DB2_DB02_TAB_TS_DETAILS		STRU	0	0
19	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
20	OBJECT_TYPE	☐	DB2TSTYPE		CHAR	20	0	TS: Type of object
21	SPACE_TYPE	☐	DB2TSTYPE		CHAR	20	0	TS: Type of object
22	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
23	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
24	BPOOL	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
25	PGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
26	NTABLES	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
27	SEGSIZE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
28	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
29	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
30	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
31	MAXROWS	☐	DB2MROW	DB2MROW	INT2	5	0	Maximum number of rows that DB2 will place on a data page
32	DSSIZE	☐	INT4	INT4	INT4	10	0	Natural number
33	AVGROWLEN	☐	INT4	INT4	INT4	10	0	Natural number
34	MAXPARTITIONS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
35	TAB_STRUCTURE	☐	DB2_DB02_TAB_STRUCTURE		STRU	0	0
36	IT_COLS	☐	DB2_T_TABSTRUC		TTYP	0	0
37	TAB_HISTORY	☐	DB2_DB02_TAB_HISTORY		STRU	0	0
38	FROM_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
39	TO_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
40	IT_TABLES	☐	DB_T_TABHIST		TTYP	0	0
41	RANGE	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
42	RANGE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
43	COLLAPSED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
44	EXPANDED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
45	RANGE_PREV	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
46	HIST_KEEP_DAYS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
47	HIST_KEEP_WEEKS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
48	HIST_KEEP_MONTHS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
49	TAB_INDEXES	☐	DB2_DB02_IX_STRUCTURE		STRU	0	0
50	IT_COLS	☐	DB2_T_IXSTRUC		TTYP	0	0
51	TAB_PARTITIONS	☐	DB2_DB02_TAB_PARTITIONS		STRU	0	0
52	IT_PARTITIONS	☐	DB2TBPARTLIST		TTYP	0	0
53	TAB_PART_DETAILS	☐	DB2_DB02_TAB_PART_DETAILS		STRU	0	0
54	PARTNO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
55	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
56	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
57	PQTY	☐	INT4	INT4	INT4	10	0	Natural number
58	SQTY	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
59	STORNAME	☐	DB2STOGROUP		CHAR	128	0	Storage group
60	FARINDREF	☐	INT4	INT4	INT4	10	0	Natural number
61	NEARINDREF	☐	INT4	INT4	INT4	10	0	Natural number
62	PERCACTIVE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
63	LIMITKEY	☐	DB2LIMITKEY		CHAR	128	0	limitkey
64	FREEPAGE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
65	PCTFREE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
66	COMPRESS	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
67	PAGE_SAVE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
68	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
69	GBPCACHE	☐	DB2GBPCACHL		CHAR	8	0	Group buffer pool cache option
70	CARDF	☐	DB2DB02CARDF		DEC	19	0	cardf
71	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
72	DSNUM	☐	INT4	INT4	INT4	10	0	Natural number
73	EXTENTS	☐	INT4	INT4	INT4	10	0	Natural number
74	LOGICAL_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
75	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
76	AVGROWLEN	☐	INT4	INT4	INT4	10	0	Natural number
77	ROW_FORMAT	☐	DB2ROWFORMAT		CHAR	16	0	Row Format
78	REORG_LR_TS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
79	FREE_SPACE	☐	DB2SIZEKB		DEC	19	0	Size in KB
80	PCT_USED	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
81	LIST_VOL	☐	DB2VOLID	CHAR6	CHAR	6	0	Serial number of the volume
82	TAB_LOBS	☐	DB2_DB02_TAB_LOBS		STRU	0	0
83	IT_LOBS	☐	DB2_T_LOBS		TTYP	0	0
84	TAB_BASE	☐	DB2_DB02_TAB_BASE		STRU	0	0
85	TABLE	☐	DB2BASETAB_TAB		TTYP	0	0
86	PARTLIST	☐	DBA_LISTBOX_LIST		TTYP	0	0

History

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