Data Element list used by SAP ABAP Function Module MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement)
SAP ABAP Function Module 
MSS_GET_SQLEXPLAIN (MS SQL Server get explain for a given SQL statement) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DBCON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) LIKE DBCON-CON_NAME DEFAULT 'DEFAULT' |
| 2 | Data Element |
MSQLONGSQL | MS SQL server - SQL statement | SOURCE VALUE(FINAL_COMMAND) LIKE MSQEXPLAIN-LONGSQLTXT OPTIONAL |
| 3 | Data Element |
MSQOBJNAME | Object name as defined in system table sysobjects. | SOURCE VALUE(SP_NAME) LIKE MSQOBJECTS-NAME DEFAULT ' ' |
| 4 | Data Element |
MSQSHPLOPT | MS SQL server - show plan options string. | SOURCE VALUE(STATIO_X) LIKE MSQEXPLAIN-IOSTATSON DEFAULT 'X' |
| 5 | Data Element |
MSQSHPLOPT | MS SQL server - show plan options string. | SOURCE VALUE(NOEXEC_X) LIKE MSQEXPLAIN-NOEXEC DEFAULT ' ' |
| 6 | Data Element |
MSQSHPLOPT | MS SQL server - show plan options string. | SOURCE VALUE(SHOWPLAN_X) LIKE MSQEXPLAIN-SHOWPLANON DEFAULT 'X' |
| 7 | Data Element |
MSQSHPLOPT | MS SQL server - show plan options string. | SOURCE VALUE(TIMESTATS_X) LIKE MSQEXPLAIN-TIMESTATON DEFAULT 'X' |
| 8 | Data Element |
MSQTRFLAGS | MS SQL server - trace flags | SOURCE VALUE(TRACE_FLAGS) LIKE MSQEXPLAIN-TRACEFLAGS DEFAULT ' ' |
| 9 | Data Element |
MSSMIRRFLG | MS SQL Server mirror flag (shows that a device is mirrored) | SOURCE VALUE(GURU_AT_WORK) LIKE MSSHELP-MIRRFLAG DEFAULT ' ' |
| 10 | Data Element |
MSSSCHEMA | Schema name | SOURCE VALUE(SCHEMA) TYPE MSSSCHEMA DEFAULT SPACE |
| 11 | Data Element |
MSSSQLTEXT | SQL definition statement text |
