In this post, I will try and describe everything you need to know about the SAP crmd_es_tmplhdr 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_TMPLHDR 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_TMPLHDR....Right lets get started!
Object Name: CRMD_ES_TMPLHDR
Dictionary Type: Transparent table
Description: 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_TMPLSET | Template Set ID | CRM_ES_TEMPLATE_SET | ||||||
| TEMPLATE_ID | CRM_ES_TEMPLATE_ID | CHAR | 20(0) | Template ID for CRM ES | ESH_D_OM_OBJECT_TYPE | |||||||
| BOR_OBJ_TYPE | SWO_OBJTYP | CHAR | 10(0) | * | Object Type | OJ_NAME | OBJ | |||||
| TYPE | CRM_ES_TEMPLATE_TYPE | CHAR | 1(0) | Template Type from CRM ES | ESH_D_OM_OBJECT_TYPE_TYPE | |||||||
| ROOT_OBJ | CRMT_EXT_OBJ_NAME | CHAR | 30(0) | External Name of Object | CRM_OBJEXT_NAME | |||||||
| DATA | CRM_ES_XML_DATA | STRG | 0(0) | XML Data for ES | CRM_ES_XML_DATA | |||||||
| TRANSFER_FLAG | CRM_ES_TRANSFER | CHAR | 1(0) | Transfer Indicator for CRM ES Data Transfer | BOOLEAN | |||||||
| TO_TABLE | TABNAME16 | CHAR | 16(0) | Table name, 16 characters | DBOBJ_NAME | DTB | SDIC | DD_DBTB_16 | TABNAME | |||
| TO_DOMNAME | DOMNAME_SG | CHAR | 30(0) | * | Name of a domain with Set/Get parameter | DOMNAME | DOM | SDIC | DD_DOMA | DOMNAME | ||
| CHANGED_AT | TZNTSTMPS | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| CHANGED_BY | UNAME | CHAR | 12(0) | User Name | UNAME | SAP | ||||||
| TRANS_AT | TZNTSTMPS | DEC | 15(0) | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |||||||
| TRANS_BY | UNAME | CHAR | 12(0) | User Name | UNAME | SAP | ||||||
| SWITCH_ID | SFW_SWITCH_ID | CHAR | 30(0) | * | Id of a Switch in Switch Framework | SFW_SWITCHID | SFW | SWITCH_ID | ||||
| REACTION | SFW_SHOWHIDE | CHAR | 1(0) | Reaction to Switch | SFW_SHOWHIDE |