SAP ABAP Table CRMT_IPM_QUERY_ADVSEARCH_IP_MC (IPM/IP: Search structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IM-IPM-MD (Application Component) Master Data
     ⤷ CRM_IPM_IP_GENIL (Package) IPM: GenIL for IP

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IPM_QUERY_ADVSEARCH_IP_MC	Table Relationship Diagram
Short Description	IPM/IP: Search structure

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	IPM/IP: Search structure
2	.INCLUDE	☐				0	0	General Parameters for Search
3	MAX_ROWS	☐	BAPIMAXROW	SYST_LONG	INT4	10	0	Maximum number of lines of hits
4	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
5	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
6	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
7	CATEGORY_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
8	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
9	ALTID_VALUE	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
10	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
11	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
12	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
13	STATUS	☐	COMT_PRODUCT_STATUS	CRM_J_STATUS	CHAR	5	0	Status
14	PARTNER	☐	COMT_IL_BU_PARTNER_ID	BU_PARTNER	CHAR	10	0	Business Partner Number	*
15	PARTNER_DESC	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
16	PARTNER_FUNC	☐	COMT_LINK_PARTNER_FCT	COM_LINK_PARTNER_FCT	CHAR	8	0	Relationship Product-Partner: Partner Function
17	.INCLU--AP	☐				0	0	IPM/IP Search extensions
18	LIBRARY	☐	CRMT_IPM_LIBRARY	CRMT_IPM_LIBRARY	CHAR	20	0	Library
19	LIBRARY_TYPE	☐	CRMT_IPM_LIBRAR_TYPE	CRMT_IPM_LIBRARY_TYPE	CHAR	20	0	Library Type
20	TITLE_LEVEL	☐	CRMT_IPM_TITLELEVEL_UI	CRMT_IPM_TITLE_LEVEL	CHAR	1	0	Title Level	*
21	ALIAS	☐	IPM_SHORTT_UI	IPM_SHORTT_UI	CHAR	40	0	Alias
22	MFORMARKET	☐	CRMT_IPM_MFORMARKET_UI	CRMT_IPM_MARKET	CHAR	18	0	Made for Market	*
23	MFORMARKET_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
24	CONTRELCA	☐	CRMT_IPM_CONRELCAT_UI	CRMT_IPM_CONTRELCAT	CHAR	18	0	Content Category	*
25	CONTRELCA_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
26	RELDAT	☐	CRMT_IPM_RELEASE_DAT_UI	CRMT_IPM_RELEASE_DAT_UI	DATS	8	0	Publication Date
27	ALIAS_DESC	☐	CRMT_IPM_ALIAS_DESC	CRMT_IPM_ALIAS_DESC	CHAR	40	0	IPM alias or product description
28	IPACC_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
29	IPACC_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
30	IPACC_TITLELEVEL	☐	CRMT_IPM_TITLELEVEL_UI	CRMT_IPM_TITLE_LEVEL	CHAR	1	0	Title Level	*
31	ROWN_DESC	☐	CRMT_IPM_RIGHTS_SCD	CRMT_IPM_RIGHTS_SCD	CHAR	100	0	Rights Scope Descrip.
32	ROWN_VALID_FROM	☐	CRMT_IPM_DATE_FROM_UI	CRMT_IPM_DATE_FROM_UI	DATS	8	0	Valid From
33	ROWN_VALID_TO	☐	CRMT_IPM_DATE_TO_UI	CRMT_IPM_DATE_TO_UI	DATS	8	0	Valid To
34	ROWN_RGHTDIM01	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
35	ROWN_RGHTDIM02	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
36	ROWN_RGHTDIM03	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
37	ROWN_RGHTDIM04	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
38	ROWN_RGHTDIM05	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
39	ROWN_EXCL_TYPE	☐	CRMT_IPM_EXCL_TYPE	CRMT_IPM_EXCLUSIVITY_TYPE	CHAR	20	0	Exclusivity Type for Rights Usage	*
40	ROWN_XOPTION	☐	CRMT_IPM_OPTION	CRMT_IPM_OPTION	CHAR	1	0	Option
41	ROWN_OPTION_FR	☐	CRMT_IPM_OPTION_FROM	CRMT_IPM_OPTION_FROM	DATS	8	0	Option Valid From
42	ROWN_OPTION_TO	☐	CRMT_IPM_OPTION_TO	CRMT_IPM_OPTION_TO	DATS	8	0	Option Valid To
43	RELD_DESC	☐	CRMT_IPM_RIGHTS_SCD	CRMT_IPM_RIGHTS_SCD	CHAR	100	0	Rights Scope Descrip.
44	RELD_VALID_FROM	☐	CRMT_IPM_DATE_FROM_UI	CRMT_IPM_DATE_FROM_UI	DATS	8	0	Valid From
45	RELD_VALID_TO	☐	CRMT_IPM_DATE_TO_UI	CRMT_IPM_DATE_TO_UI	DATS	8	0	Valid To
46	RELD_RGHTDIM01	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
47	RELD_RGHTDIM02	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
48	RELD_RGHTDIM03	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
49	RELD_RGHTDIM04	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
50	RELD_RGHTDIM05	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
51	RELRES_DESC	☐	CRMT_IPM_RIGHTS_SCD	CRMT_IPM_RIGHTS_SCD	CHAR	100	0	Rights Scope Descrip.
52	RELRES_VALID_FROM	☐	CRMT_IPM_DATE_FROM_UI	CRMT_IPM_DATE_FROM_UI	DATS	8	0	Valid From
53	RELRES_VALID_TO	☐	CRMT_IPM_DATE_TO_UI	CRMT_IPM_DATE_TO_UI	DATS	8	0	Valid To
54	RELRES_RGHTDIM01	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
55	RELRES_RGHTDIM02	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
56	RELRES_RGHTDIM03	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
57	RELRES_RGHTDIM04	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
58	RELRES_RGHTDIM05	☐	CRMT_IPM_RIGHTDIM_VALUE	CRMT_IPM_RIGHTDIM_VALUE	STRG	0	0	Rights Dimension Value ID
59	RELRES_TY	☐	CRMT_IPM_RELRES_TYPE	CRMT_IPM_RELRES_TYPE	CHAR	20	0	Type of Release Restriction	*
60	IPUCO_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
61	IPUCO_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
62	IPUCO_TITLELEVEL	☐	CRMT_IPM_TITLELEVEL_UI	CRMT_IPM_TITLE_LEVEL	CHAR	1	0	Title Level	*
63	IPPAC_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
64	IPPAC_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
65	IPTTL_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
66	IPTTL_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
67	PRDBP_PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
68	PRDBP_PARTNER_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
69	PRDBP_PARTNER_FUNC	☐	COMT_LINK_PARTNER_FCT_TXT	TEXT30	CHAR	30	0	Link Product Partner: Description Partner Function
70	PRDBP_VALID_FROM	☐	COMT_PRDBP_VALID_FROM_DATE	COM_PRODUCT_LINK_PARTNER_DATE	DATS	8	0	Valid-From Date of a Product/ Individual Object Link
71	PRDBP_VALID_TO	☐	COMT_PRDBP_VALID_TO_DATE	COM_PRODUCT_LINK_PARTNER_DATE	DATS	8	0	Valid-To Date of a Product/ Individual Object Link
72	IPSMAT_MATERIAL_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
73	IPSMAT_MATERIAL_DESC	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
74	UOM_UNIT_ID	☐	COMT_UNIT_UI	CHR3	CHAR	3	0	Units of Measure of Product
75	UOM_UNIT_DESC	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
76	ALIAS_LANGUAGE	☐	IPR_LANGUA_UI	CRMT_IPM_IPLANGU	CHAR	10	0	Language of an IP Name or Content	*
77	IRG_RULE_ID	☐	CRMT_IPM_IRG_RULE_IP_UI	CRMT_IPM_IRG_RULE	CHAR	4	0	Generation Formula	*
78	IRG_RULE_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
79	TAX_CTY	☐	CRMT_TAX_CTY	LAND1	CHAR	3	0	Country	*
80	TAX_CTY_DESC	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
81	TAX_TYPE	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type
82	TAX_TYPE_DESC	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
83	IPMAT_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
84	IPMAT_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
85	IPSMAT_PRODUCT_ID	☐	COMT_PRWB_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product
86	IPSMAT_DESCRIPTION	☐	COMT_PRWB_PRODUCT_DESCR	TEXT40	CHAR	40	0	Product Description
87	CONTRELCA_MAIN	☐	CRMT_IPM_CONRELCAT_UI	CRMT_IPM_CONTRELCAT	CHAR	18	0	Content Category	*
88	LIBRARY_VALID_FROM	☐	CRMT_IPM_LIBR_FROM	CRMT_IPM_LIBR_FROM	DATS	8	0	Library Valid From
89	LIBRARY_VALID_TO	☐	CRMT_IPM_LIBR_TO	CRMT_IPM_LIBR_TO	DATS	8	0	Library Valid To

History

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