SAP ABAP Table CRMT_PRIL_QUERY_ADVSEARCH_TERR (Advanced Search for Products with Territories)

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_TERR	Table Relationship Diagram
Short Description	Advanced Search for Products with Territories

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	General Parameters for Search
2	MAX_ROWS	☐	BAPIMAXROW	SYST_LONG	INT4	10	0	Maximum number of lines of hits
3	.INCLUDE	☐				0	0	Search Structure with General Product Attributes
4	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
5	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
6	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
7	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
8	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
9	BATCH_DEDICATED	☐	COMT_BATCH_DEDICATED	COM_BOOLEAN	CHAR	1	0	Specifies Whether Batches Are Maintained for Product
10	COMPETITOR_PROD	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
11	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
12	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
13	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
14	CAT_SUBTREE	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
15	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
16	CATEGORY_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
17	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
18	CREATED_ON	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
19	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
20	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
21	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*

History

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