OIU_PR_MPVD

Transparent Table Application Table
21 Fields 2 CDS Views

PRA: Measurement Point Variable Data

OIU_PR_MPVD is an SAP database table in S/4HANA. PRA: Measurement Point Variable Data. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRAMsmtPointVariableData view_entity from BASIC PRA Measurement Point Variable Data
UPOV_PR_MPVD_PRA view from Measure Point Variable Data PRA

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mp_no OIU_MP_NO Measurement Pt
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
hvcls OIB_HVCLS HV class
crud_type_cd OIU_CRUD_TYPE_CD Crude type
sa_pt_fl OIU_SA_PT_FL Sales point
inactive_fl OIU_INACTIVE_FL Inactive
op_fl OIU_OPERATOR_FL Operated
sat_dry_cd OIU_SAT_DRY_CD Saturated/Dry
intra_nwk_fl OIU_INTRA_NWK_FL Inter-Nwk Node
plt_inlet_fl OIU_PLT_INLET_FL Plant inlet
strm_type_cd OIU_STRM_TYPE_CD Multi strm type
strm_dflt_fl OIU_STRM_DFLT_FL Stream Default
rlf_usage_fl OIU_RLF_USAGE_FL RLF usage pt.
company_code BUKRS Company Code
cost_center OIUCM_KOSTL Cost Center
chrt_typ_cd OIU_CHRT_TYP_CD Chart type
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
pipl_open_pd OIU_PIPL_OPEN_PD Pipeline Open Pd

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.

-- PRA: Measurement Point Variable Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_MPVD (
    MANDT,          -- Client [MANDT]
    MP_NO,          -- Measurement Pt [OIU_MP_NO]
    EFF_FROM_DT,    -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,      -- Effective To [OIU_EFF_TO_DT]
    HVCLS,          -- HV class [OIB_HVCLS]
    CRUD_TYPE_CD,   -- Crude type [OIU_CRUD_TYPE_CD]
    SA_PT_FL,       -- Sales point [OIU_SA_PT_FL]
    INACTIVE_FL,    -- Inactive [OIU_INACTIVE_FL]
    OP_FL,          -- Operated [OIU_OPERATOR_FL]
    SAT_DRY_CD,     -- Saturated/Dry [OIU_SAT_DRY_CD]
    INTRA_NWK_FL,   -- Inter-Nwk Node [OIU_INTRA_NWK_FL]
    PLT_INLET_FL,   -- Plant inlet [OIU_PLT_INLET_FL]
    STRM_TYPE_CD,   -- Multi strm type [OIU_STRM_TYPE_CD]
    STRM_DFLT_FL,   -- Stream Default [OIU_STRM_DFLT_FL]
    RLF_USAGE_FL,   -- RLF usage pt. [OIU_RLF_USAGE_FL]
    COMPANY_CODE,   -- Company Code [BUKRS]
    COST_CENTER,    -- Cost Center [OIUCM_KOSTL]
    CHRT_TYP_CD,    -- Chart type [OIU_CHRT_TYP_CD]
    OIU_CRUSER,     -- Created By [ERNAM]
    OIU_TIMESTAMP,  -- Time Stamp [TZNTSTMPS]
    PIPL_OPEN_PD,   -- Pipeline Open Pd [OIU_PIPL_OPEN_PD]
    PRIMARY KEY (MANDT, MP_NO, EFF_FROM_DT)
);

Learn More