OIUCM_CONTRACT SAP table for – PRA Contracts

Here we would like to draw your attention to OIUCM_CONTRACT 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). OIUCM_CONTRACT is a SAP standard transp table used for storing PRA Contracts related data in SAP. It comes under the package OIU_CM.

SAP OIUCM_CONTRACT table

Table OIUCM_CONTRACT technical data

TableOIUCM_CONTRACT
Data storingPRA Contracts
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU_CM
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUCM_CONTRACT 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 OIUCM_CONTRACT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZET : Entry time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • ANGDT : Quotation/Inquiry is valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BNDDT : Date until which bid/quotation is binding (valid-to date)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUDAT : Document Date (Date Received/Sent)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBTYP : SD document category
    Its data type is CHAR (Character String) with field length 1
  • TRVOG : Transaction group
    Its data type is CHAR (Character String) with field length 1
  • AUART : Sales Document Type
    Its data type is CHAR (Character String) with field length 4
  • NETWR : Net Value of the Sales Order in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • WAERK : SD document currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VKORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • GUEBG : Valid-from date (outline agreements, product proposals)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GUEEN : Valid-to date (outline agreements, product proposals)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KNUMV : Number of the document condition
    Its data type is CHAR (Character String) with field length 10
  • VDATU : Requested delivery date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VPRGR : Proposed Period for Date
    Its data type is CHAR (Character String) with field length 1
  • KALSM : Sales and Distribution: Pricing Procedure in Pricing
    Its data type is CHAR (Character String) with field length 6
  • FKARA : Proposed billing type for an order-related billing document
    Its data type is CHAR (Character String) with field length 4
  • AWAHR : Sales Probability
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KTEXT : Search term for product proposal
    Its data type is CHAR (Character String) with field length 40
  • BSTNK : Customer purchase order number
    Its data type is CHAR (Character String) with field length 20
  • BSTDK : Customer purchase order date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BNAME : Name of orderer
    Its data type is CHAR (Character String) with field length 35
  • KUNNR : Sold-to party
    Its data type is CHAR (Character String) with field length 10
  • STWAE : Statistics currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • BUKRS_VF : Company code to be billed
    Its data type is CHAR (Character String) with field length 4
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • PRSDT : Date for pricing and exchange rate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : E&P Contract Table Header
  • OIU_CT_TYPE_CD : Contract Type
    Its data type is CHAR (Character String) with field length 2
  • OIU_CUST_VEND_CD : Customer/Vendor Indicator
    Its data type is CHAR (Character String) with field length 1
  • OIU_APPR_FL : Approval indicator
    Its data type is CHAR (Character String) with field length 1
  • OIU_APPR_DT : Approval Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_EXEC_DT : Contract Execution Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_STD_CT_FL : Standard Contract Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_PREV_CT_NO : Old / Previous Contract Number
    Its data type is CHAR (Character String) with field length 10
  • OIU_GPLT_COMPANY : Gas Plant Company
    Its data type is CHAR (Character String) with field length 4
  • OIU_GPLT_VNAME : Gas Plant Venture
    Its data type is CHAR (Character String) with field length 6
  • OIU_GPLT_DOI_NO : Gasplant DOI No
    Its data type is CHAR (Character String) with field length 5
  • OIU_MK_REP_NO : Marketing Representative No
    Its data type is CHAR (Character String) with field length 10
  • OIU_MK_REP_ISQ : Marketing Representative Interest Sequence No
    Its data type is CHAR (Character String) with field length 2
  • OIU_DEST_SALE_CD : Plant Destination Of Product Sale Codes
    Its data type is CHAR (Character String) with field length 1
  • OIU_LIFE_LSE_FL : Life Lease Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_INV_NO : Contract Invoice Number
    Its data type is CHAR (Character String) with field length 6
  • OIU_INV_FL : Invoice Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_OBLIG_DT : Obligation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_DESK_CD : Desk Codes
    Its data type is CHAR (Character String) with field length 3
  • OIU_EIA_GINA_CD : Energy Information Agency Report Code
    Its data type is CHAR (Character String) with field length 2
  • OIU_CT_STATUS_CD : Contract Status Code
    Its data type is CHAR (Character String) with field length 2
  • OIU_SPOT_TERM_CD : Spot/Term
    Its data type is CHAR (Character String) with field length 1
  • OIU_STNDEDQ_CD : Varying/Equ Daily Qu
    Its data type is CHAR (Character String) with field length 1
  • OIU_IOTR_FL : Price includes Tax Reimbursement.
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : E&P Contract Table Long Term
  • OIU_INTRA_INTER : Boundary (Intra/Inter) Codes
    Its data type is CHAR (Character String) with field length 1
  • OIU_EXRES_SPLT : Excess Residue Return (Before/After) Lease Plant Split Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_EVGN_FL : Evergreen Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_EVGNPD_BAS : Evergreen Period Basis
    Its data type is CHAR (Character String) with field length 2
  • OIU_EVGN_PERD_QY : Evergreen Period Duration
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OIU_PREIM_TM_CD : Primary Term Basis
    Its data type is CHAR (Character String) with field length 2
  • OIU_PRIM_TM_QY : Primary Term Length
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OIU_SEC_TM_CD : Secondary Term Basis
    Its data type is CHAR (Character String) with field length 2
  • OIU_SEC_TM_QY : Secondary Term Length
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OIU_EXP_NOTIF_DT : Expiration Notification Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_INTIT_RDT_DT : Initial Redetermination Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_NEXT_RDT_DT : Next redetermination date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_RTC_DT : Right to cancel date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_RDT_N_PERD : Re-determination Notification Period (in Days)
    Its data type is QUAN (Quantity field) with field length 13
  • OIU_RDT_REFQ_CD : Redetermination Frequency Code
    Its data type is CHAR (Character String) with field length 2
  • OIU_RTF_CD : Ratification Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIU_IMB_PRVSN_FL : Imbalance Provision Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_FFEE_RMB_FL : Filing Fee Reimbursement Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_FIRM_INTRPT : Firm/Interruptable Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_BAL_BAS_CD : Balancing Basis Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_PNTY_BAS_CD : Penalty Basis Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_TRANSP_BA : Transportation Basis Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_DLY_MAX_T_QY : Daily Maximum Transport Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • OIU_PRCS_FL : Processing Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_SPR_FL : Separation Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_DEHYD_FL : Dehydration Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_COMPR_FL : Compression Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_PYMT_METH_CD : Payment Method Code
    Its data type is CHAR (Character String) with field length 1
  • OIU_CON_MATNR : Contaminant material
    Its data type is CHAR (Character String) with field length 18
  • OIU_CON_MAX_QY : Contaminant Percent
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OIU_AFFIL_FL : Affiliate Flag
    Its data type is CHAR (Character String) with field length 1
  • OIU_MMS_TYPE_CD : Production: MMS-2014 – Sales Type Code
    Its data type is CHAR (Character String) with field length 4
  • OIU_MMS_ETPAY_FL : MMS-2014: Contracts with Estimated Payment
    Its data type is CHAR (Character String) with field length 1
  • OIUH_CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 6
  • .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