MKAL

Transparent Table Application Table
55 Fields 8 CDS Views

Production Versions of Material

MKAL is an SAP database table in S/4HANA. Production Versions of Material. It contains 55 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
e_mrp_mfg_comps view left_outer
I_ProductionVersion view_entity from BASIC Production Version
I_ProductionVersionBasic view from BASIC Production Version Basic
I_SchedProdnProductionVersion view from BASIC Schedule Production Production Versions
P_CostingProductionVersionVH view from BASIC
pp_mrp_read_mfg_order_comp view left_outer Read Manufacturing Order Components
pp_mrp_read_planned_order_comp view left_outer Read Planned Order Components
Pph_Ddl_Mkal view from Production Version as Source of Supply

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY verid VERID Prod. Version
bdatu BDATM Valid To
adatu ADATM Valid from
stlal STALT Alternative
stlan STLAN Usage
plnty PLNTY Task List Type
plnnr PLNNR Group
alnal PLNAL Group Counter
beskz BESKZ Procurement
sobsl SOBSL Special Procur.
losgr CK_LOSGR Cstg Lot Size
mdv01 SA_LINE1 Production Line
mdv02 MDV Planning ID
text1 VERS_TEXT Prodn Version Text
ewahr CK_EWAHR Usg Probability
verto SA_VERTO Distribution
serkz SA_VERSI REM Allowed
bstmi SA_LOSVN From Lot Size
bstma SA_LOSBS To Lot Size
rgekz SA_RGEKZ Backflush
alort ALORT Receiving SLoc
pltyg PLNTY Task List Type
plnng RATENPLAN Rate-based plng grp
alnag PLNAL Group Counter
pltym PLNTY Task List Type
plnnm GROBPLAN Rough-cut plng grp
alnam PLNAL Group Counter
csplt CSPLIT Apportionment
matko MKAL_MATKO Header material
elpro SA_ELPRO Issue stor.loc.
prvbe SA_PRVBE Supply Area
prfg_f PRFG_F Check Status
prdat MKPRDAT Date of last check
mksp MKSP Prodn Version Lock
prfg_r PRFG_R CheckStsRatebasePlan
prfg_g PRFG_G CheckStatus PrePlan
prfg_s PRFG_S Check sts, BOM
ucmat VBOB_OB_RFMAT OB ref. matrial
versind MPE_PV_VERSIND BOM/RTG Vers. Exists
configblprodprodnvers CONFIGURABLE_PRODUCT_VERID Production Version of Corresponding Configurable Product
diffplanexemstr MPE_PV_DIFFPLANEXEMSTR Plng Exec Mstr Diff
ewm_lgnum /SCWM/LGNUM Warehouse No.
ewm_lgpla /SCWM/LTAP_NLPLA Destination Bin
exe_stlal MPE_PV_EXE_STLAL SF BOM Alt.
exe_stlan MPE_PV_EXE_STLAN SF BOM Usage
exe_plnty MPE_PV_EXE_PLNTY Task list Type
exe_plnnr MPE_PV_EXE_PLNNR Tasklist Group
exe_alnal MPE_PV_EXE_ALNAL Group Counter
tsa_prvbe TSA_PRVBE Target PSA
pnguid NJIT_PVS_PNGUID Line Network GUID
dummy_mkal_incl_eew_ps CFD_DUMMY Dummy
ppeguid PVS_GUID GUID

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.

-- Production Versions of Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MKAL (
    MANDT,                   -- Client [MANDT]
    MATNR,                   -- Material [MATNR]
    WERKS,                   -- Plant [WERKS_D]
    VERID,                   -- Prod. Version [VERID]
    BDATU,                   -- Valid To [BDATM]
    ADATU,                   -- Valid from [ADATM]
    STLAL,                   -- Alternative [STALT]
    STLAN,                   -- Usage [STLAN]
    PLNTY,                   -- Task List Type [PLNTY]
    PLNNR,                   -- Group [PLNNR]
    ALNAL,                   -- Group Counter [PLNAL]
    BESKZ,                   -- Procurement [BESKZ]
    SOBSL,                   -- Special Procur. [SOBSL]
    LOSGR,                   -- Cstg Lot Size [CK_LOSGR]
    MDV01,                   -- Production Line [SA_LINE1]
    MDV02,                   -- Planning ID [MDV]
    TEXT1,                   -- Prodn Version Text [VERS_TEXT]
    EWAHR,                   -- Usg Probability [CK_EWAHR]
    VERTO,                   -- Distribution [SA_VERTO]
    SERKZ,                   -- REM Allowed [SA_VERSI]
    BSTMI,                   -- From Lot Size [SA_LOSVN]
    BSTMA,                   -- To Lot Size [SA_LOSBS]
    RGEKZ,                   -- Backflush [SA_RGEKZ]
    ALORT,                   -- Receiving SLoc [ALORT]
    PLTYG,                   -- Task List Type [PLNTY]
    PLNNG,                   -- Rate-based plng grp [RATENPLAN]
    ALNAG,                   -- Group Counter [PLNAL]
    PLTYM,                   -- Task List Type [PLNTY]
    PLNNM,                   -- Rough-cut plng grp [GROBPLAN]
    ALNAM,                   -- Group Counter [PLNAL]
    CSPLT,                   -- Apportionment [CSPLIT]
    MATKO,                   -- Header material [MKAL_MATKO]
    ELPRO,                   -- Issue stor.loc. [SA_ELPRO]
    PRVBE,                   -- Supply Area [SA_PRVBE]
    PRFG_F,                  -- Check Status [PRFG_F]
    PRDAT,                   -- Date of last check [MKPRDAT]
    MKSP,                    -- Prodn Version Lock [MKSP]
    PRFG_R,                  -- CheckStsRatebasePlan [PRFG_R]
    PRFG_G,                  -- CheckStatus PrePlan [PRFG_G]
    PRFG_S,                  -- Check sts, BOM [PRFG_S]
    UCMAT,                   -- OB ref. matrial [VBOB_OB_RFMAT]
    VERSIND,                 -- BOM/RTG Vers. Exists [MPE_PV_VERSIND]
    CONFIGBLPRODPRODNVERS,   -- Production Version of Corresponding Configurable Product [CONFIGURABLE_PRODUCT_VERID]
    DIFFPLANEXEMSTR,         -- Plng Exec Mstr Diff [MPE_PV_DIFFPLANEXEMSTR]
    EWM_LGNUM,               -- Warehouse No. [/SCWM/LGNUM]
    EWM_LGPLA,               -- Destination Bin [/SCWM/LTAP_NLPLA]
    EXE_STLAL,               -- SF BOM Alt. [MPE_PV_EXE_STLAL]
    EXE_STLAN,               -- SF BOM Usage [MPE_PV_EXE_STLAN]
    EXE_PLNTY,               -- Task list Type [MPE_PV_EXE_PLNTY]
    EXE_PLNNR,               -- Tasklist Group [MPE_PV_EXE_PLNNR]
    EXE_ALNAL,               -- Group Counter [MPE_PV_EXE_ALNAL]
    TSA_PRVBE,               -- Target PSA [TSA_PRVBE]
    PNGUID,                  -- Line Network GUID [NJIT_PVS_PNGUID]
    DUMMY_MKAL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PPEGUID,                 -- GUID [PVS_GUID]
    PRIMARY KEY (MANDT, MATNR, WERKS, VERID)
);

Learn More