OIU_PR_MPVL

Transparent Table Application Table
51 Fields 2 CDS Views

PRA: Measurement Point Volumetric Data

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MeasurementPointVolume view from BASIC Measurement Point Volume
UPOV_PR_MPVL_PRA view from Measurement Point Volumetric Data (PRA)

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mpvl_no OIU_MPVL_NO Document no
KEY mpvl_year OIU_MPVL_YEAR Fiscal Year
mp_no OIU_MP_NO Measurement Pt
vt_cd OIU_VL_TYPE_CD Volume Type
vc_cd OIU_VC_CD Volume Class
trnsp_no OIU_TRNSP_NO Transporter
trnsp_ref_no OIU_TRNSP_REF_NO Trsprt.Ref.
matnr MATNR Material
freq_cd OIU_FREQ_CD Frequency
dn_no OIU_DN_NO Delivery network ID
trnsp_mth_cd OIU_TRNSP_MTH_CD Tr.Meth.Code
ct_no OIU_CT_NO Contract
tkt_no OIU_TKT_NO Ticket Number
tkt_timestamp OIU_TKT_TIMESTMP Tick. Timestmp.
prd_dt OIU_PRD_DT Production Date
ent_timestamp OIU_ENT_TIMESTMP Entr.Timestmp.
eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
meter_start OIU_METER_START Meter start
meter_stop OIU_METER_STOP Mt.stop
conv_grp OIB_UMRSL Conv. Group
tkbtry_mp_no OIU_TKBTRY_MP_NO Tk.Batt. MP.No.
vs_cd OIU_VS_CD Volume Source
vl_cat_cd OIU_VL_CAT_CD Volume Cat Cd
ld_oil_dn_no OIU_LD_OIL_DN_NO Ld Oil DN
ld_oil_wl_no OIU_LD_OIL_WL_NO Ld Oil Well
ld_oil_wc_no OIU_LD_OIL_WC_NO Ld Oil WC
ld_oil_mp_no OIU_LD_OIL_MP_NO Ld Oil MP
std_vol OIU_STD_VOL Std Volume
std_vol_u OIU_STD_VOL_U Unit
energy OIU_ENERGY Energy Qty.
energy_u OIU_ENERGY_U Energy Unit
mol_volume OIU_MOL_VOLUME Ratio/Mole %
heat_val OIU_HEAT_VAL Heat.val.factor
heat_val_u OIU_HEAT_VAL_U HV Unit
base_density OIU_BDICH Base density
base_density_u OIU_BDNEH Unit
dentyp OIU_DNTYP Dens. Type
rec_type_cd OIU_REC_TYPE_CD Record tp. code
edi_sts_cd OIU_EDI_STS_CD EDI Status Code
me_docnr OIU_ME_DOCNR DocNr
me_docyr OIU_ME_DOCYR Doc. year
orig_mp_no OIU_ORIG_MP_NO Originating MP
invt_dt OIU_INV_DT Inventory date
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
ld_oil_wo_recov OIU_LD_OIL_WO_RECOV Ld Oil w/o Recovery
status OIU_MPVL_STS_CD Status Code
draft_me_docnr OIU_ME_DOCNR DocNr
draft_me_docyr OIU_ME_DOCYR Doc. year

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 Volumetric Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_MPVL (
    MANDT,            -- Client [MANDT]
    MPVL_NO,          -- Document no [OIU_MPVL_NO]
    MPVL_YEAR,        -- Fiscal Year [OIU_MPVL_YEAR]
    MP_NO,            -- Measurement Pt [OIU_MP_NO]
    VT_CD,            -- Volume Type [OIU_VL_TYPE_CD]
    VC_CD,            -- Volume Class [OIU_VC_CD]
    TRNSP_NO,         -- Transporter [OIU_TRNSP_NO]
    TRNSP_REF_NO,     -- Trsprt.Ref. [OIU_TRNSP_REF_NO]
    MATNR,            -- Material [MATNR]
    FREQ_CD,          -- Frequency [OIU_FREQ_CD]
    DN_NO,            -- Delivery network ID [OIU_DN_NO]
    TRNSP_MTH_CD,     -- Tr.Meth.Code [OIU_TRNSP_MTH_CD]
    CT_NO,            -- Contract [OIU_CT_NO]
    TKT_NO,           -- Ticket Number [OIU_TKT_NO]
    TKT_TIMESTAMP,    -- Tick. Timestmp. [OIU_TKT_TIMESTMP]
    PRD_DT,           -- Production Date [OIU_PRD_DT]
    ENT_TIMESTAMP,    -- Entr.Timestmp. [OIU_ENT_TIMESTMP]
    EFF_FROM_DT,      -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,        -- Effective To [OIU_EFF_TO_DT]
    METER_START,      -- Meter start [OIU_METER_START]
    METER_STOP,       -- Mt.stop [OIU_METER_STOP]
    CONV_GRP,         -- Conv. Group [OIB_UMRSL]
    TKBTRY_MP_NO,     -- Tk.Batt. MP.No. [OIU_TKBTRY_MP_NO]
    VS_CD,            -- Volume Source [OIU_VS_CD]
    VL_CAT_CD,        -- Volume Cat Cd [OIU_VL_CAT_CD]
    LD_OIL_DN_NO,     -- Ld Oil DN [OIU_LD_OIL_DN_NO]
    LD_OIL_WL_NO,     -- Ld Oil Well [OIU_LD_OIL_WL_NO]
    LD_OIL_WC_NO,     -- Ld Oil WC [OIU_LD_OIL_WC_NO]
    LD_OIL_MP_NO,     -- Ld Oil MP [OIU_LD_OIL_MP_NO]
    STD_VOL,          -- Std Volume [OIU_STD_VOL]
    STD_VOL_U,        -- Unit [OIU_STD_VOL_U]
    ENERGY,           -- Energy Qty. [OIU_ENERGY]
    ENERGY_U,         -- Energy Unit [OIU_ENERGY_U]
    MOL_VOLUME,       -- Ratio/Mole % [OIU_MOL_VOLUME]
    HEAT_VAL,         -- Heat.val.factor [OIU_HEAT_VAL]
    HEAT_VAL_U,       -- HV Unit [OIU_HEAT_VAL_U]
    BASE_DENSITY,     -- Base density [OIU_BDICH]
    BASE_DENSITY_U,   -- Unit [OIU_BDNEH]
    DENTYP,           -- Dens. Type [OIU_DNTYP]
    REC_TYPE_CD,      -- Record tp. code [OIU_REC_TYPE_CD]
    EDI_STS_CD,       -- EDI Status Code [OIU_EDI_STS_CD]
    ME_DOCNR,         -- DocNr [OIU_ME_DOCNR]
    ME_DOCYR,         -- Doc. year [OIU_ME_DOCYR]
    ORIG_MP_NO,       -- Originating MP [OIU_ORIG_MP_NO]
    INVT_DT,          -- Inventory date [OIU_INV_DT]
    OIU_CRUSER,       -- Created By [ERNAM]
    OIU_TIMESTAMP,    -- Time Stamp [TZNTSTMPS]
    LD_OIL_WO_RECOV,  -- Ld Oil w/o Recovery [OIU_LD_OIL_WO_RECOV]
    STATUS,           -- Status Code [OIU_MPVL_STS_CD]
    DRAFT_ME_DOCNR,   -- DocNr [OIU_ME_DOCNR]
    DRAFT_ME_DOCYR,   -- Doc. year [OIU_ME_DOCYR]
    PRIMARY KEY (MANDT, MPVL_NO, MPVL_YEAR)
);

Learn More