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!
Object Name: CRMD_ES_TMPLREL
Dictionary Type: Transparent table
Description: Relations of templates for ES
| 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 | |||||
| TEMPLATE_SET_ID | CRM_ES_TEMPLATE_SET | CHAR | 20(0) | CRMD_ES_TMPLHDR | Template Set ID | CRM_ES_TEMPLATE_SET | ||||||
| TEMPLATE_ID | CRM_ES_TEMPLATE_ID | CHAR | 20(0) | CRMD_ES_TMPLHDR | Template ID for CRM ES | ESH_D_OM_OBJECT_TYPE | ||||||
| TARGET_TEMPLATE | CRM_ES_TEMPLATE_ID | CHAR | 20(0) | Template ID for CRM ES | ESH_D_OM_OBJECT_TYPE | |||||||
| RELATION_ID | ESH_E_OM_RELATION_ID | CHAR | 32(0) | Relation ID | ESH_D_OM_RELATION_ID | |||||||
| RELATION_ID_ES | ESH_E_OM_RELATION_ID | CHAR | 32(0) | Relation ID | ESH_D_OM_RELATION_ID | |||||||
| OBJ_ID | ESH_E_OM_NODE_NAME | CHAR | 20(0) | Node Name | ESH_D_OM_NODE_NAME | |||||||
| TARGET_PROVIDER | ESH_E_OM_PROVIDER_ID | CHAR | 32(0) | Provider ID | ESH_D_IF_PROVIDER_ID | |||||||
| TARGET_OBJ_ID | ESH_E_OM_NODE_NAME | CHAR | 20(0) | Node Name | ESH_D_OM_NODE_NAME | |||||||
| TARGET_TYPE | CRM_ES_TEMPLATE_TYPE | CHAR | 1(0) | Template Type from CRM ES | ESH_D_OM_OBJECT_TYPE_TYPE | |||||||
| SOURCE_CARD | ESH_E_OM_CARDSOURCE | CHAR | 2(0) | Cardinality Source | ESH_D_OM_CARDSOURCE | |||||||
| TARGET_CARD | ESH_E_OM_CARDTARGET | CHAR | 2(0) | Cardinality Target | ESH_D_OM_CARDTARGET | |||||||
| CONTAINMENT | ESH_E_OM_CONTAINMENT | CHAR | 1(0) | Flag: Containment | XFELD | |||||||
| FIELD_ID | CRM_ES_FIELD_ID | CHAR | 30(0) | * | Field ID for CRM ES | FDNAME | ||||||
| CHANGED_AT | TZNTSTMPS | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| CHANGED_BY | UNAME | CHAR | 12(0) | User Name | UNAME | SAP |