WRF_MATGRP_HIER

Transparent Table Application Table
14 Fields 6 CDS Views

Article Hierarchy Properties

WRF_MATGRP_HIER is an SAP database table in S/4HANA. Article Hierarchy Properties. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
CIC_ArtHierDirectory view_entity from Core View on Article Hierarchy Directory
CIC_ArtHierNode view_entity left_outer Category Structure Core Entity
CIC_ARTHIERNODE2PRODUCT view_entity left_outer Core View on Article Hier Node2Product
I_ArticleHierarchy view_entity from BASIC Article Hierarchy
I_ArticleHierProperties view from BASIC Core view on Article Hier Properties
I_ProductHierAssign view inner BASIC Article Assignment Core Entity

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_id WRF_HIER_CNT Hierarchy
node WRF_STRUC_NODE Hierarchy Node
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
status WRF_CATSTATE Hierarchy Status
prodflg WRF_PRODFLAG Prdct Hier.Flag
bwflg WRF_BWFLAG BW Flag
hierflg WRF_HIERFLAG Hierarchy Flag
mltpflg WRF_MLTPFLAG Mult. Assignm. Flag
dateflg WRF_DATEFLAG Scheduling Flag
ersda ERSDA Created On
laeda LAEDA Last Change
laend LAEND Last changed by

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Article Hierarchy Properties
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF_MATGRP_HIER (
    MANDT,    -- Client [MANDT]
    HIER_ID,  -- Hierarchy [WRF_HIER_CNT]
    NODE,     -- Hierarchy Node [WRF_STRUC_NODE]
    VKORG,    -- Sales Org. [VKORG]
    VTWEG,    -- Distr. Channel [VTWEG]
    STATUS,   -- Hierarchy Status [WRF_CATSTATE]
    PRODFLG,  -- Prdct Hier.Flag [WRF_PRODFLAG]
    BWFLG,    -- BW Flag [WRF_BWFLAG]
    HIERFLG,  -- Hierarchy Flag [WRF_HIERFLAG]
    MLTPFLG,  -- Mult. Assignm. Flag [WRF_MLTPFLAG]
    DATEFLG,  -- Scheduling Flag [WRF_DATEFLAG]
    ERSDA,    -- Created On [ERSDA]
    LAEDA,    -- Last Change [LAEDA]
    LAEND,    -- Last changed by [LAEND]
    PRIMARY KEY (MANDT, HIER_ID)
);

Learn More