SAP S/4Hana table CRMD_MKTPL_TMPL stores Transaction Templates for Marketing Elementdata

  

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_MKTPL_TMPL 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_MKTPL_TMPL dictionary attributes

Object Name: CRMD_MKTPL_TMPL
Dictionary Type: Transparent table
Description: Transaction Templates for Marketing Element


Field list for CRMD_MKTPL_TMPL 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
GUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUID
PROJECT_GUIDCGPL_GUID16RAW16(0) Project Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUID
TASK_GUIDCGPL_GUID16RAW16(0) Project Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUID
COM_CHANNELCRM_MKTPL_COM_CHANNELNUMC2(0) CRM Marketing Planning - Communication MethodCRM_MKTPL_COM_CHANNEL
PROCESS_TYPECRMT_PROCESS_TYPECHAR4(0) Business Transaction TypeCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPEPROCESS_TYPE
TEMPLATE_IDCRMT_OBJECT_IDCHAR10(0) Transaction IDCRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_IDOBJECT_ID
UNIT_OF_OFFSETCRM_MKTPL_TMPL_OFFSET_UNITNUMC1(0) Time Unit of DifferenceCRM_MKTPL_TMPL_OFFSET_UNIT
REF_DATE_STARTCRM_MKTPL_TMPL_REFDATECHAR3(0) Reference DateCRM_MKTPL_TMPL_REFDATE
OFFSET_STARTCRM_MKTPL_TMPL_OFFSETDEC4(0) Difference to Reference DateCRM_MKTPL_TMPL_OFFSET
REF_DATE_ENDCRM_MKTPL_TMPL_REFDATECHAR3(0) Reference DateCRM_MKTPL_TMPL_REFDATE
OFFSET_ENDCRM_MKTPL_TMPL_OFFSETDEC4(0) Difference to Reference DateCRM_MKTPL_TMPL_OFFSET
NODELETE_FLAGCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEAN
NOREUSE_FLAGCRMT_BOOLEANCHAR1(0) Logical VariableCRM_BOOLEAN


View list of all S4 Hana tables