The CMCDT_2 table in SAP ERP or S/4HANA stores Master Data for Subcategory data. There are total 12 fields in CMCDT_2 table. The Master Data for Subcategory table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMCDT_2 table. It is in Analytical Application CM (RS_AA_CM) ABAP package and is part of the Categorie Management Consumer Products (BW-BCT-CPG-CMC) module.
SAP CMCDT_2 Table Fields
Following is the list of fields that are available in SAP CMCDT_2 table. The primary key fields of the table are MANDT (Client), HIER_ID (Hierarchy ID), CDT2 (Subcategory).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| HIER_ID | Hierarchy ID | CMHIER_CNT | CHAR (2) | |
| CDT2 | Subcategory | CMCDT2 | CHAR (18) | |
| STRATEGY | Node Strategy | CMCATSTRATEGY | CMMATGRP_STRAT | CHAR (20) |
| VKORG | Sales Organization | VKORG | CHAR (4) | |
| VTWEG | Distribution Channel | VTWEG | CHAR (2) | |
| CDT1 | Category | CMCDT1 | CMCDT_1 | CHAR (18) |
| SHLFSPC | CM: Shelf Space | CMSHFSPC | QUAN (9) | |
| LINSPC | CM: Contact Area | CMLINSPC | QUAN (9) | |
| SPACEUNIT | CM: Shelf Space Unit | CMSPCUNIT | T006 | UNIT (3) |
| LINUNIT | CM: Contact Area Unit | CMLINUNIT | T006 | UNIT (3) |
| CHKDATE | CM: Key Date for Space Analyses | CMCHKDATE | DATS (8) |
