The CMMD_SKU table in SAP ERP or S/4HANA stores CDT-SKU Assignment Table data. There are total 18 fields in CMMD_SKU table. The CDT-SKU Assignment Table 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 CMMD_SKU table. It is in Category Management – Master Data (CM_MD) ABAP package and is part of the Obsolete Functionality (LO-RFM-OBS) module.
SAP CMMD_SKU Table Fields
Following is the list of fields that are available in SAP CMMD_SKU table. The primary key fields of the table are MANDT (Client), MATNR (Material Number), HIER_ID (Hierarchy ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| MATNR | Material Number | MATNR | * | CHAR (40) |
| HIER_ID | Hierarchy ID | HIER_CNT | CHAR (2) | |
| STRATEGY | Node Strategy | CATSTRATEGY | CHAR (20) | |
| CDT1 | Category | CM_CDT1 | CHAR (18) | |
| CDT2 | Subcategory | CM_CDT2 | CHAR (18) | |
| CDT3 | Segment | CM_CDT3 | CHAR (18) | |
| CDT4 | Subsegment | CM_CDT4 | CHAR (18) | |
| CDT5 | Sub-Subsegment | CM_CDT5 | CHAR (18) | |
| CDT6 | Product Group | CM_CDT6 | CHAR (18) | |
| CDT7 | Brand | CM_CDT7 | CHAR (18) | |
| VKORG | Sales Organization | VKORG | * | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | * | CHAR (2) |
| SHLFSPC | CM: Shelf Space | CM_SHFSPC | QUAN (9) | |
| LINSPC | CM: Contact Area | CM_LINSPC | QUAN (9) | |
| SPACEUNIT | CM: Shelf-Space Unit | CM_SPCUNIT | T006 | UNIT (3) |
| LINUNIT | CM: Unit of Contact Area | CM_LINUNIT | T006 | UNIT (3) |
| CHKDATE | CM: Space Management Key Date | CM_CHKDATE | DATS (8) |
