OIU_RV_CGPT SAP table for – Contract General Price Terms

Here we would like to draw your attention to OIU_RV_CGPT 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_RV_CGPT is a SAP standard transp table used for storing Contract General Price Terms related data in SAP. It comes under the package OIU.

SAP OIU_RV_CGPT table

Table OIU_RV_CGPT technical data

TableOIU_RV_CGPT
Data storingContract General Price Terms
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIU_RV_CGPT 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_RV_CGPT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • 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
  • MAJPD_CD : Major product code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • 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
  • CGPT_NO : Contract General Price Terms No
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • VBAS_CD : Volume Basis Code
    Its data type is CHAR (Character String) with field length 1
  • UOM_VE : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PS_BASE_QY : Pressure Base
    Its data type is QUAN (Quantity field) with field length 13
  • PS_BASE_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HEAT_VALUE_CL : Heating value class (calorific value class)
    Its data type is CHAR (Character String) with field length 2
  • HEAT_VALUE_FCT : Heating value
    Its data type is QUAN (Quantity field) with field length 13
  • HEAT_VALUE_FCT_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ALT_DENSITY_QY : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • DENSITY_U : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DNTYP : Density Type
    Its data type is CHAR (Character String) with field length 1
  • BRAND_CD : Brand Code
    Its data type is CHAR (Character String) with field length 4
  • STNDEDQ_CD : Varying/Equ Daily Qu
    Its data type is CHAR (Character String) with field length 1
  • PRC_TYPE : Price Types
    Its data type is CHAR (Character String) with field length 2
  • PRC_METHOD : Price Methods (Incentive/Interval)
    Its data type is CHAR (Character String) with field length 1
  • IOTR_CD : Price includes Tax Reimbursement.
    Its data type is CHAR (Character String) with field length 1
  • MEAS_GRP_ID : Measurement Group ID
    Its data type is CHAR (Character String) with field length 10
  • .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