WRF_MATGRP_SKU

Transparent Table Application Table
8 Fields 3 CDS Views

Article Assignments Table

WRF_MATGRP_SKU is an SAP database table in S/4HANA. Article Assignments Table. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CIC_ARTHIERNODE2PRODUCT view_entity from Core View on Article Hier Node2Product
I_ArticleHierNodeArticle view_entity from BASIC Article Hierarchy Node to Article
I_ProductHierAssign view from BASIC Article Assignment Core Entity

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_id WRF_HIER_CNT Hierarchy
KEY matnr MATNR Material
KEY node WRF_STRUC_NODE Hierarchy Node
KEY date_from WRF_DATE_FROM Validity Start Date
date_to WRF_DATE_TO Validity End Date
mainflg WRF_MAIN_FLAG Main Assignment
strategy WRF_CATSTRATEGY Strategy

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 Assignments Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF_MATGRP_SKU (
    MANDT,      -- Client [MANDT]
    HIER_ID,    -- Hierarchy [WRF_HIER_CNT]
    MATNR,      -- Material [MATNR]
    NODE,       -- Hierarchy Node [WRF_STRUC_NODE]
    DATE_FROM,  -- Validity Start Date [WRF_DATE_FROM]
    DATE_TO,    -- Validity End Date [WRF_DATE_TO]
    MAINFLG,    -- Main Assignment [WRF_MAIN_FLAG]
    STRATEGY,   -- Strategy [WRF_CATSTRATEGY]
    PRIMARY KEY (MANDT, HIER_ID, MATNR, NODE, DATE_FROM)
);

Learn More