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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL_ASSIGN_ENR (Package) CRM Marketing Planning - Assignments: Enrollment

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_ENR_DB_JOIN	Table Relationship Diagram
Short Description	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	ACCOUNT	☐	CRMS_MKTPL_ENR_BP		STRU	0	0
28	ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
29	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
30	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
31	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
32	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
33	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
34	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
35	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
36	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
37	CREATED_BY_BP	☐	CRMS_MKTPL_ENR_BP		STRU	0	0
38	ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
39	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
40	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
41	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
42	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
43	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
44	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
45	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
46	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
47	CHANGED_BY_BP	☐	CRMS_MKTPL_ENR_BP		STRU	0	0
48	ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
49	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
50	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
51	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
52	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
53	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
54	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
55	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
56	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
57	CREATED_BY_USER_DESCR	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
58	CHANGED_BY_USER_DESCR	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person

History

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