SAP ABAP View V_SCRMMKT_PGM_P (View for Selection of BW Initial Fill (Projects))

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_PGM_P
Short Description	View for Selection of BW Initial Fill (Projects)
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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CGPL_PROJECT	CLIENT	JL	EQ				0	0
2	CRM_MKTPL_ATTR	CLIENT	JR	EQ			AND	0	0
3	CGPL_PROJECT	GUID	JL	EQ				0	0
4	CRM_MKTPL_ATTR	GUID	JR	EQ			AND	0	0
5	CGPL_PROJECT	OBJECT_TYPE		EQ	'PGM'			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	EXTERNAL_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
4	PROJECT_GUID	CRM_MKTPL_ATTR	PROJECT_GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
5	OBJECT_TYPE	CGPL_PROJECT	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning
6	PRIORITY	CGPL_PROJECT	PRIORITY		☐	CGPL_PRIORITY	☐	Priority
7	PLANSTART	CGPL_PROJECT	PLANSTART		☐	CGPL_PLANSTART	☐	Planned start date
8	PLANFINISH	CGPL_PROJECT	PLANFINISH		☐	CGPL_PLANFINISH	☐	Planned Finish Date
9	ACTUALSTART	CGPL_PROJECT	ACTUALSTART		☐	CGPL_ACTUALSTART	☐	Actual Start Date
10	ACTUALFINISH	CGPL_PROJECT	ACTUALFINISH		☐	CGPL_ACTUALFINISH	☐	Actual Finish Date
11	COMPLETION	CGPL_PROJECT	COMPLETION		☐	CGPL_COMPLETION	☐	Percentage of Completion
12	MILESTONE	CGPL_PROJECT	MILESTONE		☐	CGPL_MILESTONE	☐	Milestone indicator
13	CONSTRAINT_TYPE	CGPL_PROJECT	CONSTRAINT_TYPE		☐	CGPL_CONSTRAINT	☐	Type of Scheduling Constraint
14	CONSTRAINT_TIME	CGPL_PROJECT	CONSTRAINT_TIME		☐	CGPL_CONSTRAINT_TIME	☐	Constraint Date
15	CREATED_BY	CGPL_PROJECT	CREATED_BY		☐	CGPL_CREATED_BY	☐	Name of Person Who Created Object
16	CREATED_ON	CGPL_PROJECT	CREATED_ON		☐	CGPL_CREATED_ON	☐	Date on Which the Object was Created
17	CHANGED_BY	CGPL_PROJECT	CHANGED_BY		☐	CGPL_CHANGED_BY	☐	Name of Person Who Changed Object
18	CHANGED_ON	CGPL_PROJECT	CHANGED_ON		☐	CGPL_CHANGED_ON	☐	Date on Which Object Was Last Changed
19	CAMP_TYPE	CRM_MKTPL_ATTR	CAMP_TYPE		☐	CRM_MKTPL_CAMPTYPE	☐	Type
20	CHANNEL	CRM_MKTPL_ATTR	CHANNEL		☐	CRM_MKTPL_CHANNEL	☐	ID of Communication Medium
21	RESPONSIBLE	CRM_MKTPL_ATTR	RESPONSIBLE		☐	BU_PARTNER_GUID	☐	Business Partner GUID
22	SMARTFORM	CRM_MKTPL_ATTR	SMARTFORM		☐	CRMT_MKTPL_EMAIL_FORM	☐	Form for E-Mail
23	MAIL_FORM	CRM_MKTPL_ATTR	MAIL_FORM		☐	CRMT_MKTPL_MAIL_FORM	☐	Form for Sending a Letter
24	FAX_FORM	CRM_MKTPL_ATTR	FAX_FORM		☐	CRMT_MKTPL_FAX_FORM	☐	Form for Fax
25	SMS_FORM	CRM_MKTPL_ATTR	SMS_FORM		☐	CRMT_MKTPL_SMS_FORM	☐	Form for SMS/Pager Services
26	ADRESS_ID	CRM_MKTPL_ATTR	ADRESS_ID		☐	CRMT_IM_E_ID	☐	Identification for an E-mail Address
27	SHORTCUT	CRM_MKTPL_ATTR	SHORTCUT		☐	CRMT_MKTPL_CAMPAIGN_SHORTCUT	☐	Campaign Code
28	PRINT_ID	CRM_MKTPL_ATTR	PRINT_ID		☐	CRMT_IM_PRINT_ID	☐	Profile for Print Parameters
29	SEND_PARTNER	CRM_MKTPL_ATTR	SEND_PARTNER		☐	CRM_IM_SEND_PARTNER	☐	Business partner for Sender Address Determination
30	TACTICS	CRM_MKTPL_ATTR	TACTICS		☐	CRM_MKTPL_TACTICS	☐	Tactic
31	OBJECTIVE	CRM_MKTPL_ATTR	OBJECTIVE		☐	CRM_MKTPL_OBJECTIVE	☐	Objective
32	AUTH_GROUP	CRM_MKTPL_ATTR	AUTH_GROUP		☐	CRM_MKTPL_AUTH_GROUP	☐	Authorization Group
33	PLANGROUP	CGPL_PROJECT	PLANGROUP		☐	CGPL_SEM_PLGRP	☐	Planning Profile Group
34	SCRIPT	CRM_MKTPL_ATTR	SCRIPT		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
35	CALENDAR_ID	CGPL_PROJECT	CALENDAR_ID		☐	WFCID	☐	Factory Calendar
36	ACTION_PROFILE	CRM_MKTPL_ATTR	ACTION_PROFILE		☐	CRM_MKTPL_ACTION_PROFILE	☐	ID of Action Profile
37	CAMPAIGN_LINK	CRM_MKTPL_ATTR	CAMPAIGN_LINK		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
38	CURRENCY	CRM_MKTPL_ATTR	CURRENCY		☐	CRM_MKTPL_CUKY	☐	MKTPL: Currency Object
39	CPT_TYPE	CRM_MKTPL_ATTR	CPT_TYPE		☐	CRMT_MKTCA_CPT_TYPE	☐	Type of Campaign Element Used
40	SURVEYID	CRM_MKTPL_ATTR	SURVEYID		☐	CRM_SVY_DB_SID	☐	CRM Surveys: Survey ID
41	SURVEYVERSION	CRM_MKTPL_ATTR	SURVEYVERSION		☐	CRM_SVY_DB_SVERS	☐	CRM Surveys: Survey Version
42	RECURRING	CRM_MKTPL_ATTR	RECURRING		☐	CRMT_MKTCA_CPG_RECURRING	☐	Indicator Recurring Campaign for Camp. Automation
43	CAMP_PERIOD	CRM_MKTPL_ATTR	CAMP_PERIOD		☐	CRMT_MKTCA_PERIOD	☐	Period for Campaign
44	N_CAMP_PERIODS	CRM_MKTPL_ATTR	N_CAMP_PERIODS		☐	CRMT_MKTCA_NUMBER_PERIODS	☐	No. of Processing Periods
45	TERR_PATH_GUID	CRM_MKTPL_ATTR	TERR_PATH_GUID		☐	CRMT_TERRITORY_PATH_GUID	☐	Territory Path GUID
46	TERR_PATH_ID	CRM_MKTPL_ATTR	TERR_PATH_ID		☐	CRMT_TERRITORY_PATH_ID	☐	Territory Hierarchy ID
47	FILE_EXPORT_FORM	CRM_MKTPL_ATTR	FILE_EXPORT_FORM		☐	CRMT_IM_EXPORT_FORM	☐	File Export Form
48	INACTIV	CRM_MKTPL_ATTR	INACTIVE		☐	CRMT_MKTPL_INACTIVE	☐	Inactive Marketing Project
49	MKT_ORG	CRM_MKTPL_ATTR	MKT_ORG		☐	CRM_MKTPL_MORG	☐	Marketing Organization
50	TIMEZONE_CREATED	CRM_MKTPL_ATTR	TIMEZONE_CREATED		☐	CRM_MKTPL_TIMEZONE_CREATED	☐	Time Zone of User Who Created the Marketing Project
51	ADI_FLAG	CRM_MKTPL_ATTR	ADI_FLAG		☐	CRM_MKTPL_ADI	☐	Abnormal Demand Indicator
52	REF_TYPE	CRM_MKTPL_ATTR	REF_TYPE		☐	CRM_MKTPL_REF_TYPE	☐	Usage Type
53	ENROLLMENT_REQ	CRM_MKTPL_ATTR	ENROLLMENT_REQ		☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	☐	Indicator, that enrollment is required
54	CHM_RELEVANT	CRM_MKTPL_ATTR	CHM_RELEVANT		☐	CRMT_MKTPL_CHM_RELEVANT	☐	Open to Partners
55	BWIDENTIFIER	CGPL_PROJECT	BWIDENTIFIER		☐	CGPL_BWIDENTIFIER	☐	Project Planning - BW Identification
56	*	CRM_MKTPL_ATTR	*		☐		☐
57	-	CRM_MKTPL_ATTR	CLIENT		☐	MANDT	☐	Client
58	-	CRM_MKTPL_ATTR	GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
59	ORIG_SYSTEM	CRM_MKTPL_ATTR	ORIG_SYSTEM		☐	CRM_MKTPL_ORIG_SYST	☐	CRM Marketing Planning - Campaign Original System
60	SPICE_SCRIPT	CRM_MKTPL_ATTR	SPICE_SCRIPT		☐	CRM_IC_SCRNAME	☐	Name of Interaction Center (IC) WebClient Script
61	NO_R3_INT	CRM_MKTPL_ATTR	NO_R3_INT		☐	CRM_MKTPL_NO_R3_INT	☐	Marketing Planning: Object Not Integrated into ERP PS
62	MKTCA_WFTASK	CRM_MKTPL_ATTR	MKTCA_WFTASK		☐	CRMT_MKTCA_WFTASK	☐	Assignment Term Workflow for Task ID
63	RESPONSE_FLAG	CRM_MKTPL_ATTR	RESPONSE_FLAG		☐	CRMT_MKTCA_RESPONSE_FLAG	☐	Start for Every Respondent?
64	ET_CAMPAIGN	CRM_MKTPL_ATTR	ET_CAMPAIGN		☐	CRMT_MKTCA_EVENT_TRIGGERED_CPG	☐	Indicator for Event Triggered Campaigns
65	SCHEDULING_TYPE	CRM_MKTPL_ATTR	SCHEDULING_TYPE		☐	CRMT_MKTCA_SCHEDULING_TYPE	☐	Scheduling Type
66	DELAY	CRM_MKTPL_ATTR	DELAY		☐	CRMT_MKTCA_DELAY	☐	Delay (Relative Scheduling)
67	DELAY_UNIT	CRM_MKTPL_ATTR	DELAY_UNIT		☐	CRMT_MKTCA_DELAY_UNIT	☐	Unit for Delay (Relative Scheduling)
68	CAMP_PERIOD_DUR	CRM_MKTPL_ATTR	CAMP_PERIOD_DUR		☐	CRMT_MKTCA_PERIOD_N	☐	Period Duration for Recurring Campaigns
69	EXCL_IND	CRM_MKTPL_ATTR	EXCL_IND		☐	CRM_MKTPL_EXCL_IND	☐	Indicator: Marketing Project Is Exclusive
70	PROD_PL_BASIS	CRM_MKTPL_ATTR	PROD_PL_BASIS		☐	CRM_MKTSS_PL_BASIS	☐	Product Planning Basis
71	TEMPLATE	CRM_MKTPL_ATTR	TEMPLATE		☐	CRM_MKTPL_TEMPLATE	☐	Template Indicator
72	SMARTDAY_FLAG	CRM_MKTPL_ATTR	SMARTDAY_FLAG		☐	CRMT_BOOLEAN	☐	Logical Variable
73	VALIDATION_PROF	CRM_MKTPL_ATTR	VALIDATION_PROF		☐	CRM_CLA_VS_VAL_PROFILE_ID	☐	ID of Validation Sheet Profile
74	DETERM_PROC	CRM_MKTPL_ATTR	DETERM_PROC		☐	COMT_PARTNER_DETERM_PROC	☐	ID of a Partner Determination Procedure
75	RATES_ORIGIN	CRM_MKTPL_ATTR	RATES_ORIGIN		☐	CRM_MKTGS_RATES_ORIGIN	☐	Rates Origin
76	USE_FIX_TZ_UTC	CRM_MKTPL_ATTR	USE_FIX_TZ_UTC		☐	CRM_MKTPL_USE_FIX_TIMEZONE	☐	MKTPL: Use Fix Timezone UTC for Timestamp - Date/Time Conv.
77	COMB_TYPE	CRM_MKTPL_ATTR	COMB_TYPE		☐	CRM_MKTPL_LOY_COMB_TYPE	☐	Combinability Type for Reward Rule Group
78	EXECUTION_LANG	CRM_MKTPL_ATTR	EXECUTION_LANG		☐	CRM_MKTPL_EXECUTION_LANGUAGE	☐	Execution Language in High-Volume Scenario
79	BP_CORR_LANG_IND	CRM_MKTPL_ATTR	BP_CORR_LANG_IND		☐	CRM_MKTPL_DETERMINE_CORR_LANG	☐	Indicator: Determine BP Correspondence Language
80	NOTIF_PROF	CRM_MKTPL_ATTR	NOTIF_PROF		☐	CRMT_NOTIF_PROF	☐	Notification Profile
81	MKTPL_HEADER	CRM_MKTPL_ATTR	MKTPL_HEADER		☐	DUMMY	☐	Dummy function in length 1
82	ENROLLMENT_TYPE	CRM_MKTPL_ATTR	ENROLLMENT_TYPE		☐	CRM_MKTPL_ENR_TYPE	☐	Data Element For Enrollment Type
83	CHECK_CONSENT	CRM_MKTPL_ATTR	CHECK_CONSENT		☐	CRM_MKTPL_CHECK_MKT_PERMISSION	☐	Check Consent (Marketing Permission)

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	700