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