SAP DB2QPLANHIST table - History plan table details in SAP


SAP DB2QPLANHIST table summary

Object Name: DB2QPLANHIST
Dictionary Type: Structure
Description: History plan table


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

Details
DB2QPLANHIST-MEMBNM table field - DB2 member name in data sharing environment

Description: DB2 member name in data sharing environment
Field Name: MEMBNM
Data Element: DB2MEMN
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR08
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MEMBNM

DB2QPLANHIST-USERID table field -

Description:
Field Name: USERID
Data Element: DB2USERID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERID

DB2QPLANHIST-QUERYNO table field -

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

See all SAP tables containing field QUERYNO

DB2QPLANHIST-PLANDATE table field - Field of type DATS

Description: Field of type DATS
Field Name: PLANDATE
Data Element: DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANDATE

DB2QPLANHIST-PLANTIME table field - Field of type TIMS

Description: Field of type TIMS
Field Name: PLANTIME
Data Element: TIMS
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANTIME

DB2QPLANHIST-PLANMSEC table field - Event time stamp (milliseconds)

Description: Event time stamp (milliseconds)
Field Name: PLANMSEC
Data Element: DB2EVTTMS
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: DB2CHAR06
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANMSEC

DB2QPLANHIST-PLANNO table field -

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

See all SAP tables containing field PLANNO

DB2QPLANHIST-QBLOCKNO table field -

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

See all SAP tables containing field QBLOCKNO

DB2QPLANHIST-ACCESSCREATOR table field -

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

See all SAP tables containing field ACCESSCREATOR

DB2QPLANHIST-ACCESSNAME table field -

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

See all SAP tables containing field ACCESSNAME

DB2QPLANHIST-ACCESSTYPE table field -

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

See all SAP tables containing field ACCESSTYPE

DB2QPLANHIST-ACCESS_DEGREE table field -

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

See all SAP tables containing field ACCESS_DEGREE

DB2QPLANHIST-ACCESS_PGROUP_ID table field -

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

See all SAP tables containing field ACCESS_PGROUP_ID

DB2QPLANHIST-APPLNAME table field -

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

See all SAP tables containing field APPLNAME

DB2QPLANHIST-BIND_TIME table field -

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

See all SAP tables containing field BIND_TIME

DB2QPLANHIST-COLLID table field -

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

See all SAP tables containing field COLLID

DB2QPLANHIST-COLUMN_FN_EVAL table field -

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

See all SAP tables containing field COLUMN_FN_EVAL

DB2QPLANHIST-CORRELATION_NAME table field -

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

See all SAP tables containing field CORRELATION_NAME

DB2QPLANHIST-CREATOR table field -

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

See all SAP tables containing field CREATOR

DB2QPLANHIST-CTEREF table field -

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

See all SAP tables containing field CTEREF

DB2QPLANHIST-GROUP_MEMBER table field -

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

See all SAP tables containing field GROUP_MEMBER

DB2QPLANHIST-HINT_USED table field -

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

See all SAP tables containing field HINT_USED

DB2QPLANHIST-IBM_SERVICE_DATA table field -

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

See all SAP tables containing field IBM_SERVICE_DATA

DB2QPLANHIST-INDEXONLY table field -

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

See all SAP tables containing field INDEXONLY

DB2QPLANHIST-JOIN_DEGREE table field -

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

See all SAP tables containing field JOIN_DEGREE

DB2QPLANHIST-JOIN_PGROUP_ID table field -

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

See all SAP tables containing field JOIN_PGROUP_ID

DB2QPLANHIST-JOIN_TYPE table field -

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

See all SAP tables containing field JOIN_TYPE

DB2QPLANHIST-MATCHCOLS table field -

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

See all SAP tables containing field MATCHCOLS

DB2QPLANHIST-MERGE_JOIN_COLS table field -

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

See all SAP tables containing field MERGE_JOIN_COLS

DB2QPLANHIST-METHOD table field -

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

See all SAP tables containing field METHOD

