SAP WRF_CMMD_SKU CDT-SKU Assignment Table Table
Overview
WRF_CMMD_SKU is a standard SAP S/4HANA table that stores CDT-SKU Assignment Table data. There are total 20 fields in the WRF_CMMD_SKU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_CMMD_SKU belongs to Consumer Decision Tree (Article Hierarchy) (LO-RFM-MD-CDT) module and is located in the package Category Management - Master Data (WRF_CM_MD).
In addition, following links provide an overview of foreign key relationships, if any, that link WRF_CMMD_SKU to other SAP tables and standard CDS views available based on WRF_CMMD_SKU table in S/4HANA 2020.
Techincal Settings of WRF_CMMD_SKU
Below are technical details of the table WRF_CMMD_SKU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_CMMD_SKU Fields
The following table gives you an overview of the fields available in WRF_CMMD_SKU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| MATNR | Material Number | MATNR | * | CHAR | 40 |
| HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 |
| STRATEGY | Node Strategy | WRF_CATSTRATEGY | WRF_MATGRP_STRA | CHAR | 20 |
| CDT1 | Category | WRF_CM_CDT1 | WRF_CMMD_CDT1 | CHAR | 18 |
| CDT2 | Subcategory | WRF_CM_CDT2 | WRF_CMMD_CDT2 | CHAR | 18 |
| CDT3 | Segment | WRF_CM_CDT3 | WRF_CMMD_CDT3 | CHAR | 18 |
| CDT4 | Subsegment | WRF_CM_CDT4 | WRF_CMMD_CDT4 | CHAR | 18 |
| CDT5 | Sub-Subsegment | WRF_CM_CDT5 | WRF_CMMD_CDT5 | CHAR | 18 |
| CDT6 | Product Group | WRF_CM_CDT6 | WRF_CMMD_CDT6 | CHAR | 18 |
| CDT7 | Brand | WRF_CM_CDT7 | WRF_CMMD_CDT7 | CHAR | 18 |
| VKORG | Sales Organization | VKORG | * | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | * | CHAR | 2 |
| SHLFSPC | CM: Shelf Space | WRF_CM_SHFSPC | QUAN | 9 | |
| LINSPC | CM: Contact Area | WRF_CM_LINSPC | QUAN | 9 | |
| SPACEUNIT | CM: Shelf-Space Unit | WRF_CM_SPCUNIT | T006 | UNIT | 3 |
| LINUNIT | CM: Unit of Contact Area | WRF_CM_LINUNIT | T006 | UNIT | 3 |
| CHKDATE | CM: Space Management Key Date | WRF_CM_CHKDATE | DATS | 8 | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | |
| DELETEFLAG | Deletion Indicator | WRF_DELETE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WRF_CMMD_SKU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_CMMD_SKU | CDT1 | : | WRF_CMMD_CDT1 |
| WRF_CMMD_SKU | CDT2 | : | WRF_CMMD_CDT2 |
| WRF_CMMD_SKU | CDT3 | : | WRF_CMMD_CDT3 |
| WRF_CMMD_SKU | CDT4 | : | WRF_CMMD_CDT4 |
| WRF_CMMD_SKU | CDT5 | : | WRF_CMMD_CDT5 |
| WRF_CMMD_SKU | CDT6 | : | WRF_CMMD_CDT6 |
| WRF_CMMD_SKU | CDT7 | : | WRF_CMMD_CDT7 |
| WRF_CMMD_SKU | HIER_ID | : | WRF_MATGRP_HIER |
| WRF_CMMD_SKU | LINUNIT | : | T006 |
| WRF_CMMD_SKU | MANDT | : | T000 |
| WRF_CMMD_SKU | SPACEUNIT | : | T006 |
| WRF_CMMD_SKU | STRATEGY | : | WRF_MATGRP_STRA |