SAP ABAP Table SCRMMKT_BW (Marketing Planning: Structure Data Source for Mktg Element)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	SCRMMKT_BW	Table Relationship Diagram
Short Description	Marketing Planning: Structure Data Source for Mktg Element

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	☐	CGPL_GUID32	SYSUUID_C	CHAR	32	0	Project Planning: 32 Character GUID for Projects and Tasks
3	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
4	PROJECT_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
5	OBJECT_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
6	DELFLAG	☐	CGPL_BW_DELFLAG		CHAR	1	0	BW Deletion Indicator
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
8	PLANSTARTDATE	☐	CGPL_PLANSTARTDATE	DATUM	DATS	8	0	Planned Start Date
9	PLANFINISHDATE	☐	CGPL_PLANFINISHDATE	DATUM	DATS	8	0	Planned Finish Date
10	ACTUALSTARTDATE	☐	CGPL_ACTUALSTARTDATE	DATUM	DATS	8	0	Actual Start Date
11	ACTUALFINISHDATE	☐	CGPL_ACTUALFINISHDATE	DATUM	DATS	8	0	Actual Finish (Date)
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINTDATE	☐	CGPL_CONSTRAINTDATE	DATUM	DATS	8	0	Constraint Date (Date)
16	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
17	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
18	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
19	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
20	POSID	☐	CGPL_R3_POSID	CGPL_EXTID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
21	CAMP_TYPE	☐	CRM_MKTPL_CAMPTYPE	CRM_MKTPL_CAMPTYPE	CHAR	4	0	Type	*
22	CHANNEL	☐	CRM_MKTPL_CHANNEL	CRM_MKTPL_CHANNEL	CHAR	4	0	ID of Communication Medium
23	RESPONSIBLE_NAME	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
24	SMARTFORM	☐	CRMT_IM_EMAIL_FORM	TDSFNAME	CHAR	30	0	Form for E-Mail	*
25	MAIL_FORM	☐	CRMT_IM_MAIL_FORM	TDSFNAME	CHAR	30	0	Form for letter	*
26	FAX_FORM	☐	CRMT_IM_FAX_FORM	TDSFNAME	CHAR	30	0	Form for Fax	*
27	SMS_FORM	☐	CRMT_IM_SMS_FORM	TDSFNAME	CHAR	30	0	Form for SMS	*
28	ADRESS_ID	☐	CRMT_IM_E_ID	CHAR12	CHAR	12	0	Identification for an E-mail Address
29	SHORTCUT	☐	COMT_PON_CAMPAIGN_SC	CHAR4	CHAR	4	0	Campaign Code
30	PRINT_ID	☐	CRMT_IM_PRINT_ID	CHAR12	CHAR	12	0	Profile for Print Parameters
31	SEND_PARTNER	☐	CRM_IM_SEND_PARTNER	BU_PARTNER	CHAR	10	0	Business partner for Sender Address Determination	*
32	BWSTMKTSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
33	BWSTMKTSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
34	BWSTMKTSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
35	BWSTMKTSYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
36	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
37	TACTICS	☐	CRM_MKTPL_TACTICS	CRM_MKTPL_TACTICS	CHAR	4	0	Tactic
38	OBJECTIVE	☐	CRM_MKTPL_OBJECTIVE	CRM_MKTPL_OBJECTIVE	CHAR	4	0	Objective
39	AUTH_GROUP	☐	CRM_MKTPL_AUTH_GROUP	CRM_MKTPL_AUTH_GROUP	CHAR	4	0	Authorization Group
40	SCRIPT_TREEID	☐	CRMT_TREEID	CRM_TREEID	NUMC	8	0	Name of Interaction Center (IC) WinClient Script
41	SURVEYID	☐	CRM_SVY_DB_SID	CHAR32	CHAR	32	0	CRM Surveys: Survey ID
42	SURVEYVERSION	☐	CRM_SVY_DB_SVERS	NUMC10	NUMC	10	0	CRM Surveys: Survey Version
43	RECURRING	☐	CRMT_MKTCA_CPG_RECURRING	CRM_MKTCA_CPG_RECURRING	CHAR	1	0	Indicator Recurring Campaign for Camp. Automation
44	CAMP_PERIOD	☐	CRMT_MKTCA_PERIOD	CRM_MKTCA_PERIOD	CHAR	30	0	Period for Campaign
45	N_CAMP_PERIODS	☐	CRMT_MKTCA_NUMBER_PERIODS	CRM_MKTCA_NUMBER_PERIODS	INT4	10	0	No. of Processing Periods
46	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
47	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
48	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
49	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
50	BP_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
51	BP_NODE	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
52	TARGETGRP_GUID	☐	SMOBWTGID	SMOBWGUID	CHAR	32	0	CRM Marketing: Target Group ID
53	ACTION_PROFILE	☐	PPFDCNTXT	PPFDCNTXT	CHAR	30	0	PPF: Name of Action Profile	*
54	CAMP_LINK_EXTID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
55	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
56	TERR_PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
57	TERR_PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
58	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
59	CPT_TYPE	☐	CRMT_MKTCA_CPT_TYPE	CRM_MKTCA_CPT_TYPE	CHAR	2	0	Type of Campaign Element Used
60	APO_ELEM_EXTID	☐	CRM_MKTPL_APO_ID	CHAR22	CHAR	22	0	APO Integration: Campaign ID in APO
61	APO_LOGSYS	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
62	R3_LOGSYS	☐	CRM_MKTPL_R3_RFCDEST	RFCDEST	CHAR	32	0	Marketing Planning: Logical System for ERP Integration	*
63	PARTNER01_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
64	PARTNER02_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
65	PARTNER03_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
66	PARTNER04_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
67	PARTNER05_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
68	PARTNER06_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
69	FILE_EXPORT_FORM	☐	CRMT_IM_EXPORT_FORM	TDSFNAME	CHAR	30	0	File Export Form	*
70	INACTIVE	☐	CRMT_MKTPL_INACTIVE	CHAR1	CHAR	1	0	Inactive Marketing Project
71	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
72	DISTMETHOD	☐	CRM_MKTPL_DISTMETHOD	CRM_MKTPL_DISTMETHOD	CHAR	10	0	Distribution Method for Coupon
73	EXP_DATE	☐	CRM_MKTPL_EXP_DATE	CRM_MKTPL_EXP_DATE	DATS	8	0	Expiration Date for Coupon
74	OFRCODE	☐	CRM_MKTPL_OFRCODE	CRM_MKTPL_OFRCODE	CHAR	16	0	Coupon Code
75	CLEARING_HOUSE	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
76	FCO_COUNTRY	☐	CRM_MKTPL_FCO_COUNTRY	LAND1	CHAR	3	0	Country of the Family Code for a Coupon	*
77	FAMCODE	☐	CRM_MKTPL_FAMCODE	CRM_MKTPL_FAMCODE	CHAR	4	0	Family Code for Coupon
78	CHECK_DIGIT	☐	CRM_MKTPL_CHECK_DIGIT	CRM_MKTPL_CHECK_DIGIT	CHAR	1	0	Check Digit of Coupon Code for Coupon
79	VALCODE	☐	CRM_MKTPL_VALCODE	CRM_MKTPL_VALCODE	CHAR	3	0	Value Code for Coupon
80	MANUFACTCODE	☐	CRM_MKTPL_MANUCODE	CRM_MKTPL_MANUCODE	CHAR	12	0	Manufacturer Code for Coupon
81	BARCODE_TYPE	☐	CRM_MKTPL_BARCODE_TYPE	CRM_MKTPL_BARCODE_TYPE	CHAR	20	0	Barcode Type for Coupon
82	SAVE_COUPON_IND	☐	CRM_MKTPL_SAVE_COUPON_IND	CRM_BOOLEAN	CHAR	1	0	Save Coupon Indicator
83	RETAIL_SAVE_IND	☐	CRM_MKTPL_RETAILER_SAVE_IND	CRM_BOOLEAN	CHAR	1	0	Sorted coupons by retailer
84	DATE_RANGE_ST01	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
85	DATE_RANGE_ST02	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
86	DATE_RANGE_ST03	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
87	DATE_RANGE_ST04	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
88	DATE_RANGE_ST05	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
89	DATE_RANGE_ST06	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
90	DATE_RANGE_ST07	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
91	DATE_RANGE_ST08	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
92	DATE_RANGE_ST09	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
93	DATE_RANGE_ST10	☐	CRM_MKTPL_DATE_FROM	DATUM	DATS	8	0	From Date (Search)
94	DATE_RANGE_END01	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
95	DATE_RANGE_END02	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
96	DATE_RANGE_END03	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
97	DATE_RANGE_END04	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
98	DATE_RANGE_END05	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
99	DATE_RANGE_END06	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
100	DATE_RANGE_END07	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
101	DATE_RANGE_END08	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
102	DATE_RANGE_END09	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
103	DATE_RANGE_END10	☐	CRM_MKTPL_DATE_TO	DATUM	DATS	8	0	To Date (Search)
104	MDF_PROGRAM_ID	☐	CRM_MKTPL_MDF_PROGRAM	CGPL_EXTID	CHAR	24	0	Program Identification
105	ADI_FLAG	☐	CRM_MKTPL_ADI	CRM_MKTPL_ADI	CHAR	1	0	Abnormal Demand Indicator
106	REF_TYPE	☐	CRM_MKTPL_REF_TYPE	CRM_MKTPL_REF_TYPE_DOM	CHAR	4	0	Usage Type
107	ENROLLMENT_REQ	☐	CRM_MKTPL_ENR_ENROLLMENT_REQ	XFELD	CHAR	1	0	Indicator, that enrollment is required
108	AGREEMENT_GUID	☐	CGPL_GUID32	SYSUUID_C	CHAR	32	0	Project Planning: 32 Character GUID for Projects and Tasks
109	.INCLUDE	☐				0	0
110	.INCLUDE	☐				0	0
111	.INCLUDE	☐				0	0
112	PPG_STATUS	☐	CRMT_PPG_STATUS	CRM_PPG_STATUS	CHAR	1	0	PPG Status
113	LOY_FLAG	☐	CRM_MKTPL_LOY_REQ	XFELD	CHAR	1	0	Loyalty Scenario
114	LOY_PGM_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
115	LOY_CPG_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
116	LOY_RRG_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
117	CCM_CCPG_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
118	CCM_CCPG_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
119	CCM_CHPART	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
120	CCM_CORP_CHPART	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
121	PLANNING_MODE	☐	CRM_MKTPL_PLANNING_MODE	CRM_MKTPL_PLANNING_MODE	CHAR	4	0	Planning Mode

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A