SAP S/4Hana table CRMD_IM_ML_ITEM_DS stores Dialog Structure of E-mail Itemdata

  

So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_IM_ML_ITEM_DS look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana CRMD_IM_ML_ITEM_DS dictionary attributes

Object Name: CRMD_IM_ML_ITEM_DS
Dictionary Type: Structure
Description: Dialog Structure of E-mail Item


Field list for CRMD_IM_ML_ITEM_DS table on an S/4 SAP system

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTEST
ML_GUID_ICRMT_IM_GUIDRAW16(0) GUID of an Object in the Mailing ListSYSUUID
ML_GUID_HCRMT_IM_GUIDRAW16(0) CRMD_IM_ML_HEADGUID of an Object in the Mailing ListSYSUUID
PARTNER_GUIDBU_PARTNER_GUIDRAW16(0) Business Partner GUIDSYSUUID
ADD_PARTNER_GUIDCRMT_IM_ADD_PARTNERRAW16(0) Additional Business PartnerSYSUUID
SUM_ACCESSCRMT_IM_NUMBER_ACCESSINT25(0) Number of Times a Link is AccessedINT2
SUM_REPLIESCRMT_IM_NUMBER_REPLIESINT25(0) Obsolete. See Table CRMD_MKTCA_CT for Inbounds.INT2
OBJKEYSWO_TYPEIDCHAR70(0) Object keySWO_TYPEID
OBJTYPESWO_OBJTYPCHAR10(0) *Object TypeOJ_NAMEOBJ
LOGSYSLOGSYSCHAR10(0) *Logical systemLOGSYS
CHANNELCRM_MKTPL_COM_CHANNELNUMC2(0) CRM Marketing Planning - Communication MethodCRM_MKTPL_COM_CHANNEL
MSGIDARBGBCHAR20(0) *Application AreaARBGBMAGSDIC
MSGNRMSGNRCHAR3(0) *Message numberMSGNRSDIC
CHANGED_ATCRMT_CHANGED_ATDEC15(0) Time of Last Change to the TransactionBCOS_TSTMP
STATUSCRMT_IM_STATUSCHAR1(0) CRM Marketing: Technical Status for an OutboundCRM_IM_STATUS
.INCLU--AP0(0)
MP_GUIDCRMT_MKTHV_MC_GENERIC_GUIDRAW16(0) CRM Marketing: Marketing Prospect Generic GUIDSYSUUID
IO_DESCRIPTIONCRMT_IO_DESCRIPTIONCHAR40(0) Description of Interaction Object (Language Independent)CHAR40
IO_TYPECRMT_IM_IO_TYPENUMC2(0) Interaction Object CategoryCRMT_IM_IO_TYPE
IO_STATUSCRMT_IM_IO_STATUSCHAR2(0) Status of Inbound Interaction ObjectCRMT_IM_IO_STATUS
IO_CHANGED_BYCRMT_CHANGED_BYCHAR12(0) Transaction Last Changed ByUNAME
URL_GUIDCRMT_IM_URL_GUIDRAW16(0) Personalized Mails: GUID of a URLSYSUUID
IO_SCORECRMT_IM_IO_SCORENUMC2(0) Interaction Object ScoreNUMC02
ITM_CREATED_ATCRMT_CREATED_ATDEC15(0) Transaction was Created at this TimeBCOS_TSTMP
ITM_CREATED_BYCRMT_CREATED_BYCHAR12(0) User that Created the TransactionUNAMEUSER_ADDRBNAME
ELM_ITEM_GUIDCRMT_MKTLIST_I_GUIDRAW16(0) CRM Marketing: Line GUID for External List ItemSYSUUID
ORDER_GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUID
PRCCRMT_MKT_ICRH_PRC_CHARCHAR12(0) CRM Marketing: ICRH - Personalized Response Code - characterCRM_MKT_ICRH_PRC_CHAR
TABIXCRM_IM_TABIXINT410(0) Index of Entry in Document TableSYST_LONG


View list of all S4 Hana tables