WRF_MATGRP_STRCT

Transparent Table Application Table

Language-Dependent Name of a Hierarchy Node

WRF_MATGRP_STRCT is an SAP database table in S/4HANA. Language-Dependent Name of a Hierarchy Node. It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CIC_ArtHierNode view_entity left_outer Category Structure Core Entity
I_ArticleHierarchyNodeText view_entity from BASIC Article Hierarchy Node - Text
I_CategoryStrucText view from BASIC Text View for Hierarchy Node

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hier_id WRF_HIER_CNT Hierarchy
KEY node WRF_STRUC_NODE Hierarchy Node
KEY spras SPRAS Language
ltext WRF_MATGRP_TEXT2 Description
ltextg WRF_MATGRP_TEXTLG Name in Upper-Case
ltextlg WRF_MATGRP_TEXTL Long Text

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.

-- Language-Dependent Name of a Hierarchy Node
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRF_MATGRP_STRCT (
    MANDT,    -- Client [MANDT]
    HIER_ID,  -- Hierarchy [WRF_HIER_CNT]
    NODE,     -- Hierarchy Node [WRF_STRUC_NODE]
    SPRAS,    -- Language [SPRAS]
    LTEXT,    -- Description [WRF_MATGRP_TEXT2]
    LTEXTG,   -- Name in Upper-Case [WRF_MATGRP_TEXTLG]
    LTEXTLG,  -- Long Text [WRF_MATGRP_TEXTL]
    PRIMARY KEY (MANDT, HIER_ID, NODE, SPRAS)
);