MPE_OPER_DETAILS

Transparent Table Application Table
34 Fields 3 CDS Views

MPE Data for Operations

MPE_OPER_DETAILS is an SAP database table in S/4HANA. MPE Data for Operations. It contains 34 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BOOOperationChgStOANBasic view from BASIC BOO Operation Change State OAN Basic
I_ProdnModOpActyCompBasic view_entity inner BASIC OAC Keys and basic data
I_ProdnModOpActyCompInstceBsc view_entity inner BASIC OACI Keys and basic data

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plnty PLNTY Task List Type
KEY plnnr PLNNR Group
KEY plnkn PLNKN Node
KEY counter CIM_COUNT Counter
versn PLNVERSN Routing Version
set_versn_track_guid CP_GUID Guid
oan_id_setup MPE_OAN_ID OAN ID
oan_version_setup MPE_OAN_VERSION_NO OAN Version
oan_id_produce MPE_OAN_ID OAN ID
oan_version_produce MPE_OAN_VERSION_NO OAN Version
oan_id_teardown MPE_OAN_ID OAN ID
oan_version_teardown MPE_OAN_VERSION_NO OAN Version
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
has_eqc_relevance MPE_RTG_HAS_EQC_RELEVANCE EQC Relevant
wempf WEMPF Recipient
ablad ABLAD Unloading Point
plnty_reft PLNTY Task List Type
plnnr_reft MPE_RTG_REFT_GROUP Template Group
plnal_reft MPE_RTG_REFT_VARIANT Group Counter
versn_reft MPE_RTG_REFT_VERSION Template Versn
plnfl_reft PLNFOLGE Sequence
plnkn_reft MPE_RTG_REFT_PLNKN Node
plnty_reft_old PLNTY Task List Type
plnnr_reft_old MPE_RTG_REFT_GROUP Template Group
plnal_reft_old MPE_RTG_REFT_VARIANT Group Counter
versn_reft_old MPE_RTG_REFT_VERSION Template Versn
plnfl_reft_old PLNFOLGE Sequence
plnkn_reft_old MPE_RTG_REFT_PLNKN Node

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.

-- MPE Data for Operations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_OPER_DETAILS (
    MANDT,                 -- Client [MANDT]
    PLNTY,                 -- Task List Type [PLNTY]
    PLNNR,                 -- Group [PLNNR]
    PLNKN,                 -- Node [PLNKN]
    COUNTER,               -- Counter [CIM_COUNT]
    VERSN,                 -- Routing Version [PLNVERSN]
    SET_VERSN_TRACK_GUID,  -- Guid [CP_GUID]
    OAN_ID_SETUP,          -- OAN ID [MPE_OAN_ID]
    OAN_VERSION_SETUP,     -- OAN Version [MPE_OAN_VERSION_NO]
    OAN_ID_PRODUCE,        -- OAN ID [MPE_OAN_ID]
    OAN_VERSION_PRODUCE,   -- OAN Version [MPE_OAN_VERSION_NO]
    OAN_ID_TEARDOWN,       -- OAN ID [MPE_OAN_ID]
    OAN_VERSION_TEARDOWN,  -- OAN Version [MPE_OAN_VERSION_NO]
    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]
    HAS_EQC_RELEVANCE,     -- EQC Relevant [MPE_RTG_HAS_EQC_RELEVANCE]
    WEMPF,                 -- Recipient [WEMPF]
    ABLAD,                 -- Unloading Point [ABLAD]
    PLNTY_REFT,            -- Task List Type [PLNTY]
    PLNNR_REFT,            -- Template Group [MPE_RTG_REFT_GROUP]
    PLNAL_REFT,            -- Group Counter [MPE_RTG_REFT_VARIANT]
    VERSN_REFT,            -- Template Versn [MPE_RTG_REFT_VERSION]
    PLNFL_REFT,            -- Sequence [PLNFOLGE]
    PLNKN_REFT,            -- Node [MPE_RTG_REFT_PLNKN]
    PLNTY_REFT_OLD,        -- Task List Type [PLNTY]
    PLNNR_REFT_OLD,        -- Template Group [MPE_RTG_REFT_GROUP]
    PLNAL_REFT_OLD,        -- Group Counter [MPE_RTG_REFT_VARIANT]
    VERSN_REFT_OLD,        -- Template Versn [MPE_RTG_REFT_VERSION]
    PLNFL_REFT_OLD,        -- Sequence [PLNFOLGE]
    PLNKN_REFT_OLD,        -- Node [MPE_RTG_REFT_PLNKN]
    PRIMARY KEY (MANDT, PLNTY, PLNNR, PLNKN, COUNTER)
);

Learn More