SAP CRMS4S_PRIL_QUERY_ADVSEARCH table - Advanced Search for Products details in SAP

SAP CRMS4S_PRIL_QUERY_ADVSEARCH table summary

Object Name: CRMS4S_PRIL_QUERY_ADVSEARCH
Dictionary Type: Structure
Description: Advanced Search for Products

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

Details

CRMS4S_PRIL_QUERY_ADVSEARCH-PRODUCT_ID table field - Material Number ▼

Description: Material Number
Field Name: PRODUCT_ID
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field PRODUCT_ID

CRMS4S_PRIL_QUERY_ADVSEARCH-PRODUCT_TYPE table field - Product Type Group ▼

Description: Product Type Group
Field Name: PRODUCT_TYPE
Data Element: PRODUCT_TYPE
Data Type: CHAR
length (Dec): 2(0)
Check table: CMD_PRDTYPE
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODUCT_TYPE

CRMS4S_PRIL_QUERY_ADVSEARCH-DESCRIPTION table field - Material Description ▼

Description: Material Description
Field Name: DESCRIPTION
Data Element: MAKTX
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPTION

CRMS4S_PRIL_QUERY_ADVSEARCH-MATERIAL_TYPE table field - Material type ▼

Description: Material type
Field Name: MATERIAL_TYPE
Data Element: MTART
Data Type: CHAR
length (Dec): 4(0)
Check table: T134
Conversion Routine:
Domain Name: MTART
MemoryID: MTA
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MATERIAL_TYPE

CRMS4S_PRIL_QUERY_ADVSEARCH-PRODUCT_HIERARCHY table field - Product hierarchy ▼

Description: Product hierarchy
Field Name: PRODUCT_HIERARCHY
Data Element: PRODH_D
Data Type: CHAR
length (Dec): 18(0)
Check table: T179
Conversion Routine:
Domain Name: PRODH
MemoryID: VPR
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODUCT_HIERARCHY

CRMS4S_PRIL_QUERY_ADVSEARCH-CREATED_BY table field - User Name ▼

Description: User Name
Field Name: CREATED_BY
Data Element: SYUNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR12
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_BY

CRMS4S_PRIL_QUERY_ADVSEARCH-CREATED_ON table field - Date data element for SYST ▼

Description: Date data element for SYST
Field Name: CREATED_ON
Data Element: SYDATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYDATS
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATED_ON

CRMS4S_PRIL_QUERY_ADVSEARCH-PRODUCTISCONFIGURABLE table field - Configurable Material ▼

Description: Configurable Material
Field Name: PRODUCTISCONFIGURABLE
Data Element: KZKFG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODUCTISCONFIGURABLE

CRMS4S_PRIL_QUERY_ADVSEARCH-MAIN_GTIN table field - International Article Number (EAN/UPC) ▼

Description: International Article Number (EAN/UPC)
Field Name: MAIN_GTIN
Data Element: EAN11
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine: EAN11
Domain Name: EAN11
MemoryID: EAN
AppClass: MGW
SHLP:
SHLP Field:
ConvExit: EAN11

See all SAP tables containing field MAIN_GTIN

CRMS4S_PRIL_QUERY_ADVSEARCH-SALES_ORG table field - Sales Organization ID ▼

Description: Sales Organization ID
Field Name: SALES_ORG
Data Element: CRMT_SALES_ORG
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: HROBJEC_14
MemoryID:
AppClass:
SHLP: CRM_ORGMAN_SALES_ORG
SHLP Field: SALES_ORG
ConvExit:

See all SAP tables containing field SALES_ORG

CRMS4S_PRIL_QUERY_ADVSEARCH-DISTR_CHAN table field - Distribution Channel ▼

Description: Distribution Channel
Field Name: DISTR_CHAN
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table: TVTW
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field DISTR_CHAN

CRMS4S_PRIL_QUERY_ADVSEARCH-SALES_HIERARCHY table field - Product hierarchy ▼

Description: Product hierarchy
Field Name: SALES_HIERARCHY
Data Element: PRODH_D
Data Type: CHAR
length (Dec): 18(0)
Check table: T179
Conversion Routine:
Domain Name: PRODH
MemoryID: VPR
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_HIERARCHY

CRMS4S_PRIL_QUERY_ADVSEARCH-DUMMY_PRD_INCL_EEW_PS table field - Dummy Field ▼

Description: Dummy Field
Field Name: DUMMY_PRD_INCL_EEW_PS
Data Element: PRD_INCL_EEW
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: PRD_INCL_EEW
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUMMY_PRD_INCL_EEW_PS

CRMS4S_PRIL_QUERY_ADVSEARCH-SALES_ORG_SD table field - Sales Organization ▼

Description: Sales Organization
Field Name: SALES_ORG_SD
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field SALES_ORG_SD

View list of all SAP tables(S4H/ECC)

Select data from SAP table