SAP ABAP Table CRMT_PRP_BUPA_I_SORT (PRP Business Partners: Working Structure for Sorting)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_BUPA_I_SORT	Table Relationship Diagram
Short Description	PRP Business Partners: Working Structure for Sorting

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 Business Partner References: Working Structure
2	.INCLUDE	☐				0	0	PPR BUPA References: Working Structure without Parameters
3	.INCLUDE	☐				0	0	PPR Business Partner Reference
4	.INCLUDE	☐				0	0	Partner/Product Range Item-Partner Assignment
5	.INCLUDE	☐				0	0	PPR business partners: 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	PPR business partners: 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 business partners: fields manipulated internally
11	BUPA_REF_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
12	PARENT_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
13	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
14	READ_EXTENSIONS	☐	CRMT_PRP_BUPA_I_EXTENSIONS	CRM_BOOLEAN	CHAR	1	0	PPRs: Business Partner Reference has extensions
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_BUPA_NO	NUMC10	NUMC	10	0	Number for arranging PPR BUPAs within the same Item
21	.INCLUDE	☐				0	0	PPR BuPa hierarchy: fields manipulated externally
22	HIERARCHY_TYPE	☐	BU_HIERARCHY_TYPE		CHAR	2	0	Hierarchy Category of BP Group Hierarchy
23	.INCLUDE	☐				0	0	PPR BuPa hierarchy: fields manipulated internally
24	TREE_GUID	☐	BU_TREE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Tree
25	HIER_TYPE_GUID	☐	BU_HIERARCHY_TYPE_GUID	SYSUUID	RAW	16	0	GUID for Hierarchy Category of BP Group Hierarchy
26	.INCLUDE	☐				0	0	PPR rules: fields manipulated externally
27	RULE_ID	☐	CRMT_PRP_RULE_ID	CHAR8	CHAR	8	0	Identifier for a Partner/Product Range (PPR) Rule
28	.INCLUDE	☐				0	0	PPR rules: fields manipulated internally
29	RULE_TYPE	☐	CRMT_PRP_RULE_TYPE	CRM_PRP_RULE_TYPE	CHAR	2	0	PPR Rule Type
30	PARAMETER_ID	☐	CRMT_PRP_PARAMETER_ID	CHAR8	CHAR	8	0	ID for PPR Rule Parameter
31	.INCLUDE	☐				0	0	PPR Business Partners: Structure with Dynamic Fields
32	PROCESSING_MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
33	DELETED_FLAG	☐	CRMT_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion
34	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
35	PARTNER_ID_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
36	PARTNER_TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
37	PARTNER_TYPE_TEXT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
38	TARGETGRP_ID	☐	CRMT_TARGETGRP_ID	CRM_MARKETING_ID	CHAR	32	0	CRM Marketing: Target Group ID
39	TARGETGRP_DESCR	☐	CRMT_TARGETGRP_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Description for Target Group
40	BUHI_NODE_TEXT	☐	CRM_BU_NODE_DESCRIPTION_LONG	CRM_BU_NODE_DESCRIPTION_LONG	CHAR	201	0	Description of a Node
41	BUHI_NODE_SEARCH	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
42	BUHI_TYPE	☐	BU_HIERARCHY_TYPE		CHAR	2	0	Hierarchy Category of BP Group Hierarchy
43	BUHI_TYPE_TEXT	☐	BU_HIERARCHY_TYPE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Category
44	BUHI_TREE_SEARCH	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
45	BUHI_TREE_TEXT	☐	BU_TREE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Tree
46	MKT_SEG_DESCR	☐	CRMT_MKTTG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of an Object
47	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
48	MKT_SEG_TYPE_DESCR	☐	CRMT_PRP_MKT_SEG_TYPE_DESCR	CRMDESCRS	CHAR	30	0	Marketing Segment type description
49	MKT_SEG_CAT	☐	CRMT_MKTTG_SEGM_CAT	CRM_MKTTG_SEGM_CAT	CHAR	2	0	CRM Marketing: Usage Category
50	MKT_SEG_CAT_DESCR	☐	CRMT_MKTTG_SEGM_CAT_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Segment Category
51	.INCLUDE	☐				0	0	Reference other PPRs; working structure include
52	REF_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
53	REF_PRP_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
54	REF_PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
55	REF_PRP_TYPE_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
56	RULE_ID_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
57	PARAMETER_ID_TEXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
58	PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
59	PRP_RANK	☐	CRMT_PRP_RANK	CRM_PRP_RANK	NUMC	10	0	Rank Indicator of a PPR	*
60	ALL_BP_VALIDITY	☐	CRMT_PRP_ALL_BP_VALIDITY	CRM_BOOLEAN	CHAR	1	0	PPR Item Valid for all Possible Business Partner References
61	RULE_PAR_WRK	☐	CRMT_PRP_PAR_I_WRK_TAB		TTYP	0	0
62	EXCLUDED_BUPA	☐	CRMT_PRP_FLAG	CRM_BOOLEAN	CHAR	1	0	Flag to be used in PPR context

Foreign Keys

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

History

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