WRF_MATGRP_STRUC

Transparent Table Application Table
14 Fields 2 CDS Views

Category Structure

WRF_MATGRP_STRUC is an SAP database table in S/4HANA. Category Structure. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CIC_ArtHierNode view_entity from Category Structure Core Entity
CIC_ARTHIERNODE2PRODUCT view_entity left_outer Core View on Article Hier Node2Product

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hier_id wrf_hier_cnt Hierarchy
KEY node wrf_struc_node2 Hierarchy Node
KEY date_from wrf_date_from Validity Start Date
date_to wrf_date_to Validity End Date
tree_level wrf_cdt_level Hierarchy Level
parent wrf_struc_parent Parent Node
catflg wrf_catflag Category
role wrf_catrole Role
strategy wrf_catstrategy Strategy
productclf wrf_prdclf Goods Schedule Line
price_group price_group Price Level Group
reference wrf_cdt_ref Reference Node
responsibility wrf_resp Responsibility

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.

-- Category Structure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF_MATGRP_STRUC (
    MANDT,           -- Client [mandt]
    HIER_ID,         -- Hierarchy [wrf_hier_cnt]
    NODE,            -- Hierarchy Node [wrf_struc_node2]
    DATE_FROM,       -- Validity Start Date [wrf_date_from]
    DATE_TO,         -- Validity End Date [wrf_date_to]
    TREE_LEVEL,      -- Hierarchy Level [wrf_cdt_level]
    PARENT,          -- Parent Node [wrf_struc_parent]
    CATFLG,          -- Category [wrf_catflag]
    ROLE,            -- Role [wrf_catrole]
    STRATEGY,        -- Strategy [wrf_catstrategy]
    PRODUCTCLF,      -- Goods Schedule Line [wrf_prdclf]
    PRICE_GROUP,     -- Price Level Group [price_group]
    REFERENCE,       -- Reference Node [wrf_cdt_ref]
    RESPONSIBILITY,  -- Responsibility [wrf_resp]
    PRIMARY KEY (MANDT, HIER_ID, NODE, DATE_FROM)
);

Learn More