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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTPL (Package) CRM Marketing Planning - User Interfaces

Basic Data

View Type	D	Database View
Database View	V_SCRMMKT_BW_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	'MPL'		OR	0	0
6	CGPL_PROJECT	OBJECT_TYPE		EQ	'CPG'		OR	0	0
7	CGPL_PROJECT	OBJECT_TYPE		EQ	'TPM'		OR	0	0
8	CGPL_PROJECT	OBJECT_TYPE		EQ	'DLM'		OR	0	0
9	CGPL_PROJECT	OBJECT_TYPE		EQ	'AGR'		OR	0	0
10	CGPL_PROJECT	OBJECT_TYPE		EQ	'LOY'		OR	0	0
11	CGPL_PROJECT	OBJECT_TYPE		EQ	'RRG'		OR	0	0
12	CGPL_PROJECT	OBJECT_TYPE		EQ	'RRL'		AND	0	0
13	CRM_MKTPL_ATTR	TEMPLATE		EQ	' '			0	0

View Fields

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