SAP ABAP Table CRMT_BSP_PRD_ADVSRCH_IOBJECT (Extended Search for PC-UI Application CRMM_PRD_IOBJECT)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO-PCU (Application Component) People-Centric UI (Product)
     ⤷ CRM_PRODUCT_BSP (Package) CRM Product Master BSP Interface (Distribution Chain Dep.)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_PRD_ADVSRCH_IOBJECT	Table Relationship Diagram
Short Description	Extended Search for PC-UI Application CRMM_PRD_IOBJECT

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_BSP_OBJECT	TEXT40	CHAR	40	0	Object ID or Object Description
2	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
3	PRODUCT_TYPE_TEXT	☐	COMT_PR_TYPE_DESC_BSP	TEXT40	CHAR	40	0	Product Type Description
4	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
5	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
6	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
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_40	CHAR40	CHAR	40	0	Field Value for Alternative IDs
10	PARTNER	☐	COMT_BSP_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
11	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
12	REF_PRODUCT	☐	COMT_REF_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
13	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
14	COUNTER_ID	☐	CRMT_MPK_OBJECT_ID_MPOINT	CRM_MPK_OBJECT_ID_MPOINT	CHAR	20	0	Counter Identifier
15	COUNTER_DESCR	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description
16	COUNTER	☐	CRMT_MPK_IDENT	CRM_MPK_DESCR	CHAR	40	0	Counter ID/Description
17	.INCLU--AP	☐				0	0	Component Description or Code
18	IB_DESCR	☐	IB_INST_DESCR	TEXT40	CHAR	40	0	IB: Component Description
19	CODE_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
20	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
21	EXT_CODE	☐	CRMT_STRUCT_CODE	CRMT_TSRV_EXT_CODE	CHAR	40	0	External Code
22	IDENTIFICATION	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
23	EXTID	☐	IB_EXTID	CHAR30	CHAR	30	0	IB: External Name/ID of Installed Base
24	.INCLU--AP	☐				0	0	Individual Object: Advanced Search by Location Address
25	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
26	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
27	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
28	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
29	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
30	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
31	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
32	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
33	.INCLU--AP	☐				0	0	Enhanced Search According to Ind. Objct via Ctrct Objt Data
34	BUAG_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
35	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
36	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
37	.INCLU--AP	☐				0	0	Advanced Search by Status
38	STATUS	☐	COMT_PRODUCT_STATUS	CRM_J_STATUS	CHAR	5	0	Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_PRD_ADVSRCH_IOBJECT	DISTR_CHAN	CRMC_DISTCHAN	DISTCHAN

History

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