SAP ABAP Table CRMT_PRP_PROD_I_WRK_SORT_S (Listing product maintainence with sort field)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_LISTING (Package) Listing-specific PPR Functionality

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_PROD_I_WRK_SORT_S	Table Relationship Diagram
Short Description	Listing product maintainence with sort field

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: Working Structure
2	.INCLUDE	☐				0	0	PPR Product References: Working Structure without Parameters
3	.INCLUDE	☐				0	0	PPR Product References plus Extension Fields
4	.INCLUDE	☐				0	0	Partner/Product Range Item-Product Assignment
5	.INCLUDE	☐				0	0	PRP products: primary key fields
6	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
7	GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
8	.INCLUDE	☐				0	0	PRP products: fields manipulated externally
9	TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	CRMC_PRP_REFTYP
10	.INCLUDE	☐				0	0	PRP products: fields manipulated internally
11	PRODUCT_REF_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
12	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
13	READ_EXTENSIONS	☐	CRMT_PRP_PROD_I_EXTENSIONS	CRM_BOOLEAN	CHAR	1	0	PPRs: Product Reference has Extensions
14	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
15	VP_AVAILABLE	☐	CRMT_PRP_PROD_VAL_PERIOD	CRM_BOOLEAN	CHAR	1	0	Flag to label if a product entry has an own validity period
16	PROP_RELEVANT	☐	CRMT_PRP_PRD_PROPOSAL	CRM_BOOLEAN	CHAR	1	0	Relevant for Item Proposal (Valid Only for Listing)
17	.INCLUDE	☐				0	0	Partner/Product Ranges (PPRs): Administrative Data
18	VALID_FROM	☐	COMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Valid From (Time Stamp)
19	VALID_TO	☐	COMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Valid To (Time Stamp)
20	UPNAME	☐	COMT_UPNAME	UNAME	CHAR	12	0	Name of the User Who Last Changed the Set
21	HISTEX	☐	COMT_HISTEX	COM_BOOLEAN	CHAR	1	0	History Exists
22	NUMBER_INT	☐	CRMT_PRP_PROD_NO	NUMC10	NUMC	10	0	Number for Arranging PPR Products Within the same Item
23	SETTYPE_ID	☐	CRMT_PRP_SETTYPE_ID	CHAR16	CHAR	16	0	PPR Set Type ID for PPR Object Extensions
24	.INCLUDE	☐				0	0	PPR product ref extension: fields manipulated externally
25	BC_PRODUCT_DESCR	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
26	BC_CAT_ID	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
27	BC_CAT_ITEM_ID	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
28	BC_SUPPL_PROD_ID	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
29	PCAT_CTY_GUID	☐	COMT_PCAT_CTY_GUID	SYSUUID	RAW	16	0	GUID of a Product Catalog Area
30	.INCLUDE	☐				0	0	PRP products for BCs: fields manipulated internally
31	CATEGORY_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
32	.INCLUDE	☐				0	0	PPR rules: fields manipulated externally
33	RULE_ID	☐	CRMT_PRP_RULE_ID	CHAR8	CHAR	8	0	Identifier for a Partner/Product Range (PPR) Rule
34	.INCLUDE	☐				0	0	PPR rules: fields manipulated internally
35	RULE_TYPE	☐	CRMT_PRP_RULE_TYPE	CRM_PRP_RULE_TYPE	CHAR	2	0	PPR Rule Type
36	PARAMETER_ID	☐	CRMT_PRP_PARAMETER_ID	CHAR8	CHAR	8	0	ID for PPR Rule Parameter
37	.INCLUDE	☐				0	0	Structure for Non-Existing ID Fields
38	NON_EXISTING_ID1	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
39	NON_EXISTING_ID2	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
40	NON_EXISTING_ID3	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
41	NON_EXISTING_ID4	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
42	.INCLUDE	☐				0	0	PPR Validity Period for Prod.: Fields Manipulated Externally
43	LISTED_FROM	☐	CRMT_PRP_TS_LOW	BCOS_TSTMP	DEC	15	0	PPR Validity Period: Start Date
44	LISTED_TO	☐	CRMT_PRP_TS_HIGH	BCOS_TSTMP	DEC	15	0	PPR Validity Period: End Date
45	CONF_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
46	CONF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
47	.INCLUDE	☐				0	0	PPR product references: dynamic fields
48	PROCESSING_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
49	DELETED_FLAG	☐	CRMT_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion
50	REF_HANDLE	☐	CRMT_PRP_HANDLE		NUMC	10	0	Handle
51	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
52	PRODUCT_ID	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
53	PRODUCT_ID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
54	PRODUCT_ID_TYPE_TEXT	☐	COMT_ALTID_TYPE_TEXT	COMT_TXT40	CHAR	40	0	Description of Alternative ID Type
55	.INCLUDE	☐				0	0	ID and the related ID Type maintained in the UI
56	ID_UI	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
57	ID_TYPE_UI	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
58	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
59	OBJECT_FAMILY_DESCR	☐	COMT_PRODUCT_OBJECT_FAMILY_DES	TEXT40	CHAR	40	0	Description of Object Family
60	LOGICAL_SYSTEM	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
61	ID_TYPE_PROFILE	☐	COMT_ALTID_PROFILE	COMT_ALTID_PROFILE	CHAR	30	0	Profile for Alternative IDs
62	STANDARD_PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
63	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
64	SHORT_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
65	SHTEXT_LARGE	☐	COMT_PRSHTEXTG	PRSHTEXTG40	CHAR	40	0	Product Description in Uppercase for F4 Help
66	PRODUCT_TYPE_TEXT	☐	COMT_PR_TYPE_DESC	TEXT40	CHAR	40	0	Product Type Description
67	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
68	HIERARCHY_GUID	☐	COMT_HIERARCHY_GUID	SYSUUID	RAW	16	0	Category Hierarchy GUID
69	HIERARCHY_TEXT	☐	COMT_HIERARCHY_TEXT	TEXT40	CHAR	40	0	Category Hierarchy Description
70	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
71	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
72	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
73	PCAT_SHORTCUT	☐	COMT_PCAT_SC	CHAR4	CHAR	4	0	Product Catalog ID
74	PCAT_TYPE	☐	COMT_PCAT_TYPE	COM_PCAT_TYPE	CHAR	4	0	Catalog Type	*
75	PCAT_TYPE_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
76	PCAT_CTY	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
77	PCAT_CTY_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
78	PCAT_CTY_TYPE	☐	COMT_PCAT_CATEGORY_TYPE	COM_PCAT_CATEGORYTYPE	CHAR	4	0	Catalog Area Type
79	PCAT_CTY_TYPE_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
80	PCAT_VIEW_ID	☐	COMT_PCAT_VIEW_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog View
81	PCAT_VIEW_ID_TEXT	☐	COMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
82	IBASE_HEADER	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
83	IBASE_H_DESCR	☐	IB_IBASE_DESCR	TEXT40	CHAR	40	0	IB: IBase Short Text/Description
84	IBASE_COMPONENT	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
85	IBASE_C_DESCR	☐	IB_INST_DESCR	TEXT40	CHAR	40	0	IB: Component Description
86	.INCLUDE	☐				0	0	Reference other PPRs; working structure include
87	REF_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
88	REF_PRP_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
89	REF_PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
90	REF_PRP_TYPE_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
91	RULE_ID_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
92	PARAMETER_ID_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
93	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
94	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
95	NODE_PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
96	NODE_PARENT_TYPE	☐	CRMT_PRP_REFERENCE_TYPE	CRM_PRP_REFERENCE_TYPE	CHAR	2	0	Reference Type of the PPR	*
97	COMPETITOR_PRODUCT	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
98	ALL_PROD_VALIDITY	☐	CRMT_PRP_ALL_PRODUCT_VALIDITY	CRM_BOOLEAN	CHAR	1	0	PPR Item valid for all possible Product References
99	EXCLUDED_PRODUCT	☐	CRMT_PRP_FLAG	CRM_BOOLEAN	CHAR	1	0	Flag to be used in PPR context
100	RULE_PAR_WRK	☐	CRMT_PRP_PAR_I_WRK_TAB		TTYP	0	0
101	SORT_INDEX	☐			INT4	10	0

Foreign Keys

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

History

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