SAP ABAP Table CRMT_PRP_IL_PRODUCT (GENIL: PPR Product References plus Extension Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_IL (Package) GenIL/BOL Classes for PPR Application

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_IL_PRODUCT	Table Relationship Diagram
Short Description	GENIL: PPR Product References plus Extension Fields

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	PPR Product References plus Extension Fields
2	.INCLUDE	☐				0	0	Partner/Product Range Item-Product Assignment
3	.INCLUDE	☐				0	0	PRP products: primary key fields
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
6	.INCLUDE	☐				0	0	PRP products: fields manipulated externally
7	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	CRMC_PRP_REFTYP
8	.INCLUDE	☐				0	0	PRP products: fields manipulated internally
9	PRODUCT_REF_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
10	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
11	READ_EXTENSIONS	☐	CRMT_PRP_PROD_I_EXTENSIONS	CRM_BOOLEAN	CHAR	1	0	PPRs: Product Reference has Extensions
12	EXT_AVAILABLE	☐	CRMT_PRP_EXT_AVAILABLE	CRM_BOOLEAN	CHAR	1	0	Flag to label, if a PPR Obj. Ext. (EXT_H,EXT_I) is available
13	VP_AVAILABLE	☐	CRMT_PRP_PROD_VAL_PERIOD	CRM_BOOLEAN	CHAR	1	0	Flag to label if a product entry has an own validity period
14	PROP_RELEVANT	☐	CRMT_PRP_PRD_PROPOSAL	CRM_BOOLEAN	CHAR	1	0	Relevant for Item Proposal (Valid Only for Listing)
15	.INCLUDE	☐				0	0	Partner/Product Ranges (PPRs): Administrative Data
16	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
17	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
18	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
19	HISTEX	☐	COMT_HISTEX	COM_BOOLEAN	CHAR	1	0	History Exists
20	NUMBER_INT	☐	CRMT_PRP_PROD_NO	NUMC10	NUMC	10	0	Number for Arranging PPR Products Within the same Item
21	SETTYPE_ID	☐	CRMT_PRP_SETTYPE_ID	CHAR16	CHAR	16	0	PPR Set Type ID for PPR Object Extensions
22	.INCLUDE	☐				0	0	PPR product ref extension: fields manipulated externally
23	BC_PRODUCT_DESCR	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
24	BC_CAT_ID	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
25	BC_CAT_ITEM_ID	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
26	BC_SUPPL_PROD_ID	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
27	PCAT_CTY_GUID	☐	COMT_PCAT_CTY_GUID	SYSUUID	RAW	16	0	GUID of a Product Catalog Area
28	.INCLUDE	☐				0	0	PRP products for BCs: fields manipulated internally
29	CATEGORY_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
30	.INCLUDE	☐				0	0	PPR rules: fields manipulated externally
31	RULE_ID	☐	CRMT_PRP_RULE_ID	CHAR8	CHAR	8	0	Identifier for a Partner/Product Range (PPR) Rule
32	.INCLUDE	☐				0	0	PPR rules: fields manipulated internally
33	RULE_TYPE	☐	CRMT_PRP_RULE_TYPE	CRM_PRP_RULE_TYPE	CHAR	2	0	PPR Rule Type
34	PARAMETER_ID	☐	CRMT_PRP_PARAMETER_ID	CHAR8	CHAR	8	0	ID for PPR Rule Parameter
35	.INCLUDE	☐				0	0	Structure for Non-Existing ID Fields
36	NON_EXISTING_ID1	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
37	NON_EXISTING_ID2	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
38	NON_EXISTING_ID3	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
39	NON_EXISTING_ID4	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
40	.INCLUDE	☐				0	0	PPR Validity Period for Prod.: Fields Manipulated Externally
41	LISTED_FROM	☐	CRMT_PRP_TS_LOW	BCOS_TSTMP	DEC	15	0	PPR Validity Period: Start Date
42	LISTED_TO	☐	CRMT_PRP_TS_HIGH	BCOS_TSTMP	DEC	15	0	PPR Validity Period: End Date
43	CONF_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
44	CONF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
45	PRODUCT_REF_TYPE	☐	LSTT_PRP_REFTYPE_TEXT	TEXT40	CHAR	40	0	Listing Item Type
46	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
47	PRODUCT_DESCR	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
48	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
49	PRODUCT_ID_TYPE_TEXT	☐	COMT_ALTID_TYPE_TEXT	COMT_TXT40	CHAR	40	0	Description of Alternative ID Type
50	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
51	PRODUCT_TYPE_TEXT	☐	COMT_PR_TYPE_DESC	TEXT40	CHAR	40	0	Product Type Description
52	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
53	CATEGORY_DESCR	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
54	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
55	HIERARCHY_DESRC	☐	COMT_HIERARCHY_TEXT	TEXT40	CHAR	40	0	Category Hierarchy Description
56	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
57	PCAT_DESCR	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
58	PCAT_TYPE	☐	COMT_PCAT_TYPE	COM_PCAT_TYPE	CHAR	4	0	Catalog Type	*
59	BW_REPORT	☐	CRMT_MKTBW_BW_PARAM_ID	CRM_BW_ID	CHAR	32	0	CRM Marketing: BW Parameter Identification
60	LISTED_FROM_DATE	☐	CRMT_PRP_DATE_VALID_FROM	DATE	DATS	8	0	Start Date of Validity Period
61	LISTED_TO_DATE	☐	CRMT_PRP_DATE_VALID_TO	DATE	DATS	8	0	End Date of Validity Period
62	REF_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
63	REF_PRP_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
64	REF_PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
65	REF_PRP_TYPE_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
66	IBASE_COMPONENT	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
67	IBASE_C_DESCR	☐	IB_INST_DESCR	TEXT40	CHAR	40	0	IB: Component Description
68	IBASE_HEADER	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
69	IBASE_H_DESCR	☐	IB_IBASE_DESCR	TEXT40	CHAR	40	0	IB: IBase Short Text/Description
70	PCAT_TYPE_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
71	PCAT_CTY	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
72	PCAT_CTY_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
73	PCAT_VIEW_ID	☐	COMT_PCAT_VIEW_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog View
74	PCAT_VIEW_ID_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
75	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
76	OBJECT_FAMILY_DESCR	☐	COMT_PRODUCT_OBJECT_FAMILY_DES	TEXT40	CHAR	40	0	Description of Object Family
77	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
78	ALL_PROD_VALIDITY	☐	CRMT_PRP_ALL_PRODUCT_VALIDITY	CRM_BOOLEAN	CHAR	1	0	PPR Item valid for all possible Product References

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PRP_IL_PRODUCT	TYPE	CRMC_PRP_REFTYP	REFERENCE_TYPE	KEY	C	CN

History

Last changed by/on	SAP	20131122
SAP Release Created in	520