In this post, I will try and describe everything you need to know about the SAP crmd_im_ml_item 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_ITEM 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_ITEM....Right lets get started!
Object Name: CRMD_IM_ML_ITEM
Dictionary Type: Transparent table
Description: Personalized Mails: Contact Tracking Outbound Table (Item)
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| ML_GUID_I | CRMT_IM_GUID | RAW | 16(0) | GUID of an Object in the Mailing List | SYSUUID | CRM | ||||||
| ML_GUID_H | CRMT_IM_GUID | RAW | 16(0) | * | GUID of an Object in the Mailing List | SYSUUID | CRM | |||||
| PARTNER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| ADD_PARTNER_GUID | CRMT_IM_ADD_PARTNER | RAW | 16(0) | Additional Business Partner | SYSUUID | CRM | ||||||
| SUM_ACCESS | CRMT_IM_NUMBER_ACCESS | INT2 | 5(0) | Number of Times a Link is Accessed | INT2 | CRM | ||||||
| SUM_REPLIES | CRMT_IM_NUMBER_REPLIES | INT2 | 5(0) | Obsolete. See Table CRMD_MKTCA_CT for Inbounds. | INT2 | CRM | ||||||
| OBJKEY | SWO_TYPEID | CHAR | 70(0) | Object key | SWO_TYPEID | CRM | ||||||
| OBJTYPE | SWO_OBJTYP | CHAR | 10(0) | * | Object Type | OJ_NAME | OBJ | CRM | ||||
| LOGSYS | LOGSYS | CHAR | 10(0) | * | Logical system | LOGSYS | CRM | |||||
| CHANNEL | CRM_MKTPL_COM_CHANNEL | NUMC | 2(0) | CRM Marketing Planning - Communication Method | CRM_MKTPL_COM_CHANNEL | CRM | ||||||
| MSGID | ARBGB | CHAR | 20(0) | * | Application Area | ARBGB | MAG | SDIC | CRM | |||
| MSGNR | MSGNR | CHAR | 3(0) | * | Message number | MSGNR | SDIC | CRM | ||||
| CHANGED_AT | CRMT_CHANGED_AT | DEC | 15(0) | Time of Last Change to the Transaction | BCOS_TSTMP | CRM | ||||||
| STATUS | CRMT_IM_STATUS | CHAR | 1(0) | CRM Marketing: Technical Status for an Outbound | CRM_IM_STATUS | CRM | ||||||
| ELM_ITEM_GUID | CRMT_MKTLIST_I_GUID | RAW | 16(0) | CRM Marketing: Line GUID for External List Item | SYSUUID | CRM | ||||||
| ORDER_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| PRC | CRMT_MKT_ICRH_PRC_CHAR | CHAR | 12(0) | CRM Marketing: ICRH - Personalized Response Code - character | CRM_MKT_ICRH_PRC_CHAR | CRM |