SAP Table WRF_MATGRP_MD5
Hierarchy Level 5 - Time-Dependent
WRF_MATGRP_MD5 (Hierarchy Level 5 - Time-Dependent) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WRF_MATGRP_MD5 to other SAP tables.
WRF_MATGRP_MD5 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | 0 | |||||||
HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 | 0 | ||||||
DATE_FROM | Validity Start Date of Assignment in Article Hierarchy | WRF_DATE_FROM | DATS | 8 | 0 | |||||||
DATE_TO | Validity End Date of Assignment in Article Hierarchy | WRF_DATE_TO | DATS | 8 | 0 | |||||||
ROLE | Category Role | WRF_CATROLE | WRF_MATGRP_ROLE | CHAR | 20 | 0 | ||||||
STRATEGY | Node Strategy | WRF_CATSTRATEGY | WRF_MATGRP_STRA | CHAR | 20 | 0 | ||||||
PARENT | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | 0 | |||||||
HIERNODE1 | Hierarchy Node 1 | WRF_HIER_NODE1 | CHAR | 18 | 0 | |||||||
HIERNODE2 | Hierarchy Node 2 | WRF_HIER_NODE2 | CHAR | 18 | 0 | |||||||
HIERNODE3 | Hierarchy Node 3 | WRF_HIER_NODE3 | CHAR | 18 | 0 | |||||||
HIERNODE4 | Hierarchy Node 4 | WRF_HIER_NODE4 | CHAR | 18 | 0 | |||||||
VKORG | Sales Organization | VKORG | CHAR | 4 | 0 | |||||||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | 0 | |||||||
TREE_LEVEL | Hierarchy Level | WRF_CDT_LEVEL | NUMC | 2 | 0 | |||||||
SHLFSPC | CM: Shelf Space | WRF_CM_SHFSPC | QUAN | 9 | 3 | |||||||
LINSPC | CM: Contact Area | WRF_CM_LINSPC | QUAN | 9 | 3 | |||||||
SPACEUNIT | CM: Shelf-Space Unit | WRF_CM_SPCUNIT | T006 | UNIT | 3 | 0 | ||||||
LINUNIT | CM: Unit of Contact Area | WRF_CM_LINUNIT | T006 | UNIT | 3 | 0 | ||||||
STORES | CM: Number of Stores with Articles from the Category | WRF_CM_STORES | NUMC | 9 | 0 | |||||||
CHKDATE | CM: Space Management Key Date | WRF_CM_CHKDATE | DATS | 8 | 0 | |||||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | 0 | |||||||
DELETEFLAG | Deletion Indicator | WRF_DELETE | CHAR | 1 | 0 |
Possible values
|
||||||
EPRGR | Price point group | EPRGR | TWPK | CHAR | 6 | 0 | ||||||
PRODUCTCLF | Goods Schedule Line | WRF_PRDCLF | CHAR | 2 | 0 |
Possible values
|
||||||
PRICE_GROUP | Price Level Group | PRICE_GROUP | WRF_PRGRP | CHAR | 6 | 0 | ||||||
REFERENCE | Reference Node | WRF_CDT_REF | CHAR | 18 | 0 | |||||||
RESPONSIBILITY | Responsibility | WRF_RESP | CHAR | 20 | 0 |
WRF_MATGRP_MD5 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
WRF_MATGRP_MD5 | EPRGR | WRF_MATGRP_MD5 | MANDT | TWPK | Sales price calculation: price point groups | MANDT |
WRF_MATGRP_MD5 | EPRGR | WRF_MATGRP_MD5 | EPRGR | TWPK | Sales price calculation: price point groups | EPRGR |
WRF_MATGRP_MD5 | HIER_ID | WRF_MATGRP_MD5 | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | HIER_ID |
WRF_MATGRP_MD5 | HIER_ID | WRF_MATGRP_MD5 | MANDT | WRF_MATGRP_HIER | Article Hierarchy Properties | MANDT |
WRF_MATGRP_MD5 | LINUNIT | WRF_MATGRP_MD5 | MANDT | T006 | Units of Measurement | MANDT |
WRF_MATGRP_MD5 | LINUNIT | WRF_MATGRP_MD5 | LINUNIT | T006 | Units of Measurement | MSEHI |
WRF_MATGRP_MD5 | MANDT | WRF_MATGRP_MD5 | MANDT | T000 | Clients | MANDT |
WRF_MATGRP_MD5 | PRICE_GROUP | WRF_MATGRP_MD5 | PRICE_GROUP | WRF_PRGRP | Price Level Groups | PRICE_GROUP |
WRF_MATGRP_MD5 | PRICE_GROUP | WRF_MATGRP_MD5 | MANDT | WRF_PRGRP | Price Level Groups | MANDT |
WRF_MATGRP_MD5 | ROLE | WRF_MATGRP_MD5 | MANDT | WRF_MATGRP_ROLE | Category Role | MANDT |
WRF_MATGRP_MD5 | ROLE | WRF_MATGRP_MD5 | ROLE | WRF_MATGRP_ROLE | Category Role | ROLE |
WRF_MATGRP_MD5 | SPACEUNIT | WRF_MATGRP_MD5 | MANDT | T006 | Units of Measurement | MANDT |
WRF_MATGRP_MD5 | SPACEUNIT | WRF_MATGRP_MD5 | SPACEUNIT | T006 | Units of Measurement | MSEHI |
WRF_MATGRP_MD5 | STRATEGY | WRF_MATGRP_MD5 | MANDT | WRF_MATGRP_STRA | Category Strategy | MANDT |
WRF_MATGRP_MD5 | STRATEGY | WRF_MATGRP_MD5 | STRATEGY | WRF_MATGRP_STRA | Category Strategy | STRATEGY |