- Home
- Resources
- SAP Tables
- MATGRP_HIER - Article Hierarchy Properties
SAP Table MATGRP_HIER
Article Hierarchy Properties
MATGRP_HIER (Article Hierarchy Properties) 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 MATGRP_HIER to other SAP tables.
Source: MATGRP_HIER (Article Hierarchy Properties)
MATGRP_HIER table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| HIER_ID |
Hierarchy ID |
HIER_CNT |
|
CHAR |
|
2 |
0 |
|
| NODE |
Hierarchy Node |
STRUC_NODE |
MATGRP_STRUC
|
CHAR |
|
18 |
0 |
|
| VKORG |
Sales Organization |
VKORG |
TVKO
|
CHAR |
|
4 |
0 |
|
| VTWEG |
Distribution Channel |
VTWEG |
TVTW
|
CHAR |
|
2 |
0 |
|
| STATUS |
Article Hierarchy Status |
CATSTATE |
|
CHAR |
|
2 |
0 |
Possible values
| 01 |
planned |
| 02 |
released |
| 03 |
deactivated |
|
| HIER_ID_AKT |
Hierarchy ID |
HIER_CNT |
|
CHAR |
|
2 |
0 |
|
| PRODFLG |
Product Hierarchy Flag |
PRODFLAG |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Flag set. Event has occurred. |
| NULL |
Flag is Not Set |
|
| MAPFLG |
MAP Flag |
MAPFLAG |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Flag set. Event has occurred. |
| NULL |
Flag is Not Set |
|
| BWFLG |
BW Flag |
BWFLAG |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Flag set. Event has occurred. |
| NULL |
Flag is Not Set |
|
| ERSDA |
Created On |
ERSDA |
|
DATS |
|
8 |
0 |
|
| LAEDA |
Date of Last Change |
LAEDA |
|
DATS |
|
8 |
0 |
|
| LAEND |
Last person to change the key figure/information item |
LAEND |
|
CHAR |
|
12 |
0 |
|
MATGRP_HIER foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| MATGRP_HIER |
MANDT |
MATGRP_HIER |
MANDT |
T000 |
Clients |
MANDT |
| MATGRP_HIER |
NODE |
MATGRP_HIER |
MANDT |
MATGRP_STRUC |
Category Structure |
MANDT |
| MATGRP_HIER |
NODE |
MATGRP_HIER |
HIER_ID |
MATGRP_STRUC |
Category Structure |
HIER_ID |
| MATGRP_HIER |
NODE |
MATGRP_HIER |
NODE |
MATGRP_STRUC |
Category Structure |
NODE |
| MATGRP_HIER |
VKORG |
MATGRP_HIER |
MANDT |
TVKO |
Organizational Unit: Sales Organizations |
MANDT |
| MATGRP_HIER |
VKORG |
MATGRP_HIER |
VKORG |
TVKO |
Organizational Unit: Sales Organizations |
VKORG |
| MATGRP_HIER |
VTWEG |
MATGRP_HIER |
MANDT |
TVTW |
Organizational Unit: Distribution Channels |
MANDT |
| MATGRP_HIER |
VTWEG |
MATGRP_HIER |
VTWEG |
TVTW |
Organizational Unit: Distribution Channels |
VTWEG |
