SAP ABAP Table SCRMMKT_MDF_CAU_BW (Extract structure for mdf 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

Table Category	INTTAB	Structure
Structure	SCRMMKT_MDF_CAU_BW	Table Relationship Diagram
Short Description	Extract structure for mdf causal data extraction

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
4	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
6	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
7	CAUSAL_TYPE	☐	CRM_MKTPL_CAU_TYPE	CRM_MKTPL_CAU_TYPE	CHAR	4	0	Causal Factor Type
8	PLANNED_VALUE	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
9	MDF_PGM_ID	☐	CRM_MKTPL_PROGRAMID	CGPL_EXTID	CHAR	24	0	MDF Program
10	MDF_SPG_ID	☐	CRM_MKTPL_MDFCAMPAIGNID	CGPL_EXTID	CHAR	24	0	MDF Special Program ID
11	MDF_INI_ID	☐	CRM_MKTPL_INITIATIVEID	CGPL_EXTID	CHAR	24	0	MDF Initiative
12	MDF_MKTPL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
13	MDF_INT_ID	☐	CRM_MKTPL_INITIATIVE_TASKID	CGPL_EXTID	CHAR	24	0	Campaign Element
14	MDF_PGM_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
15	MDF_SPG_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
16	MDF_INI_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
17	MDF_MKTPL_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
18	MDF_INT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
19	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
20	PROD_CAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
21	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
22	.INCLUDE	☐				0	0	TPM Integration: Include Structure for Causal
23	DISPLAY_TYPE	☐	CRM_MKTPL_CAU_DISPLAY_TYPE	CRM_MKTPL_CAU_DISPLAY_TYPE	CHAR	3	0	Causal Factor: Display Type
24	DISPLAY_LOCATION	☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	CRM_MKTPL_CAU_DISPLAY_LOCATION	CHAR	3	0	Causal Factor: Display Location
25	FEATURE_AD	☐	CRM_MKTPL_CAU_FEATURE_AD	CRM_MKTPL_CAU_FEATURE_AD	CHAR	3	0	Causal Factor: Feature AD
26	FEATURE_AD_ACV	☐	CRM_MKTPL_CAU_FEATURE_AD_ACV	CRM_MKTPL_CAU_FEATURE_AD_ACV	NUMC	3	0	Causal Factor: Feature AD ACV %
27	MEDIA	☐	CRM_MKTPL_CAU_MEDIA	CRM_MKTPL_CAU_MEDIA	CHAR	3	0	Causal Factor Media
28	REG_RETAIL_PRC	☐	CRM_MKTPL_CAU_REG_RETAIL_PRC	CRM_MKTPL_CAU_REG_RETAIL_PRC	CURR	15	2	Causal Factor: Regular Retail Price
29	RETAIL_PRICE	☐	CRM_MKTPL_CAU_RETAIL_PRC	CRM_MKTPL_CAU_RETAIL_PRC	CURR	15	2	Retail Price
30	RETAIL_CURRENCY	☐	CRM_MKTPL_CAU_RETAIL_CURR	WAERS	CUKY	5	0	Retail Price Currency	*
31	BUY	☐	CRM_MKTPL_CAU_UNITS	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Promotion Retail Unit
32	GET_FREE	☐	CRM_MKTPL_CAU_FREE_UNITS	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Get Free (#Units)
33	MEDIA_ACV	☐	CRM_MKTPL_CAU_MEDIA_ACV	CRM_MKTPL_CAU_MEDIA_ACV	NUMC	3	0	Media ACV %
34	SLOTTING_DATE	☐	CRM_MKTPL_CAU_SLOTTING_DATE	CRM_MKTPL_CAU_DATE	DATS	8	0	Slotting Date
35	SLOTTING_SKU	☐	CRM_MKTPL_CAU_SLOTTING_SKU	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Number of Slotted SKUs
36	SPAC_CAU	☐	CRM_MKTPL_CAU_SPACE	CRM_MKTPL_CAU_SPACE	NUMC	3	0	Space
37	INC_SPAC	☐	CRM_MKTPL_CAU_INC_SPACE	CRM_MKTPL_CAU_SPACE	NUMC	3	0	Incremental Space
38	SPAC_UNIT	☐	CRM_MKTPL_CAU_SPACE_UNITS	CRM_MKTPL_CAU_SPACE_UNIT	CHAR	3	0	Space Units	*
39	SEC_LOCATIONS	☐	CRM_MKTPL_CAU_SEC_LOCATIONS	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Secondary Locations
40	SEC_LOC_INC	☐	CRM_MKTPL_CAU_INC_SEC_LOC	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Incremental Secondary Locations
41	AD_SIZE	☐	CRM_MKTPL_CAU_AD_SIZE	CRM_MKTPL_CAU_AD_SIZE	CHAR	4	0	Ad Size
42	LOGO	☐	CRM_MKTPL_CAU_LOGO	CRM_MKTPL_CAU_LOGO	CHAR	4	0	Logo
43	UNIT	☐	CRM_MKTPL_CAU_UNIT	CRM_MKTPL_CAU_UNIT	UNIT	3	0	Causal Factor Unit
44	MODE_TRANSPORT	☐	CRM_MKTPL_CAU_MODE_TRANSPORT	CRM_MKTPL_CAU_MODE_TRANSPORT	CHAR	3	0	Transport Mode
45	ACCOMODATION	☐	CRM_MKTPL_CAU_ACCOMODATION	CRM_MKTPL_CAU_ACCOMADATION	CHAR	1	0	Accomodation
46	BREAKFAST	☐	CRM_MKTPL_CAU_BREAKFAST	CRM_MKTPL_CAU_BREAKFAST	CHAR	1	0	Breakfast
47	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	701