RECMDD_MKAL

Transparent Table Temporary Data
62 Fields 1 CDS Views

Production Versions of Material

RECMDD_MKAL is an SAP database table in S/4HANA. Production Versions of Material. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RecommendedProductionVersion view_entity from BASIC Recommended Production Version

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY recmdd_id RECMDD_ID Recommended Production Version ID
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
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
ppeguid PVS_GUID GUID
andat ANDAT Created On
annam ANNAM Created by
aedat AEDAT Changed On
aenam AENAM Changed By
lastchange_datetime CR_LASTCHANGE_DATETIME Date and Time of Last Change
status STATUS_PRV Status for Production Version
event_resp EVENTRESP Event responsible for Production Version
bo_resp BORESP Business Object responsible for Production Version

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 L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RECMDD_MKAL (
    MANDT,                -- Client [MANDT]
    MATNR,                -- Material [MATNR]
    WERKS,                -- Plant [WERKS_D]
    RECMDD_ID,            -- Recommended Production Version ID [RECMDD_ID]
    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]
    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]
    PPEGUID,              -- GUID [PVS_GUID]
    ANDAT,                -- Created On [ANDAT]
    ANNAM,                -- Created by [ANNAM]
    AEDAT,                -- Changed On [AEDAT]
    AENAM,                -- Changed By [AENAM]
    LASTCHANGE_DATETIME,  -- Date and Time of Last Change [CR_LASTCHANGE_DATETIME]
    STATUS,               -- Status for Production Version [STATUS_PRV]
    EVENT_RESP,           -- Event responsible for Production Version [EVENTRESP]
    BO_RESP,              -- Business Object responsible for Production Version [BORESP]
    PRIMARY KEY (MANDT, MATNR, WERKS, RECMDD_ID)
);

Learn More