SAP ABAP Table SCRMMKT_VWS_ETDATA (Extract Structure for Validation Sheet)

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

Table Category	INTTAB	Structure
Structure	SCRMMKT_VWS_ETDATA	Table Relationship Diagram
Short Description	Extract Structure for Validation Sheet

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	VS_GUID	☐	CRM_CLA_VS_GUID	SYSUUID	RAW	16	0	GUID of a Validation Sheet
2	MDF_PGM_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
3	MDF_SPG_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
4	MDF_INI_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
5	MDF_MKTPL_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
6	MDF_PGM_ID	☐	CRM_MKTPL_PROGRAMID	CGPL_EXTID	CHAR	24	0	MDF Program
7	MDF_SPG_ID	☐	CRM_MKTPL_MDFCAMPAIGNID	CGPL_EXTID	CHAR	24	0	MDF Special Program ID
8	MDF_INI_ID	☐	CRM_MKTPL_INITIATIVEID	CGPL_EXTID	CHAR	24	0	MDF Initiative
9	MDF_MKTPL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
10	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
11	CP_GUID	☐	CRM_CLA_VS_REL_OBJ_GUID	SYSUUID	RAW	16	0	Unique ID of Related Object
12	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	SNAPSHOT_VERSION	☐	CRM_MKTPL_SEM_VERSION	CRM_MKTPL_SEM_VERSION	CHAR	10	0	CRM Marketing SEM Version
14	DATA_STATUS	☐	CRM_CLA_VS_DATA_STATUS	CRM_CLA_VS_DATA_STATUS	CHAR	1	0	Status of a Dataset
15	EXT_VS_GUID	☐	CRM_CLA_VS_EXTERNAL_ID	CRM_CLA_VS_EXTERNAL_ID	CHAR	24	0	External ID for Validation Sheet (BI Use)
16	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
17	CLAIM_REF	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
18	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type
19	CAUSAL_TYPE	☐	CRM_MKTPL_CAU_TYPE	CRM_MKTPL_CAU_TYPE	CHAR	4	0	Causal Factor Type
20	CAUSAL_FIELD	☐	NAME_FELD	FDNAME	CHAR	30	0	Field name	*
21	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
22	PRODUCT_CAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
23	.INCLUDE	☐				0	0	Pre-delivered Causal fields related to Validation Sheets
24	AD_SIZE_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
25	AD_SIZE_C	☐	CRM_MKTPL_CAU_AD_SIZE	CRM_MKTPL_CAU_AD_SIZE	CHAR	4	0	Ad Size
26	AD_SIZE_V	☐	CRM_MKTPL_CAU_AD_SIZE	CRM_MKTPL_CAU_AD_SIZE	CHAR	4	0	Ad Size
27	AD_SIZE_A	☐	CRM_MKTPL_CAU_AD_SIZE	CRM_MKTPL_CAU_AD_SIZE	CHAR	4	0	Ad Size
28	LOGO_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
29	LOGO_C	☐	CRM_MKTPL_CAU_LOGO	CRM_MKTPL_CAU_LOGO	CHAR	4	0	Logo
30	LOGO_V	☐	CRM_MKTPL_CAU_LOGO	CRM_MKTPL_CAU_LOGO	CHAR	4	0	Logo
31	LOGO_A	☐	CRM_MKTPL_CAU_LOGO	CRM_MKTPL_CAU_LOGO	CHAR	4	0	Logo
32	DISP_LOC_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
33	DISP_LOC_C	☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	CRM_MKTPL_CAU_DISPLAY_LOCATION	CHAR	3	0	Causal Factor: Display Location
34	DISP_LOC_V	☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	CRM_MKTPL_CAU_DISPLAY_LOCATION	CHAR	3	0	Causal Factor: Display Location
35	DISP_LOC_A	☐	CRM_MKTPL_CAU_DISPLAY_LOCATION	CRM_MKTPL_CAU_DISPLAY_LOCATION	CHAR	3	0	Causal Factor: Display Location
36	DISPLAY_TYPE_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
37	DISPLAY_TYPE_C	☐	CRM_MKTPL_CAU_DISPLAY_TYPE	CRM_MKTPL_CAU_DISPLAY_TYPE	CHAR	3	0	Causal Factor: Display Type
38	DISPLAY_TYPE_V	☐	CRM_MKTPL_CAU_DISPLAY_TYPE	CRM_MKTPL_CAU_DISPLAY_TYPE	CHAR	3	0	Causal Factor: Display Type
39	DISPLAY_TYPE_A	☐	CRM_MKTPL_CAU_DISPLAY_TYPE	CRM_MKTPL_CAU_DISPLAY_TYPE	CHAR	3	0	Causal Factor: Display Type
40	FEATURE_AD_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
41	FEATURE_AD_C	☐	CRM_MKTPL_CAU_FEATURE_AD	CRM_MKTPL_CAU_FEATURE_AD	CHAR	3	0	Causal Factor: Feature AD
42	FEATURE_AD_V	☐	CRM_MKTPL_CAU_FEATURE_AD	CRM_MKTPL_CAU_FEATURE_AD	CHAR	3	0	Causal Factor: Feature AD
43	FEATURE_AD_A	☐	CRM_MKTPL_CAU_FEATURE_AD	CRM_MKTPL_CAU_FEATURE_AD	CHAR	3	0	Causal Factor: Feature AD
44	MEDIA_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
45	MEDIA_C	☐	CRM_MKTPL_CAU_MEDIA	CRM_MKTPL_CAU_MEDIA	CHAR	3	0	Causal Factor Media
46	MEDIA_V	☐	CRM_MKTPL_CAU_MEDIA	CRM_MKTPL_CAU_MEDIA	CHAR	3	0	Causal Factor Media
47	MEDIA_A	☐	CRM_MKTPL_CAU_MEDIA	CRM_MKTPL_CAU_MEDIA	CHAR	3	0	Causal Factor Media
48	INC_SEC_LOC_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
49	INC_SEC_LOC_C	☐	CRM_MKTPL_CAU_INC_SEC_LOC	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Incremental Secondary Locations
50	INC_SEC_LOC_V	☐	CRM_MKTPL_CAU_INC_SEC_LOC	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Incremental Secondary Locations
51	INC_SEC_LOC_A	☐	CRM_MKTPL_CAU_INC_SEC_LOC	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Incremental Secondary Locations
52	SLOTTING_SKU_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
53	SLOTTING_SKU_C	☐	CRM_MKTPL_CAU_SLOTTING_SKU	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Number of Slotted SKUs
54	SLOTTING_SKU_V	☐	CRM_MKTPL_CAU_SLOTTING_SKU	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Number of Slotted SKUs
55	SLOTTING_SKU_A	☐	CRM_MKTPL_CAU_SLOTTING_SKU	CRM_MKTPL_CAU_UNITS	NUMC	3	0	Number of Slotted SKUs
56	SEC_LOCATIONS_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
57	SEC_LOCATIONS_C	☐	CRM_MKTPL_CAU_SEC_LOCATIONS	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Secondary Locations
58	SEC_LOCATIONS_V	☐	CRM_MKTPL_CAU_SEC_LOCATIONS	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Secondary Locations
59	SEC_LOCATIONS_A	☐	CRM_MKTPL_CAU_SEC_LOCATIONS	CRM_MKTPL_CAU_SEC_LOC	NUMC	3	0	Secondary Locations
60	MODE_TRANSPORT_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
61	MODE_TRANSPORT_C	☐	CRM_MKTPL_CAU_MODE_TRANSPORT	CRM_MKTPL_CAU_MODE_TRANSPORT	CHAR	3	0	Transport Mode
62	MODE_TRANSPORT_V	☐	CRM_MKTPL_CAU_MODE_TRANSPORT	CRM_MKTPL_CAU_MODE_TRANSPORT	CHAR	3	0	Transport Mode
63	MODE_TRANSPORT_A	☐	CRM_MKTPL_CAU_MODE_TRANSPORT	CRM_MKTPL_CAU_MODE_TRANSPORT	CHAR	3	0	Transport Mode
64	ACCOMODATION_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
65	ACCOMODATION_C	☐	CRM_MKTPL_CAU_ACCOMODATION	CRM_MKTPL_CAU_ACCOMADATION	CHAR	1	0	Accomodation
66	ACCOMODATION_V	☐	CRM_MKTPL_CAU_ACCOMODATION	CRM_MKTPL_CAU_ACCOMADATION	CHAR	1	0	Accomodation
67	ACCOMODATION_A	☐	CRM_MKTPL_CAU_ACCOMODATION	CRM_MKTPL_CAU_ACCOMADATION	CHAR	1	0	Accomodation
68	BREAKFAST_S	☐	CRM_CLA_VS_VALUE	CRM_CLA_VS_VALUE	CHAR	255	0	Value
69	BREAKFAST_C	☐	CRM_MKTPL_CAU_BREAKFAST	CRM_MKTPL_CAU_BREAKFAST	CHAR	1	0	Breakfast
70	BREAKFAST_V	☐	CRM_MKTPL_CAU_BREAKFAST	CRM_MKTPL_CAU_BREAKFAST	CHAR	1	0	Breakfast
71	BREAKFAST_A	☐	CRM_MKTPL_CAU_BREAKFAST	CRM_MKTPL_CAU_BREAKFAST	CHAR	1	0	Breakfast
72	.INCLUDE	☐				0	0	Validation Sheet Extractor fields for Causal Field
73	VWSCAU_CUS	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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