OIU_PR_MPVL SAP table for – PRA: Measurement Point Volumetric Data

Here we would like to draw your attention to OIU_PR_MPVL table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIU_PR_MPVL is a SAP standard transp table used for storing PRA: Measurement Point Volumetric Data related data in SAP. It comes under the package OIU.

SAP OIU_PR_MPVL table

Table OIU_PR_MPVL technical data

TableOIU_PR_MPVL
Data storingPRA: Measurement Point Volumetric Data
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_PR_MPVL Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIU_PR_MPVL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MPVL_NO : MP volume Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MPVL_YEAR : Measurement point document year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • VT_CD : Volume Type Code
    Its data type is CHAR (Character String) with field length 2
  • VC_CD : Volume class code
    Its data type is CHAR (Character String) with field length 1
  • TRNSP_NO : Transporter number
    Its data type is CHAR (Character String) with field length 10
  • TRNSP_REF_NO : Transporter Reference Number
    Its data type is CHAR (Character String) with field length 25
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • FREQ_CD : Frequency
    Its data type is CHAR (Character String) with field length 1
  • DN_NO : Delivery network number
    Its data type is CHAR (Character String) with field length 20
  • TRNSP_MTH_CD : Transportion method code
    Its data type is CHAR (Character String) with field length 1
  • CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • TKT_NO : Ticket number
    Its data type is CHAR (Character String) with field length 7
  • TKT_TIMESTAMP : Ticket timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PRD_DT : Production date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENT_TIMESTAMP : Entry timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • EFF_FROM_DT : Effective from date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • METER_START : Meter start time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • METER_STOP : Meter stop time
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CONV_GRP : Conversion Group (Oil, Natural Gas,..)
    Its data type is CHAR (Character String) with field length 4
  • TKBTRY_MP_NO : Tank battery measurement point number
    Its data type is CHAR (Character String) with field length 20
  • VS_CD : Volume Source Code
    Its data type is CHAR (Character String) with field length 1
  • VL_CAT_CD : Volume Category Code
    Its data type is CHAR (Character String) with field length 1
  • LD_OIL_DN_NO : Load oil delivery network
    Its data type is CHAR (Character String) with field length 20
  • LD_OIL_WL_NO : Load oil well number
    Its data type is CHAR (Character String) with field length 15
  • LD_OIL_WC_NO : Load oil well completion
    Its data type is CHAR (Character String) with field length 5
  • LD_OIL_MP_NO : Load oil measurement point
    Its data type is CHAR (Character String) with field length 20
  • STD_VOL : Standard volume
    Its data type is QUAN (Quantity field) with field length 13
  • STD_VOL_U : Standard volume unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ENERGY : Energy quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ENERGY_U : Energy quantity unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MOL_VOLUME : Gas mol volume
    Its data type is QUAN (Quantity field) with field length 13
  • HEAT_VAL : Heating value
    Its data type is QUAN (Quantity field) with field length 13
  • HEAT_VAL_U : Heating Value Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BASE_DENSITY : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • BASE_DENSITY_U : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DENTYP : Density Type
    Its data type is CHAR (Character String) with field length 1
  • REC_TYPE_CD : Record type code
    Its data type is CHAR (Character String) with field length 4
  • EDI_STS_CD : EDI status code
    Its data type is CHAR (Character String) with field length 1
  • ME_DOCNR : Meas. document number
    Its data type is CHAR (Character String) with field length 10
  • ME_DOCYR : Meas. document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ORIG_MP_NO : Original measurement point number
    Its data type is CHAR (Character String) with field length 20
  • INVT_DT : Inventory date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15