1. SAP Tutorial
  2. Oil & Gas

OIUP_PR_MPVL SAP table for – PRA: Measurement Point Volumetric Data (PDM Shadow)

Here we would like to draw your attention to OIUP_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). OIUP_PR_MPVL is a SAP standard transp table used for storing PRA: Measurement Point Volumetric Data (PDM Shadow) related data in SAP. It comes under the package OIU_P.

SAP OIUP_PR_MPVL table

Table OIUP_PR_MPVL technical data

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

SAP OIUP_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 OIUP_PR_MPVL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PDM_GUID : GUID in ‘CHAR’ Format in Uppercase
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • 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

    • OIUP_PR_MPVL related tables

    • OIUP_PDM_ADMIN : Administrative Data For PDM Enabled And Configured Tables
    • OIUP_PDM_ENAB_TX : PDM – Table Descriptions
    • OIUP_ME_MEDOC_IT : Measurement document item (PDM Shadow)
    • OIUP_EXE_GRP : PDM: Table Groups (Workbench Execution)
    • OIUP_SB_ACTWC : Actual Owner Level CA results at WC’s (PDM Shadow)
    • OIUP_PDM_ENABLED : PDM Enabled Tables
    • OIUP_SB_ACTMP : Actual Owner Level CA results at MP’s (PDM Shadow)
    • OIUP_PR_WCDVLH : WC Disposition Volumes Header (PDM Shadow)
    • OIUP_SYNCED_TABS : PDM – Synchronized Tables – Which Are GUARANTEED To Be Equal
    • OIUP_DBCON : PDM – Valid DB Connections
    • OIUP_MONTH_LIST : PDM – List of Possible Months
    • OIUP_SB_RNAWC : Residue and NGL actual at a WC level (PDM Shadow)
    • OIUP_PR_MPVL : PRA: Measurement Point Volumetric Data (PDM Shadow)
    • OIUP_ME_MEDOC : Measurement document header (PDM Shadow)
    • OIUP_RET_GRP_T : PDM: Table Groups Description (Retention Period)
    • OIUP_RET_ASSIGN : PDM – Group Assignment for Retention Period
    • OIUP_PDM_CONFIG : PDM Customer Configuration
    • OIUPH_RV_RJE : Journal Entry (PDM Shadow)
    • OIUP_EXE_GRP_T : PDM: Table Groups Description (Workbench Execution)
    • OIUP_DBCON_TX : PDM – Valid DB Connection Descriptions

    OIUP_PR_MPVL related transaction codes under SAP package OIU_P

    • O5UP_SET_MONTHS : Set Data Retention Periods
    • O3UP_ADMIN_WORKBENCH : PDM Administrators’ Workbench

    Related References

    Related Tutorials

    OIUP_ME_MEDOC_IT SAP table for – Measurement document item (PDM Shadow)

    OIUP_ME_MEDOC_IT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_ME_MEDOC SAP table for – Measurement document header (PDM Shadow)

    OIUP_ME_MEDOC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SB_RNAWC SAP table for – Residue and NGL actual at a WC level (PDM Shadow)

    OIUP_SB_RNAWC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIU_PR_MPVL SAP table for – PRA: Measurement Point Volumetric Data

    OIU_PR_MPVL table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SB_ENTMP SAP table for – MP level owner entitlements (PDM Shadow)

    OIUP_SB_ENTMP table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SB_ACTWC SAP table for – Actual Owner Level CA results at WC’s (PDM Shadow)

    OIUP_SB_ACTWC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SB_RNEWC SAP table for – Residue and NGL entitlements at a WC level (PDM Shadow)

    OIUP_SB_RNEWC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »