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

Dictionary Type: Table
Description: User Settings for CRM Event Calendar




ABAP Code to SELECT data from CRMC_MKTPL_SETTI
Related tables to CRMC_MKTPL_SETTI
Access table CRMC_MKTPL_SETTI




Table field list including key, data, relationships and ABAP select examples

CRMC_MKTPL_SETTI is a standard SAP Table which is used to store User Settings for CRM Event Calendar data and is available within R/3 SAP systems depending on the version and release level.

The CRMC_MKTPL_SETTI table consists of various fields, each holding specific information or linking keys about User Settings for CRM Event Calendar data available in SAP. These include USERS (User Name), QUERY (CAL: QueryID), QUERY_PORTAL (CAL: QueryID), QUERY_REL_TPM (CAL: QueryID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP CRMC_MKTPL_SETTI table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
USERSUser Name SYUNAMECHAR12SYCHAR12
QUERYCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_PORTALCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_REL_TPMCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_REL_CONSCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_REL_TPM_PCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_REL_CONS_PCAL: QueryID CRM_MKTPL_QUERYIDCHAR35CRM_MKTPL_QUERYID
QUERY_REL_POPUPSend popup to enter search field values for related objects CRM_MKTPL_FLG_QUERY_POPUPCHAR1CRM_MKTPL_FLG_QUERY_POPUP
HIERARCHYHierarchical View CRM_MKTPL_HIERARCHYCHAR35CRMC_MKTPL_VIEWCRM_MKTPL_HIERARCHY
PLANNED_PERIODPlanning Period CRM_MKTPL_PLANNING_PERIODCHAR3CRM_MKTPL_PLANNING_PERIOD
FLG_GRAPHIC_VIEWIndicator: Graphical Display Selected CRM_MKTPL_FLG_GRAPHIC_VIEWCHAR1CRM_MKTPL_FLG_GRAPHIC_VIEW
FLG_QUERY_DETAILIndicator: Query Detail Visible CRM_MKTPL_FLG_QUERY_DETAILCHAR1CRM_MKTPL_FLG_QUERY_DETAIL
FLG_INFO_STATUSIndicator: Promotion Status Visible in Bar Context CRM_MKTPL_FLG_INFO_STATUSCHAR1CRM_MKTPL_FLG_INFO_STATUS
FLG_INFO_TYPEIndicator: Promotion Category Visible in Bar Context CRM_MKTPL_FLG_INFO_TYPECHAR1CRM_MKTPL_FLG_INFO_TYPE
FLG_INFO_TITLEIndicator: Promotion Title Visible in Bar Context CRM_MKTPL_FLG_INFO_TITLECHAR1CRM_MKTPL_FLG_INFO_TITLE
FLG_STATUS_VIEWIndicator: Calendar Color Selection Status CRM_MKTPL_FLG_STATUS_VIEWCHAR1CRM_MKTPL_FLG_STATUS_VIEW
BAR_PROFILE_IDID for Graphic Profile CRM_MKTPL_BAR_PROFILE_IDCHAR4CRMC_MKTPL_TBCGCRM_MKTPL_BAR_PROFILE_ID
FLG_FIXED_DATEFlag: Fixed Date for Time Axis for CRM Event Calendar CRM_MKTPL_CLDR_FLG_FIXED_DATECHAR1CRM_MKTPL_FLAG
START_DATEStart Date Time Axis from Calendar CRMS_MKTPL_BAR_START_DATEDATS8DATE
END_DATEEnd Date Time Axis for Calendar CRMS_MKTPL_BAR_END_DATEDATS8DATE
FLG_REL_DATEFlag: Relative Date for Time Axis for CRM Event Calendar CRM_MKTPL_CLDR_FLG_REL_DATECHAR1CRM_MKTPL_FLAG
WEEKS_BEFORECRM Mkt. Cal.: No. of Weeks to Time Axis Before Current Date CRM_MKTPL_CLDR_WEEKS_BEFOREINT13
WEEKS_AFTERCRM Marketing Calendar: Weeks to Time Axis by Current Date CRM_MKTPL_CLDR_WEEKS_AFTERINT13
FLG_AUTO_DATEFlag: Automatic Date for Time Axis for CRM Event Calendar CRM_MKTPL_CLDR_FLG_AUTO_DATECHAR1CRM_MKTPL_FLAG
FLGFIRSTDATEACTFlag: First Date in Time Axis for CRM Event Cal. is Active CRM_MKTPL_CLDR_FLGFIRSTDATEACTCHAR1CRM_MKTPL_FLAG
FLGFIRSTDATEANYFlag: First Preferred Date of Time Axis from CRM Event Cal. CRM_MKTPL_CLDR_FLGFIRSTDATEANYCHAR1CRM_MKTPL_FLAG
FIRST_DATEPreferred First Visible Date Time Axis CRM Event Calendar CRM_MKTPL_CLDR_ANY_FIRST_DATEDATS8DATUM
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SEARCH_MAXHITSMaximum Number of Search Hits for Marketing Calendar CRM_MKTPL_CLDR_SEARCH_MAXHITSINT410INT4

Key field Non-key field



How do I retrieve data from SAP table CRMC_MKTPL_SETTI using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMC_MKTPL_SETTI to SELECT all data from the table
DATA: WA_CRMC_MKTPL_SETTI TYPE CRMC_MKTPL_SETTI.

SELECT SINGLE *
FROM CRMC_MKTPL_SETTI
INTO CORRESPONDING FIELDS OF WA_CRMC_MKTPL_SETTI
WHERE...

How to access SAP table CRMC_MKTPL_SETTI

Within an ECC or HANA version of SAP you can also view further information about CRMC_MKTPL_SETTI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!