In this post, I will try and describe everything you need to know about the SAP crmd_mktpl_dsel 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_MKTPL_DSEL 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_MKTPL_DSEL....Right lets get started!
Object Name: CRMD_MKTPL_DSEL
Dictionary Type: Transparent table
Description: Value Distribution for Hierarchy Nodes
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| DISTLINEGUID | SYSUUID_X | RAW | 16(0) | UUID in X form (binary) | SYSUUID | CRM | ||||||
| PROJECT_GUID | CGPL_PROJECT_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Projects | CGPL_PROJECT_GUID | CRM | ||||||
| TASK_GUID | CGPL_TASK_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Tasks | CGPL_PROJECT_GUID | CRM | ||||||
| LINE | CRMT_MKTVL_LINNO | INT4 | 10(0) | Line Number | CRM | |||||||
| OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR | 3(0) | Object Type in Project Planning | CHAR3 | CRM | ||||||
| DISTRIBTYPE | CRMT_MKTVL_DISTR | CHAR | 4(0) | Distribution Category | CRM | |||||||
| CO | CRMT_COUNTRY | CHAR | 3(0) | T005 | Country | LAND1 | CRM | |||||
| SO | CRMT_SALES_ORG | CHAR | 14(0) | Sales Organization | HROBJEC_14 | CRM_ORGMAN_SALES_ORG | SALES_ORG | CRM | ||||
| MO | CRM_MKTPL_MORG | CHAR | 14(0) | Marketing Organization | HROBJEC_14 | CRM_MKTPL_MORG | MKT_ORG | CRM | ||||
| DC | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2(0) | CRMC_DISTCHAN | Distribution Channel | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | DIS_CHANNEL | CRM | |||
| DV | CRMT_DIVISION | CHAR | 2(0) | CRMC_DIVISION | Division | CRM_DIVISION | CRM_DIVISION | DIVISION | CRM | |||
| PG | CRMT_PRC_GROUP1 | CHAR | 3(0) | CRMC_PRC_GRP1 | Product Group 1 | CRM_PRC_GROUP1 | CRM | |||||
| CG1 | CRMT_CUST_GROUP1 | CHAR | 3(0) | CRMC_CUSTGRP1 | Customer Group 1 | CRM_CUST_GROUP1 | CRM | |||||
| CG4 | CRMT_CUST_GROUP4 | CHAR | 3(0) | * | Customer Group 4 | CRM_CUST_GROUP4 | CRM | |||||
| PRH1 | COMT_CATEGORY_ID | CHAR | 20(0) | Category ID | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | CRM | |||
| PRH2 | COMT_CATEGORY_ID | CHAR | 20(0) | Category ID | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | CRM | |||
| PRH3 | COMT_CATEGORY_ID | CHAR | 20(0) | Category ID | COM_CATEGORY_ID | COM_CATEGORY_ID | COM_CAT_HIER | CATEGORY_ID | CRM | |||
| BPH1 | BU_NODE_SEARCH_TERM | CHAR | 20(0) | Hierarchy Node ID | BUHI_NODE_SEARCH_TERM2 | SEARCH_TERM | CRM | |||||
| BPH2 | BU_NODE_SEARCH_TERM | CHAR | 20(0) | Hierarchy Node ID | BUHI_NODE_SEARCH_TERM2 | SEARCH_TERM | CRM | |||||
| BPH3 | BU_NODE_SEARCH_TERM | CHAR | 20(0) | Hierarchy Node ID | BUHI_NODE_SEARCH_TERM2 | SEARCH_TERM | CRM | |||||
| PROD | COMT_PRODUCT_ID | CHAR | 40(0) | Product ID | COM_PRODUCT_ID | COM_PR_COLLECTION | PRODUCT_ID | CRM | ||||
| BP | BU_PARTNER | CHAR | 10(0) | * | Business Partner Number | BU_PARTNER | BPA | BUPA | PARTNER | CRM | ||
| PRODUCT_GUID | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | CRM | ||||||
| PARTNER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| CATEGORY1_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| CATEGORY2_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| CATEGORY3_GUID | COMT_CATEGORY_GUID | RAW | 16(0) | Category GUID | SYSUUID | CRM | ||||||
| NODE1_GUID | BU_NODE_GUID | RAW | 16(0) | GUID of Hierarchy Node | SYSUUID | CRM | ||||||
| NODE2_GUID | BU_NODE_GUID | RAW | 16(0) | GUID of Hierarchy Node | SYSUUID | CRM | ||||||
| NODE3_GUID | BU_NODE_GUID | RAW | 16(0) | GUID of Hierarchy Node | SYSUUID | CRM |