SAP ABAP Table CRMT_PRP_IL_BUPA (GenIL: PPR Business Partner References plus Extension Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PPR (Application Component) Partner/Product Range
     ⤷ CRM_PRP_IL (Package) GenIL/BOL Classes for PPR Application

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRP_IL_BUPA	Table Relationship Diagram
Short Description	GenIL: PPR Business Partner References plus Extension Fields

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	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
30	PARTNER_ID_TEXT	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
31	PARTNER_TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
32	ALL_BP_VALIDITY	☐	CRMT_PRP_ALL_BP_VALIDITY	CRM_BOOLEAN	CHAR	1	0	PPR Item Valid for all Possible Business Partner References
33	BUHI_NODE_TEXT	☐	CRM_BU_NODE_DESCRIPTION_LONG	CRM_BU_NODE_DESCRIPTION_LONG	CHAR	201	0	Description of a Node
34	BUHI_NODE_SEARCH	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
35	BUHI_TYPE	☐	BU_HIERARCHY_TYPE		CHAR	2	0	Hierarchy Category of BP Group Hierarchy
36	BUHI_TYPE_TEXT	☐	BU_HIERARCHY_TYPE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Category
37	BUHI_TREE_SEARCH	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
38	BUHI_TREE_TEXT	☐	BU_TREE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Tree
39	MKT_SEG_DESCR	☐	CRMT_MKTTG_DESCR	CRM_MARKETING_DESC	CHAR	72	0	Description of an Object
40	MKT_SEG_TYPE	☐	CRMT_MKTTG_TYPE	CRM_MKTTG_TYPE	CHAR	1	0	CRM Marketing: Object Type (Set, Profile, Target Group)
41	MKT_SEG_TYPE_DESCR	☐	CRMT_PRP_MKT_SEG_TYPE_DESCR	CRMDESCRS	CHAR	30	0	Marketing Segment type description
42	MKT_SEG_CAT	☐	CRMT_MKTTG_SEGM_CAT	CRM_MKTTG_SEGM_CAT	CHAR	2	0	CRM Marketing: Usage Category
43	MKT_SEG_CAT_DESCR	☐	CRMT_MKTTG_SEGM_CAT_DESCR	CRM_MARKETING_DESC	CHAR	72	0	CRM Marketing: Segment Category
44	REF_PRP_ID	☐	CRMT_PRP_ID	CRM_PRP_ID	CHAR	40	0	Identifier for a Partner/Product Range (PPR) Assignment
45	REF_PRP_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment
46	REF_PRP_TYPE	☐	CRMT_PRP_TYPE	CRM_PRP_TYPE	CHAR	4	0	Type of a Partner/Product Range (PPR)	*
47	REF_PRP_TYPE_TEXT	☐	CRMT_PRP_SHTEXT	CRM_PRP_SHTEXT	CHAR	40	0	Description of a Partner/Product Range Assignment

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	520