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 |