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