SAP ABAP Table CRM_CAU_EXTRACT_STRUCT (Extract structure 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

Table Category	INTTAB	Structure
Structure	CRM_CAU_EXTRACT_STRUCT	Table Relationship Diagram
Short Description	Extract structure for 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	.INCLUDE	☐				0	0	Assignment object Causal
2	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment Primary Key Include
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
5	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
6	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
8	.INCLUDE	☐				0	0	TPM Integration: Include Structure for Causal
9	DISPLAY_TYPE	☐	CRM_MKTPL_CAU_DISPLAY_TYPE	CRM_MKTPL_CAU_DISPLAY_TYPE	CHAR	3	0	Causal Factor: Display Type
10	DISPLAY_LOCATION	☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	CRM_MKTPL_CAU_DISPLAY_LOCATION	CHAR	3	0	Causal Factor: Display Location
11	FEATURE_AD	☐	CRM_MKTPL_CAU_FEATURE_AD	CRM_MKTPL_CAU_FEATURE_AD	CHAR	3	0	Causal Factor: Feature AD
12	FEATURE_AD_ACV	☐	CRM_MKTPL_CAU_FEATURE_AD_ACV	CRM_MKTPL_CAU_FEATURE_AD_ACV	NUMC	3	0	Causal Factor: Feature AD ACV %
13	MEDIA	☐	CRM_MKTPL_CAU_MEDIA	CRM_MKTPL_CAU_MEDIA	CHAR	3	0	Causal Factor Media
14	REG_RETAIL_PRC	☐	CRM_MKTPL_CAU_REG_RETAIL_PRC	CRM_MKTPL_CAU_REG_RETAIL_PRC	CURR	15	2	Causal Factor: Regular Retail Price
15	RETAIL_PRICE	☐	CRM_MKTPL_CAU_RETAIL_PRC	CRM_MKTPL_CAU_RETAIL_PRC	CURR	15	2	Retail Price
16	RETAIL_CURRENCY	☐	CRM_MKTPL_CAU_RETAIL_CURR	WAERS	CUKY	5	0	Retail Price Currency	*
17	BUY	☐	CRM_MKTPL_CAU_UNITS	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Promotion Retail Unit
18	GET_FREE	☐	CRM_MKTPL_CAU_FREE_UNITS	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Get Free (#Units)
19	MEDIA_ACV	☐	CRM_MKTPL_CAU_MEDIA_ACV	CRM_MKTPL_CAU_MEDIA_ACV	NUMC	3	0	Media ACV %
20	SLOTTING_DATE	☐	CRM_MKTPL_CAU_SLOTTING_DATE	CRM_MKTPL_CAU_DATE	DATS	8	0	Slotting Date
21	SLOTTING_SKU	☐	CRM_MKTPL_CAU_SLOTTING_SKU	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Number of Slotted SKUs
22	SPAC_CAU	☐	CRM_MKTPL_CAU_SPACE	CRM_MKTPL_CAU_SPACE	NUMC	3	0	Space
23	INC_SPAC	☐	CRM_MKTPL_CAU_INC_SPACE	CRM_MKTPL_CAU_SPACE	NUMC	3	0	Incremental Space
24	SPAC_UNIT	☐	CRM_MKTPL_CAU_SPACE_UNITS	CRM_MKTPL_CAU_SPACE_UNIT	CHAR	3	0	Space Units	*
25	SEC_LOCATIONS	☐	CRM_MKTPL_CAU_SEC_LOCATIONS	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Secondary Locations
26	SEC_LOC_INC	☐	CRM_MKTPL_CAU_INC_SEC_LOC	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Incremental Secondary Locations
27	AD_SIZE	☐	CRM_MKTPL_CAU_AD_SIZE	CRM_MKTPL_CAU_AD_SIZE	CHAR	4	0	Ad Size
28	LOGO	☐	CRM_MKTPL_CAU_LOGO	CRM_MKTPL_CAU_LOGO	CHAR	4	0	Logo
29	UNIT	☐	CRM_MKTPL_CAU_UNIT	CRM_MKTPL_CAU_UNIT	UNIT	3	0	Causal Factor Unit
30	MODE_TRANSPORT	☐	CRM_MKTPL_CAU_MODE_TRANSPORT	CRM_MKTPL_CAU_MODE_TRANSPORT	CHAR	3	0	Transport Mode
31	ACCOMODATION	☐	CRM_MKTPL_CAU_ACCOMODATION	CRM_MKTPL_CAU_ACCOMADATION	CHAR	1	0	Accomodation
32	BREAKFAST	☐	CRM_MKTPL_CAU_BREAKFAST	CRM_MKTPL_CAU_BREAKFAST	CHAR	1	0	Breakfast
33	.INCLUDE	☐				0	0
34	CAUSAL_ID	☐	CRM_MKTPL_CAU_ID	CRM_MKTPL_CAU_ID	CHAR	72	0	Causal Factor ID
35	DIMENSION_TYPE	☐	CRM_MKTPL_CAU_DIMENSION_TYPE	CRM_MKTPL_CAU_DIMENSION_TYPE	CHAR	3	0	Dimension Type
36	DIMENSION_GUID	☐	CRM_MKTPL_CAU_DIMENSION_GUID	SYSUUID	RAW	16	0	Dimension GUID
37	PRODUCT_GROUP	☐	CRM_MKTPL_CAU_PRODUCT_GROUP		CHAR	3	0	Product Group
38	SEG_GUID	☐	CRM_MKTPL_CAU_SEG_GUID	CRM_MKTPL_CAU_SEG_GUID	RAW	16	0	CRM Marketing: Marketing Segment GUID
39	FIELDNAME	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
40	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
41	CAUSAL_TYPE	☐	CRM_MKTPL_CAU_TYPE	CRM_MKTPL_CAU_TYPE	CHAR	4	0	Causal Factor Type
42	CAUSAL_MANDATORY	☐	CRM_BOOLEAN	CRMD_BOOLEAN	CHAR	1	0	Data element to simulate bool: 'X' is true and ' ' is false
43	.INCLUDE	☐				0	0	Initiative Causal
44	MKTPL_CAUSAL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
45	DELFLAG	☐	CGPL_BW_DELFLAG		CHAR	1	0	BW Deletion Indicator

History

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