WRF_MATGRP_SKU

Transparent Table Application Table

Article Assignments Table

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
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)
);