DB2QPLANHIST-MIXOPSEQ table field -

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

See all SAP tables containing field MIXOPSEQ

DB2QPLANHIST-OPTHINT table field -

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

See all SAP tables containing field OPTHINT

DB2QPLANHIST-PAGE_RANGE table field -

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

See all SAP tables containing field PAGE_RANGE

DB2QPLANHIST-PARALLELISM_MODE table field -

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

See all SAP tables containing field PARALLELISM_MODE

DB2QPLANHIST-PARENT_QBLOCKNO table field -

Description:
Field Name: PARENT_QBLOCKNO
Data Element:
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_QBLOCKNO

DB2QPLANHIST-PREFETCH table field -

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

See all SAP tables containing field PREFETCH

DB2QPLANHIST-PRIMARY_ACCESSTY table field -

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

See all SAP tables containing field PRIMARY_ACCESSTY

DB2QPLANHIST-PROGNAME table field -

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

See all SAP tables containing field PROGNAME

DB2QPLANHIST-QBLOCK_TYPE table field -

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

See all SAP tables containing field QBLOCK_TYPE

DB2QPLANHIST-REMARKS table field -

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

See all SAP tables containing field REMARKS

DB2QPLANHIST-ROUTINE_ID table field -

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

See all SAP tables containing field ROUTINE_ID

DB2QPLANHIST-SORTC_GROUPBY table field -

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

See all SAP tables containing field SORTC_GROUPBY

DB2QPLANHIST-SORTC_JOIN table field -

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

See all SAP tables containing field SORTC_JOIN

DB2QPLANHIST-SORTC_ORDERBY table field -

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

See all SAP tables containing field SORTC_ORDERBY

DB2QPLANHIST-SORTC_PGROUP_ID table field -

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

See all SAP tables containing field SORTC_PGROUP_ID

DB2QPLANHIST-SORTC_UNIQ table field -

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

See all SAP tables containing field SORTC_UNIQ

DB2QPLANHIST-SORTN_GROUPBY table field -

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

See all SAP tables containing field SORTN_GROUPBY

DB2QPLANHIST-SORTN_JOIN table field -

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

See all SAP tables containing field SORTN_JOIN

DB2QPLANHIST-SORTN_ORDERBY table field -

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

See all SAP tables containing field SORTN_ORDERBY

DB2QPLANHIST-SORTN_PGROUP_ID table field -

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

See all SAP tables containing field SORTN_PGROUP_ID

DB2QPLANHIST-SORTN_UNIQ table field -

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

See all SAP tables containing field SORTN_UNIQ

DB2QPLANHIST-STMTTOKEN table field -

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

See all SAP tables containing field STMTTOKEN

DB2QPLANHIST-TABLE_DCCSID table field -

Description:
Field Name: TABLE_DCCSID
Data Element:
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_DCCSID

DB2QPLANHIST-TABLE_ENCODE table field -

Description:
Field Name: TABLE_ENCODE
Data Element:
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_ENCODE

DB2QPLANHIST-TABLE_MCCSID table field -

Description:
Field Name: TABLE_MCCSID
Data Element:
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_MCCSID

DB2QPLANHIST-TABLE_SCCSID table field -

Description:
Field Name: TABLE_SCCSID
Data Element:
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_SCCSID

DB2QPLANHIST-TABLE_TYPE table field -

Description:
Field Name: TABLE_TYPE
Data Element:
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

DB2QPLANHIST-TABNO table field -

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

See all SAP tables containing field TABNO

DB2QPLANHIST-TIMESTAMP table field -

Description:
Field Name: TIMESTAMP
Data Element:
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

DB2QPLANHIST-TNAME table field -

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

See all SAP tables containing field TNAME

DB2QPLANHIST-TSLOCKMODE table field -

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

See all SAP tables containing field TSLOCKMODE

DB2QPLANHIST-VERSION table field -

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

See all SAP tables containing field VERSION

DB2QPLANHIST-WHEN_OPTIMIZE table field -

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

See all SAP tables containing field WHEN_OPTIMIZE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table