SAP Marketing Planner Tables

Are you looking for the right table related to SAP Marketing Planner 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 Planner (CRM-MKT-MPL) module.

Top 10 tables in Marketing Planner

TableDescription
CRMC_MKTPL_AL02TAllocation Rules
CRMD_MKTCCM_CPTGCCM: Partner Campaign Generation Target Group
CRMC_MKTPL_MSPCRM Customiz. Market. Plan.: Marketing Spends
CRMC_MKTPL_CPRITCRM Customizing Marketing Planning: Priority Texts
CRMC_MKTPL_CTYPTCRM Customizing Marketing Planning: Campaign Types Texts
CRMC_MKTPL_DISCCRM Marketing: Discount method table
CRMC_MKTPL_CRULRules for Copy Control
CRMC_MKTPL_DFPPGDefaulting Planning Profile Group Mapping Table
CRMC_MKTPL_COS1CRM Marketing: Spend method table
CRMC_MKTPL_DMAPAssignment of Rules for Default Control

List of tables in Marketing Planner

TableDescription
CRMC_MKTPL_AL02TAllocation Rules
CRMD_MKTCCM_CPTGCCM: Partner Campaign Generation Target Group
CRMC_MKTPL_MSPCRM Customiz. Market. Plan.: Marketing Spends
CRMC_MKTPL_CPRITCRM Customizing Marketing Planning: Priority Texts
CRMC_MKTPL_CTYPTCRM Customizing Marketing Planning: Campaign Types Texts
CRMC_MKTPL_DISCCRM Marketing: Discount method table
CRMC_MKTPL_CRULRules for Copy Control
CRMC_MKTPL_DFPPGDefaulting Planning Profile Group Mapping Table
CRMC_MKTPL_COS1CRM Marketing: Spend method table
CRMC_MKTPL_DMAPAssignment of Rules for Default Control
CRMC_MKTPL_BCO_TBarcode type texts for coupon
CRMD_MKTPL_PCATMarketing Planning Assignment of Product Category
CRMC_MKTPL_FIXTZMKTPL: Define Fix Conversion Timezone for Object Class
CRMC_MKTPL_CTYTPCRM Marketing ToDo for campaign type and involved parties
CRMC_OBJ_TPMILCase Management: Interaction Layer Objects
CRMC_MKTPL_CRULTDescriptive Texts for Copy Rules
CRMD_MKTSC_SCN_TScenario Planning: Scenario Text
CRMC_MKTPL_FMPRTCampaign FMI: Integration Profile Texts
CRMC_MKTPL_AGPLCustomizing for planning block in agreements
BDSLOPR27BDS: Attribute Values of Logical Information Objects
CRMD_MKTGS_CIMAPMapping of client-independent fields to comm. structure
CRMD_MKTGS_CCAMetadata table for the Cross-checks
CRMD_MKTCCM_CPMBCCM: Partner Campaign Generation Channel Partner Member
CRMC_MKTPL_VER1CRM Marketing: SEM Versioning - user status
CRMC_MKTPL_SKMSuccess Key Measure - relations
CRMC_TPM_KYFG_MPTPM: Mapping of BI key figures to output structure
CRMD_MKTPL_PURCIPurchasing items
CRM_MKTPL_STRTYPSystem Table for Marketing Structure Types
CRMT_MKT_MRMBW_JMRMBW Jobs
CRMD_MKTPL_TODOTo-Do assignment attributes
CRMD_MKTCCM_CPIOCCM: Partner Campaign Generation Channel Partner iObject
CRMC_MKTPL_CHGPTransaction type for GP controlled communication channel
CRMC_MKTPL_LSTPRCRM Marketing Planner:PPR flag and Listing Procedures
CRM_MKTPL_OBJGRMarketing Planner Object Groups
CRMC_MKTPL_PDCustomizing Table for Partner Determination Procedure Assgnt
CRMC_MKTGS_TGRCRM Marketing: Tier growth rebate
CRMD_MKTPL_AL00Allocation Header
CRMC_MKTPL_GADEFMarketing Planner - Generic Actions Defaults
CRMC_MKTPL_COS5CRM Marketing: related volume table
CRMD_MKTCCM_JOBCCM: batch jobs of collaborative campaign: date, time in UTC
CRMD_MKTPL_RELTYCRM Marketing Planning - Relatnshp Category for Target Group
CRMD_MKTGS_APPChoose application and source structure for listing check
CRMD_MKTPL_OPEROperations in Marketing Programs
CRMD_MKTGS_ARCAdditional archiving information for marketing projects
CRMC_MKTPL_AL00CRM Customizing Marketing Planning: Allocation Application
CRMC_MKTVL_DTYPTDistribution Type Text
CRMC_MKTPL_CPRIOCRM Customizing Marketing Planning: Priority
CRMC_MKTGS_BDIMTCRM Marketing: Base dimension KPI text table
CRMC_MKTPL_DRUL4Attribute Maintenance for Default Control
CRMC_MKTPL_SFT_TForms template customizing text table
CGPL_PLANGRPPROFCustomizing SEM-BPS: Assigning Profiles to Planning Groups
CRMD_MKTCCM_JPARCCM: batch job parameter of collaborative campaign
CRMS_GIL_MKT_MODGENIL Model for MKTPL Trade Spend Component
CRMD_MKTPL_STMIGMarketing projects with migrated settype values
CRMD_MKTPL_CCPCorporate Channel Partner assignment attributes
CRMC_MKTPL_TDCATMarketing To-Do categories
CRMD_MKTPL_GUIDSTemporary table of CGPL guids
CRMC_MKTPL_OBMAPOBSOLETE: Will be deleted (new table is CRMC_MKTPL_CTMAP)
CRMA_MKTPL_CPGNMAPO Integration: Match CRM and generated APO Campaigns
CRMD_MKTPL_TGGRPAssignment of Target Group in Marketing Planner
CRMC_MKTPL_FMPRFCampaign FMI: Integration Profile Settings
CRMC_MKTPL_CMAPAssignment of Rules for Copy Control
CRMC_MKTPL_MSEXPCampaign FMI: Mapping Marketing Spends to Expense Types
CRMC_MKTGS_RATECRM Marketing: Rate type definition for tiers
CRMC_MKTPL_COS2CRM Marketing: cost category to cost type association
CRMC_MKTGS_TGRKFCRM Marketing Tier Growth Rebate KPI planning map. (Fields)
CRMC_MKTPL_FCOCRM Customiz. Market. Plan.: Family Codes Coupon
CRMC_MKTPL_MGR_TMarketing spend group texts for coupon
CRMC_MKTPL_DATEUnique identifier for additional date ranges
CRMC_MKTPL_HIERCustomizing for Marketing Project Hierarchy
CRMC_MKTPL_UPLIFCust. for Siginificant Uplift for TPM
CRMC_PLGRPCUSTcustomizing table customer type / planning profile groups
BDSREPR27BDS: Relationship Attributes
CRMC_MKTGS_RATESContains value indicating if rates are specfied in CRM vs BI
CRMD_MKTGS_FREEGProduct independent free goods
CRMC_MKTPL_PRFIXPrefixes per object type for the auto-naming BAdI
CRMD_MKTPL_SHCUTCRM Marketing Planning - Campaign Code
CRMC_MKTPL_VOLMNDefine where the volume is entered
CRM_MKTPL_UISCNTMarketing User Interface Scenario Description
CRMD_MKTPL_PRCATAssignment of Product Catalog in Marketing Planning
CRMC_MKTPL_VUIATCustomerizing table for the version ui for attr assignment
CRMC_MKTPL_GAFLTMarketing Planner - Generic Actions Filters Text table
BDSCHKO27BDS: Checkout Data for Physical Information Object
CRMC_MKTPL_CHANTCRM Customizing Marketing Planning: Comm Media Texts
CRMC_MKTPL_SFTForms template customizing
CRMC_MKTGS_CALCTCRM Marketing: Calculation Method text table
CRMC_MKTPL_TSFLTActivate trade spend filtering
CRMC_MKTPL_CHPRCRM Customizing Marketing Planning: Channel Priority
CRMC_MKTPL_ACLBSP: Table of Access Classes for Each Screen Structure
CRMC_MKTPL_PROFCRM Customizing of Marketing Planning: Campaign Types
CRMC_TPM_QUERYTPM: Query for access of BI key figures in Promotions
CRMD_MKTPL_OBJCRM Marketing - Persistency table for proxy class
CRMC_MKTPL_OBJTVCRM Customizing Marketing Planning: Objectives
CRMD_MKTPL_COUPCoupon assignment attributes
CRMC_MKTPL_SKM_KSKM - KPI
CRMC_MKTPL_MACCustomizing table for manufacturer codes
CRMC_MKTPL_CTYEXAssign Expense Types and Accrual Profiles to MDF Initiative
CRMC_MKTPL_DRUL1Rule Maintenance for Default Control
CRMC_MKTPL_AL04Allocation: Status of actual quantities
CRMC_MKTPL_QEPOSQuick Entry Trade Spend Position Table
CRM_MKTGS_FLDMAPSearch Structure Field Mapping Customizing
BDSPHPR27BDS: Attributes of Physical Information Objects
CRMD_ENREnrollment Table
CRMC_MKTGS_CDMAPMapping of client-dependent fields to comm. structure
CRMD_MKTPL_ASTSTMKTPL OL: Test Assignment DB Table
CRMD_MKTPL_AL01Allocation Data: Product Assignments
CRMD_MKTPL_GD3PTMarketing Element to be processed for 3rd party
CRMC_MKTPL_GAFL1CRM Marketing - Generic Actions filters definition
CRMC_AGR_DOVCHAgreement - Dimensions to be used for Overlap Check
CRMC_MKTVL_OBTDTAssignment Object Category to Distribution Type
CRM_MKTGS_FSGRPFast Search Field Grouping Customizing
CRMC_MKTPL_COS3CRM Marketing: spend method to cost type association
CRMD_MKTPL_CONCTMarketing Planner: Assignment of Connection to Ext. Applic.
CRMD_FM_SF_INDEXIndex Table of Statistics Upload
CRMC_MKTGS_TIERTCRM Marketing: Tier type definition for tiers
CRMC_MKTPL_BCOCustomizing table for barcode types
BDSLORE27BDS: Outgoing Relationships of Logical Information Objects
CRMC_PLGRPPRODPlanning Profiles / Product Planning Basis Relation
CRMC_MKTPL_CL_PRCRM Customiz. Market. Plann.: Clearing House and Prod. Hier.
CRMD_MKTSC_SCN_HScenario Planning: Scenario Header
CRMC_MKTPL_FMPPDCampaign FMI: Planning Profile Definition for Cost Key Fig.
CRMD_MKTSC_WLWorklist entries
CRMD_MKTSC_FAVFavorite Scenario Sets
CRMD_MKTPL_SPNDMarketing spend assignment attributes
CRMC_MKTSS_PLBCustumizing : Product Planning Basis
CRMD_MKTSC_WKS_TScenario Planning: Scenario Set Texts
CRM_MKTPL_UISCENMarketing User Interface Scenario
CRMD_MKTPLTP_PCGDB table for MKTPL TPM Product Category Assignments
CRMC_MKTPL_APONMAPO Integration: Customizing
CRMC_MKTPL_MAC_TText table for manufacturer codes
CRMD_MKTPL_ENCPCCRM Marketing: Partner Campaign Enrollment Enhancement (CCM)
CRMC_MKTGS_CALCCRM Marketing: Calculation Method definition for tiers
CRMC_MKTPL_DRUL2Structure Maintenance for Default Control
CRMC_MKTGS_RATETCRM Marketing: Rate type definition for tiers
CRMC_MKTPL_PPRPartner Product Selection Types Marketing Planner
CRM_MKTPL_OGRPObject Groups in Marketing Planner
CRMC_MKTPL_COTMKTPL: to link camp. types and objectives to tactics
CRMD_ENR_MEMBERCRM Enrollment Member Table
CRMC_MKTGS_TGRPFCRM Marketing Tier Growth Rebate KPI planning map. (Appl)
CRMC_MKTPL_EXAGEUsage for 3rd Party Tool
CRMC_MKTPL_RT_ACCRM Marketing Planner - Archiving Control residency time
CRMC_MKTPL_BW_MDBW Master Data Online Activation
CRMD_MKTPL_AL03Allocation Data
BDSRE27BDS: Relationship Instances
CRMC_MKTPL_COS4Disc Meth to Spndt Type and Spnd Cat association
CRMC_MKTSS_PLBASCustomizing table for Product Planning Basis - MKT and ACP
CRMC_MKTPL_AL03Allocation Priorities
CRMD_MKTSC_WKS_HScenario Planning: Scenario Set Header
CRMD_MKTCCM_JSUMCCM: summarized results on collaborative campaign batch jobs
BDSPHF27BDS: Files of Physical Information Objects
CRMC_MKTSC_LSTATScenario Planning: Locked Status (Committed Plan)
CRMC_MKTPL_COS5TCRM Marketing: related volume text table
CRMC_MKTPL_PLGRPCRM Customizing Marketing Planning: Planning Groups
CRMC_MKTPL_CTDATAssignment of Date IDs to Marketing Project Types
CRMD_MKTGS_TIERTier assignment table
CRMC_MKTPL_TODOCRM Marketing ToDo
CRMC_MKTSC_BWURLAccess Parameters for BW Reports
CRMC_MKTPL_CHFECAssignment of File Export Variant to Communication Medium
CGPL_PLANGRPTCustomizing SEM-BPS Interface: Planning Group Texts
CRMC_MKTPL_AL00TCRM Customizing Marketing Planning: Allocation Application
CRMD_MKTPL_PARAssignment Partner Set in Marketing Planning
CRMC_MKTPL_DRULTDescriptive Texts for Default Rules
CRMC_AGR_IOVCHAgreement - Statuses to Ignore for Overlap Checks
CRMD_MK_VER_STATStatuses of TPM for a particular version
CRMC_MKTPL_AL02Allocation Rules
CRMT_MKT_MRMBW_AMRMBW: Job Attributes
CRMC_MKTPL_TACTSCRM Customizing of Marketing Planning: Campaign Types
CRMD_MKTPL_FNDPLFund Plan assignment attributes
CRMC_MKTPL_REFTTMarketing - Customizing Table for Reference Type
CRMC_MKTPL_TSPNDAllowed trade spends
CRMC_MKTPL_PD_BWCustomizing Table for Partner Procedure BW Export
CRMC_MKTPL_SKM_ECRM Marketing: Enable Success Key Measures
CRM_MKTPL_APO_STAPO Integration: Site Type Attributes
CRMD_MKTSC_OPTUser options
CRM_MKTPL_TPATTRCRM Marketing Planner: Trade Promotion attributes
CRMD_MKTGS_TMPGeneric template attributes
CRMC_MKTPL_PUMAPPI: Assign Measure to Planning Profile Grp for Budget Check
CRMC_MKTGS_TGRTCRM Marketing: Tier growth rebate text table
CRM_MKTPL_NO_DEFNot Proposed Attributes with Structure
CRMD_MKTPL_CCPGACollaborative Campaign Attributes
CRMC_MKTPL_TSDTCRM Marketing: date range to cost type association
CRM_MKTPL_OBJTYPSystem Table for Marketing Element Types
CRMD_MKTGS_TGRDB table for CRMS_MKTGS_TGR_ATTRIBUTES
MCF_MAP_STATUSMap CRM MCF Campaign status to ERP Promotion status blocked
CRM_MKTGS_FRSFLDDefinition of Fields for Freestyle Search
CRMC_MKTPL_MGRCRM Customiz. Market. Plan.: Marketing Spend Groups
CRMC_MKTPL_VOLKFDefine key figure for volume
CRMC_MKTPL_MSP_TMarketing spend texts for coupon
CRMC_MKT_CUSTCONMarketing Customer Connection Functionality Activation
CRM_MKTGS_ARCTYPGeneric marketing Archiving Types
CRMD_MKTPL_ENREnrollment List
CRMD_MK_VER_DATVERSION DATA TABLE
CRMC_MKTGS_TIERCRM Marketing: Tier type definition for tiers
CRMD_MK_VER_HDRVERSION HEADER TABLE
CRMC_MKTPL_AL04TAllocation: Status of actual quantities
CRMC_MKTPL_ROWPRCustomizing TPM Product view default number of avail. rows
CRMD_MKTSC_SCO_IScenario Planning: Scope Item
CRMD_MKTPL_PURCHPurchasing headers
CRM_MKTPL_PRTTExternal Portal application, descriptions
BDSLOIO27BDS: Instances of Logical Information Objects
CRMC_MKTPL_DATETAdditional date ranges label
CRMC_MKTCCM_PARAParallel Customizing for Collaborative Scenario
CRMD_MKTCCM_JDETCCM: batcj job details (e.g. for partner cpg executions )
CRMC_MKTPL_BI_IOBI InfoObjects corresponding to marketing object types
CRMC_MKTPL_COS1TCRM Marketing: Spend method text table
CRMC_MKTPL_VRSTSystem status customizing for versioning
CRMC_MKTPL_AL03TAllocation Priorities
BDSLOIOT27BDS: Descriptions of Logical Information Objects
CRM_MKTPL_ATTRCRM Marketing Planner: Marketing plan/campaign attributes
CRM_MKTPL_OGRPTText table for crm_mktpl_ogrp
CRMD_MKTGS_PTRProduct Tiered Rebate Database Table
CRMC_MKTPL_TACTTCRM Customizing Marketing Planning: Texts Strategies
TRFCPROFILERFC Destination and Respective Project Profile
CRMC_MKTGS_TSTGRCRM Marketing: Trade spend TGR association
CRMC_MKTPL_GAFLMarketing Planner - Generic Actions Filters
CRMC_MKTPL_AUTHTCRM Customizing Marketing Planning:Authorization Group Texts
CRMC_MKTPL_REFTMarketing - Customizing Table for Reference Type
CRMC_MKTSC_BWActivate SAP BW Update
CRMD_MKTPL_DATEAdditional date ranges for marketing object
CRMC_MKTPL_COS0TCRM Marketing: cost category text table
CRMC_MKTPL_COS0CRM Marketing: cost category table
CRMC_MKTPL_AGRTPCustomizing table for elements copied from AGR to TPM
CRMC_MKTPL_CTYTDCRM Marketing ToDo for campaign type
CRMC_MKTPL_OBJTTCRM Customizing Market Planning: Texts Objective(s)
CRMC_MKTPL_VCAVCCampaign FMI: Value Category to AVC Profile
CRMC_MKTPL_COS6Vol to Spnd Type, Spnd Cat, Spnt Meth association
CRMC_MKTPL_DISTTDistribution method texts for coupon
BDSLORI27BDS: Incoming Relationships of Logical Information Objects
CRMD_MKTPL_DRESValue Distribution for Hierarchy Nodes
CRM_MKTPL_OCLASTText table for crm_mktpl_oclas
CRMC_MKTPL_CTYOBMKTPL: to link camp. type to objectives
CRMC_MKTPL_ETACMCampaign FMI: Assign Accrual Profile to Expense Type
CRMC_MKTPL_CTMAPCampaign Type Object Mapping Table
CRMC_MKTGS_COMPTCRM Marketing: Comparison KPI text table
CRMD_MKTPL_DSELValue Distribution for Hierarchy Nodes
BDSCONT27BDS: Table for Document Contents (Import/Export)
CRMD_MKTPL_OFROffer Code Related Data for Coupon Assignment
CGPL_PLANGRPCustomizing SEM-BPS Interface: Planning Groups
CRMD_MKTGS_TSPEXTrade Spend Exceptions Assignments table
CRMC_MKTGS_BIREPAvailable BW reports for each application
CRMC_MKTPL_CHANCRM Customizing Marketing Planning: Communication Media
CRMC_MKTPL_ACL_CBSP: Customer table of Access Classes to Screen Structures
CRM_MKTPL_OCLASObject Classes in Marketing Planner
CRMC_MKTGS_PARSettings for Parallel Processing
CRMD_MKTSC_ACLOGScenario Planning: Action Log
CRM_MKTPL_STRTYTText Table for Structure Types
BDSPHHR27BDS: Outgoing Hyperlinks from Physical Objects
CRM_MKTPL_PRTExternal Portal application
CRMC_MKTPL_STVCMCampaign FMI: Status to Value Category Mapping
CRM_MKTGS_ASSMTDGeneric Assignment Metadata table
CRMD_MKTPL_AL02Allocation List
CRMC_MKTPL_CTYDACRM Marketing ToDo for campaign type
CRMC_MKTPL_DRUL3Attribute Maintenance for Default Control
CRMD_MKTPLTP_PGRDB table for MKTPL TPM Product Group Assignments
CRMC_MKTPL_VRUSTuser status customizing for versioning
CRMC_MKTPL_DISTMCRM Customiz. Market. Plan.: Distribution Methods Coupon
CRMD_MKTGS_APP_TListing application translations
BDSCHKF27BDS: File Name for Last Check-Out
CRMD_MKTGS_LINKSMarketing: Generic Softlinks
CRMC_MKTPL_CTYPECRM Customizing of Marketing Planning: Campaign Types
CRM_MKTPL_CDEFSystem Table for Default Behavior During Selective Copying
CRMD_MKTGS_PRSEGCRM Marketing Planning: Product Segment Assignment
CRMC_MKTPL_BWActivate SAP BW Update
BDSPHIO27BDS: Instances of Physical Information Objects
CRMC_MKTPL_MSKFMCampaign FMI: Mapping Info Object to Marketing Spend
CRMC_MKTPL_CLRESStructure of Resolution Tree in Claims
CRMC_MKTVL_ATTXTOutput Texts for Attributes
CRMC_MKTPL_DEALGCRM Customizing Marketing Planning: Deals Generation
CRMC_MKTPL_COSTKPI: Cost type definition for Key figure planning
CRMC_MKTPL_VERUICustomerizing table for assignment types
BDSPHNM27BDS: Use of Target Anchors in Physical Objects
CRMC_MKTSC_BWURTTexts for BW Analyses
CRMC_MKTPL_DISCTCRM Marketing: Discount method text table
CRMC_MKTGS_BDIMCRM Marketing: Base dimension KPI definition for tiers
CRMC_MKTPL_CHIERSelected Planning Customer Hierarchy for TPM & TPT
BDSPHRE27BDS: Outgoing Relationships of Physical Information Objects
CRM_MKTPL_OBJCLMarketing Planner Object Classes
CRM_MKTGS_FLDSETField set definition for generic fast search framework
CRMC_MKTPL_FCO_TFamily code texts for coupon
BDSPHRI27BDS: Incoming Relationships of Physical Information Objects
CRM_MKTGS_ASGCCHMKTGS OL: Generic Assignment Cross Check Meta Data
CRMC_MKTVL_ATTRAttributes for Value Splitting Marketing Planner
CRM_MKTPL_OBJTXTText Table for Marketing Element Types
CRM_MKTPL_STRSystem Table for Structure Types and Structures
CRMC_MKTPL_AUTHGCRM Customizing Marketing Planning: Authorization Group
CRMC_MKTPL_CMCustomizing Table for CM File Structure (Obj.cl., Camp.type)
CRMC_MKTVL_DTYPEDistribution Category
CRM_MKTPL_STRTSystem Text Table for Structures
CRMT_MKT_MRMBW_CMRMBW: Cache for Coupon Redemption Prediction
CRMD_MKTPL_PRODAssignment of Product in Marketing Planning
CRMC_MKTPL_SKM_TSuccess Key Measure description
CRMC_MKTGS_COMPCRM Marketing: Comparison KPI definition for tiers
CRMC_MKTPL_TODOTCRM Marketing ToDo: ToDo description and Long text
BDS_CONN27BDS: Link Table
CRMC_MKTPL_VER0CRM Marketing: SEM Versioning - system status