SAP HDB_P_QUERYPLANS table - Structure for P_QUERYPLANS for EXPLAIN details in SAP

SAP HDB_P_QUERYPLANS table summary

Object Name: HDB_P_QUERYPLANS
Dictionary Type: Structure
Description: Structure for P_QUERYPLANS for EXPLAIN

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

Details

HDB_P_QUERYPLANS-STATEMENT_NAME table field - explain plan command internal ▼

Description: explain plan command internal
Field Name: STATEMENT_NAME
Data Element: STATEMENT_NAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATEMENT_NAME

HDB_P_QUERYPLANS-OP_NAME table field - Name of logical operator ▼

Description: Name of logical operator
Field Name: OP_NAME
Data Element: OPERATOR_NAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OP_NAME

HDB_P_QUERYPLANS-OP_DETAILS table field - additional information ▼

Description: additional information
Field Name: OP_DETAILS
Data Element: OPERATOR_DETAILS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OP_DETAILS

HDB_P_QUERYPLANS-OPERATOR_PROPERTIES table field - Internal properties of an operator ▼

Description: Internal properties of an operator
Field Name: OPERATOR_PROPERTIES
Data Element: OP_PROPERTIES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OPERATOR_PROPERTIES

HDB_P_QUERYPLANS-EXECUTION_ENGINE table field - List of all involved execution frameworks ▼

Description: List of all involved execution frameworks
Field Name: EXECUTION_ENGINE
Data Element: EXECUTION_ENGINE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECUTION_ENGINE

HDB_P_QUERYPLANS-DATABASE_NAME table field - database name the object belongs to ▼

Description: database name the object belongs to
Field Name: DATABASE_NAME
Data Element: DATABASE_NAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATABASE_NAME

HDB_P_QUERYPLANS-SCHEMA_NAME table field - schema name the dependent object belongs to ▼

Description: schema name the dependent object belongs to
Field Name: SCHEMA_NAME
Data Element: SCHEMA_NAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEMA_NAME

HDB_P_QUERYPLANS-OBJ_NAME table field - Name of the database tables and views accessed by operator ▼

Description: Name of the database tables and views accessed by operator
Field Name: OBJ_NAME
Data Element: HDB_TAB_NAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJ_NAME

HDB_P_QUERYPLANS-TABLE_TYPE table field - type stored type . COLUMN or ROW ▼

Description: type stored type . COLUMN or ROW
Field Name: TABLE_TYPE
Data Element: HDB_TAB_TYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_TYPE

HDB_P_QUERYPLANS-SUBTREE_COST table field - estimated cost of executing tje subtree starting from an op ▼

Description: estimated cost of executing tje subtree starting from an op
Field Name: SUBTREE_COST
Data Element: SUBTREE_COST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUBTREE_COST

HDB_P_QUERYPLANS-INPUT_CARDINALITY table field - Estimated input row count of an operator. ▼

Description: Estimated input row count of an operator.
Field Name: INPUT_CARDINALITY
Data Element: TABLE_SIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INPUT_CARDINALITY

HDB_P_QUERYPLANS-OUTPUT_CARDINALITY table field - estimated output row count of an operator ▼

Description: estimated output row count of an operator
Field Name: OUTPUT_CARDINALITY
Data Element: OUTPUT_SIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTPUT_CARDINALITY

HDB_P_QUERYPLANS-OP_ID table field - unique ID of an operator. ▼

Description: unique ID of an operator.
Field Name: OP_ID
Data Element: OPERATOR_ID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OP_ID

HDB_P_QUERYPLANS-PARENT_OP_ID table field - Operator id of the parent of an operator ▼

Description: Operator id of the parent of an operator
Field Name: PARENT_OP_ID
Data Element: PARENT_OPERATOR_ID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT_OP_ID

HDB_P_QUERYPLANS-HDB_LEVEL table field - level from the root operator ▼

Description: level from the root operator
Field Name: HDB_LEVEL
Data Element: OPERATOR_LEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDB_LEVEL

HDB_P_QUERYPLANS-HDB_POSITION table field - position in the parent operator ▼

Description: position in the parent operator
Field Name: HDB_POSITION
Data Element: OPERATOR_POSITION
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HDB_POSITION

HDB_P_QUERYPLANS-TIMESTAMP table field - Time stamp (stored in format YYYY-MM-DD HH:MM:SS) ▼

Description: Time stamp (stored in format YYYY-MM-DD HH:MM:SS)
Field Name: TIMESTAMP
Data Element: HDB_TSTMP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMESTAMP

HDB_P_QUERYPLANS-HOST table field - target node where the execution is expected to take place ▼

Description: target node where the execution is expected to take place
Field Name: HOST
Data Element: TARGET_HOST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOST

HDB_P_QUERYPLANS-PORT table field - Target node where the execution is expected to take place ▼

Description: Target node where the execution is expected to take place
Field Name: PORT
Data Element: TARGET_PORT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PORT

HDB_P_QUERYPLANS-CONNECTION_ID table field - connection id ▼

Description: connection id
Field Name: CONNECTION_ID
Data Element: CONNECTION_ID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTION_ID