SAP /SCMTMS/S_QUERY_ENHANCE table - Query enhancement table details in SAP

SAP /SCMTMS/S_QUERY_ENHANCE table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

Object Name: /SCMTMS/S_QUERY_ENHANCE
Dictionary Type: Structure
Description: Query enhancement table

Field list for /SCMTMS/S_QUERY_ENHANCE table on an S/4 SAP system

Details

/SCMTMS/S_QUERY_ENHANCE-QUERY_CAT table field - Query Category: '': Standard Query; 'G':Gen.Result Query ▼

Description: Query Category: '': Standard Query; 'G':Gen.Result Query
Field Name: QUERY_CAT
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 QUERY_CAT

/SCMTMS/S_QUERY_ENHANCE-QUERY_KEY table field - Query ▼

Description: Query
Field Name: QUERY_KEY
Data Element: /BOBF/OBM_QUERY_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUERY_KEY

/SCMTMS/S_QUERY_ENHANCE-ATTR_NODE_KEY table field - Node ▼

Description: Node
Field Name: ATTR_NODE_KEY
Data Element: /BOBF/OBM_NODE_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ATTR_NODE_KEY

/SCMTMS/S_QUERY_ENHANCE-SRC_DB_NAME table field - Table Name ▼

Description: Table Name
Field Name: SRC_DB_NAME
Data Element: TABNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: AS4TAB
MemoryID: DTB
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRC_DB_NAME

/SCMTMS/S_QUERY_ENHANCE-DB_COUNTER table field - Source DB Count ▼

Description: Source DB Count
Field Name: DB_COUNTER
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 DB_COUNTER

/SCMTMS/S_QUERY_ENHANCE-NODE_ATTR table field - Node Attribute ▼

Description: Node Attribute
Field Name: NODE_ATTR
Data Element: /SCMTMS/QENH_NODE_ATTRIBUTE
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODE_ATTR

/SCMTMS/S_QUERY_ENHANCE-EXT_BO_KEY table field - Business Object ▼

Description: Business Object
Field Name: EXT_BO_KEY
Data Element: /BOBF/OBM_BO_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXT_BO_KEY

/SCMTMS/S_QUERY_ENHANCE-EXT_NODE_KEY table field - Node ▼

Description: Node
Field Name: EXT_NODE_KEY
Data Element: /BOBF/OBM_NODE_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXT_NODE_KEY

/SCMTMS/S_QUERY_ENHANCE-TRGT_DB_NAME table field - Table Name ▼

Description: Table Name
Field Name: TRGT_DB_NAME
Data Element: TABNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: AS4TAB
MemoryID: DTB
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRGT_DB_NAME

/SCMTMS/S_QUERY_ENHANCE-TRGT_DB_COUNTER table field - Target DB Count ▼

Description: Target DB Count
Field Name: TRGT_DB_COUNTER
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 TRGT_DB_COUNTER

/SCMTMS/S_QUERY_ENHANCE-NODE_JOIN_ATTR table field - Source Join Attribute (on Cross BO Assoc. Node of Query BO) ▼

Description: Source Join Attribute (on Cross BO Assoc. Node of Query BO)
Field Name: NODE_JOIN_ATTR
Data Element: /SCMTMS/QENH_NODE_JOIN_ATTR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODE_JOIN_ATTR

/SCMTMS/S_QUERY_ENHANCE-TRGT_JOIN_ATTR table field - External Join Attribute (Cross BO Assoc. Node or DB Table) ▼

Description: External Join Attribute (Cross BO Assoc. Node or DB Table)
Field Name: TRGT_JOIN_ATTR
Data Element: /SCMTMS/QENH_EXT_JOIN_ATTR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRGT_JOIN_ATTR

/SCMTMS/S_QUERY_ENHANCE-NODE_JOIN_ATTR2 table field - Add. Join Attribute (on Src/Trgt DB Table Such as LANGU) ▼

Description: Add. Join Attribute (on Src/Trgt DB Table Such as LANGU)
Field Name: NODE_JOIN_ATTR2
Data Element: /SCMTMS/QENH_NODE_JOIN_ATTR2
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODE_JOIN_ATTR2

/SCMTMS/S_QUERY_ENHANCE-TRGT_JOIN_ATTR2 table field - External Join Attribute (Cross BO Assoc. Node or DB Table) ▼

Description: External Join Attribute (Cross BO Assoc. Node or DB Table)
Field Name: TRGT_JOIN_ATTR2
Data Element: /SCMTMS/QENH_EXT_JOIN_ATTR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRGT_JOIN_ATTR2

