OIU_PR_WC SAP table for – PRA: Well Completion

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

SAP OIU_PR_WC table

Table OIU_PR_WC technical data

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

SAP OIU_PR_WC 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_WC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • API_WC_NO : API well completion number
    Its data type is CHAR (Character String) with field length 3
  • NAME : Well completion name
    Its data type is CHAR (Character String) with field length 35
  • SHTXT : Description
    Its data type is CHAR (Character String) with field length 35
  • UOM_GRP : unit of measure group
    Its data type is CHAR (Character String) with field length 3
  • DEV_PGM_NO : Development program number
    Its data type is CHAR (Character String) with field length 2
  • LAT_NO : Latitude number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • LAT_DIR_CD : Latitude direction code
    Its data type is CHAR (Character String) with field length 1
  • LNG_NO : Longitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • LNG_DIR_CD : Longitude Direction Code
    Its data type is CHAR (Character String) with field length 1
  • ELEV_DPH_U : Elevation/Depth Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PLG_BCK_DPTH : Plug hole depth
    Its data type is QUAN (Quantity field) with field length 17
  • DATUM_DPTH : Datum depth
    Its data type is QUAN (Quantity field) with field length 17
  • KB_ELEV : KB elevation
    Its data type is QUAN (Quantity field) with field length 17
  • BASE_BHP_U : Base bottom hole pressure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BASE_BHP : Base bottom hole pressure (BHP)
    Its data type is QUAN (Quantity field) with field length 17
  • CNTRY_CD : Country
    Its data type is CHAR (Character String) with field length 3
  • PRI_GEO_LOC : Primary geographical location (PRI geo. loc.)
    Its data type is CHAR (Character String) with field length 2
  • SEC_GEO_LOC : Secondary geographic location
    Its data type is CHAR (Character String) with field length 3
  • RESRV : Reservoir ID
    Its data type is CHAR (Character String) with field length 10
  • RESZN : Reservoir zone
    Its data type is CHAR (Character String) with field length 10
  • FIELD : Field ID
    Its data type is CHAR (Character String) with field length 10
  • PF_NO : Platform number
    Its data type is CHAR (Character String) with field length 10
  • PUR_CD : Well purpose code
    Its data type is CHAR (Character String) with field length 1
  • LSE_LE_WL_FL : Lease line well flag
    Its data type is CHAR (Character String) with field length 1
  • BEG_PRF_DPH : Begin Perforation Depth
    Its data type is QUAN (Quantity field) with field length 17
  • END_PRF_DPH : End Performation Depth
    Its data type is QUAN (Quantity field) with field length 17
  • ALT_WC_KEY : Alternate WC Key
    Its data type is CHAR (Character String) with field length 20
  • LCL_WL_NO : Local Well Number
    Its data type is CHAR (Character String) with field length 15
  • WC_SET : Well Completion Hierarchy Group
    Its data type is CHAR (Character String) with field length 15
  • DOCNR : Well completion document number
    Its data type is CHAR (Character String) with field length 10
  • DOCYR : Document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OR1_OR_LVL_1_NO : Org. Level 1 – Company
    Its data type is CHAR (Character String) with field length 3
  • OR2_OR_LVL_2_NO : Second-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 1
  • OR3_OR_LVL_3_NO : Third-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 3
  • OR4_OR_LVL_4_NO : Fourth-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 2
  • .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