SAP ABAP Table CRMT_PRIL_QUERY_ADVSEARCH_PROD (Advanced Search for Products)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO (Application Component) Products
     ⤷ CRM_PRODIL_QUERIES (Package) Methods for product queries

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRIL_QUERY_ADVSEARCH_PROD	Table Relationship Diagram
Short Description	Advanced Search for Products

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Extensibility Search Query Product - Material
2	QUERY_PROD_MAT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
3	.INCLUDE	☐				0	0	General Parameters for Search
4	MAX_ROWS	☐	BAPIMAXROW	SYST_LONG	INT4	10	0	Maximum number of lines of hits
5	.INCLUDE	☐				0	0	Search Structure with General Product Attributes
6	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
7	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
8	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
9	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
10	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
11	BATCH_DEDICATED	☐	COMT_BATCH_DEDICATED	COM_BOOLEAN	CHAR	1	0	Specifies Whether Batches Are Maintained for Product
12	COMPETITOR_PROD	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
13	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
14	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
15	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
16	CAT_SUBTREE	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
17	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
18	CATEGORY_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
19	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
20	CREATED_ON	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
21	.INCLUDE	☐				0	0	Extensibility Search Query Product - Financing
22	QUERY_PROD_FIN	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
23	.INCLUDE	☐				0	0	Extensibility Search Query Product - FS Product
24	QUERY_PROD_FS	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
25	DESC_FUZZY	☐	COM_SEARCH_TV_MODE_FUZZY	X	CHAR	1	0	Option Fuzzy Mode
26	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
27	ALTID_VALUE	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
28	MAIN_GTIN	☐	COMT_GTIN	COM_GTIN	CHAR	40	0	Global Trade Item Number (GTIN)
29	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
30	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
31	STATUS	☐	CHAR14	CHAR14	CHAR	14	0	Text field length 14
32	MGR_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
33	ONLY_01_02	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
34	ONLY_03_07	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
35	NO_COMP_PROD	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
36	ONLY_COMP_PROD	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
37	WITH_INDOBJECTS	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
38	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
39	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
40	SALESCAT_ID	☐	CRMT_SALESCAT_ID	COM_CATEGORY_ID	CHAR	20	0	Sales Category
41	.INCLU--AP	☐				0	0	Product DR search attributes
42	REG_STATUS	☐	CRM_CSDR_PRD_REGS	CRM_CSDR_PROD_REGS	CHAR	2	0	Registration Status	*
43	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
44	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
45	ACT_STATUS	☐	CRM_CSDR_PRD_ACTS	CRM_CSDR_PRD_ACTS	CHAR	2	0	Activity Status
46	.INCLU--AP	☐				0	0	Append for Loyalty-attributes Search for products
47	CARD_TYPE	☐	CRM_LOY_CARD_TYPE	CRM_LOY_CRD_CARD_CTYPE	CHAR	5	0	Loyalty Card Type

History

Last changed by/on	SAP	20130604
SAP Release Created in	510