SAP ABAP Table CRMT_PRP_BUPA_I_WRKF (PPR BUPA References: Working Structure without Parameters)

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_WRKF	Table Relationship Diagram
Short Description	PPR BUPA References: Working Structure without Parameters

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

Foreign Keys

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

History

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