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