1. SAP Tutorial
  2. Oil & Gas

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

    • OIUCM_CONTRACT related tables

    • OIUCM_LV_GROUPT : List Viewer Group Definition
    • OIUCM_CUST_KTOKD : Valid Customer Account Groups for Business Associates
    • OIUCM_LV_MAINGRP : list viewer – group table
    • OIUCM_CMPNT : Common table for cross-referencing product codes and compo
    • OIUCM_BA_TYPE_TX : Business Associate Type Description
    • OIUCM_BA_TYPE : Business Associate Types
    • OIUCM_ACTG_OFST : Accounting Offset
    • OIUCM_BA_LINK : Business Associate -> SAP Master Link
    • OIUCM_LV_CATEG : list viewer – category table
    • OIUCM_PID_CONFIG : Override PID Configuration
    • OIUCM_LV_DDTEXT : List viewer – table for the dd description
    • OIUCM_PID_TXN : Transactions With Override PID Enabled
    • OIUCM_LV_DETAIL : list viewer – jil detail table
    • OIUCM_CONTRACT : PRA Contracts
    • OIUCM_SN_NR_T : Text Descriptions for OIU_CM_SN_NR tables
    • OIUCM_COMB_PD_TX : Combined Product Code Text
    • OIUCM_SN_NR_CONF : Number Range Interval Assignments To PRA Tables
    • OIUCM_TAB_MAINTS : PRA Generic Table Maintenance – Non Key Field Control Tab
    • OIUCM_VEND_KTOKK : Valid Vendor Account Groups for Business Associates
    • OIUCM_TAB_MAINTC : PRA Generic Table Maintenance – Non Key Field Control Tab

    OIUCM_CONTRACT related transaction codes under SAP package OIU_CM

    • O3UCM_TAB_MAINT_004 : Material and Product Code Proc XRef
    • S_SOG_81000045 : IMG activity: OIUCM_PPARSN
    • O3UCM_TAB_MAINT_008 : Sliding Scale Methods – Dim / Materl
    • O5UCM_SN_NR : PRA Number Range Maintenance
    • O3UCM_T8JV : PRA Joint Venture Master Data
    • O3UCM_BA : Integrated Business Associate
    • S_SOG_81000050 : IMG activity: OIUCM_MAINTAIN_NRIV
    • O3UCM_TAB_MAINT_007 : SPF Wet Gas Equivalent
    • O3UCM_TAB_MAINT_005 : Material Sum – Gas Plant Comp Alloc
    • S_SO7_65001026 : Generated Text
    • O3UCM_TAB_MAINT_017 : Roy Rpt: Code Maintenance
    • S_SO7_65001025 : Generated Text
    • O3UCM_TAB_MAINT_010 : Volumetric SKF
    • O3UCM_TAB_MAINT_006 : SPF NGL Component Allocation Basis
    • O5UCM_TT : Common Table Maintenance
    • S_SO7_65001027 : Generated Text
    • O3UCM_TAB_MAINT_014 : PRA JVA Companies
    • O3UCM_TAB_MAINT_003 : Reclassification of Production Codes
    • O3UCM_TAB_MAINT : Generic Table Maintenance
    • O3UCM_TAB_MAINT_009 : PRA Partner Table from JV

    Related References

    Related Tutorials

    A440 SAP table for – PRA Pricing – Contract, Material

    A440 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUCA_CTWC SAP table for – PRA: Transporter Contract Well Completion XRef

    OIUCA_CTWC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUCA_CTMP SAP table for – PRA: Transporter Contract Measurement Point XRef

    OIUCA_CTMP table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    A416 SAP table for – PRA Pricing – Contract, Well, Well Completion, Material

    A416 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    A438 SAP table for – PRA Pricing – Contract, Measurement Point, Material

    A438 table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIU_PR_MPALB SAP table for – PRA: Measurement Point Allocation Base

    OIU_PR_MPALB table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIU_PR_WCTRNH SAP table for – PRA: Well Completion Transporter Xref

    OIU_PR_WCTRNH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »