SAP ABAP Class CL_MSS_ACTION_TABLEDETAIL (Table details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_MSS_ACTION_CONTROLLER	MSS: Abstract Action Controller	20070531

Properties

Class	CL_MSS_ACTION_TABLEDETAIL
Short Description	Table details
Super Class	CL_MSS_ACTION_CONTROLLER	MSS: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STUN_MSS	Package for new SQL Server monitoring objects
Created	20070531	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	MSSCC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_MSS_ACTION_TABLEDETAIL has no interface implemented.

Friends

Class CL_MSS_ACTION_TABLEDETAIL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALV_IDX	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3		Indexes tab2	20070531
2	ALV_OPSTATS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3			20071010
3	ALV_PART_DIST	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV		Partition data distribution	20070724
4	ALV_STAT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3		Stats tab2	20070531
5	ALV_STATEMENTS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV			20130823
6	ALV_TABCOL	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3			20070605
7	ALV_TABPROPS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV			20070605
8	ALV_USESTATS	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_ALV3			20071010
9	CHK_CUSTOM_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER			20070801
10	CHK_DBCC_TEXTEDIT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_TEXTEDIT			20070801
11	CMD_ABAP	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'ABAP'		20130823
12	CMD_DENSITY	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'DNST'	Calculate density	20070801
13	CMD_EXPLAIN	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'EXPLAIN'		20130823
14	CMD_HISTOGRAM	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'HIST'	Show histogram	20070802
15	CMD_OP_NEXT_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'ONXT'	Show next operational view	20071015
16	CMD_SELECTIVITY	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'SLCT'	Calculate selectivity	20070801
17	CMD_SHOWCONTIG	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'SHCN'	Run dbcc showcontig	20070802
18	CMD_SQL	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'SQL'		20130823
19	CMD_STAT	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'STAT'	Show statistics for column statistics	20070731
20	CMD_UPDATESTATS	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'UPDT'	Update statistics	20070802
21	CMD_USE_NEXT_VIEW	Instance attribute	Private	☐	Type reference (TYPE)	SYUCOMM	'UNXT'	Show next usage view	20071015
22	COL_CUSTOM_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER			20071011
23	CTRL	Instance attribute	Private	☐	Attribute reference (LIKE)				20070531
24	CURRENT_OPSTATSVIEW	Instance attribute	Private	☐	Type reference (TYPE)	I	1		20071011
25	CURRENT_USESTATSVIEW	Instance attribute	Private	☐	Type reference (TYPE)	I	1		20071011
26	DBCC_TEXTEDIT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_TEXTEDIT			20070801
27	HAS_OPSTATS	Instance attribute	Private	☐	Type reference (TYPE)	BOOLEAN			20070803
28	HAS_USAGE	Instance attribute	Private	☐	Type reference (TYPE)	BOOLEAN			20070803
29	IDX_STAT_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER			20071011
30	IDX_STAT_SPLITTER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_EASY_SPLITTER_CONTAINER			20071011
31	IT_CHK_DBCCLIST	Instance attribute	Private	☐	See coding				20070801
32	IT_DBCCLIST	Instance attribute	Private	☐	See coding				20070801
33	IT_IDX	Instance attribute	Private	☐	See coding				20070531
34	IT_OPSTATS	Instance attribute	Private	☐	See coding				20071010
35	IT_PART_DIST	Instance attribute	Private	☐	See coding				20070724
36	IT_STAT	Instance attribute	Private	☐	See coding				20070531
37	IT_STATEMENTS	Instance attribute	Private	☐	See coding				20130823
38	IT_TABCOL	Instance attribute	Private	☐	See coding				20070605
39	IT_TABPROPS	Instance attribute	Private	☐	See coding				20070605
40	IT_USESTATS	Instance attribute	Private	☐	See coding				20071010
41	MAJOR	Instance attribute	Private	☐	Type reference (TYPE)	I			20110131
42	NAV_REF	Instance attribute	Private	☐	Attribute reference (LIKE)				20070531
43	NUM_TRIGGERS	Instance attribute	Private	☐	Type reference (TYPE)	I	0	Number of triggers on the table	20070606
44	N_PART	Instance attribute	Private	☐	Type reference (TYPE)	I			20070803
45	OBJ_TYPE	Instance attribute	Private	☐	Type reference (TYPE)	MSSOBJTYPE			20070807
46	RUNSTATS_CONTAINER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER			20071010
47	RUNSTATS_SPLITTER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_EASY_SPLITTER_CONTAINER			20071010
48	SAFE_TO_GET_PARTCOUNTS	Instance attribute	Private	☐	Type reference (TYPE)	I	100000	It is safe to get partition size information	20070831
49	SP_PARAMS	Instance attribute	Private	☐	See coding				20130823
50	SV_OBJ	Instance attribute	Private	☐	Type reference (TYPE)	MSSVIEWORTABLE			20070801
51	SV_OBJNAME	Instance attribute	Private	☐	Type reference (TYPE)	MSSVIEWORTABLE			20070531
52	SV_OBJ_DB	Instance attribute	Private	☐	Type reference (TYPE)	MSSDB			20070801
53	SV_SCHEMA	Instance attribute	Private	☐	Type reference (TYPE)	MSSSCHEMA			20070801
54	TABCOL_SPLITTER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_EASY_SPLITTER_CONTAINER			20071011
55	VIEW_DATA	Instance attribute	Public	☑	Type reference (TYPE)	MSSCC_ACTION_TABDET		Data in table details	20070531

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_OBJNAME	Instance method	Public	Method	Check input object name (table or view)	20070604
2	CHECK_OBJ_DB	Instance method	Public	Method	Check database name	20070605
3	CHECK_OBJ_SCHEMA	Instance method	Public	Method	Check that the schema exists in the db	20070605
4	DBCC_CHECKTABLE	Instance method	Private	Method	Handle selectivity and density commands	20070801
5	DISPLAY_STATEMENT_DATA	Instance method	Private	Method		20130823
6	DISPLAY_TABSZHIST	Instance method	Private	Method	Display table size history	20080213
7	FIELDNAME_IN_OPSTATS_VIEW	Instance method	Private	Method	Return true if field is in a given view	20071011
8	FIELDNAME_IN_USESTATS_VIEW	Instance method	Private	Method	Return true if field is in a given view	20071011
9	GET_FIELD_LIST	Instance method	Private	Method	Get field list	20070605
10	GET_INDEX_AND_STATS_DATA	Instance method	Private	Method	Get index and statistics data	20070531
11	GET_PART_INFO	Instance method	Private	Method	Get partitioning information	20070723
12	GET_RUNTIME_STATISTICS	Instance method	Private	Method	Get operational and usage statistics	20070605
13	GET_SIZE_DATA	Instance method	Private	Method	Get size data for tab 1	20070531
14	GET_SQL_CODE	Instance method	Private	Method		20130823
15	GET_TABPROPS	Instance method	Private	Method	Get table properties	20070605
16	GOTO_DDIC	Instance method	Private	Method	Jump to DDIC for the current table	20080117
17	PATTERN_TO_VALUES	Instance method	Public	Method	Translate a pattern for table or view to a list of values	20070604
18	POPUP_COL_STAT_IN_BROWSER	Instance method	Private	Method	Get all column statistics and display in browser	20070802
19	SET_GRID_ATTRIBUTES	Instance method	Private	Method	Set grid attributes - duh	20070531
20	SET_OPSTATS_LAYOUT	Instance method	Private	Method	Set the fieldcatalog of the current layout for use stats	20071015
21	SET_USESTATS_LAYOUT	Instance method	Private	Method	Set the fieldcatalog of the current layout for use stats	20071011
22	SHOW_ABAP_CODE	Instance method	Private	Method		20130823
23	SHOW_DENSITY_OR_SELECTIVITY	Instance method	Private	Method	Handle selectivity and density commands	20070801
24	SHOW_SQL_CODE	Instance method	Private	Method		20130823
25	SHOW_STATISTICS	Instance method	Private	Method	Show either index or column statistics	20070731
26	SP_RECOMPILE	Instance method	Private	Method	Issue sp_recompile for the table	20090505
27	UPDATE_USAGE	Instance method	Private	Method	Run dbcc Update usage for a table	20070802

Events

Class CL_MSS_ACTION_TABLEDETAIL has no event.

Types

Class CL_MSS_ACTION_TABLEDETAIL has no local type.

Method Signatures

Method CHECK_OBJNAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	OBJNAME	Call by reference	☐	Type reference (TYPE)	MSSVIEWORTABLE		Object name	20070604

Method CHECK_OBJNAME on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method CHECK_OBJ_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	OBJ_DB	Call by reference	☐	Type reference (TYPE)	MSSDB		Database name	20070605

Method CHECK_OBJ_DB on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method CHECK_OBJ_SCHEMA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	OBJ_SCHEMA	Call by reference	☐	Type reference (TYPE)	MSSSCHEMA		Schema name	20070605
2	Changing	SCHEMA_TAB	Call by reference	☐	Type reference (TYPE)	TABLE			20070605

Method CHECK_OBJ_SCHEMA on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method DBCC_CHECKTABLE Signature

Method DBCC_CHECKTABLE on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method DBCC_CHECKTABLE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method DISPLAY_STATEMENT_DATA Signature

Method DISPLAY_STATEMENT_DATA on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method DISPLAY_STATEMENT_DATA on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method DISPLAY_TABSZHIST Signature

Method DISPLAY_TABSZHIST on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method DISPLAY_TABSZHIST on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method FIELDNAME_IN_OPSTATS_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	COL_POS	Call by reference	☐	Type reference (TYPE)	LVC_COLPOS		ALV control: Output column	20071015
2	Exporting	EMPHASIZE	Call by reference	☐	Type reference (TYPE)	LVC_EMPHSZ		ALV control: Highlight column with color	20071015
3	Importing	FIELDNAME	Call by reference	☐	Type reference (TYPE)	C			20071011
4	Exporting	NO_OUT	Call by reference	☐	Type reference (TYPE)	LVC_NOOUT		ALV control: Column is not output	20071015
5	Importing	VIEW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20071011

Method FIELDNAME_IN_OPSTATS_VIEW on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method FIELDNAME_IN_USESTATS_VIEW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	COL_POS	Call by reference	☐	Type reference (TYPE)	LVC_COLPOS		ALV control: Output column	20071015
2	Importing	FIELDNAME	Call by reference	☐	Type reference (TYPE)	C			20071011
3	Exporting	NO_OUT	Call by reference	☐	Type reference (TYPE)	LVC_NOOUT		ALV control: Column is not output	20071015
4	Importing	VIEW_NUMBER	Call by reference	☐	Type reference (TYPE)	I			20071011

Method FIELDNAME_IN_USESTATS_VIEW on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_FIELD_LIST Signature

Method GET_FIELD_LIST on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_FIELD_LIST on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_INDEX_AND_STATS_DATA Signature

Method GET_INDEX_AND_STATS_DATA on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_INDEX_AND_STATS_DATA on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_PART_INFO Signature

Method GET_PART_INFO on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_PART_INFO on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_RUNTIME_STATISTICS Signature

Method GET_RUNTIME_STATISTICS on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_RUNTIME_STATISTICS on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_SIZE_DATA Signature

Method GET_SIZE_DATA on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_SIZE_DATA on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_SQL_CODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	PARAMS	Call by reference	☐	Type reference (TYPE)	MSS_T_MSQSPPARAM			20130823
2	Importing	REQ	Call by reference	☐	Type reference (TYPE)	MSSQUERYSTATS			20130823
3	Changing	SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20130823

Method GET_SQL_CODE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GET_TABPROPS Signature

Method GET_TABPROPS on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GET_TABPROPS on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method GOTO_DDIC Signature

Method GOTO_DDIC on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method GOTO_DDIC on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method PATTERN_TO_VALUES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	TABVIEW_TAB	Call by reference	☐	Type reference (TYPE)	TABLE			20070604
2	Changing	TV_PATTERN	Call by reference	☐	Type reference (TYPE)	MSSTABLE		Table name	20070604

Method PATTERN_TO_VALUES on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method POPUP_COL_STAT_IN_BROWSER Signature

Method POPUP_COL_STAT_IN_BROWSER on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method POPUP_COL_STAT_IN_BROWSER on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SET_GRID_ATTRIBUTES Signature

Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SET_OPSTATS_LAYOUT Signature

Method SET_OPSTATS_LAYOUT on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method SET_OPSTATS_LAYOUT on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SET_USESTATS_LAYOUT Signature

Method SET_USESTATS_LAYOUT on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method SET_USESTATS_LAYOUT on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SHOW_ABAP_CODE Signature

Method SHOW_ABAP_CODE on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method SHOW_ABAP_CODE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SHOW_DENSITY_OR_SELECTIVITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CMD	Value transfer	☐	Type reference (TYPE)	SYUCOMM		Statistics or index	20070801

Method SHOW_DENSITY_OR_SELECTIVITY on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SHOW_SQL_CODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TAB	Call by reference	☐	Type reference (TYPE)	I			20130823

Method SHOW_SQL_CODE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SHOW_STATISTICS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CMD	Value transfer	☐	Type reference (TYPE)	SYUCOMM		Command requested on index or statistic	20070731
2	Importing	IS_IDX	Value transfer	☐	Type reference (TYPE)	BOOLEAN		True if index, false if statistic	20070802

Method SHOW_STATISTICS on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method SP_RECOMPILE Signature

Method SP_RECOMPILE on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method SP_RECOMPILE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

Method UPDATE_USAGE Signature

Method UPDATE_USAGE on class CL_MSS_ACTION_TABLEDETAIL has no parameter.
Method UPDATE_USAGE on class CL_MSS_ACTION_TABLEDETAIL has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	710