SAP Table CRMD_ES_TMPLREL stores Relations of templates for ESdata

  

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


SAP CRMD_ES_TMPLREL dictionary attributes

Object Name: CRMD_ES_TMPLREL
Dictionary Type: Transparent table
Description: Relations of templates for ES


CRMD_ES_TMPLREL field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTEST
TEMPLATE_SET_IDCRM_ES_TEMPLATE_SETCHAR20(0) CRMD_ES_TMPLHDRTemplate Set IDCRM_ES_TEMPLATE_SET
TEMPLATE_IDCRM_ES_TEMPLATE_IDCHAR20(0) CRMD_ES_TMPLHDRTemplate ID for CRM ESESH_D_OM_OBJECT_TYPE
TARGET_TEMPLATECRM_ES_TEMPLATE_IDCHAR20(0) Template ID for CRM ESESH_D_OM_OBJECT_TYPE
RELATION_IDESH_E_OM_RELATION_IDCHAR32(0) Relation IDESH_D_OM_RELATION_ID
RELATION_ID_ESESH_E_OM_RELATION_IDCHAR32(0) Relation IDESH_D_OM_RELATION_ID
OBJ_IDESH_E_OM_NODE_NAMECHAR20(0) Node NameESH_D_OM_NODE_NAME
TARGET_PROVIDERESH_E_OM_PROVIDER_IDCHAR32(0) Provider IDESH_D_IF_PROVIDER_ID
TARGET_OBJ_IDESH_E_OM_NODE_NAMECHAR20(0) Node NameESH_D_OM_NODE_NAME
TARGET_TYPECRM_ES_TEMPLATE_TYPECHAR1(0) Template Type from CRM ESESH_D_OM_OBJECT_TYPE_TYPE
SOURCE_CARDESH_E_OM_CARDSOURCECHAR2(0) Cardinality SourceESH_D_OM_CARDSOURCE
TARGET_CARDESH_E_OM_CARDTARGETCHAR2(0) Cardinality TargetESH_D_OM_CARDTARGET
CONTAINMENTESH_E_OM_CONTAINMENTCHAR1(0) Flag: ContainmentXFELD
FIELD_IDCRM_ES_FIELD_IDCHAR30(0) *Field ID for CRM ESFDNAME
CHANGED_ATTZNTSTMPSDEC15(0) UTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPS
CHANGED_BYUNAMECHAR12(0) User NameUNAMESAP


View list of all tables