SAP ABAP Table SYB_VIEW_TABLES_SPACE_DTL (SYB: View data for Table Details (Space))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYB_VIEW_TABLES_SPACE_DTL	Table Relationship Diagram
Short Description	SYB: View data for Table Details (Space)

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	TABLE	☐	SYBMON_TABLE_SPACE		STRU	0	0
2	DBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
3	TABOWNER	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
4	TABNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
5	PARTITIONNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
6	ID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
7	PARTITIONID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
8	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
9	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
10	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
11	TIME_PERIOD	☐			INT4	10	0
12	NUM_PARTITIONS	☐			INT4	10	0
13	NUM_PARTITIONS_MAX	☐			INT4	10	0
14	ROW_COUNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	ROW_COUNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	TAB_RESERVED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	TAB_RESERVED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	TAB_USED_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	TAB_USED_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	TAB_DATA_LOB_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	TAB_DATA_LOB_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	TAB_DATA_UTL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	TAB_DATA_UTL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	TAB_DATAPGCLRATIO	☐			DEC	5	2
25	TAB_DATAPGCLRATIO_MIN	☐			DEC	5	2
26	TAB_LRGIOEFF	☐			DEC	5	2
27	TAB_LRGIOEFF_MIN	☐			DEC	5	2
28	DATACHANGE	☐			DEC	12	2
29	DATACHANGE_MAX	☐			DEC	12	2
30	FORWROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	FORWROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
32	DELROWCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
33	DELROWCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
34	EXTENT0PGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
35	EXTENT0PGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
36	OAMAPGCNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
37	OAMAPGCNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
38	OAMPAGECNT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
39	OAMPAGECNT_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
40	STATMODDATE	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
41	DATAROWSIZE	☐			INT2	5	0
42	DATAROWSIZE_MAX	☐			INT2	5	0
43	TAB_DATA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
44	TAB_DATA_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
45	TAB_DATA_UTL_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
46	TAB_DATA_UTL_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
47	TAB_USED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
48	TAB_USED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
49	TAB_RESERVED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
50	TAB_RESERVED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
51	TAB_UNUSED_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
52	TAB_UNUSED_TOTAL_KB_MAX	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
53	TAB_DATA_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
54	TAB_USED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
55	TAB_RESERVED_DELTA_TOTAL_KB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
56	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname
57	HISTORY	☐	SYBMON_TABLE_SPACE_TAB		TTYP	0	0
58	HAS_PARTITIONS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
59	SHOW_PARTITIONS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
60	IS_SUMMARY_CONDENSED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
61	IS_DETAIL_CONDENSED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

Last changed by/on	SAP	20141013
SAP Release Created in	731