MATSTKQTYSET

Transparent Table Application Table
8 Fields 1 CDS Views

Material Stock Quantity Set (for Output)

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlStockReportQuantitySet view_entity from BASIC Material Stock Report Quantity Set

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matstockquantset_id matstockquantsetid Stock QuantitySet
KEY matstockquantset_det_id matstockquantsetelid Set Element Id
material matnr Material
storagelocation lgort_d Location
inventorystocktype nsdm_lbbsa Stock Type
matlwrhsstkqtyinmatlbaseunit 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 Stock Quantity Set (for Output)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATSTKQTYSET (
    MANDT,                         -- Client [mandt]
    MATSTOCKQUANTSET_ID,           -- Stock QuantitySet [matstockquantsetid]
    MATSTOCKQUANTSET_DET_ID,       -- Set Element Id [matstockquantsetelid]
    MATERIAL,                      -- Material [matnr]
    STORAGELOCATION,               -- Location [lgort_d]
    INVENTORYSTOCKTYPE,            -- Stock Type [nsdm_lbbsa]
    MATLWRHSSTKQTYINMATLBASEUNIT,  -- Quantity [menge_d]
    MATERIALBASEUNIT,              -- Base Unit [meins]
    PRIMARY KEY (MANDT, MATSTOCKQUANTSET_ID, MATSTOCKQUANTSET_DET_ID)
);

Learn More