SAP WRF_MATGRP_PROD Hierarchy-Product Assignment Table Table
Overview
WRF_MATGRP_PROD is a standard SAP S/4HANA table that stores Hierarchy-Product Assignment Table data. There are total 27 fields in the WRF_MATGRP_PROD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRF_MATGRP_PROD 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_PROD to other SAP tables and standard CDS views available based on WRF_MATGRP_PROD table in S/4HANA 2020.
Techincal Settings of WRF_MATGRP_PROD
Below are technical details of the table WRF_MATGRP_PROD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WRF_MATGRP_PROD Fields
The following table gives you an overview of the fields available in WRF_MATGRP_PROD
| 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 |
| NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | |
| 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 | |
| STRATEGY | Node Strategy | WRF_CATSTRATEGY | WRF_MATGRP_STRA | CHAR | 20 |
| MAINFLG | Main Assignment | WRF_MAIN_FLAG | CHAR | 1 | |
| 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 | |
| HIERNODE4 | Hierarchy Node 4 | WRF_HIER_NODE4 | CHAR | 18 | |
| HIERNODE5 | Hierarchy Node 5 | WRF_HIER_NODE5 | CHAR | 18 | |
| HIERNODE6 | Hierarchy Node 6 | WRF_HIER_NODE6 | CHAR | 18 | |
| HIERNODE7 | Hierarchy Node 7 | WRF_HIER_NODE7 | CHAR | 18 | |
| HIERNODE8 | Hierarchy Node 8 | WRF_HIER_NODE8 | CHAR | 18 | |
| HIERNODE9 | Hierarchy Node 9 | WRF_HIER_NODE9 | CHAR | 18 | |
| HIERNODE10 | Hierarchy Node 10 | WRF_HIER_NODE10 | 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_MATGRP_PROD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRF_MATGRP_PROD | HIER_ID | : | WRF_MATGRP_HIER |
| WRF_MATGRP_PROD | LINUNIT | : | T006 |
| WRF_MATGRP_PROD | MANDT | : | T000 |
| WRF_MATGRP_PROD | SPACEUNIT | : | T006 |
| WRF_MATGRP_PROD | STRATEGY | : | WRF_MATGRP_STRA |