SAP ABAP Table COMT_BSP_PRD_ADVSRCH_GENERAL (General Advanced Search for COM)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-PCU-PRO (Application Component) Dialog People-Centric UI for Products
     ⤷ COM_PRODUCT_BSP (Package) Product Master BSP Interface (Distribution Chain Dependent)

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_BSP_PRD_ADVSRCH_GENERAL	Table Relationship Diagram
Short Description	General Advanced Search for COM

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	OBJECT	☐	COMT_PRWB_OBJECT	TEXT40	CHAR	40	0	Object ID or Description of Object
2	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
3	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
4	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
5	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
6	SALEABILITY	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
7	MAIN_GTIN	☐	COMT_GTIN	COM_GTIN	CHAR	40	0	Global Trade Item Number (GTIN)
8	ID_TYPE	☐	COMT_BSP_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
9	ID_VALUE	☐	COMT_BSP_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of Alternative ID for Products or Individual Objects
10	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE_UI	XFELD	CHAR	1	0	Determines Whether a Product Is Configurable
11	.INCLU--AP	☐				0	0	Component Description or Code
12	IB_DESCR	☐	IB_INST_DESCR	TEXT40	CHAR	40	0	IB: Component Description
13	CODE_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
14	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
15	EXT_CODE	☐	CRMT_STRUCT_CODE	CRMT_TSRV_EXT_CODE	CHAR	40	0	External Code
16	IDENTIFICATION	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
17	EXTID	☐	IB_EXTID	CHAR30	CHAR	30	0	IB: External Name/ID of Installed Base
18	.INCLU--AP	☐				0	0	General Advanced Search for COM
19	CUSTOMER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
20	COMPETITOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
21	OWN_PRODUCT	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
22	SALES_ORG	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
23	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
24	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
25	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
26	REF_PRODUCT	☐	COMT_REF_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
27	COUNTER_ID	☐	CRMT_MPK_OBJECT_ID_MPOINT	CRM_MPK_OBJECT_ID_MPOINT	CHAR	20	0	Counter Identifier
28	COUNTER_DESCR	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description
29	.INCLU--AP	☐				0	0	Individual Object: Advanced Search by Location Address
30	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
31	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
32	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
33	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
34	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
35	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
36	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
37	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
38	.INCLU--AP	☐				0	0	Enhanced Search According to Ind. Objct via Ctrct Objt Data
39	BUAG_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
40	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
41	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
42	.INCLU--AP	☐				0	0	CRMTS: Status Individual Object
43	STATUS	☐	COMT_PRODUCT_STATUS	CRM_J_STATUS	CHAR	5	0	Status

History

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