SAP ABAP Table CRMT_PRIL_QUERY_ADVSEARCH_CP (Advanced Search for Competitor 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_CP	Table Relationship Diagram
Short Description	Advanced Search for Competitor 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 - Competitor
2	QUERY_PROD_CMP	☐	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	DESC_FUZZY	☐	COM_SEARCH_TV_MODE_FUZZY	X	CHAR	1	0	Option Fuzzy Mode
22	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
23	ALTID_VALUE	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
24	MAIN_GTIN	☐	COMT_GTIN	COM_GTIN	CHAR	40	0	Global Trade Item Number (GTIN)
25	SALES_ORG_DESC	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
26	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
27	OWN_PRODUCT	☐	COMT_OWN_PRODUCT	COM_PRODUCT_ID	CHAR	40	0	Own Product ID
28	CUSTOMER	☐	COMT_CUSTOMER	BU_PARTNER	CHAR	10	0	Account ID for Competitor Product	*
29	COMPETITOR	☐	COMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitor ID for Competitor Product	*
30	SALEABILITY	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product

History

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