In this post, I will try and describe everything you need to know about the SAP crmd_kw_templ 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_KW_TEMPL 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_KW_TEMPL....Right lets get started!
Object Name: CRMD_KW_TEMPL
Dictionary Type: Transparent table
Description: Tree Structure of KW Templates
| 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 | CRM | ||||
| TEMPLATE_NAME | CRMT_TEMPLATE_NAME | CHAR | 64(0) | Name of a Folder Template | CHAR64 | CRMS_TEMPLATE_NAME | TEMPLATE_NAME | CRM | ||||
| NODE_KEY | TV_NODEKEY | CHAR | 12(0) | Tree Control: Node Key | TM_CHAR12 | CRM | ||||||
| RELATKEY | TV_NODEKEY | CHAR | 12(0) | Tree Control: Node Key | TM_CHAR12 | CRM | ||||||
| RELATSHIP | INT4 | INT4 | 10(0) | Natural Number | INT4 | CRM | ||||||
| NAME | SDOK_DESCR | CHAR | 64(0) | Short Description | TEXT64 | CRM | ||||||
| DESCRIPTION | SDOK_DESCR | CHAR | 64(0) | Short Description | TEXT64 | CRM | ||||||
| PROP_NAME1 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE1 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME2 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE2 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME3 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE3 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME4 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE4 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME5 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE5 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME6 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE6 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME7 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE7 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME8 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE8 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME9 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE9 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM | ||||||
| PROP_NAME10 | SDOK_PROPN | CHAR | 25(0) | * | Attribute of a document or a relationship | SDOK_PROPN | CRM | |||||
| PROP_VALUE10 | SDOK_PROPV | CHAR | 64(0) | Attribute Value | SDOK_PROPV | CRM |