MPE_BOM_PS_REL

Transparent Table Application Table
30 Fields 2 CDS Views

Serialized Product for End Item and Major Assembly

MPE_BOM_PS_REL is an SAP database table in S/4HANA. Serialized Product for End Item and Major Assembly. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgImpactOrderEffectivity view from BASIC Order Effectivity
I_EndItmMjrAssyProjSystRelshp view from BASIC BOM Proj Syst Relationshop for EI and MA

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sfi_id MPE_SFI_ID Serial.Mat. ID
matnr MATNR Material
werks WERKS_D Plant
stlnr STNUM BOM
stlal STALT Alternative
stlan STLAN Usage
bom_versn BOM_VERSION BOM Version
crtn_time MPE_TIMESTAMPL Time Stamp
techs TECHS StandardVariant
aufnr NW_AUFNR Network
parent_ma MPE_PARENTMA Parent MA
version_selection MPE_VERSION_SELECT Version Selection
project_id PS_PSPID Project def.
parent_sfi_id MPE_P_SFI_ID Parent Ser. Matl ID
explosion_date MPE_EXPLOSION_DATE Explosion Date
parent_matnr MPE_PARENT_MATNR Parent Material
parent_stlnr MPE_PARENT_STLNR Parent BOM Number
parent_stlal MPE_PARENT_STLAL Parent Altern. BOM
parent_stlan MPE_PARENT_STLAN Parent BOM Usage
parent_bom_versn MPE_PARENT_BOM_VERSN Parent BOM Version
parent_stlkn MPE_PARENT_STLKN Parent BOM Item Node
parent_stvkn MPE_PARENT_STVKN Parent Item Node
parent_aufpl MPE_PARENT_AUFPL Parent Rtg No. Ops.
parent_aplzl MPE_PARENT_APLZL Parent Counter
ismanetwork MPE_ISMANETWORK MA Network
projassign MPE_PROJASSIGN Assignment
wbselement PS_POSID WBS Element
isnonwreq MPE_NONWREQ No Network Required
bgprocstatus MPE_MAPROJ_PROC_STATUS Backgr. Procg Status

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.

-- Serialized Product for End Item and Major Assembly
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_BOM_PS_REL (
    MANDT,              -- Client [MANDT]
    SFI_ID,             -- Serial.Mat. ID [MPE_SFI_ID]
    MATNR,              -- Material [MATNR]
    WERKS,              -- Plant [WERKS_D]
    STLNR,              -- BOM [STNUM]
    STLAL,              -- Alternative [STALT]
    STLAN,              -- Usage [STLAN]
    BOM_VERSN,          -- BOM Version [BOM_VERSION]
    CRTN_TIME,          -- Time Stamp [MPE_TIMESTAMPL]
    TECHS,              -- StandardVariant [TECHS]
    AUFNR,              -- Network [NW_AUFNR]
    PARENT_MA,          -- Parent MA [MPE_PARENTMA]
    VERSION_SELECTION,  -- Version Selection [MPE_VERSION_SELECT]
    PROJECT_ID,         -- Project def. [PS_PSPID]
    PARENT_SFI_ID,      -- Parent Ser. Matl ID [MPE_P_SFI_ID]
    EXPLOSION_DATE,     -- Explosion Date [MPE_EXPLOSION_DATE]
    PARENT_MATNR,       -- Parent Material [MPE_PARENT_MATNR]
    PARENT_STLNR,       -- Parent BOM Number [MPE_PARENT_STLNR]
    PARENT_STLAL,       -- Parent Altern. BOM [MPE_PARENT_STLAL]
    PARENT_STLAN,       -- Parent BOM Usage [MPE_PARENT_STLAN]
    PARENT_BOM_VERSN,   -- Parent BOM Version [MPE_PARENT_BOM_VERSN]
    PARENT_STLKN,       -- Parent BOM Item Node [MPE_PARENT_STLKN]
    PARENT_STVKN,       -- Parent Item Node [MPE_PARENT_STVKN]
    PARENT_AUFPL,       -- Parent Rtg No. Ops. [MPE_PARENT_AUFPL]
    PARENT_APLZL,       -- Parent Counter [MPE_PARENT_APLZL]
    ISMANETWORK,        -- MA Network [MPE_ISMANETWORK]
    PROJASSIGN,         -- Assignment [MPE_PROJASSIGN]
    WBSELEMENT,         -- WBS Element [PS_POSID]
    ISNONWREQ,          -- No Network Required [MPE_NONWREQ]
    BGPROCSTATUS,       -- Backgr. Procg Status [MPE_MAPROJ_PROC_STATUS]
    PRIMARY KEY (MANDT, SFI_ID)
);

Learn More