MAST

Transparent Table Application Table
14 Fields 10 CDS Views

Material to BOM Link

MAST is an SAP database table in S/4HANA. Material to BOM Link. It contains 14 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_BOOPlngBOMAssignment view inner BASIC PBOM assigned to Planning Routing
I_ChgRecdWithMatl view left_outer BASIC Open Change Record Details with Material
I_DFS_DisconnectedMaterialBOM view inner BASIC Disconnected Material BOM
I_JITOutbBOM view from BASIC Bill of material details for JIT
I_Mast view from BASIC Material to BOM Link
I_MaterialBOMLink view from BASIC Material Link for Bill of Material
I_MaterialBOMLinkDEX view from BASIC Data Extraction MAST
P_ChangeHeaderDetails view inner BASIC
P_MATERIALBOMLINKDEX_2 view_entity from BASIC
RFM_PP_MBOMConstcyChkMatlLink view from

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY stlan STLAN Usage
KEY stlnr STNUM BOM
KEY stlal STALT Alternative
losvn LOSVN From Lot Size
losbs LOSBS To Lot Size
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
cslty CSLTY Configured matl
material_bom_key CS_MATBOM_KEY MBOM key

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 to BOM Link
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAST (
    MANDT,             -- Client [MANDT]
    MATNR,             -- Material [MATNR]
    WERKS,             -- Plant [WERKS_D]
    STLAN,             -- Usage [STLAN]
    STLNR,             -- BOM [STNUM]
    STLAL,             -- Alternative [STALT]
    LOSVN,             -- From Lot Size [LOSVN]
    LOSBS,             -- To Lot Size [LOSBS]
    ANDAT,             -- Created On [ANDAT]
    ANNAM,             -- Created by [ANNAM]
    AEDAT,             -- Changed On [AEDAT]
    AENAM,             -- Changed By [AENAM]
    CSLTY,             -- Configured matl [CSLTY]
    MATERIAL_BOM_KEY,  -- MBOM key [CS_MATBOM_KEY]
    PRIMARY KEY (MANDT, MATNR, WERKS, STLAN, STLNR, STLAL)
);

Learn More