SAP ABAP View V_SCRMMKT_MDF_EN (View for extraction of enrolled partners for MDF)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-MDF (Application Component) Marketing Development Funds
     ⤷ CRM_MKTPL_MDF_BW (Package) Package for BW development for MDF objects

Basic Data

View Type	D	Database View
Database View	V_SCRMMKT_MDF_EN
Short Description	View for extraction of enrolled partners for MDF
Root table	CRMD_MKTPL_ENR	Enrollment List

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTPL_ENR	CRMD_MKTPL_ENR
2	BUT000
3	CGPL_PROJECT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_MKTPL_ENR	CLIENT	JL	EQ				0	0
2	BUT000	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTPL_ENR	CLIENT	JL	EQ				0	0
4	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
5	CRMD_MKTPL_ENR	ACCOUNT_GUID	JL	EQ				0	0
6	BUT000	PARTNER_GUID	JR	EQ			AND	0	0
7	CRMD_MKTPL_ENR	PROJECT_GUID	JL	EQ				0	0
8	CGPL_PROJECT	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_MKTPL_ENR	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_MKTPL_ENR	GUID		☐	SYSUUID_X	☐	UUID in X form (binary)
3	PROJECT_GUID	CRMD_MKTPL_ENR	PROJECT_GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
4	TASK_GUID	CRMD_MKTPL_ENR	TASK_GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
5	ACCOUNT_GUID	CRMD_MKTPL_ENR	ACCOUNT_GUID		☐	BU_PARTNER_GUID	☐	Business Partner GUID
6	ENROLLED	CRMD_MKTPL_ENR	ENROLLED		☐	CRM_MKTPL_ENR_ENROLLED	☐	Enrolled
7	CREATED_ON	CRMD_MKTPL_ENR	CREATED_ON		☐	CRM_MKTPL_ENR_CREATED_ON	☐	First Enrolled On
8	CREATED_BY_USER	CRMD_MKTPL_ENR	CREATED_BY_USER		☐	CRM_MKTPL_ENR_CREATED_BY_USER	☐	First Enrolled By
9	CREATED_BY_BP	CRMD_MKTPL_ENR	CREATED_BY_BP		☐	CRM_MKTPL_ENR_CREATED_BY_BP	☐	First Enrolled By Partner
10	CHANGED_ON	CRMD_MKTPL_ENR	CHANGED_ON		☐	CRM_MKTPL_ENR_CHANGED_ON	☐	Changed On
11	CHANGED_BY_USER	CRMD_MKTPL_ENR	CHANGED_BY_USER		☐	CRM_MKTPL_ENR_CHANGED_BY_USER	☐	Changed By
12	CHANGED_BY_BP	CRMD_MKTPL_ENR	CHANGED_BY_BP		☐	CRM_MKTPL_ENR_CHANGED_BY_BP	☐	Changed By Partner
13	CREATED_INTERNAL	CRMD_MKTPL_ENR	CREATED_INTERNAL		☐	CRM_MKTPL_ENR_CREATED_INTERNAL	☐	First Enrolled by Internal User
14	CHANGED_INTERNAL	CRMD_MKTPL_ENR	CHANGED_INTERNAL		☐	CRM_MKTPL_ENR_CHANGED_INTERNAL	☐	Changed by Internal User
15	CCP	CRMD_MKTPL_ENR	CCP		☐	CRM_MKTPL_MDF_ENR_CCP	☐	Corporate Channel Partner (Specific to MDF)
16	LOCK_CP	CRMD_MKTPL_ENR	LOCK_CP		☐	CRM_MKTPL_MDF_ENR_LOCK	☐	Determines whether the partner is locked or not
17	POTENTIAL	CRMD_MKTPL_ENR	POTENTIAL		☐	CRM_MKTPL_MDF_ENR_POTENTIAL	☐	Determines whether the partner is eligible
18	FUND_GENERATED	CRMD_MKTPL_ENR	FUND_GENERATED		☐	CRM_MKTPL_MDF_ENR_FUND	☐	Determines whether Fund is generated or not
19	TARGET_GROUP	CRMD_MKTPL_ENR	TARGET_GROUP		☐	CRMT_TARGETGRP_GUID	☐	CRM Marketing: GUID of Target Group
20	PARTNER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
21	EXTERNAL_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
22	OBJECT_TYPE	CGPL_PROJECT	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140117
SAP Release Created in	700