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