SAP ABAP Table CRMT_PRP_BUPA_I_WRK (PPR Business Partner References: Working Structure)

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

History

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