/SCMTMS/S_QUERY_ENHANCE-ND_JN_ATTR2_VAL table field - Target Node Join Attribute Value ▼

Description: Target Node Join Attribute Value
Field Name: ND_JN_ATTR2_VAL
Data Element: /SCMTMS/QENH_NODE_JOIN_VAL
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/QENH_NODE_JOIN_VAL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ND_JN_ATTR2_VAL

/SCMTMS/S_QUERY_ENHANCE-ND_JN_ATTR2_C table field - Target Node Join Attribute Value from Constant or Type ▼

Description: Target Node Join Attribute Value from Constant or Type
Field Name: ND_JN_ATTR2_C
Data Element: /SCMTMS/QENH_NODE_JOIN_C
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ND_JN_ATTR2_C

/SCMTMS/S_QUERY_ENHANCE-NODE_JOIN_ATTR3 table field - Add. Join Attribute (on Src/Trgt DB Table Such as LANGU) ▼

Description: Add. Join Attribute (on Src/Trgt DB Table Such as LANGU)
Field Name: NODE_JOIN_ATTR3
Data Element: /SCMTMS/QENH_NODE_JOIN_ATTR2
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODE_JOIN_ATTR3

/SCMTMS/S_QUERY_ENHANCE-ND_JN_ATTR3_VAL table field - Target Node Join Attribute Value ▼

Description: Target Node Join Attribute Value
Field Name: ND_JN_ATTR3_VAL
Data Element: /SCMTMS/QENH_NODE_JOIN_VAL
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/QENH_NODE_JOIN_VAL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ND_JN_ATTR3_VAL

/SCMTMS/S_QUERY_ENHANCE-ND_JN_ATTR3_C table field - Target Node Join Attribute Value from Constant or Type ▼

Description: Target Node Join Attribute Value from Constant or Type
Field Name: ND_JN_ATTR3_C
Data Element: /SCMTMS/QENH_NODE_JOIN_C
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ND_JN_ATTR3_C

/SCMTMS/S_QUERY_ENHANCE-QUERY_ATTR table field - Query Attribute ▼

Description: Query Attribute
Field Name: QUERY_ATTR
Data Element: /SCMTMS/QENH_QUERY_ATTR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUERY_ATTR

/SCMTMS/S_QUERY_ENHANCE-QUERY_ATTR_GRPID table field - Query attribute group ID ▼

Description: Query attribute group ID
Field Name: QUERY_ATTR_GRPID
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 QUERY_ATTR_GRPID

/SCMTMS/S_QUERY_ENHANCE-FILTER_AFTER_SELECTION table field - Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') ▼

Description: Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
Field Name: FILTER_AFTER_SELECTION
Data Element: BOOLE_D
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BOOLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILTER_AFTER_SELECTION

/SCMTMS/S_QUERY_ENHANCE-NO_ALPHA_CONV table field - Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') ▼

Description: Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
Field Name: NO_ALPHA_CONV
Data Element: BOOLE_D
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BOOLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NO_ALPHA_CONV

/SCMTMS/S_QUERY_ENHANCE-S_SUBQUERY_EXISTS table field - ▼

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

See all SAP tables containing field S_SUBQUERY_EXISTS

/SCMTMS/S_QUERY_ENHANCE-SRC_DB_COUNTER table field - Two digit number ▼

Description: Two digit number
Field Name: SRC_DB_COUNTER
Data Element: NUMC2
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: NUMC2
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRC_DB_COUNTER

/SCMTMS/S_QUERY_ENHANCE-SRC_DB_NAME table field - Table Name ▼

/SCMTMS/S_QUERY_ENHANCE-NODE_JOIN_ATTR table field - Field Name ▼

Description: Field Name
Field Name: NODE_JOIN_ATTR
Data Element: FIELDNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID: DFD
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NODE_JOIN_ATTR

/SCMTMS/S_QUERY_ENHANCE-TRGT_JOIN_ATTR table field - Field Name ▼

Description: Field Name
Field Name: TRGT_JOIN_ATTR
Data Element: FIELDNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: FDNAME
MemoryID: DFD
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRGT_JOIN_ATTR

/SCMTMS/S_QUERY_ENHANCE-NEGATIVE_SUBQUERY table field - Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') ▼

Description: Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
Field Name: NEGATIVE_SUBQUERY
Data Element: BOOLE_D
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BOOLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEGATIVE_SUBQUERY

/SCMTMS/S_QUERY_ENHANCE-T_ENHANCE_DEF table field - ▼

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

See all SAP tables containing field T_ENHANCE_DEF

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279

View list of all SAP tables(S4H/ECC)

Select data from SAP table