Hierarchy

⤷

⤷

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 | 20080515 |
Meta Relationship - Used By
# | Relationship type | Used by | Short Description | Created on |
---|---|---|---|---|
1 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_ACTION_QA_INIT | SQL Command Editor | 20080522 |
Properties
Class | CL_MSS_ACTION_QA | |
Short Description | Query Analyzer, SQL Command Window, Explain | |
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 | 20080515 | SAP |
Last change | 20130531 | SAP |
Shared Memory-enabled | ||
Fixed point arithmetic | ||
Unicode checks active |
Forward declarations
# | Type group / Object type | Type | Type Description |
---|---|---|---|
1 | ![]() |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
2 | ![]() |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class CL_MSS_ACTION_QA has no interface implemented.
Friends
Class CL_MSS_ACTION_QA has no friend class.
Attributes
Methods
# | Method | Level | Visibility | Method type | Description | Created on |
---|---|---|---|---|---|---|
1 | ![]() |
Instance method | Private | Method | Build nodes and items for the tree using plan_rowset | 20080519 |
2 | ![]() |
Instance method | Private | Method | Reset the connection back to the original | 20080516 |
3 | ![]() |
Instance method | Private | Method | Create a temporary stored proc name for explain purposes | 20080528 |
4 | ![]() |
Instance method | Private | Method | Create the tree controls | 20080516 |
5 | ![]() |
Instance method | Private | Method | Go to db02 single table analysis for current table | 20080520 |
6 | ![]() |
Instance method | Private | Method | Display XML plan in external browser | 20080520 |
7 | ![]() |
Instance method | Private | Method | Execute current SQL Query | 20080515 |
8 | ![]() |
Instance method | Private | Method | Redirect the connection temporarily for explain | 20080515 |
9 | ![]() |
Instance method | Private | Method | Switch the editor on or off | 20080605 |
10 | ![]() |
Instance method | Private | Method | Utility method to execute code - possibly redirected | 20080528 |
11 | ![]() |
Instance method | Private | Method | Read types from xml stmt. Fill in it_para. | 20080721 |
12 | ![]() |
Instance method | Private | Method | Show the property values on the prop alv | 20080519 |
13 | ![]() |
Instance method | Private | Method | Get raw explain output and format for edit control | 20080516 |
14 | ![]() |
Instance method | Private | Method | Read the SQL Code edit control and fill it_code | 20080515 |
15 | ![]() |
Instance method | Private | Method | Simple determination of type of command | 20080527 |
16 | ![]() |
Static method | Public | Method | Read the XML Plan and generate it_raw_text_explain | 20080521 |
17 | ![]() |
Static method | Private | Method | For a given row in the plan_rowset, fill a list of propertie | 20080717 |
18 | ![]() |
Instance method | Private | Method | Get statistics to show in the text explain output | 20080516 |
19 | ![]() |
Instance method | Private | Method | Given a row in the plan rowset, get the tabname if possible | 20080520 |
20 | ![]() |
Instance method | Private | Method | Get the table name from raw text explain output | 20080516 |
21 | ![]() |
Instance method | Private | Method | Convert the editor code into something we can explain | 20080523 |
22 | ![]() |
Instance method | Private | Method | Generate the it_plan_data given the it_tmp_stmt_lines | 20080516 |
23 | ![]() |
Instance method | Private | Event handling method | Handle event data_changed for para_alv grid | 20080714 |
24 | ![]() |
Instance method | Private | Event handling method | Handle double click on property grid | 20080519 |
25 | ![]() |
Instance method | Private | Event handling method | Handle double click on node in explain tree | 20080519 |
26 | ![]() |
Instance method | Private | Event handling method | Handle double click on node in explain tree | 20080519 |
27 | ![]() |
Instance method | Private | Method | Display statistics for current table in a browser | 20080523 |
28 | ![]() |
Instance method | Private | Method | Display statistics for current index in a browser | 20080523 |
29 | ![]() |
Instance method | Private | Method | Read the xchg_data and set internal variables. | 20080515 |
30 | ![]() |
Instance method | Private | Method | Create the node and item tables and show them on the screen | 20080519 |
31 | ![]() |
Instance method | Private | Method | Show the contents of it_xpl_txt. | 20080516 |
32 | ![]() |
Instance method | Private | Method | Set grid attributes | 20080515 |
33 | ![]() |
Instance method | Private | Method | Set the value of the edit control in the XPL tree | 20080519 |
34 | ![]() |
Instance method | Private | Method | Display the abap code for the current statement | 20080520 |
35 | ![]() |
Instance method | Private | Method | Produce explain in a textual format for current data | 20080515 |
36 | ![]() |
Instance method | Private | Method | Run explain and display the tree control. | 20080516 |
37 | ![]() |
Instance method | Private | Method | Convert st05 value list to our preferred parameter list | 20080516 |
Events
Class CL_MSS_ACTION_QA has no event.
Types
# | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
---|---|---|---|---|---|---|---|
1 | T_DATAFLDS | Private | See coding | 20080519 | begin of t_dataflds,
name type tv_itmname,
len type i,
end of t_dataflds
|
||
2 | T_IT_DATAFLDS | Private | See coding | 20080519 | t_it_dataflds type standard table of t_dataflds
|
||
3 | T_PROP | Private | See coding | 20080519 | begin of t_prop,
name type tv_itmname,
descr(32) type c,
len type i,
end of t_prop
|
||
4 | T_XPLPLAN | Private | Type reference (TYPE) | MSSXPLPLAN | 20080519 |
|
|
5 | T_XPLPROPS | Private | Type reference (TYPE) | MSSXPLPROPS | 20080519 |
|
|
6 | T_XPLPROPSTAB | Private | See coding | 20080717 | t_xplpropstab type standard table of t_xplprops
|
Method Signatures
Method BUILD_NODE_AND_ITEM_TABLE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
DATAFLDS | Call by reference | Type reference (TYPE) | T_IT_DATAFLDS | 20080519 | |||
2 | ![]() |
ITEM_TABLE | Call by reference | Type reference (TYPE) | MSSXPLTREEITM_TAB | Tree item for Explain tree control | 20080519 | ||
3 | ![]() |
NODE_TABLE | Call by reference | Type reference (TYPE) | TREEV_NTAB | Tree Control: Node Table | 20080519 |
Method BUILD_NODE_AND_ITEM_TABLE on class CL_MSS_ACTION_QA has no exception.
Method CLEANUP_REDIRECT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
TMP_CON_NAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20080516 |
Method CLEANUP_REDIRECT on class CL_MSS_ACTION_QA has no exception.
Method CONSTRUCT_TEMP_SPNAME Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
SPNAME | Call by reference | Type reference (TYPE) | MSSSPNAME | Stored procedure name | 20080528 |
Method CONSTRUCT_TEMP_SPNAME on class CL_MSS_ACTION_QA has no exception.
Method CREATE_EXPLAIN_TREE Signature
Method CREATE_EXPLAIN_TREE on class CL_MSS_ACTION_QA has no parameter.
Method CREATE_EXPLAIN_TREE on class CL_MSS_ACTION_QA has no exception.
Method DISPLAY_TABLE_DETAILS Signature
Method DISPLAY_TABLE_DETAILS on class CL_MSS_ACTION_QA has no parameter.
Method DISPLAY_TABLE_DETAILS on class CL_MSS_ACTION_QA has no exception.
Method DISPLAY_XML Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
FILENAME | Call by reference | Type reference (TYPE) | STRING | 20080520 | |||
2 | ![]() |
XML_SHOWPLAN | Value transfer | Type reference (TYPE) | STRING | 20080520 |
Method DISPLAY_XML on class CL_MSS_ACTION_QA has no exception.
Method DO_EXECUTE Signature
Method DO_EXECUTE on class CL_MSS_ACTION_QA has no parameter.
Method DO_EXECUTE on class CL_MSS_ACTION_QA has no exception.
Method DO_REDIRECT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
TMP_CON_NAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20080516 |
Method DO_REDIRECT on class CL_MSS_ACTION_QA has no exception.
Method ED_TOGGLE Signature
Method ED_TOGGLE on class CL_MSS_ACTION_QA has no parameter.
Method ED_TOGGLE on class CL_MSS_ACTION_QA has no exception.
Method EXEC_SQL_CODE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
SOMESTR | Call by reference | Type reference (TYPE) | MSSSQLTEXT | SQL definition statement text | 20080528 | ||
2 | ![]() |
SUBRC | Value transfer | Type reference (TYPE) | INT4 | Success code | 20080528 |
Method EXEC_SQL_CODE on class CL_MSS_ACTION_QA has no exception.
Method FILL_IN_TYPES_FROM_XML Signature
Method FILL_IN_TYPES_FROM_XML on class CL_MSS_ACTION_QA has no parameter.
Method FILL_IN_TYPES_FROM_XML on class CL_MSS_ACTION_QA has no exception.
Method FILL_XPLPROPS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
NODE_KEY | Call by reference | Type reference (TYPE) | TV_NODEKEY | Tree Control: Node Key | 20080519 |
Method FILL_XPLPROPS on class CL_MSS_ACTION_QA has no exception.
Method FORMAT_TEXT_EXPLAIN Signature
Method FORMAT_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no parameter.
Method FORMAT_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no exception.
Method GET_CODE_AS_TABLE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
IS_MODIFIED | Value transfer | Type reference (TYPE) | I | 20080515 |
Method GET_CODE_AS_TABLE on class CL_MSS_ACTION_QA has no exception.
Method GET_COMMAND_TYPE Signature
Method GET_COMMAND_TYPE on class CL_MSS_ACTION_QA has no parameter.
Method GET_COMMAND_TYPE on class CL_MSS_ACTION_QA has no exception.
Method GET_PLAN_TEXT_FROM_XML Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
IT_TEXT_EXPLAIN | Call by reference | Type reference (TYPE) | STANDARD TABLE | MS SQL server - stored procedure text | 20100120 | ||
2 | ![]() |
XML_SHOWPLAN | Call by reference | Type reference (TYPE) | STRING | 20100120 |
Method GET_PLAN_TEXT_FROM_XML on class CL_MSS_ACTION_QA has no exception.
Method GET_PROPERTY_LIST Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
PLAN_ROWSET_ROW | Call by reference | Type reference (TYPE) | MSSXPLPLAN | Structured output from queries when set showplan_all is on. | 20080717 | ||
2 | ![]() |
PROPS_TAB | Call by reference | Type reference (TYPE) | T_XPLPROPSTAB | 20080717 |
Method GET_PROPERTY_LIST on class CL_MSS_ACTION_QA has no exception.
Method GET_SIMPLE_STATS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
TABNAME | Call by reference | Type reference (TYPE) | MSSTABLE | Table name | 20080516 |
Method GET_SIMPLE_STATS on class CL_MSS_ACTION_QA has no exception.
Method GET_TABLE_FROM_PLAN_ROWSET Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
ROW | Call by reference | Type reference (TYPE) | T_XPLPLAN | 20080520 |
Method GET_TABLE_FROM_PLAN_ROWSET on class CL_MSS_ACTION_QA has no exception.
Method GET_TABLE_FROM_TEXT_EXPLAIN Signature
Method GET_TABLE_FROM_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no parameter.
Method GET_TABLE_FROM_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no exception.
Method GET_TMP_STMT_LINES Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
IS_IT_OK | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20080523 |
Method GET_TMP_STMT_LINES on class CL_MSS_ACTION_QA has no exception.
Method GET_TREE_DATA Signature
Method GET_TREE_DATA on class CL_MSS_ACTION_QA has no parameter.
Method GET_TREE_DATA on class CL_MSS_ACTION_QA has no exception.
Method HANDLE_DATA_CHANGED Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
ER_DATA_CHANGED | Value transfer | Attribute reference (LIKE) | 20080714 |
Method HANDLE_DATA_CHANGED on class CL_MSS_ACTION_QA has no exception.
Method HANDLE_GRID_DOUBLE_CLICK Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
E_ROW | Value transfer | Attribute reference (LIKE) | 20080519 |
Method HANDLE_GRID_DOUBLE_CLICK on class CL_MSS_ACTION_QA has no exception.
Method HANDLE_ITEM_DOUBLE_CLICK Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
NODE_KEY | Value transfer | Attribute reference (LIKE) | 20080519 |
Method HANDLE_ITEM_DOUBLE_CLICK on class CL_MSS_ACTION_QA has no exception.
Method HANDLE_NODE_DOUBLE_CLICK Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
NODE_KEY | Value transfer | Attribute reference (LIKE) | 20080519 |
Method HANDLE_NODE_DOUBLE_CLICK on class CL_MSS_ACTION_QA has no exception.
Method POPUP_COL_STAT_IN_BROWSER Signature
Method POPUP_COL_STAT_IN_BROWSER on class CL_MSS_ACTION_QA has no parameter.
Method POPUP_COL_STAT_IN_BROWSER on class CL_MSS_ACTION_QA has no exception.
Method POPUP_IDX_STAT_IN_BROWSER Signature
Method POPUP_IDX_STAT_IN_BROWSER on class CL_MSS_ACTION_QA has no parameter.
Method POPUP_IDX_STAT_IN_BROWSER on class CL_MSS_ACTION_QA has no exception.
Method PROCESS_PARAMETERS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
NEW_SESSION | Call by reference | Type reference (TYPE) | C | SPACE | We are starting a new session in a new window | 20110318 |
Method PROCESS_PARAMETERS on class CL_MSS_ACTION_QA has no exception.
Method REFRESH_EXPLAIN_TREE Signature
Method REFRESH_EXPLAIN_TREE on class CL_MSS_ACTION_QA has no parameter.
Method REFRESH_EXPLAIN_TREE on class CL_MSS_ACTION_QA has no exception.
Method REFRESH_TEXT_EXPLAIN Signature
Method REFRESH_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no parameter.
Method REFRESH_TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no exception.
Method SET_GRID_ATTRIBUTES Signature
Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_QA has no parameter.
Method SET_GRID_ATTRIBUTES on class CL_MSS_ACTION_QA has no exception.
Method SET_LONGTEXT Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
TXT | Value transfer | Type reference (TYPE) | MSSXPLPROPVALUE | Property Value | 20080519 |
Method SET_LONGTEXT on class CL_MSS_ACTION_QA has no exception.
Method SHOW_ABAP_CODE Signature
Method SHOW_ABAP_CODE on class CL_MSS_ACTION_QA has no parameter.
Method SHOW_ABAP_CODE on class CL_MSS_ACTION_QA has no exception.
Method TEXT_EXPLAIN Signature
Method TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no parameter.
Method TEXT_EXPLAIN on class CL_MSS_ACTION_QA has no exception.
Method TREE_EXPLAIN Signature
Method TREE_EXPLAIN on class CL_MSS_ACTION_QA has no parameter.
Method TREE_EXPLAIN on class CL_MSS_ACTION_QA has no exception.
Method VALUES_TO_PARAMS Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
STMT_STR | Call by reference | Type reference (TYPE) | STRING | 20080516 | |||
2 | ![]() |
VALUES | Call by reference | Object reference (TYPE REF TO) | DATA | 20080516 |
Method VALUES_TO_PARAMS on class CL_MSS_ACTION_QA has no exception.
History
Last changed by/on | SAP | 20130531 |
SAP Release Created in | 711 |