SAP CRMS4S_PRIL_QUERY_ADVSEARCH table - Advanced Search for Products details in SAP

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

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

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

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

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

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

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

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

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

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

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

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

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

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