SAP ABAP Table CRMC_MKTPL_SETTI (User Settings for CRM Event Calendar)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-CAL (Application Component) Marketing Calendar
     ⤷ CRM_MKTPL_CALENDAR (Package) Marketing Planner calendar

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_MKTPL_SETTI	Table Relationship Diagram
Short Description	User Settings for CRM Event Calendar

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	USERS	☑	SYUNAME	SYCHAR12	CHAR	12	0	User Name
3	QUERY	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
4	QUERY_PORTAL	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
5	QUERY_REL_TPM	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
6	QUERY_REL_CONS	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
7	QUERY_REL_TPM_P	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
8	QUERY_REL_CONS_P	☐	CRM_MKTPL_QUERYID	CRM_MKTPL_QUERYID	CHAR	35	0	Query ID
9	QUERY_REL_POPUP	☐	CRM_MKTPL_FLG_QUERY_POPUP	CRM_MKTPL_FLG_QUERY_POPUP	CHAR	1	0	Send popup to enter search field values for related objects
10	HIERARCHY	☐	CRM_MKTPL_HIERARCHY	CRM_MKTPL_HIERARCHY	CHAR	35	0	Hierarchical View	CRMC_MKTPL_VIEW
11	PLANNED_PERIOD	☐	CRM_MKTPL_PLANNING_PERIOD	CRM_MKTPL_PLANNING_PERIOD	CHAR	3	0	Planning Period
12	FLG_GRAPHIC_VIEW	☐	CRM_MKTPL_FLG_GRAPHIC_VIEW	CRM_MKTPL_FLG_GRAPHIC_VIEW	CHAR	1	0	Indicator: Selection of Graphical Display
13	FLG_QUERY_DETAIL	☐	CRM_MKTPL_FLG_QUERY_DETAIL	CRM_MKTPL_FLG_QUERY_DETAIL	CHAR	1	0	Indicator: Query Detail Visible
14	FLG_INFO_STATUS	☐	CRM_MKTPL_FLG_INFO_STATUS	CRM_MKTPL_FLG_INFO_STATUS	CHAR	1	0	Indicator: Visibility of Promotion Status in the Bar Context
15	FLG_INFO_TYPE	☐	CRM_MKTPL_FLG_INFO_TYPE	CRM_MKTPL_FLG_INFO_TYPE	CHAR	1	0	Indicator: Promotion Category Visible in Bar Context
16	FLG_INFO_TITLE	☐	CRM_MKTPL_FLG_INFO_TITLE	CRM_MKTPL_FLG_INFO_TITLE	CHAR	1	0	Indicator: Promotion Title Visible in Bar Context
17	FLG_STATUS_VIEW	☐	CRM_MKTPL_FLG_STATUS_VIEW	CRM_MKTPL_FLG_STATUS_VIEW	CHAR	1	0	Indicator: Calendar Color Selection Status
18	BAR_PROFILE_ID	☐	CRM_MKTPL_BAR_PROFILE_ID	CRM_MKTPL_BAR_PROFILE_ID	CHAR	4	0	ID for Graphic Profile	CRMC_MKTPL_TBCG
19	FLG_FIXED_DATE	☐	CRM_MKTPL_CLDR_FLG_FIXED_DATE	CRM_MKTPL_FLAG	CHAR	1	0	Ind.: Fixed Date for Time Axis for CRM Marketing Calendar
20	START_DATE	☐	CRMS_MKTPL_BAR_START_DATE	DATE	DATS	8	0	Start Date on the Time Axis of the Calendar
21	END_DATE	☐	CRMS_MKTPL_BAR_END_DATE	DATE	DATS	8	0	End Date on the Time Axis of the Marketing Calendar
22	FLG_REL_DATE	☐	CRM_MKTPL_CLDR_FLG_REL_DATE	CRM_MKTPL_FLAG	CHAR	1	0	Ind.: Relative Date for Time Axis for CRM Mkt. Calendar
23	WEEKS_BEFORE	☐	CRM_MKTPL_CLDR_WEEKS_BEFORE		INT1	3	0	CRM Mkt. Cal.: No. of Weeks to Time Axis Before Current Date
24	WEEKS_AFTER	☐	CRM_MKTPL_CLDR_WEEKS_AFTER		INT1	3	0	CRM Marketing Calendar: Weeks to Time Axis by Current Date
25	FLG_AUTO_DATE	☐	CRM_MKTPL_CLDR_FLG_AUTO_DATE	CRM_MKTPL_FLAG	CHAR	1	0	Ind.: Automatic Date for Time Axis on the CRM Mkt. Calendar
26	FLGFIRSTDATEACT	☐	CRM_MKTPL_CLDR_FLGFIRSTDATEACT	CRM_MKTPL_FLAG	CHAR	1	0	Ind.: First Date in Time Axis for Mkt. Cal. is Active
27	FLGFIRSTDATEANY	☐	CRM_MKTPL_CLDR_FLGFIRSTDATEANY	CRM_MKTPL_FLAG	CHAR	1	0	Ind.: First Preferred Date of Time Axis from CRM Mkt. Cal.
28	FIRST_DATE	☐	CRM_MKTPL_CLDR_ANY_FIRST_DATE	DATUM	DATS	8	0	Preferred First Visible Date Time Axis CRM Event Calendar
29	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
30	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
31	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
32	SEARCH_MAXHITS	☐	CRM_MKTPL_CLDR_SEARCH_MAXHITS	INT4	INT4	10	0	Maximum Number of Search Hits for Marketing Calendar
33	FLG_SPLIT_CAL	☐	CRMT_MKTCAL_SPLITCAL	CRMT_MKTCAL_BOOL_VALUE	CHAR	1	0	Split marketing calendar enabled
34	FLG_TIME_FIELDS	☐	CRMT_MKTCAL_TIMEFIELDS	CRMT_MKTCAL_BOOL_VALUE	CHAR	1	0	Display timefields in Marketing Calendar
35	HEIGHT	☐	CRMT_MKTCAL_HEIGHT		INT4	10	0	Height of marketing calendar applet (in pixel)
36	FISCAL_PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
37	FACTORY_CALENDAR	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
38	HOLIDAY_OPTION	☐	CRMT_HOLIDAY_OPTION		CHAR	4	0	Holiday Options
39	COLOR_OPTION	☐	CRM_MKTPL_COLORID	CRM_MKTPL_COLORID	NUMC	3	0	Color ID
40	BASE_CURR	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_MKTPL_SETTI	BAR_PROFILE_ID	CRMC_MKTPL_TBCG	BAR_PROFILE_ID	REF	1	CN
2	CRMC_MKTPL_SETTI	HIERARCHY	CRMC_MKTPL_VIEW	HIERARCHY	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	300