MPE_COMP_ASSEMBL

Transparent Table Application Table
45 Fields 1 CDS Views

Component Assembly

MPE_COMP_ASSEMBL is an SAP database table in S/4HANA. Component Assembly. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderComponentAssembly view from BASIC Manufacturing Order Component Assembly

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY adoc_number mpe_comp_assembly_doc_nmbr Document Number
KEY adoc_item mpe_comp_doc_item Item Number
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
parent_sfi_id mpe_parent_sfi_id Parent SFI ID
sfi_id mpe_assembled_sfi_id Assembled Serialized Material ID
material mpe_component_matnr Component
batch charg_d Batch
pl_quantity bdmng Requirement qty
quantity kmpmg Quantity
uom meins Base Unit
action_user ru_ernam Entered by User
action_time mpe_oac_actn_time Executed On
crtn_user mpe_aenam_type Changed By
crtn_time mpe_timestampl Time Stamp
rsnum rsnum Reservation
rspos rspos Item no.
rsart rsart Record type
gm_status mpe_comp_assembly_gm_status GoodsMovStatus
msgid syst_msgid Message ID
msgno syst_msgno Message Number
msgty syst_msgty Message Type
msgv1 syst_msgv Message Variable
msgv2 syst_msgv Message Variable
msgv3 syst_msgv Message Variable
msgv4 syst_msgv Message Variable
mblnr mblnr Material Doc.
mjahr mjahr Mat. Doc. Year
mblpo mblpo Mat. Doc.Item
werks werks_d Plant
lgort lgort_d Location
is_posted_retroactively mpe_is_posted_retroactively Retroactive Action
erfmg erfmgv Qty in UnE
erfme erfme Unit of Entry
exec_oan_instance_id mpe_exec_oan_instance_id Instance ID
exec_oan_element_number mpe_exec_oan_element_number Element Number
vbeln vbeln_vl Delivery
posnr posnr_vl Item
weblnr weblnr Doc.gds mvt err
weblpos cim_count Counter
insmk mpe_insmk Stock Type
shkzg shkzg Debit/Credit
crrtn_doc_number mpe_assy_crrtn_doc_nmbr Document Number
crrtn_item_type mpe_assy_crrtn_item_type Correction Item Type

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.

-- Component Assembly
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_COMP_ASSEMBL (
    MANDT,                    -- Client [mandt]
    ADOC_NUMBER,              -- Document Number [mpe_comp_assembly_doc_nmbr]
    ADOC_ITEM,                -- Item Number [mpe_comp_doc_item]
    OAN_INSTANCE_ID,          -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,       -- Element Number [mpe_oan_element_number]
    PARENT_SFI_ID,            -- Parent SFI ID [mpe_parent_sfi_id]
    SFI_ID,                   -- Assembled Serialized Material ID [mpe_assembled_sfi_id]
    MATERIAL,                 -- Component [mpe_component_matnr]
    BATCH,                    -- Batch [charg_d]
    PL_QUANTITY,              -- Requirement qty [bdmng]
    QUANTITY,                 -- Quantity [kmpmg]
    UOM,                      -- Base Unit [meins]
    ACTION_USER,              -- Entered by User [ru_ernam]
    ACTION_TIME,              -- Executed On [mpe_oac_actn_time]
    CRTN_USER,                -- Changed By [mpe_aenam_type]
    CRTN_TIME,                -- Time Stamp [mpe_timestampl]
    RSNUM,                    -- Reservation [rsnum]
    RSPOS,                    -- Item no. [rspos]
    RSART,                    -- Record type [rsart]
    GM_STATUS,                -- GoodsMovStatus [mpe_comp_assembly_gm_status]
    MSGID,                    -- Message ID [syst_msgid]
    MSGNO,                    -- Message Number [syst_msgno]
    MSGTY,                    -- Message Type [syst_msgty]
    MSGV1,                    -- Message Variable [syst_msgv]
    MSGV2,                    -- Message Variable [syst_msgv]
    MSGV3,                    -- Message Variable [syst_msgv]
    MSGV4,                    -- Message Variable [syst_msgv]
    MBLNR,                    -- Material Doc. [mblnr]
    MJAHR,                    -- Mat. Doc. Year [mjahr]
    MBLPO,                    -- Mat. Doc.Item [mblpo]
    WERKS,                    -- Plant [werks_d]
    LGORT,                    -- Location [lgort_d]
    IS_POSTED_RETROACTIVELY,  -- Retroactive Action [mpe_is_posted_retroactively]
    ERFMG,                    -- Qty in UnE [erfmgv]
    ERFME,                    -- Unit of Entry [erfme]
    EXEC_OAN_INSTANCE_ID,     -- Instance ID [mpe_exec_oan_instance_id]
    EXEC_OAN_ELEMENT_NUMBER,  -- Element Number [mpe_exec_oan_element_number]
    VBELN,                    -- Delivery [vbeln_vl]
    POSNR,                    -- Item [posnr_vl]
    WEBLNR,                   -- Doc.gds mvt err [weblnr]
    WEBLPOS,                  -- Counter [cim_count]
    INSMK,                    -- Stock Type [mpe_insmk]
    SHKZG,                    -- Debit/Credit [shkzg]
    CRRTN_DOC_NUMBER,         -- Document Number [mpe_assy_crrtn_doc_nmbr]
    CRRTN_ITEM_TYPE,          -- Correction Item Type [mpe_assy_crrtn_item_type]
    PRIMARY KEY (MANDT, ADOC_NUMBER, ADOC_ITEM)
);

Learn More