MSTA

Transparent Table Application Table
16 Fields 1 CDS Views

Material Master Status

MSTA is an SAP database table in S/4HANA. Material Master Status. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductMasterStatus view_entity from BASIC Product Master Status

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY statm STATM Maint. status
KEY zhler DZHLER Counter
ersda ERSDA Created On
ernam ERNAM Created By
laeda LAEDA Last Change
aenam AENAM Changed By
werks WERKS_D Plant
lgort LGORT_D Location
lgnum LGNUM Warehouse No.
lgtyp LGTYP Storage Type
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
bwkey BWKEY Valuation Area
bwtar BWTAR_D Valuation Type

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 Master Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MSTA (
    MANDT,  -- Client [MANDT]
    MATNR,  -- Material [MATNR]
    STATM,  -- Maint. status [STATM]
    ZHLER,  -- Counter [DZHLER]
    ERSDA,  -- Created On [ERSDA]
    ERNAM,  -- Created By [ERNAM]
    LAEDA,  -- Last Change [LAEDA]
    AENAM,  -- Changed By [AENAM]
    WERKS,  -- Plant [WERKS_D]
    LGORT,  -- Location [LGORT_D]
    LGNUM,  -- Warehouse No. [LGNUM]
    LGTYP,  -- Storage Type [LGTYP]
    VKORG,  -- Sales Org. [VKORG]
    VTWEG,  -- Distr. Channel [VTWEG]
    BWKEY,  -- Valuation Area [BWKEY]
    BWTAR,  -- Valuation Type [BWTAR_D]
    PRIMARY KEY (MANDT, MATNR, STATM, ZHLER)
);

Learn More