OIU_PR_MPAPH

Transparent Table Application Table

Measure Point Allocation Profile Header

OIU_PR_MPAPH is an SAP database table in S/4HANA. Measure Point Allocation Profile Header. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAMsmtPtAllocProfileHeader view_entity from BASIC Measure Point Allocation Profile Header
UPOV_PR_MPAPH_PRA view from PRA: Measurement Point Allocation Header

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mp_no OIU_MP_NO Measurement Pt
KEY dn_no OIU_DN_NO Delivery network ID
KEY freq_cd OIU_FREQ_CD Frequency
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
mpaph_no OIU_MPAPH_NO MP alloc no
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

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.

-- Measure Point Allocation Profile Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_MPAPH (
    MANDT,          -- Client [MANDT]
    MP_NO,          -- Measurement Pt [OIU_MP_NO]
    DN_NO,          -- Delivery network ID [OIU_DN_NO]
    FREQ_CD,        -- Frequency [OIU_FREQ_CD]
    EFF_FROM_DT,    -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,      -- Effective To [OIU_EFF_TO_DT]
    MPAPH_NO,       -- MP alloc no [OIU_MPAPH_NO]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, MP_NO, DN_NO, FREQ_CD, EFF_FROM_DT)
);