SAP MSQEXPLAIN table - MS SQL server - sql statement execution plan options details in SAP

SAP MSQEXPLAIN table summary

Object Name: MSQEXPLAIN
Dictionary Type: Structure
Description: MS SQL server - sql statement execution plan options

Field list for MSQEXPLAIN table on an S/4 SAP system

Details

MSQEXPLAIN-LONGSQLTXT table field - MS SQL server - SQL statement ▼

Description: MS SQL server - SQL statement
Field Name: LONGSQLTXT
Data Element: MSQLONGSQL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LONGSQLTXT

MSQEXPLAIN-SIMPLEEXPL table field - MS SQL server - show plan options string. ▼

Description: MS SQL server - show plan options string.
Field Name: SIMPLEEXPL
Data Element: MSQSHPLOPT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SIMPLEEXPL

MSQEXPLAIN-IOSTATSON table field - MS SQL server - show plan options string. ▼

Description: MS SQL server - show plan options string.
Field Name: IOSTATSON
Data Element: MSQSHPLOPT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IOSTATSON

MSQEXPLAIN-TIMESTATON table field - MS SQL server - show plan options string. ▼

Description: MS SQL server - show plan options string.
Field Name: TIMESTATON
Data Element: MSQSHPLOPT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMESTATON

MSQEXPLAIN-SHOWPLANON table field - MS SQL server - show plan options string. ▼

Description: MS SQL server - show plan options string.
Field Name: SHOWPLANON
Data Element: MSQSHPLOPT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHOWPLANON

MSQEXPLAIN-TRACEFLAGS table field - MS SQL server - trace flags ▼

Description: MS SQL server - trace flags
Field Name: TRACEFLAGS
Data Element: MSQTRFLAGS
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRACEFLAGS

MSQEXPLAIN-NOEXEC table field - MS SQL server - show plan options string. ▼

Description: MS SQL server - show plan options string.
Field Name: NOEXEC
Data Element: MSQSHPLOPT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOEXEC

View list of all SAP tables(S4H/ECC)

Select data from SAP table