SAP Table WRF_MAT_AH_ASSIGNM_STY
Material Assignment to Article Hierarchy in Table Control
WRF_MAT_AH_ASSIGNM_STY (Material Assignment to Article Hierarchy in Table Control) 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_MAT_AH_ASSIGNM_STY to other SAP tables.
WRF_MAT_AH_ASSIGNM_STY table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 | 0 | ||||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||
| NODE | Hierarchy Node | WRF_STRUC_NODE | WRF_MATGRP_STRUC | CHAR | 18 | 0 | ||||||||||||
| NODE_DESC | Description | WRF_MATGRP_TEXT2 | CHAR | 40 | 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 | |||||||||||||
| MAINFLG | Main Assignment | WRF_MAIN_FLAG | CHAR | 1 | 0 | |||||||||||||
| PARENT_NODE | Parent Node | WRF_STRUC_PARENT | CHAR | 18 | 0 | |||||||||||||
| PARENT_NODE_DESC | Description | WRF_MATGRP_TEXT2 | CHAR | 40 | 0 | |||||||||||||
| UPDKZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
WRF_MAT_AH_ASSIGNM_STY foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WRF_MAT_AH_ASSIGNM_STY | HIER_ID | SYST | MANDT | WRF_MATGRP_HIER | Article Hierarchy Properties | MANDT |
| WRF_MAT_AH_ASSIGNM_STY | HIER_ID | WRF_MAT_AH_ASSIGNM_STY | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | HIER_ID |
| WRF_MAT_AH_ASSIGNM_STY | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| WRF_MAT_AH_ASSIGNM_STY | MATNR | WRF_MAT_AH_ASSIGNM_STY | MATNR | MARA | General Material Data | MATNR |
| WRF_MAT_AH_ASSIGNM_STY | NODE | WRF_MAT_AH_ASSIGNM_STY | NODE | WRF_MATGRP_STRUC | Category Structure | NODE |
| WRF_MAT_AH_ASSIGNM_STY | NODE | * | WRF_MATGRP_STRUC | Category Structure | DATE_FROM | |
| WRF_MAT_AH_ASSIGNM_STY | NODE | SYST | MANDT | WRF_MATGRP_STRUC | Category Structure | MANDT |
| WRF_MAT_AH_ASSIGNM_STY | NODE | WRF_MAT_AH_ASSIGNM_STY | HIER_ID | WRF_MATGRP_STRUC | Category Structure | HIER_ID |
