MPE_OAI_PRT_REG

Transparent Table Application Table
22 Fields 1 CDS Views

PRT Registration during OA Execution

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyInstcePRTRegistration view_entity from BASIC PRT Registration at an Operation Activity Instance

Fields (22)

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
sfi_at_oai_group_id MPE_SFI_AT_OAI_GROUP_ID Serial Number Group
objty CR_OBJTY Object Type
objid CR_OBJID Object ID
erfmg ERFMGV Qty in UnE
erfme ERFME Unit of Entry
quantity MPE_CONSUMED_QTY_IN_BASE_UNIT Cnsmd Qty / Base UoM
uom MEINS Base Unit
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

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.

-- PRT 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_PRT_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]
    SFI_AT_OAI_GROUP_ID,  -- Serial Number Group [MPE_SFI_AT_OAI_GROUP_ID]
    OBJTY,                -- Object Type [CR_OBJTY]
    OBJID,                -- Object ID [CR_OBJID]
    ERFMG,                -- Qty in UnE [ERFMGV]
    ERFME,                -- Unit of Entry [ERFME]
    QUANTITY,             -- Cnsmd Qty / Base UoM [MPE_CONSUMED_QTY_IN_BASE_UNIT]
    UOM,                  -- Base Unit [MEINS]
    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]
    PRIMARY KEY (MANDT, DOC_NMBR)
);

Learn More