SAP ABAP Table CRMT_PRP_PROD_I (PPR Product References plus Extension Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_PRODUCTS (Package) Partner/Product Ranges (PPRs): Products

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_PROD_I	Table Relationship Diagram
Short Description	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	Partner/Product Range Item-Product Assignment
2	.INCLUDE	☐				0	0	PRP products: primary key fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
5	.INCLUDE	☐				0	0	PRP products: fields manipulated externally
6	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	CRMC_PRP_REFTYP
7	.INCLUDE	☐				0	0	PRP products: fields manipulated internally
8	PRODUCT_REF_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
9	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
10	READ_EXTENSIONS	☐	CRMT_PRP_PROD_I_EXTENSIONS	CRM_BOOLEAN	CHAR	1	0	PPRs: Product Reference has Extensions
11	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
12	VP_AVAILABLE	☐	CRMT_PRP_PROD_VAL_PERIOD	CRM_BOOLEAN	CHAR	1	0	Flag to label if a product entry has an own validity period
13	PROP_RELEVANT	☐	CRMT_PRP_PRD_PROPOSAL	CRM_BOOLEAN	CHAR	1	0	Relevant for Item Proposal (Valid Only for Listing)
14	.INCLUDE	☐				0	0	Partner/Product Ranges (PPRs): Administrative Data
15	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
16	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
17	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
18	HISTEX	☐	COMT_HISTEX	COM_BOOLEAN	CHAR	1	0	History Exists
19	NUMBER_INT	☐	CRMT_PRP_PROD_NO	NUMC10	NUMC	10	0	Number for Arranging PPR Products Within the same Item
20	SETTYPE_ID	☐	CRMT_PRP_SETTYPE_ID	CHAR16	CHAR	16	0	PPR Set Type ID for PPR Object Extensions
21	.INCLUDE	☐				0	0	PPR product ref extension: fields manipulated externally
22	BC_PRODUCT_DESCR	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
23	BC_CAT_ID	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
24	BC_CAT_ITEM_ID	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
25	BC_SUPPL_PROD_ID	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
26	PCAT_CTY_GUID	☐	COMT_PCAT_CTY_GUID	SYSUUID	RAW	16	0	GUID of a Product Catalog Area
27	.INCLUDE	☐				0	0	PRP products for BCs: fields manipulated internally
28	CATEGORY_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
29	.INCLUDE	☐				0	0	PPR rules: fields manipulated externally
30	RULE_ID	☐	CRMT_PRP_RULE_ID	CHAR8	CHAR	8	0	Identifier for a Partner/Product Range (PPR) Rule
31	.INCLUDE	☐				0	0	PPR rules: fields manipulated internally
32	RULE_TYPE	☐	CRMT_PRP_RULE_TYPE	CRM_PRP_RULE_TYPE	CHAR	2	0	PPR Rule Type
33	PARAMETER_ID	☐	CRMT_PRP_PARAMETER_ID	CHAR8	CHAR	8	0	ID for PPR Rule Parameter
34	.INCLUDE	☐				0	0	Structure for Non-Existing ID Fields
35	NON_EXISTING_ID1	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
36	NON_EXISTING_ID2	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
37	NON_EXISTING_ID3	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
38	NON_EXISTING_ID4	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
39	.INCLUDE	☐				0	0	PPR Validity Period for Prod.: Fields Manipulated Externally
40	LISTED_FROM	☐	CRMT_PRP_TS_LOW	BCOS_TSTMP	DEC	15	0	PPR Validity Period: Start Date
41	LISTED_TO	☐	CRMT_PRP_TS_HIGH	BCOS_TSTMP	DEC	15	0	PPR Validity Period: End Date
42	CONF_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
43	CONF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID

Foreign Keys

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

History

Last changed by/on	SAP	20100421
SAP Release Created in	12A