OIU_PR_WCVD SAP table for – Well Completion Variable Data

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

SAP OIU_PR_WCVD table

Table OIU_PR_WCVD technical data

TableOIU_PR_WCVD
Data storingWell Completion Variable Data
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_PR_WCVD 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_WCVD 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
  • EFF_FROM_DT : Effective from date
    Its a key field. 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
  • HVCLS : Heating value class (calorific value class)
    Its data type is CHAR (Character String) with field length 2
  • CRUD_TYPE_CD : Crude type code
    Its data type is CHAR (Character String) with field length 2
  • OP_FL : Operated flag
    Its data type is CHAR (Character String) with field length 1
  • CONTN_FL : Continuous Flag
    Its data type is CHAR (Character String) with field length 1
  • WL_COUNT : Well count
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PRD_MTH_CD : Producing method code
    Its data type is CHAR (Character String) with field length 2
  • WL_CLASS_CD : Well class code
    Its data type is CHAR (Character String) with field length 2
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • COST_CENTER : PRA Cost Center
    Its data type is CHAR (Character String) with field length 10
  • OPERATOR : Operator
    Its data type is CHAR (Character String) with field length 10
  • STATUS_CD : Well completion status code
    Its data type is CHAR (Character String) with field length 2
  • PSPNR : WBS Element
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • EXT_LOSS_PC : Ext. Loss Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • .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