SAP ABAP Table CRMT_PRP_PROD_I_SORT (PRP product references: sorting structure)

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_SORT	Table Relationship Diagram
Short Description	PRP product references: sorting 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	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	.INCLUDE	☐				0	0	PPR product references: dynamic fields
46	PROCESSING_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
47	DELETED_FLAG	☐	CRMT_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion
48	REF_HANDLE	☐	CRMT_PRP_HANDLE		NUMC	10	0	Handle
49	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
50	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
51	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
52	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
53	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
54	STANDARD_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
55	ID_TYPE_PROFILE	☐	COMT_ALTID_PROFILE	COMT_ALTID_PROFILE	CHAR	30	0	Profile for Alternative IDs
56	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*

Foreign Keys

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

History

Last changed by/on	SAP	20100421
SAP Release Created in	20C