OIU_PR_WELL SAP table for – PRA: Well

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

SAP OIU_PR_WELL table

Table OIU_PR_WELL technical data

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

SAP OIU_PR_WELL 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_WELL 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
  • API_NO : API well number
    Its data type is CHAR (Character String) with field length 12
  • WL_DE : Well Description
    Its data type is CHAR (Character String) with field length 35
  • SHTXT : Description
    Its data type is CHAR (Character String) with field length 35
  • DEV_CD : Well drilled
    Its data type is CHAR (Character String) with field length 1
  • GLE_U : Ground level elevation unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GLE : Ground level elevation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13
  • SLOT_NO : Slot Number (Base Meridian)
    Its data type is CHAR (Character String) with field length 5
  • SUR_LAT_NO : Surface Latitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • SUR_LAT_D_CD : Surface latitude Direction
    Its data type is CHAR (Character String) with field length 1
  • SUR_LNG_NO : Surface longitude
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SUR_LNG_D_CD : Surface longitude direction code
    Its data type is CHAR (Character String) with field length 1
  • LEG_DE : Legal Description
    Its data type is CHAR (Character String) with field length 60
  • DO_DPTH_U : Drill-out depth unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DO_DPTH : Drill-out depth
    Its data type is QUAN (Quantity field) with field length 13
  • QTR_1_NO : Quarter 1 Number
    Its data type is CHAR (Character String) with field length 2
  • QTR_2_NO : Quarter 2 Number
    Its data type is CHAR (Character String) with field length 2
  • SECTION_NO : Section Number
    Its data type is CHAR (Character String) with field length 3
  • TWP_NO : Township number
    Its data type is CHAR (Character String) with field length 3
  • TWP_DIR_CD : Township direction code
    Its data type is CHAR (Character String) with field length 1
  • RNG_NO : Range number
    Its data type is CHAR (Character String) with field length 3
  • RNG_DIR_CD : Range Direction Code
    Its data type is CHAR (Character String) with field length 1
  • TARG_DPTH_U : Target depth unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TARG_DPTH : Target depth
    Its data type is QUAN (Quantity field) with field length 13
  • MMS_OWNER_CD : MMS Ownership Code
    Its data type is CHAR (Character String) with field length 1
  • WL_GRP : Well Number Range Group
    Its data type is CHAR (Character String) with field length 4
  • DOCNR : Well 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
  • .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