SAP Table
CRMD_KW_TEMPL Tree Structure of KW Templates
SAP table CRMD_KW_TEMPL has 3 primary key fields being MANDT,TEMPLATE_NAME,NODE_KEY.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
CRMD_KW_TEMPL columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeyTEMPLATE_NAME | Name of a Folder Template | CHAR | 64 | 0 | CRMT_TEMPLATE_NAME | ||
| KeyNODE_KEY | Tree Control: Node Key | CHAR | 12 | 0 | TV_NODEKEY | ||
| RELATKEY | Tree Control: Node Key | CHAR | 12 | 0 | TV_NODEKEY | ||
| RELATSHIP | 4 Byte Signed Integer | INT4 | 10 | 0 | INT4 | ||
| NAME | Short Description | CHAR | 64 | 0 | SDOK_DESCR | ||
| DESCRIPTION | Short Description | CHAR | 64 | 0 | SDOK_DESCR | ||
| PROP_NAME1 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE1 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME2 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE2 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME3 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE3 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME4 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE4 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME5 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE5 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME6 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE6 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME7 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE7 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME8 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE8 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME9 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE9 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV | ||
| PROP_NAME10 | Attribute of a document or a relationship | CHAR | 25 | 0 | SDOK_PROPN | ||
| PROP_VALUE10 | Attribute Value | CHAR | 64 | 0 | SDOK_PROPV |