SAP Table CRMD_MKTPL_TMPL stores Transaction Templates for Marketing Elementdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_tmpl 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_MKTPL_TMPL 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_MKTPL_TMPL....Right lets get started!


SAP CRMD_MKTPL_TMPL dictionary attributes

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


CRMD_MKTPL_TMPL field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDSYSUUID_XRAW16(0) UUID in X form (binary)SYSUUIDCRM
PROJECT_GUIDCGPL_GUID16RAW16(0) Project Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUIDCRM
TASK_GUIDCGPL_GUID16RAW16(0) Project Planning: 16-Character GUID for Projects and ActivtsCGPL_PROJECT_GUIDCRM
COM_CHANNELCRM_MKTPL_COM_CHANNELNUMC2(0) CRM Marketing Planning - Communication MethodCRM_MKTPL_COM_CHANNELCRM
PROCESS_TYPECRMT_PROCESS_TYPECHAR4(0) *Business Transaction TypeCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPEPROCESS_TYPECRM
TEMPLATE_IDCRMT_OBJECT_IDCHAR10(0) Transaction IDCRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_IDOBJECT_IDCRM
UNIT_OF_OFFSETCRM_MKTPL_TMPL_OFFSET_UNITNUMC1(0) Time Unit of DifferenceCRM_MKTPL_TMPL_OFFSET_UNITCRM
REF_DATE_STARTCRM_MKTPL_TMPL_REFDATECHAR2(0) Reference DateCRM_MKTPL_TMPL_REFDATECRM
OFFSET_STARTCRM_MKTPL_TMPL_OFFSETDEC4(0) Difference to Reference DateCRM_MKTPL_TMPL_OFFSETCRM
REF_DATE_ENDCRM_MKTPL_TMPL_REFDATECHAR2(0) Reference DateCRM_MKTPL_TMPL_REFDATECRM
OFFSET_ENDCRM_MKTPL_TMPL_OFFSETDEC4(0) Difference to Reference DateCRM_MKTPL_TMPL_OFFSETCRM