MPE_SOA_GRP_P_M

Transparent Table Application Table
7 Fields 1 CDS Views

Mapping of OA PRT to SFI@OA-Group PRT

MPE_SOA_GRP_P_M is an SAP database table in S/4HANA. Mapping of OA PRT to SFI@OA-Group PRT. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActySFIGrpOpActyPRTMappg view from BASIC OA to SFI at OA Group PRT Mapping

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sfi_group_id MPE_SFI_AT_OAI_GROUP_ID Serial Number Group
KEY group_pzlfh PZLFH PRT Item Count.
KEY aufpl CO_AUFPL Plan No.f.Oper.
KEY pzlfh PZLFH PRT Item Count.
KEY oan_instance_id MPE_OAN_INSTANCE_ID Instance ID
KEY oan_element_number MPE_OAN_ELEMENT_NUMBER Element Number

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.

-- Mapping of OA PRT to SFI@OA-Group PRT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MPE_SOA_GRP_P_M (
    MANDT,               -- Client [MANDT]
    SFI_GROUP_ID,        -- Serial Number Group [MPE_SFI_AT_OAI_GROUP_ID]
    GROUP_PZLFH,         -- PRT Item Count. [PZLFH]
    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]
    PRIMARY KEY (MANDT, SFI_GROUP_ID, GROUP_PZLFH, AUFPL, PZLFH, OAN_INSTANCE_ID, OAN_ELEMENT_NUMBER)
);

Learn More