SAP table WRF_MATGRP_STRUC (Category Structure)

SAP table WRF_MATGRP_STRUC has 4 primary key fields being MANDT,HIER_ID,NODE,DATE_FROM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
HIER_ID Hierarchy CHAR 2 0 WRF_MATGRP_HIER WRF_HIER_CNT
NODE Hierarchy Node CHAR 18 0 WRF_STRUC_NODE2
DATE_FROM Validity Start Date of Assignment in Article Hierarchy DATS 8 0 WRF_DATE_FROM
DATE_TO Validity End Date of Assignment in Article Hierarchy DATS 8 0 WRF_DATE_TO
TREE_LEVEL Hierarchy Level NUMC 2 0 WRF_CDT_LEVEL
PARENT Parent Node CHAR 18 0 WRF_STRUC_PARENT
CATFLG Category Flag CHAR 1 0 WRF_CATFLAG
ROLE Category Role CHAR 20 0 WRF_CATROLE
STRATEGY Node Strategy CHAR 20 0 WRF_CATSTRATEGY
PRODUCTCLF Goods Schedule Line CHAR 2 0 WRF_PRDCLF
01 Fashion Materials
02 Basic Materials
PRICE_GROUP Price Level Group CHAR 6 0 * PRICE_GROUP
REFERENCE Reference Node CHAR 18 0 WRF_CDT_REF
RESPONSIBILITY Responsibility CHAR 20 0 WRF_RESP

WRF_MATGRP_STRUC foreign key relationships

Table Field Check Table Check Field
0 WRF_MATGRP_STRUC HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties MANDT
0 WRF_MATGRP_STRUC HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties HIER_ID