MPE_OAI_EQUI_REG

Transparent Table Application Table
20 Fields 1 CDS Views

Equipment Registration during OA Execution

MPE_OAI_EQUI_REG is an SAP database table in S/4HANA. Equipment Registration during OA Execution. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyInstceEquipRegn view_entity from BASIC Equipment Registration at an OA Instance

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY doc_nmbr mpe_doc_nmbr Document Number
aufpl co_aufpl Plan No.f.Oper.
pzlfh pzlfh PRT Item Count.
oan_instance_id mpe_oan_instance_id Instance ID
oan_element_number mpe_oan_element_number Element Number
sfi_id mpe_sfi_id Serial.Mat. ID
equnr equnr Equipment
sfi_at_oai_group_id mpe_sfi_at_oai_group_id Serial Number Group
action_user ru_ernam Entered by User
action_time mpe_oac_actn_time Executed On
created_by mpe_create_user Created By
created_at mpe_create_timestampl Created On
katalogart qkatart Catalog
codegruppe qcodegrp Code Group
code qcode Code
version qversnr Version
is_reversed mpe_is_reversed Reversed
is_reversal mpe_is_reversal Reversal
rvsd_doc_nmbr mpe_reversed_doc_nmbr Reversed Document

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.

-- Equipment Registration during OA Execution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OAI_EQUI_REG (
    MANDT,                -- Client [mandt]
    DOC_NMBR,             -- Document Number [mpe_doc_nmbr]
    AUFPL,                -- Plan No.f.Oper. [co_aufpl]
    PZLFH,                -- PRT Item Count. [pzlfh]
    OAN_INSTANCE_ID,      -- Instance ID [mpe_oan_instance_id]
    OAN_ELEMENT_NUMBER,   -- Element Number [mpe_oan_element_number]
    SFI_ID,               -- Serial.Mat. ID [mpe_sfi_id]
    EQUNR,                -- Equipment [equnr]
    SFI_AT_OAI_GROUP_ID,  -- Serial Number Group [mpe_sfi_at_oai_group_id]
    ACTION_USER,          -- Entered by User [ru_ernam]
    ACTION_TIME,          -- Executed On [mpe_oac_actn_time]
    CREATED_BY,           -- Created By [mpe_create_user]
    CREATED_AT,           -- Created On [mpe_create_timestampl]
    KATALOGART,           -- Catalog [qkatart]
    CODEGRUPPE,           -- Code Group [qcodegrp]
    CODE,                 -- Code [qcode]
    VERSION,              -- Version [qversnr]
    IS_REVERSED,          -- Reversed [mpe_is_reversed]
    IS_REVERSAL,          -- Reversal [mpe_is_reversal]
    RVSD_DOC_NMBR,        -- Reversed Document [mpe_reversed_doc_nmbr]
    PRIMARY KEY (MANDT, DOC_NMBR)
);

Learn More