SAP WRF_MATGRP_MD4 Hierarchy Level 4 - Time-Dependent Table
Overview
WRF_MATGRP_MD4 is a standard SAP S/4HANA table that stores Hierarchy Level 4 - Time-Dependent data. There are total 27 fields in the WRF_MATGRP_MD4 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_MATGRP_MD4 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_MATGRP_MD4 to other SAP tables and standard CDS views available based on WRF_MATGRP_MD4 table in S/4HANA 2020.
Techincal Settings of WRF_MATGRP_MD4
Below are technical details of the table WRF_MATGRP_MD4
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_MATGRP_MD4 Fields
The following table gives you an overview of the fields available in WRF_MATGRP_MD4
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | |
| HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 |
| DATE_FROM | Validity Start Date of Assignment in Article Hierarchy | WRF_DATE_FROM | DATS | 8 | |
| DATE_TO | Validity End Date of Assignment in Article Hierarchy | WRF_DATE_TO | DATS | 8 | |
| ROLE | Category Role | WRF_CATROLE | WRF_MATGRP_ROLE | CHAR | 20 |
| STRATEGY | Node Strategy | WRF_CATSTRATEGY | WRF_MATGRP_STRA | CHAR | 20 |
| PARENT | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | |
| HIERNODE1 | Hierarchy Node 1 | WRF_HIER_NODE1 | CHAR | 18 | |
| HIERNODE2 | Hierarchy Node 2 | WRF_HIER_NODE2 | CHAR | 18 | |
| HIERNODE3 | Hierarchy Node 3 | WRF_HIER_NODE3 | CHAR | 18 | |
| VKORG | Sales Organization | VKORG | * | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | * | CHAR | 2 |
| TREE_LEVEL | Hierarchy Level | WRF_CDT_LEVEL | NUMC | 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 |
| STORES | CM: Number of Stores with Articles from the Category | WRF_CM_STORES | NUMC | 9 | |
| 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 | |
| EPRGR | Price point group | EPRGR | TWPK | CHAR | 6 |
| PRODUCTCLF | Goods Schedule Line | WRF_PRDCLF | CHAR | 2 | |
| PRICE_GROUP | Price Level Group | PRICE_GROUP | WRF_PRGRP | CHAR | 6 |
| REFERENCE | Reference Node | WRF_CDT_REF | CHAR | 18 | |
| RESPONSIBILITY | Responsibility | WRF_RESP | CHAR | 20 |
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_MATGRP_MD4
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_MATGRP_MD4 | EPRGR | 1: CN | TWPK |
| WRF_MATGRP_MD4 | HIER_ID | : | WRF_MATGRP_HIER |
| WRF_MATGRP_MD4 | LINUNIT | : | T006 |
| WRF_MATGRP_MD4 | MANDT | : | T000 |
| WRF_MATGRP_MD4 | PRICE_GROUP | : | WRF_PRGRP |
| WRF_MATGRP_MD4 | ROLE | : | WRF_MATGRP_ROLE |
| WRF_MATGRP_MD4 | SPACEUNIT | : | T006 |
| WRF_MATGRP_MD4 | STRATEGY | : | WRF_MATGRP_STRA |