The CRMC_MCAL_ROST table in SAP ERP or S/4HANA stores Role Customizing : Default Settings for a Role data. There are total 30 fields in CRMC_MCAL_ROST table. The Role Customizing : Default Settings for a Role table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_MCAL_ROST table. It is in Marketing Calendar Customizing (CRM_MCAL_CUSTOMIZING) ABAP package and is part of the Marketing Calendar (CRM-MKT-MPL-CAL) module.
SAP CRMC_MCAL_ROST Table Fields
Following is the list of fields that are available in SAP CRMC_MCAL_ROST table. The primary key fields of the table are MANDT (Client), ROLE_ID (Business Role).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| ROLE_ID | Business Role | CRMT_UI_PROFILE | CRMC_UI_PROFILE | CHAR (12) |
| TITLE_ID | Calendar Title ID | CRM_MCAL_TITLE_ID | CRMC_MCAL_TITLE | CHAR (15) |
| FISCAL_YR_VAR_ID | Fiscal Year Variant | PERIV | T009 | CHAR (2) |
| COLOR_PROFILE_ID | ID for Graphic Profile | CRM_MKTPL_BAR_PROFILE_ID | CRMC_MCAL_CLPROF | CHAR (4) |
| FACTORY_CLDR_ID | Factory Calendar | WFCID | TFACD | CHAR (2) |
| GLOBAL_CLDR_ID | Global Calendar ID | CRM_MCAL_GC_ID | CRMC_MCAL_GC | CHAR (3) |
| HOLIDAY_COLOR_ID | Color ID | CRM_MCAL_COLOR_ID | CRMC_MCAL_COLOR | CHAR (10) |
| DEF_CORE_STR_ID | Main Structure ID | CRM_MCAL_CORE_STRUCTURE_ID | CRMC_MCAL_STRU | CHAR (15) |
| DEF_SPLIT_STR_ID | Split Calendar Structure ID | CRM_MCAL_SPLIT_STRUCTURE_ID | CRMC_MCAL_STRU | CHAR (15) |
| ALLOW_SRCH_OPT | Allowed Search Options | CRM_MCAL_ALLOWED_SRCH_OPTIONS | CHAR (40) | |
| DEF_SEARCH_OPT | Default Search Option | CRM_MCAL_DEF_SRCH_OPTION | CHAR (25) | |
| DEFAULT_TIMESCAL | Default Timescale | CRM_MCAL_TIMESCALE | CHAR (15) | |
| HARD_TP_SETTING | Time Period Restriction for Searches | CRM_MCAL_HARD_TIMEPERIOD_ID | CRMC_MCAL_TPDF | CHAR (15) |
| SOFT_TP_SETTING | Default Time Period for Blank Searches | CRM_MCAL_SOFT_TIMEPERIOD_ID | CRMC_MCAL_TPDF | CHAR (15) |
| DISPLAY_OFFSET | Offset Period Displayed in the Calendar Area | CRM_MCAL_DISPLAY_OFFSET_PERIOD | CRMC_MCAL_TPDF | CHAR (15) |
| TIME_HIER_LEVEL | Determines How the ‘Time’ Filter Search Tile is Grouped | CRM_MCAL_TIME_TILE_HIER_LEVEL | NUMC (1) | |
| MKT_PLAN_OPTION | Option in Marketing Plan Tile | CRM_MCAL_MKT_PLAN_TILE_OPTION | NUMC (1) | |
| CT_EXP_LEVEL | Default Expansion Level | CRM_MCAL_EXPANSION_LEVEL | CHAR (3) | |
| SHOW_GLOBAL_CAL | Indicator: Show Global Calendar | CRM_MCAL_SHOW_GLOBAL_CALENDAR | CHAR (1) | |
| IS_DISP_CALENDAR | Sets Integrated Marketing Calendar to Read Only Mode | CRM_MCAL_IS_READ_ONLY | CHAR (1) | |
| IS_USE_CLUSTERS | Allows Use of Marketing Project Clusters | CRM_MCAL_USE_CLUSTERS | CHAR (1) | |
| IS_SRCH_SPLIT | Allows Search in Split Calendar | CRM_MCAL_SEARCH_SPLIT_ALL | CHAR (1) | |
| IS_SYNC_SCROLL | Allows Synchronized Scrolling | CRM_MCAL_SYNC_SCROLLING | CHAR (1) | |
| ALLOW_LIST_DISP | Allows List Display | CRM_MCAL_ALLOW_LIST_DISPLAY | CHAR (1) | |
| BI_RFC_DEST | BW Destination | CRM_MCAL_RFC_DEST | CRMC_MCAL_KPI_BI | CHAR (32) |
| REPORT_ID | BW Report | CRM_MCAL_REPORT_ID | CHAR (42) | |
| FV_ATTR_GRPID | Form View Attribute Group ID | CRM_MCAL_FV_ATTR_GROUP_ID | CRMC_MCAL_FVG | CHAR (15) |
| PRODUCT_HIER | Category Hierarchy ID | COMT_HIERARCHY_ID | CHAR (10) | |
| REPORT_ID_IMP | BW Report | CRM_MCAL_REPORT_ID | CHAR (42) |
