SAP MSSXPLPLAN table - Structured output from queries when set showplan_all is on. details in SAP

SAP MSSXPLPLAN table summary

Object Name: MSSXPLPLAN
Dictionary Type: Structure
Description: Structured output from queries when set showplan_all is on.

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

Details

MSSXPLPLAN-STMTTEXT table field - Text of showplan output ▼

Description: Text of showplan output
Field Name: STMTTEXT
Data Element: MSSXPLTXT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMTTEXT

MSSXPLPLAN-STMTID table field - MSS: Plan statement ID ▼

Description: MSS: Plan statement ID
Field Name: STMTID
Data Element: MSSPLSTMTID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMTID

MSSXPLPLAN-NODEID table field - MSS: Plan node ID ▼

Description: MSS: Plan node ID
Field Name: NODEID
Data Element: MSSPLNODEID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODEID

MSSXPLPLAN-PARENT table field - MSS: Plan parent node ▼

Description: MSS: Plan parent node
Field Name: PARENT
Data Element: MSSPLPARENT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT

MSSXPLPLAN-PHYSICALOP table field - MSS:Plan physical operation name ▼

Description: MSS:Plan physical operation name
Field Name: PHYSICALOP
Data Element: MSSPLPHYSOP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYSICALOP

MSSXPLPLAN-LOGICALOP table field - MSS: Plan logical operation name ▼

Description: MSS: Plan logical operation name
Field Name: LOGICALOP
Data Element: MSSPLLOGOP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICALOP

MSSXPLPLAN-ARG table field - MSS: Plan arguments ▼

Description: MSS: Plan arguments
Field Name: ARG
Data Element: MSSPLARG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARG

MSSXPLPLAN-DEFVAL table field - MSS: Plan defined values ▼

Description: MSS: Plan defined values
Field Name: DEFVAL
Data Element: MSSPLDEFVAL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFVAL

MSSXPLPLAN-ESTROWS table field - MSS: Plan estimated rows ▼

Description: MSS: Plan estimated rows
Field Name: ESTROWS
Data Element: MSSPLESTROWS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTROWS

MSSXPLPLAN-ESTIO table field - MSS: Plan estimated IO ▼

Description: MSS: Plan estimated IO
Field Name: ESTIO
Data Element: MSSPLESTIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTIO

MSSXPLPLAN-ESTCPU table field - MSS: Plan estimated CPU ▼

Description: MSS: Plan estimated CPU
Field Name: ESTCPU
Data Element: MSSPLESTCPU
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTCPU

MSSXPLPLAN-AVGROWSZ table field - MSS: Plan average row size ▼

Description: MSS: Plan average row size
Field Name: AVGROWSZ
Data Element: MSSPLAVGROWSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVGROWSZ

MSSXPLPLAN-TOTSUBTREECO table field - MSS: Plan total subtree cost ▼

Description: MSS: Plan total subtree cost
Field Name: TOTSUBTREECO
Data Element: MSSPLTREECOST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTSUBTREECO

MSSXPLPLAN-OUTPUTLIST table field - MSS: Plan output list ▼

Description: MSS: Plan output list
Field Name: OUTPUTLIST
Data Element: MSSPLOUTLST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTPUTLIST

MSSXPLPLAN-WARNINGS table field - MSS: Plan warnings ▼

Description: MSS: Plan warnings
Field Name: WARNINGS
Data Element: MSSPLWARN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WARNINGS

MSSXPLPLAN-OPTYPE table field - MSS: Plan operation type ▼

Description: MSS: Plan operation type
Field Name: OPTYPE
Data Element: MSSPLOPTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPTYPE

MSSXPLPLAN-PARALLEL table field - MSS: Plan parallel flag ▼

Description: MSS: Plan parallel flag
Field Name: PARALLEL
Data Element: MSSPLPARALLEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARALLEL

MSSXPLPLAN-ESTEXECS table field - MSS: Plan estimated executions ▼

Description: MSS: Plan estimated executions
Field Name: ESTEXECS
Data Element: MSSPLESTEXECS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ESTEXECS

View list of all SAP tables(S4H/ECC)

Select data from SAP table