SAP ABAP View V_CRM_MKTMDFTYPE (View for Marketing Planner MDF Type)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM (Application Component) Channel Management
     ⤷ CRM_CHM_MDF (Package) Channel Management: Marketing Development Funds (MDF)

Basic Data

View Type	D	Database View
Database View	V_CRM_MKTMDFTYPE
Short Description	View for Marketing Planner MDF Type
Root table	CGPL_PROJECT	Project Planning: Attribute Table for Project Headers

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CGPL_PROJECT	CGPL_PROJECT
2	CRM_MKTPL_ATTR
3	CRMC_MKTPL_CTYPE
4	CGPL_TEXT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRM_MKTPL_ATTR	CLIENT	JL	EQ				0	0
2	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
3	CRM_MKTPL_ATTR	GUID	JL	EQ				0	0
4	CGPL_PROJECT	GUID	JR	EQ			AND	0	0
5	CRMC_MKTPL_CTYPE	MANDT	JL	EQ				0	0
6	CRM_MKTPL_ATTR	CLIENT	JR	EQ			AND	0	0
7	CRMC_MKTPL_CTYPE	CAMP_TYPE	JL	EQ				0	0
8	CRM_MKTPL_ATTR	CAMP_TYPE	JR	EQ			AND	0	0
9	CGPL_TEXT	CLIENT	JL	EQ				0	0
10	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
11	CGPL_TEXT	GUID	JL	EQ				0	0
12	CGPL_PROJECT	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CGPL_PROJECT	CLIENT		☐	MANDT	☐	Client
2	GUID	CGPL_PROJECT	GUID		☐	CGPL_PROJECT_GUID	☐	Project Planning: 16 Character GUID for Projects
3	LANGU	CGPL_TEXT	LANGU		☐	LANGU	☐	Language Key
4	EXTERNAL_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
5	PROJECT_GUID	CGPL_PROJECT	PROJECT_GUID		☐	CGPL_PROJECT_GUID	☐	Project Planning: 16 Character GUID for Projects
6	OBJECT_TYPE	CGPL_PROJECT	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning
7	CAMP_TYPE	CRM_MKTPL_ATTR	CAMP_TYPE		☐	CRM_MKTPL_CAMPTYPE	☐	Type
8	MDFTYPE	CRMC_MKTPL_CTYPE	MDFTYPE		☐	CRM_MKTPL_MDFTYPE	☐	Obsolete
9	TEXT1	CGPL_TEXT	TEXT1		☐	CGPL_TEXT1	☐	Language-Dependent Short Text

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	20130604
SAP Release Created in	500