OIU_PR_MPVD

Transparent Table Application Table
19 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 19 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 (19)

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
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]
    PIPL_OPEN_PD,  -- Pipeline Open Pd [oiu_pipl_open_pd]
    PRIMARY KEY (MANDT, MP_NO, EFF_FROM_DT)
);

Learn More