SAP ABAP Table CRMS_MKTPL_ENR_CPC_DB_JOIN (CPC Enrollment and partner attributes for select with join)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_ENR_CPC (Package) CRM Marketing: Enrollement Enh. - CCM Partner Campaign

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_ENR_CPC_DB_JOIN	Table Relationship Diagram
Short Description	CPC Enrollment and partner attributes for select with join

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	ENROLLMENT	☐	CRMD_MKTPL_ENR		STRU	0	0
2	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment Primary Key Include
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
4	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
5	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
6	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
8	.INCLUDE	☐				0	0	Enrollment attributes (include)
9	ACCOUNT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
10	ENROLLED	☐	CRM_MKTPL_ENR_ENROLLED	CRM_MKTPL_ENR_ENROLLED	CHAR	1	0	Enrolled
11	CREATED_ON	☐	CRM_MKTPL_ENR_CREATED_ON	BCOS_TSTMP	DEC	15	0	First Enrolled On
12	CREATED_BY_USER	☐	CRM_MKTPL_ENR_CREATED_BY_USER	XUBNAME	CHAR	12	0	First Enrolled By
13	CREATED_BY_BP	☐	CRM_MKTPL_ENR_CREATED_BY_BP	SYSUUID	RAW	16	0	First Enrolled By Partner
14	CHANGED_ON	☐	CRM_MKTPL_ENR_CHANGED_ON	BCOS_TSTMP	DEC	15	0	Changed On
15	CHANGED_BY_USER	☐	CRM_MKTPL_ENR_CHANGED_BY_USER	XUBNAME	CHAR	12	0	Changed By
16	CHANGED_BY_BP	☐	CRM_MKTPL_ENR_CHANGED_BY_BP	SYSUUID	RAW	16	0	Changed By Partner
17	CREATED_INTERNAL	☐	CRM_MKTPL_ENR_CREATED_INTERNAL	CRM_MKTPL_ENR_INTERNAL	CHAR	1	0	First Enrolled by Internal User
18	CHANGED_INTERNAL	☐	CRM_MKTPL_ENR_CHANGED_INTERNAL	CRM_MKTPL_ENR_INTERNAL	CHAR	1	0	Changed by Internal User
19	.INCLUDE	☐				0	0	Enrollment attributes specific to MDF (include)
20	CCP	☐	CRM_MKTPL_MDF_ENR_CCP	CRM_MKTPL_MDF_ENR_INTERNAL	CHAR	1	0	Corporate Channel Partner (Specific to MDF)
21	LOCK_CP	☐	CRM_MKTPL_MDF_ENR_LOCK	CRM_MKTPL_MDF_ENR_INTERNAL	CHAR	1	0	Determines whether the partner is locked or not
22	POTENTIAL	☐	CRM_MKTPL_MDF_ENR_POTENTIAL	CRM_MKTPL_MDF_ENR_POTENTIAL	CHAR	1	0	Determines whether the partner is eligible
23	FUND_GENERATED	☐	CRM_MKTPL_MDF_ENR_FUND	CRM_MKTPL_MDF_ENR_INTERNAL	CHAR	1	0	Determines whether Fund is generated or not
24	TARGET_GROUP	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
25	.INCLUDE	☐				0	0	Enrollment account relation attributes (include)
26	REL_ACCOUNT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
27	CPC	☐	CRMS_MKTPL_ENR_CPC_ATTR		STRU	0	0
28	.INCLUDE	☐				0	0	CRM Marketing: Partner Campaign Enrollment Enhancement (CCM)
29	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
30	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
31	ASSIGN_GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
32	PCPG_GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
33	CCPG_GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
34	ACCOUNT	☐	CRMS_MKTPL_ENR_BP		STRU	0	0
35	ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
36	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
37	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
38	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
39	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
40	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
41	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
42	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
43	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)

History

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