SAP ABAP View V_MKTPL_CAU_BW (View for causal data extraction)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM-CAU (Application Component) Causals
     ⤷ CRM_MKTPL_CAU_BW (Package) CRM Marketing Planning - Causal BW Extraction

Basic Data

View Type	D	Database View
Database View	V_MKTPL_CAU_BW
Short Description	View for causal data extraction
Root table	CRMD_MKTPL_CAU	Assignment object Causal

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTPL_CAU	CRMD_MKTPL_CAU
2	CGPL_PROJECT
3	CRM_MKTPL_ATTR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_MKTPL_CAU	CLIENT	JL	EQ				0	0
2	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
3	CRMD_MKTPL_CAU	PROJECT_GUID	JL	EQ				0	0
4	CGPL_PROJECT	GUID	JR	EQ			AND	0	0
5	CRMD_MKTPL_CAU	CLIENT	JL	EQ				0	0
6	CRM_MKTPL_ATTR	CLIENT	JR	EQ			AND	0	0
7	CRMD_MKTPL_CAU	PROJECT_GUID	JL	EQ				0	0
8	CRM_MKTPL_ATTR	GUID	JR	EQ			AND	0	0
9	CGPL_PROJECT	OBJECT_TYPE		EQ	'TPM'		OR	0	0
10	CGPL_PROJECT	OBJECT_TYPE		EQ	'INI'		AND	0	0
11	CRM_MKTPL_ATTR	TEMPLATE		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	CRMD_MKTPL_CAU	*		☐		☐
2	CLIENT	CRMD_MKTPL_CAU	CLIENT		☐	MANDT	☐	Client
3	GUID	CRMD_MKTPL_CAU	GUID		☐	SYSUUID_X	☐	UUID in X form (binary)
4	PROJECT_GUID	CRMD_MKTPL_CAU	PROJECT_GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
5	TASK_GUID	CRMD_MKTPL_CAU	TASK_GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
6	DISPLAY_TYPE	CRMD_MKTPL_CAU	DISPLAY_TYPE		☐	CRM_MKTPL_CAU_DISPLAY_TYPE	☐	Causal Factor: Display Type
7	DISPLAY_LOCATION	CRMD_MKTPL_CAU	DISPLAY_LOCATION		☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	☐	Causal Factor: Display Location
8	FEATURE_AD	CRMD_MKTPL_CAU	FEATURE_AD		☐	CRM_MKTPL_CAU_FEATURE_AD	☐	Causal Factor: Feature AD
9	FEATURE_AD_ACV	CRMD_MKTPL_CAU	FEATURE_AD_ACV		☐	CRM_MKTPL_CAU_FEATURE_AD_ACV	☐	Causal Factor: Feature AD ACV %
10	MEDIA	CRMD_MKTPL_CAU	MEDIA		☐	CRM_MKTPL_CAU_MEDIA	☐	Causal Factor Media
11	REG_RETAIL_PRC	CRMD_MKTPL_CAU	REG_RETAIL_PRC		☐	CRM_MKTPL_CAU_REG_RETAIL_PRC	☐	Causal Factor: Regular Retail Price
12	RETAIL_PRICE	CRMD_MKTPL_CAU	RETAIL_PRICE		☐	CRM_MKTPL_CAU_RETAIL_PRC	☐	Retail Price
13	RETAIL_CURRENCY	CRMD_MKTPL_CAU	RETAIL_CURRENCY		☐	CRM_MKTPL_CAU_RETAIL_CURR	☐	Retail Price Currency
14	BUY	CRMD_MKTPL_CAU	BUY		☐	CRM_MKTPL_CAU_UNITS	☐	Promotion Retail Unit
15	GET_FREE	CRMD_MKTPL_CAU	GET_FREE		☐	CRM_MKTPL_CAU_FREE_UNITS	☐	Get Free (#Units)
16	MEDIA_ACV	CRMD_MKTPL_CAU	MEDIA_ACV		☐	CRM_MKTPL_CAU_MEDIA_ACV	☐	Media ACV %
17	SLOTTING_DATE	CRMD_MKTPL_CAU	SLOTTING_DATE		☐	CRM_MKTPL_CAU_SLOTTING_DATE	☐	Slotting Date
18	SLOTTING_SKU	CRMD_MKTPL_CAU	SLOTTING_SKU		☐	CRM_MKTPL_CAU_SLOTTING_SKU	☐	Number of Slotted SKUs
19	SPAC_CAU	CRMD_MKTPL_CAU	SPAC_CAU		☐	CRM_MKTPL_CAU_SPACE	☐	Space
20	INC_SPAC	CRMD_MKTPL_CAU	INC_SPAC		☐	CRM_MKTPL_CAU_INC_SPACE	☐	Incremental Space
21	SPAC_UNIT	CRMD_MKTPL_CAU	SPAC_UNIT		☐	CRM_MKTPL_CAU_SPACE_UNITS	☐	Space Units
22	SEC_LOCATIONS	CRMD_MKTPL_CAU	SEC_LOCATIONS		☐	CRM_MKTPL_CAU_SEC_LOCATIONS	☐	Secondary Locations
23	SEC_LOC_INC	CRMD_MKTPL_CAU	SEC_LOC_INC		☐	CRM_MKTPL_CAU_INC_SEC_LOC	☐	Incremental Secondary Locations
24	AD_SIZE	CRMD_MKTPL_CAU	AD_SIZE		☐	CRM_MKTPL_CAU_AD_SIZE	☐	Ad Size
25	LOGO	CRMD_MKTPL_CAU	LOGO		☐	CRM_MKTPL_CAU_LOGO	☐	Logo
26	UNIT	CRMD_MKTPL_CAU	UNIT		☐	CRM_MKTPL_CAU_UNIT	☐	Causal Factor Unit
27	MODE_TRANSPORT	CRMD_MKTPL_CAU	MODE_TRANSPORT		☐	CRM_MKTPL_CAU_MODE_TRANSPORT	☐	Transport Mode
28	ACCOMODATION	CRMD_MKTPL_CAU	ACCOMODATION		☐	CRM_MKTPL_CAU_ACCOMODATION	☐	Accomodation
29	BREAKFAST	CRMD_MKTPL_CAU	BREAKFAST		☐	CRM_MKTPL_CAU_BREAKFAST	☐	Breakfast
30	CAUSAL_ID	CRMD_MKTPL_CAU	CAUSAL_ID		☐	CRM_MKTPL_CAU_ID	☐	Causal Factor ID
31	DIMENSION_TYPE	CRMD_MKTPL_CAU	DIMENSION_TYPE		☐	CRM_MKTPL_CAU_DIMENSION_TYPE	☐	Dimension Type
32	DIMENSION_GUID	CRMD_MKTPL_CAU	DIMENSION_GUID		☐	CRM_MKTPL_CAU_DIMENSION_GUID	☐	Dimension GUID
33	PRODUCT_GROUP	CRMD_MKTPL_CAU	PRODUCT_GROUP		☐	CRM_MKTPL_CAU_PRODUCT_GROUP	☐	Product Group
34	SEG_GUID	CRMD_MKTPL_CAU	SEG_GUID		☐	CRM_MKTPL_CAU_SEG_GUID	☐	CRM Marketing: Marketing Segment GUID
35	FIELDNAME	CRMD_MKTPL_CAU	FIELDNAME		☐	NAME_FELD	☐	Field name
36	EXPENSE_TYPE	CRMD_MKTPL_CAU	EXPENSE_TYPE		☐	CRM_FM_EXPENSE_TYPE	☐	Expense Type
37	CAUSAL_TYPE	CRMD_MKTPL_CAU	CAUSAL_TYPE		☐	CRM_MKTPL_CAU_TYPE	☐	Causal Factor Type
38	CAUSAL_MANDATORY	CRMD_MKTPL_CAU	CAUSAL_MANDATORY		☐	CRM_BOOLEAN	☐	Data element to simulate bool: 'X' is true and ' ' is false
39	MKTPL_CAUSAL	CRMD_MKTPL_CAU	MKTPL_CAUSAL		☐	DUMMY	☐	Dummy function in length 1
40	EXTERNAL_ID	CGPL_PROJECT	EXTERNAL_ID		☐	CGPL_EXTID	☐	Project Planning: External Indentifier of an Element
41	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	20130604
SAP Release Created in	700