SAP Marketing Calendar Tables
Are you looking for the right table related to SAP Marketing Calendar Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Marketing Calendar (CRM-MKT-MPL-CAL) module.
Top 10 tables in Marketing Calendar
| Table | Description |
|---|---|
| CRMC_MCAL_FVGRP | Form View Attributes / KPI Group |
| CRM_MKTPL_CAL_LS | Text Table: Field Settings for Table View |
| CRMC_MCAL_SPLIT | Maintain the Option for Split Search |
| CRMC_MKTCLDR_ATS | Selection of calendar attributes |
| CRMC_MKTPL_SC | CAL: Query Search Criteria |
| CRMC_MCAL_TPDF | Customizing : Allowed Time Period Definition |
| CRMC_MCAL_ADR_SH | Customizing table with the shape ids |
| CRMC_MCAL_STRU | Customizing : Define Structures |
| CRMC_MCAL_KPI | Marketing calendar: KPI look up table |
| CRMC_MKTPL_TEXT | Define bar and tooltip text codes |
List of tables in Marketing Calendar
| Table | Description |
|---|---|
| CRMC_MCAL_FVGRP | Form View Attributes / KPI Group |
| CRM_MKTPL_CAL_LS | Text Table: Field Settings for Table View |
| CRMC_MCAL_SPLIT | Maintain the Option for Split Search |
| CRMC_MKTCLDR_ATS | Selection of calendar attributes |
| CRMC_MKTPL_SC | CAL: Query Search Criteria |
| CRMC_MCAL_TPDF | Customizing : Allowed Time Period Definition |
| CRMC_MCAL_ADR_SH | Customizing table with the shape ids |
| CRMC_MCAL_STRU | Customizing : Define Structures |
| CRMC_MCAL_KPI | Marketing calendar: KPI look up table |
| CRMC_MKTPL_TEXT | Define bar and tooltip text codes |
| CRMC_MCAL_CLATTR | Table for other color attributes. |
| CRMC_MCAL_FVG | Define Form View Attribute Group ID |
| CRMC_MCAL_CT_TS | TimeScale Combinations |
| CRMC_MKTPL_CASC | CAL: Assignment of search criteria to Campaign Class |
| CRMC_MCAL_COLORT | Colors |
| CRMC_MCAL_TEMP | Define Template Library Options |
| CRMC_MCAL_SPLITT | Text Table : Split Search Option. |
| CRMC_MKTPL_STATL | Assignment Object Status to Layer of Graphic Profile |
| CRMC_MKTPL_ATT | Customizing table for Marketing Project Attributes |
| CRMC_MCAL_CLGRP | Customizing : Cluster View Grouping Definition |
| CRMC_MCAL_RO_OBJ | Role Customization: Objects allowed for a Role |
| CRMC_MKTPL_COLOR | Color Manintained in Mkt Calendar |
| CRMC_MCAL_ALLTP | Maintain Filter Tiles to Object Category Relations |
| CRMC_MCAL_ROST | Role Customizing : Default Settings for a Role |
| CRMC_MKTCLDR_BIM | BI Mapping Rules for Marketing Calendar |
| CRMC_MKTPL_VCOL | Column Description for Calendar Views |
| CRMD_MKTPL_QUERY | CAL: Queries |
| CRMC_MCAL_STATUS | Customizing: Status for color Profile |
| CRMC_MCAL_TS | Customizing table for Trade Spends |
| CRMC_MCAL_RO_KPI | Role Customizing: KPIs allowed for a role |
| CRMC_MCAL_RANGE | Customizing: Ranges for KPI values |
| CRMC_MCAL_CLPROF | Customizing: Color Profile |
| CRMC_MCAL_RO_SPL | Maintain Allowed Split Search DDLB options |
| CRMC_MCAL_RO_TTL | Template Library Option For a Role |
| CRMC_MCAL_TITLE | Role Customizing : Calendar Title for a Role |
| CRMC_MKTPL_KPIHT | Key Figure Grouping Text Table |
| CRMC_MKTPL_RANGE | Customizing of Ranges for KPI values |
| CRMC_MKTPL_RNG_T | Range Text |
| CRMC_MKTPL_VIEWT | Text Table: Hierarchy of Plan Views |
| CRMC_MCAL_CLUS | Customizing : Cluster Definition |
| CRMC_MCAL_TYPE | Customizing: Type for color Profile |
| CRMC_MKTPL_SETTI | User Settings for CRM Event Calendar |
| CRMC_MKTPL_TBCGT | Text Table: Graphical Profile of the CRM Event Calendar |
| CRMC_MKTPL_SP_T | Show Related Project Text Table |
| CRMC_MKTPL_RAN_T | To be deleted |
| CRMC_MCAL_GC_ET | Global Calendar Event texts |
| CRMC_MKTCLR_KPI | View Customizing: Key Figures in calendar |
| CRMC_MKTCLDR_NAV | Navigation information for TPM bars in calendar |
| CRMD_MKTPL_ATT_T | Text table for Marketing Project Attributes |
| CRMC_MCAL_RO_ACT | Role Navigation Actions for Copy , Create , Split , Template |
| CRMC_MCAL_FVKPI | Form View KPIs |
| CRMC_MCAL_DEFST | Define Height of Gantt Calendar and Filter Search Area |
| CRMC_MCAL_CLUS_T | Customizing : Language Dependent Cluster Texts |
| CRM_MKTPL_CAL_LV | Field Settings for Table View in Event Calendar |
| CRMC_MKTPL_COL_T | Text Table Color Manintained in Mkt Calendar |
| CRMC_MCAL_PER_TL | Personalization : Filter Search Tiles and their Order |
| CRMC_MCAL_GC_E | Global Calendar Events definiton |
| CRMC_MCAL_TILE_T | Customizing : Language dependent Filter Search Tiles texts |
| CRMC_MKTPL_SPLIT | Customizing table for Split Calendar Options |
| CRMC_MKTCLDR_RCS | Selection of allowed Row Context attributes |
| CRMC_MCAL_RO_CCE | Role Customization : Calendar Control Elements for a Role |
| CRMC_MCAL_STRU_T | Customizing : Language dependent Structure Texts |
| CRMC_MCAL_STRUC | Customizing : Structure Hierarchy Definition |
| CRMC_MCAL_TITL_T | Customizing : Language dependent Title Texts |
| CRMC_MCAL_GRP_T | Customizing : Language dependent Grouping Rule Texts |
| CRMC_MCAL_ATG | Define Attribute Group Id |
| CRMC_MCAL_RNG_T | Customizing: Ranges for KPI values with texts |
| CRMC_MCAL_CT_OBJ | Customizing : Assign Objectives to Campaign Types |
| CRMC_MCAL_PERS | Personalization : Basic Settings |
| CRMC_MCAL_RO_ST | Role Customization : Structures Allowed for a Role |
| CRMC_MCAL_PER_AS | Personalization : Active Show options |
| CRMC_MCAL_RO_ADR | Role Customization : Additional Date Ranges for a Role |
| CRMC_MCAL_AB | Customizing table for additional buttons |
| CRMC_MKTPL_VCOLT | Text Table: Column Description for Calendar Views |
| CRMC_MCAL_GC | Global Calendar Definition for Marketing Calendar |
| CRMC_MKTCLR_KPIT | Text Table: Text for KPI displayed |
| CRMD_MKTPL_QUVAL | CAL: Query Search Field Values |
| CRMC_MKTPL_TRANG | Additional Timeframes |
| CRMC_MCAL_AB_T | Text table for additional buttons customizing |
| CRMC_MCAL_KPI_BI | KPI Customizing: BI Reports |
| CRMC_MKTPL_SCID | CAL: Query Search Criteria ID |
| CRMC_MCAL_RO_CT | Assignment of category and type to role |
| CRMC_MCAL_RO_FV | Maintain Form View options for the Role |
| CRMC_MCAL_GRPRL | Grouping Rule |
| CRMC_MCAL_COLOR | Colors |
| CRMC_MCAL_RO_SO | Allowed Sub Objects For a Role |
| CRMC_MCAL_ATTKPI | Customizing: Appending KPI values to tooltip/bar |
| CRMC_PCLDR_TRACE | Table for Controlling Trace Functionality in Calendar |
| CRMC_MCAL_GCT | Global Calendar Definition for Marketing Calendar (Texts) |
| CRMC_MCAL_TST | Customizing text table for Trade spends |
| CRMC_MCAL_STR_AT | Customizing : Filter By Attributes available to Structure |
| CRMC_MCAL_GRP | Customizing : Grouping Rule Definition |
| CRMC_MKTPL_SCIDT | CAL: Query Search Criteria ID Description |
| CRMC_MCAL_KPI_RP | KPI Customizing: BI Reports |
| CRMC_MCAL_TEMP_T | Define template Library Options |
| CRMC_MCAL_CLVALU | Table for other color attributes. |
| CRMC_MCAL_RO_TIL | Role Customization : Tiles Allowed for a Role |
| CRMC_MCAL_FD_FW | Maintain First Day of Week , First Week of the Year Options |
| CRMC_MCAL_RO_AB | Role customizing of additional buttons |
| CRMC_MCAL_CCE | Standard : Calendar Control Elements Definition |
| CRMC_MKTPL_KPI_H | Customizing table for KPI hierarchical views |
| CRMC_MKTCAL_CONF | Customizing Values for Marketing Calendar Applet in CRM |
| CRMC_MCAL_TILES | Customizing : Filter Search Tiles Definition |
| CRMC_MCAL_TPDF_T | Customizing : Language dependent Allowed Time Period Texts |
| CRMC_MKTPL_TYPL | Assignment of Campaign Types to Graphic Profile Layer |
| CRMC_MCAL_VIEW | Hierarchy of Plan Views |
| CRMC_MCAL_RO_SHO | Marketin calendar : Maintain Show DDLB Options for a Role |
| CRMC_MKTCLDR_KPI | View Customizing: Key Figures in calendar |
| CRMC_MCAL_TEXTS | Customizing : Attribute for Bar Text and Bar Tooltip Text |
| CRMC_MKTPL_VIEW | Hierarchy of Plan Views |
| CRMC_MKTPL_ST | CAL: Search Tables for Calendar Query |
| CRMC_MCAL_KPI_T | Integrated Marketing Calendar: KPI Text Table |
| CRMC_MCAL_TT_ATT | Customizing : Calendar Bar Tooltip Attributes |
| CRMC_MCAL_CCE_T | Standard : Lang dependent Calendar Control Element Texts |
| CRMC_MCAL_BIM | Customizing: BI mapping rules for marketing calendar |
| CRMC_MCAL_CLUSTR | Customizing: Assign Cluster to Mkt Proj Type(Campaign Type ) |
| CRMC_MCAL_PER_DR | Personalization : Additional Date Ranges |
| CRMC_MCAL_ROKPIT | To be deleted - OBSOLETE!!! |
| CRMC_MKTPL_TBCG | Graphical Profile for the CRM Event Calendar |
| CRMC_MCAL_BIMS | Customizing: BI mapping rules for marketing calendar |
| CRMC_MCAL_CLPROT | Customizing: Color Profile Text Table |
| CRMC_MCAL_SHAP_T | Standard : Lang dependent Shape descriptions |
| CRMC_MCAL_RO_CLU | Role Customization : Clusters Allowed for a Role |