1. SAP Tutorial
  2. Oil & Gas

OIU_PR_TWCDVH SAP table for – Temporary Well Completion Volumes

Here we would like to draw your attention to OIU_PR_TWCDVH 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_TWCDVH is a SAP standard transp table used for storing Temporary Well Completion Volumes related data in SAP. It comes under the package OIU.

SAP OIU_PR_TWCDVH table

Table OIU_PR_TWCDVH technical data

TableOIU_PR_TWCDVH
Data storingTemporary Well Completion Volumes
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_PR_TWCDVH 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_TWCDVH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • WCDVLH_NO : Well Completion Delivery Volume Header Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DOC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Structure for WC delivery volumes
  • WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • DN_NO : Delivery network number
    Its data type is CHAR (Character String) with field length 20
  • 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
  • PRD_DT : Production date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PRD_MATNR : Production Material
    Its data type is CHAR (Character String) with field length 18
  • 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
  • TKBTRY_MP_NO : Tank battery 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
  • VS_CD : Volume Source 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
  • REC_TYPE_CD : Record type code
    Its data type is CHAR (Character String) with field length 4
  • DAYS_PROD : Days produced
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRD_HRS : Production hours
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TKT_NO : Ticket number
    Its data type is CHAR (Character String) with field length 7
  • TKT_TIMESTAMP : Ticket Timestamp (Date)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ORIG_MP_NO : Original measurement point number
    Its data type is CHAR (Character String) with field length 20
  • ORIG_MP_DOC_NO : Original MP document no
    Its data type is CHAR (Character String) with field length 10
  • ORIG_MP_DOC_YEAR : Original document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • THEO_U : Theoretical Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • THEO : Theoretical Volume
    Its data type is QUAN (Quantity field) with field length 13
  • CONV_GRP : Conversion Group (Oil, Natural Gas,..)
    Its data type is CHAR (Character String) with field length 4
  • STD_VOL_U : Standard volume unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • STD_VOL : Standard volume
    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
  • ENERGY : Energy quantity
    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
  • HEAT_VAL : Heating value
    Its data type is QUAN (Quantity field) with field length 13
  • 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
  • MOL_VOLUME : Gas mol volume
    Its data type is QUAN (Quantity field) with field length 13
  • INVT_DT : Inventory date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XREF_WL_NO : Cross-Reference Well Number
    Its data type is CHAR (Character String) with field length 15
  • XREF_WC_NO : Cross-Reference Wellcompletion Number
    Its data type is CHAR (Character String) with field length 5
  • ORIG_NO : Original WCDVL No (Well Completion Daily Volume)
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • ORIG_DOC_YEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .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
  • VL_CAT_CD : Volume Category Code
    Its data type is CHAR (Character String) with field length 1
  • XFER_MP_NO : Transfer Measurement Point
    Its data type is CHAR (Character String) with field length 20
  • GPLT_PAM_CD : Gas Plant Plant Allocation Method
    Its data type is CHAR (Character String) with field length 7
  • MAJPD_CD : Major product code
    Its data type is CHAR (Character String) with field length 1

    • OIU_PR_TWCDVH related tables

    • OIU_PR_CMPND_TX : Chemical Compound Descriptions
    • OIU_CM_SEVTTY : Severance Tax Types – TBLRV014
    • OIU_SB_OAHMP : Owner Availability Header: Measurement Points
    • OIU_CM_CTCAT_TX : Contract Category
    • OIU_CM_INTCAT_TX : Interest Category
    • OIU_CM_EIA_CD : Energy Information Agency Code Table – TBLCS037
    • OIU_PR_RESRV : PRA: Reservoir
    • OIU_PR_TCM : THEORETICAL CALCULATION METHODS TABLE – TBLPR008
    • OIU_CM_VNAMST_TX : PRA Venture Status Description – (TBLRV047)
    • OIUREP_OWNER_LOG : Log for master Data Owner Changes
    • OIUXI_PPNH : XI: Prior Period Notification Header
    • OIU_RV_FRMLD : Valuation Formula Detail
    • OIU_PR_WL_GRP : PRA: Well Group Codes
    • OIU_CM_REJCD : Reject Reason Code Table – TBLRV027
    • OIU_CM_DSK_CD_TX : CONTRACT DESK CODES – TBLMK026 – TEXT
    • OIU_ME_UOM_GR : PRA Measurement: Unit of Measurement Groups
    • OIU_PR_LWGOR : Lease Wide Gas/Oil Ratio
    • OIU_RV_GRAVIDT : Gravity table text
    • OIU_PR_VLSRC : VOLUME SOURCE – TBLCM029
    • OIU_ME_FPARM : Measurement calculation function parameters

    OIU_PR_TWCDVH related transaction codes under SAP package OIU

    • O3U_MP1 : Create Measurement Point
    • O3U_MPVL1 : Create Measurement Point Volumes
    • O3U_PF2 : Platform Maintenance Change
    • O3U_OMPMRA : M.Pt. Meas.Reading assignment
    • O3U_WCDC6 : Delete WC Downhole Commingled
    • O3U_CHA9 : Chemical Analysis List
    • O3U_CA013 : Display Marketing Group Assignment
    • O3U_CA023 : Display Allocation Cross Reference
    • O3U_DN2 : Update Delivery Network
    • O3U_SCM3 : Display Gravity Scale Defintion
    • O3U_WLTS2 : Well Test Change
    • O3U_CA071 : Create SPF Statement Volumes
    • O3U_WCDT2 : Change WC Downtime
    • O3U_WCDVL6 : Delete wc volumes
    • O3U_DN1 : Create Delivery Network
    • O3U_LWGOR3 : Display Lease Wide GOR
    • O3U_BLTMPL : CT Vol by MP Build Template
    • O3U_SS3 : Display Supply Source
    • O3U_DNAP3 : DISPLAY DN ALLOCATION PROFILE
    • O3U_CPAM2 : Change Custom Plant Allocation Mth

    Related References

    Related Tutorials

    OIU_PR_WCDVLH SAP table for – Well Completion Disposition Volumes Header

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

    OIU_PR_WVMTD SAP table for – Well Completion Volumes Measurement Type Determination

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

    O3U_WCDVL9 SAP tcode for – Well Completion Volumes List

    O3U_WCDVL9 tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Well Completion...

    OIUP_PR_WCDVLH SAP table for – WC Disposition Volumes Header (PDM Shadow)

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

    OIU_SB_CTRMP SAP table for – Volumes for sale

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

    OIU_SB_CTRMP_T SAP table for – Volumes for sale

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

    OIU_SB_CTRWC_T SAP table for – Volumes for sale

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

    «
    »