SAP WRF_CMMD_CDT2 Subcategory Table
Overview
WRF_CMMD_CDT2 is a standard SAP S/4HANA table that stores Subcategory data. There are total 20 fields in the WRF_CMMD_CDT2 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_CMMD_CDT2 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_CDT2 to other SAP tables and standard CDS views available based on WRF_CMMD_CDT2 table in S/4HANA 2020.
Techincal Settings of WRF_CMMD_CDT2
Below are technical details of the table WRF_CMMD_CDT2
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_CMMD_CDT2 Fields
The following table gives you an overview of the fields available in WRF_CMMD_CDT2
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| CDT2 | Subcategory | WRF_CM_CDT2 | CHAR | 18 | |
| STRATEGY | Node Strategy | WRF_CATSTRATEGY | WRF_MATGRP_STRA | CHAR | 20 |
| HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 |
| PARENT | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | |
| VKORG | Sales Organization | VKORG | * | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | * | CHAR | 2 |
| CDT1 | Category | WRF_CM_CDT1 | WRF_CMMD_CDT1 | CHAR | 18 |
| 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 | |
| EPRGR | Price point group | EPRGR | * | CHAR | 6 |
| PRODUCTCLF | Goods Schedule Line | WRF_PRDCLF | CHAR | 2 | |
| PRICE_GROUP | Price Level Group | PRICE_GROUP | * | CHAR | 6 |
| REFERENCE | Reference Node | WRF_CDT_REF | CHAR | 18 | |
| RESPONSIBILITY | Responsibility | WRF_RESP | CHAR | 20 | |
| 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_CDT2
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_CMMD_CDT2 | CDT1 | : | WRF_CMMD_CDT1 |
| WRF_CMMD_CDT2 | HIER_ID | : | WRF_MATGRP_HIER |
| WRF_CMMD_CDT2 | LINUNIT | : | T006 |
| WRF_CMMD_CDT2 | MANDT | : | T000 |
| WRF_CMMD_CDT2 | SPACEUNIT | : | T006 |
| WRF_CMMD_CDT2 | STRATEGY | : | WRF_MATGRP_STRA |