MPE_OAN_ELEMENT

Transparent Table Application Table
16 Fields 2 CDS Views

OAN Elements

MPE_OAN_ELEMENT is an SAP database table in S/4HANA. OAN Elements. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OpActyNtwkElement view from BASIC Operation Activity Network Element
V_SFIAtOpActyMissingStatus view inner Missing Status of SFI at Opearion Activity

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY oan_id mpe_oan_id OAN ID
KEY oan_version_no mpe_oan_version_no OAN Version
KEY oan_element_number mpe_oan_element_number Element Number
oan_element_number_ext mpe_oan_element_number_ext Op. Activity
element_id mpe_oan_element_id OAN Element ID
element_version_no mpe_oan_element_version_no Element Version
element_type mpe_oan_element_type Element Type
display_order mpe_oan_element_display_order Position in OAN
aennr cp_aennr Change Number
has_buyoff mpe_rtg_has_buyoff Buyoffs Exist
has_lcomp mpe_rtg_has_lcomp Logical Components
has_qualif mpe_rtg_has_qualif Qualifications Exist
has_workinstr mpe_rtg_has_workinstr Work Instructions
has_predecessors mpe_rtg_has_predecessors Relationships Exist
has_successors mpe_rtg_has_successors Successors Exist

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.

-- OAN Elements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OAN_ELEMENT (
    MANDT,                   -- Client [mandt]
    OAN_ID,                  -- OAN ID [mpe_oan_id]
    OAN_VERSION_NO,          -- OAN Version [mpe_oan_version_no]
    OAN_ELEMENT_NUMBER,      -- Element Number [mpe_oan_element_number]
    OAN_ELEMENT_NUMBER_EXT,  -- Op. Activity [mpe_oan_element_number_ext]
    ELEMENT_ID,              -- OAN Element ID [mpe_oan_element_id]
    ELEMENT_VERSION_NO,      -- Element Version [mpe_oan_element_version_no]
    ELEMENT_TYPE,            -- Element Type [mpe_oan_element_type]
    DISPLAY_ORDER,           -- Position in OAN [mpe_oan_element_display_order]
    AENNR,                   -- Change Number [cp_aennr]
    HAS_BUYOFF,              -- Buyoffs Exist [mpe_rtg_has_buyoff]
    HAS_LCOMP,               -- Logical Components [mpe_rtg_has_lcomp]
    HAS_QUALIF,              -- Qualifications Exist [mpe_rtg_has_qualif]
    HAS_WORKINSTR,           -- Work Instructions [mpe_rtg_has_workinstr]
    HAS_PREDECESSORS,        -- Relationships Exist [mpe_rtg_has_predecessors]
    HAS_SUCCESSORS,          -- Successors Exist [mpe_rtg_has_successors]
    PRIMARY KEY (MANDT, OAN_ID, OAN_VERSION_NO, OAN_ELEMENT_NUMBER)
);

Learn More