MATSTKDOCITMSET

Transparent Table Application Table
8 Fields 1 CDS Views

Material Document Item Set (for Output)

MATSTKDOCITMSET is an SAP database table in S/4HANA. Material Document Item Set (for Output). It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlStockDocumentItemSet view_entity from BASIC Material Document Item Set

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matdocitmset_id MATDOCITEMSETID Document Set Id
KEY matdocitmset_det_id MATDOCITEMSETELID Set Element Id
materialdocument MBLNR Material Doc.
materialdocumentyear NSDM_MJAHR Material Document Year
materialdocumentitem NSDM_MBLPO Material Document Item
stockquantity MENGE_D Quantity
materialbaseunit MEINS Base Unit

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.

-- Material Document Item Set (for Output)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATSTKDOCITMSET (
    MANDT,                 -- Client [MANDT]
    MATDOCITMSET_ID,       -- Document Set Id [MATDOCITEMSETID]
    MATDOCITMSET_DET_ID,   -- Set Element Id [MATDOCITEMSETELID]
    MATERIALDOCUMENT,      -- Material Doc. [MBLNR]
    MATERIALDOCUMENTYEAR,  -- Material Document Year [NSDM_MJAHR]
    MATERIALDOCUMENTITEM,  -- Material Document Item [NSDM_MBLPO]
    STOCKQUANTITY,         -- Quantity [MENGE_D]
    MATERIALBASEUNIT,      -- Base Unit [MEINS]
    PRIMARY KEY (MANDT, MATDOCITMSET_ID, MATDOCITMSET_DET_ID)
);

Learn More