The CRM_MKTPL_ATTR table in SAP ERP or S/4HANA stores CRM Marketing Planner: Marketing plan/campaign attributes data. There are total 59 fields in CRM_MKTPL_ATTR table. The CRM Marketing Planner: Marketing plan/campaign attributes 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 CRM_MKTPL_ATTR table. It is in CRM Marketing Planning – User Interfaces (CRM_MKTPL) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRM_MKTPL_ATTR Table Fields
Following is the list of fields that are available in SAP CRM_MKTPL_ATTR table. The primary key fields of the table are CLIENT (Client), GUID (Project Planning: 16-Character GUID for Projects and Activts).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| PROJECT_GUID | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | CGPL_PROJECT | RAW (16) |
| CAMP_TYPE | Type | CRM_MKTPL_CAMPTYPE | CRMC_MKTPL_CTYPE | CHAR (4) |
| CHANNEL | ID of Communication Medium | CRM_MKTPL_CHANNEL | CRMC_MKTPL_CHAN | CHAR (4) |
| RESPONSIBLE | Business Partner GUID | BU_PARTNER_GUID | RAW (16) | |
| SMARTFORM | Form for E-Mail | CRMT_MKTPL_EMAIL_FORM | CHAR (30) | |
| ADRESS_ID | Identification for an E-mail Address | CRMT_IM_E_ID | CRMC_IM_ADRESS | CHAR (12) |
| SCRIPT | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| SHORTCUT | Campaign Code | CRMT_MKTPL_CAMPAIGN_SHORTCUT | CHAR (4) | |
| MAIL_FORM | Form for Sending a Letter | CRMT_MKTPL_MAIL_FORM | CHAR (30) | |
| FAX_FORM | Form for Fax | CRMT_MKTPL_FAX_FORM | CHAR (30) | |
| PRINT_ID | Profile for Print Parameters | CRMT_IM_PRINT_ID | CHAR (12) | |
| SEND_PARTNER | Business partner for Sender Address Determination | CRM_IM_SEND_PARTNER | CHAR (10) | |
| SMS_FORM | Form for SMS/Pager Services | CRMT_MKTPL_SMS_FORM | CHAR (30) | |
| TACTICS | Tactic | CRM_MKTPL_TACTICS | CRMC_MKTPL_TACTS | CHAR (4) |
| OBJECTIVE | Objective | CRM_MKTPL_OBJECTIVE | CRMC_MKTPL_OBJTV | CHAR (4) |
| AUTH_GROUP | Authorization Group | CRM_MKTPL_AUTH_GROUP | CRMC_MKTPL_AUTHG | CHAR (4) |
| ORIG_SYSTEM | CRM Marketing Planning – Campaign Original System | CRM_MKTPL_ORIG_SYST | CHAR (1) | |
| SPICE_SCRIPT | Name of Interaction Center (IC) WebClient Script | CRM_IC_SCRNAME | CHAR (32) | |
| ACTION_PROFILE | ID of Action Profile | CRM_MKTPL_ACTION_PROFILE | * | CHAR (30) |
| CAMPAIGN_LINK | Project Planning: 16-Character GUID for Projects and Activts | CGPL_GUID16 | RAW (16) | |
| CURRENCY | MKTPL: Currency Object | CRM_MKTPL_CUKY | TCURC | CUKY (5) |
| NO_R3_INT | Marketing Planning: Object Not Integrated into ERP PS | CRM_MKTPL_NO_R3_INT | CHAR (1) | |
| MKT_ORG | Marketing Organization | CRM_MKTPL_MORG | CHAR (14) | |
| FILE_EXPORT_FORM | File Export Form | CRMT_IM_EXPORT_FORM | CHAR (30) | |
| CPT_TYPE | Type of Campaign Element Used | CRMT_MKTCA_CPT_TYPE | CHAR (2) | |
| SURVEYID | CRM Surveys: Survey ID | CRM_SVY_DB_SID | CRM_SVY_DB_S | CHAR (32) |
| SURVEYVERSION | CRM Surveys: Survey Version | CRM_SVY_DB_SVERS | NUMC (10) | |
| RECURRING | Indicator Recurring Campaign for Camp. Automation | CRMT_MKTCA_CPG_RECURRING | CHAR (1) | |
| MKTCA_WFTASK | Assignment Term Workflow for Task ID | CRMT_MKTCA_WFTASK | CRMC_MKTCA_WFT | CHAR (4) |
| CAMP_PERIOD | Period for Campaign | CRMT_MKTCA_PERIOD | CHAR (30) | |
| N_CAMP_PERIODS | No. of Processing Periods | CRMT_MKTCA_NUMBER_PERIODS | INT4 (10) | |
| RESPONSE_FLAG | Start for Every Respondent? | CRMT_MKTCA_RESPONSE_FLAG | CHAR (1) | |
| ET_CAMPAIGN | Indicator for Event Triggered Campaigns | CRMT_MKTCA_EVENT_TRIGGERED_CPG | CHAR (1) | |
| SCHEDULING_TYPE | Scheduling Type | CRMT_MKTCA_SCHEDULING_TYPE | CHAR (2) | |
| DELAY | Delay (Relative Scheduling) | CRMT_MKTCA_DELAY | INT1 (3) | |
| DELAY_UNIT | Unit for Delay (Relative Scheduling) | CRMT_MKTCA_DELAY_UNIT | CHAR (2) | |
| CAMP_PERIOD_DUR | Period Duration for Recurring Campaigns | CRMT_MKTCA_PERIOD_N | INT4 (10) | |
| INACTIVE | Inactive Marketing Project | CRMT_MKTPL_INACTIVE | CHAR (1) | |
| CHM_RELEVANT | Open to Partners | CRMT_MKTPL_CHM_RELEVANT | CHAR (1) | |
| EXCL_IND | Indicator: Marketing Project Is Exclusive | CRM_MKTPL_EXCL_IND | CHAR (1) | |
| TIMEZONE_CREATED | Time Zone of User Who Created the Marketing Project | CRM_MKTPL_TIMEZONE_CREATED | * | CHAR (6) |
| PROD_PL_BASIS | Product Planning Basis | CRM_MKTSS_PL_BASIS | NUMC (3) | |
| ADI_FLAG | Abnormal Demand Indicator | CRM_MKTPL_ADI | CHAR (1) | |
| ENROLLMENT_REQ | Indicator, that enrollment is required | CRM_MKTPL_ENR_ENROLLMENT_REQ | CHAR (1) | |
| REF_TYPE | Usage Type | CRM_MKTPL_REF_TYPE | CHAR (4) | |
| TEMPLATE | Template Indicator | CRM_MKTPL_TEMPLATE | CHAR (1) | |
| SMARTDAY_FLAG | Logical Variable | CRMT_BOOLEAN | CHAR (1) | |
| DETERM_PROC | ID of a Partner Determination Procedure | COMT_PARTNER_DETERM_PROC | * | CHAR (8) |
| RATES_ORIGIN | Rates Origin | CRM_MKTGS_RATES_ORIGIN | CHAR (1) | |
| USE_FIX_TZ_UTC | MKTPL: Use Fix Timezone UTC for Timestamp – Date/Time Conv. | CRM_MKTPL_USE_FIX_TIMEZONE | CHAR (1) | |
| COMB_TYPE | Combinability Type for Reward Rule Group | CRM_MKTPL_LOY_COMB_TYPE | CHAR (4) | |
| EXECUTION_LANG | Execution Language in High-Volume Scenario | CRM_MKTPL_EXECUTION_LANGUAGE | * | LANG (1) |
| BP_CORR_LANG_IND | Indicator: Determine BP Correspondence Language | CRM_MKTPL_DETERMINE_CORR_LANG | CHAR (1) | |
| NOTIF_PROF | Notification Profile | CRMT_NOTIF_PROF | * | CHAR (10) |
| MKTPL_HEADER | Dummy function in length 1 | DUMMY | CHAR (1) | |
| ENROLLMENT_TYPE | Data Element For Enrollment Type | CRM_MKTPL_ENR_TYPE | CHAR (8) | |
| CHECK_CONSENT | Check Consent (Marketing Permission) | CRM_MKTPL_CHECK_MKT_PERMISSION | CHAR (1) |
