In this post, I will try and describe everything you need to know about the SAP crmd_im_ml_list table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_IM_ML_LIST what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_IM_ML_LIST....Right lets get started!
Object Name: CRMD_IM_ML_LIST
Dictionary Type: Structure
Description: Fields for Mailing List
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
CAMP_ID | CRM_MKTPL_CAMPAIGNID | CHAR | 24(0) | Campaign | CGPL_EXTID | CRM | ||||||
TASK_ID | CRM_MKTPL_CAMPAIGN_TASKID | CHAR | 24(0) | Campaign Element | CGPL_EXTID | CRM | ||||||
SUM_MAILS | CRMT_IM_NUMBER_MAILS | INT4 | 10(0) | Number of Mails to be Sent | INT4 | CRM | ||||||
SUM_SUC_MAILS | CRMT_IM_NUMBER_SUC_MAILS | INT4 | 10(0) | Number of Mails Created | INT4 | CRM | ||||||
SUM_ACCESS | CRMT_IM_NUMBER_ACCESS | INT2 | 5(0) | Number of Times a Link is Accessed | INT2 | CRM | ||||||
SUCC_PERC | CRMT_IM_PERC | DEC | 5(2) | Number of Successful Mails (%) | PRZ32 | CRM | ||||||
BPARTNER | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM | ||
TG_DESCR | CRMT_MKTTG_TG_DESCR | CHAR | 72(0) | CRM Marketing: target group description | CRM_MKTTG_TG_DESCR | CRM | ||||||
FIRSTNAME | BU_NAMEP_F | CHAR | 40(0) | First name of business partner (person) | BU_NAME | CRM | ||||||
LASTNAME | BU_NAMEP_L | CHAR | 40(0) | Last name of business partner (person) | BU_NAME | CRM | ||||||
NAME_ORG1 | BU_NAMEOR1 | CHAR | 40(0) | Name 1 of organization | BU_NAME | CRM | ||||||
SMARTFORM | CRM_MKTPL_TDSFNAME | CHAR | 30(0) | * | CRM marketing planner form name smart forms | TDSFNAME | IM_MAIL_TYPE | FORMNAME | CRM | |||
PARTNER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
ML_GUID_H | CRMT_IM_GUID | RAW | 16(0) | GUID of an Object in the Mailing List | SYSUUID | CRM | ||||||
READ_MAIL | CRMT_IM_READ_MAIL | CHAR | 10(0) | * | Display mail | BU_PARTNER | CRM | |||||
OBJKEY | SWO_TYPEID | CHAR | 70(0) | Object key | SWO_TYPEID | CRM | ||||||
MAIL_DATE | CRMT_IM_DATE | DATS | 8(0) | Date of Mail Creation | DATS | CRM | ||||||
MAIL_TIME | CRMT_IM_TIME | TIMS | 6(0) | Time at Which Mail was Created | CRM_SCHEDLIN_TIME | CRM | ||||||
CHANNEL | CRM_MKTPL_COM_CHANNEL | NUMC | 2(0) | CRM Marketing Planning - Communication Method | CRM_MKTPL_COM_CHANNEL | CRM | ||||||
CHANNEL_TEXT | CRMT_IM_CHANNEL_TEXT | CHAR | 20(0) | Communication Channel | CHAR20 | CRM | ||||||
MSGID | ARBGB | CHAR | 20(0) | * | Application Area | ARBGB | MAG | SDIC | CRM | |||
MSGNR | MSGNR | CHAR | 3(0) | * | Message number | MSGNR | SDIC | CRM | ||||
STATUS | CRMT_IM_STATUS | CHAR | 1(0) | CRM Marketing: Technical Status for an Outbound | CRM_IM_STATUS | CRM | ||||||
STATUS_TEXT | CRMT_IM_STATUS_TEXT | CHAR | 80(0) | CRM Marketing: Status Text | CHAR80 | CRM | ||||||
PRC | CRMT_MKT_ICRH_PRC_CHAR | CHAR | 12(0) | CRM Marketing: ICRH - Personalized Response Code - character | CRM_MKT_ICRH_PRC_CHAR | CRM |