1. Home
  2. Resources
  3. SAP Tables
  4. OIUCM_CONTRACT - PRA Contracts

SAP Table OIUCM_CONTRACT

PRA Contracts

OIUCM_CONTRACT (PRA Contracts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIUCM_CONTRACT to other SAP tables.

OIUCM_CONTRACT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Contract Number OIU_CT_NO CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
TRVOG Transaction group TRVOG CHAR 1 0
0 Sales order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
6 Delivery
7 Billing documents
8 Proforma invoices
9 Sales activities
A Sales promotions
B Customer independent requirements
D Shipping notification
G Rough Goods Receipt
O Cost accounting: Variance calculation
AUART Sales Document Type AUART TVAK CHAR 4 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
WAERK SD Document Currency WAERK TCURC CUKY 5 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
GUEBG Valid-from date (outline agreements, product proposals) GUEBG DATS 8 0
GUEEN Valid-to date (outline agreements, product proposals) GUEEN DATS 8 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VDATU Requested delivery date EDATU_VBAK DATS 8 0
VPRGR Proposed date type PRGRS_VBAK CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
FKARA Proposed billing type for an order-related billing document FKARA TVFK CHAR 4 0
AWAHR Sales probability AWAHR_AK NUMC 3 0
000 Sales order probability
KTEXT Search term for product proposal KTEXT_V CHAR 40 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BNAME Name of orderer BNAME_V CHAR 35 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
STWAE Statistics currency STWAE TCURC CUKY 5 0
AEDAT Changed On AEDAT DATS 8 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
BUKRS_VF Company code to be billed BUKRS_VF T001 CHAR 4 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
OIU_CT_TYPE_CD Contract Type OIU_CT_TYPE_CD OIU_CM_CTTYP CHAR 2 0
OIU_CUST_VEND_CD Customer/Vendor Indicator OIU_CUST_VEND_CD CHAR 1 0
C Customer
V Vendor
P Partner
OIU_APPR_FL Approval indicator OIU_APPL_FL CHAR 1 0
X Active
NULL Inactive
OIU_APPR_DT Approval Date OIU_APPR_DT DATS 8 0
OIU_EXEC_DT Contract Execution Date OIU_EXEC_DT DATS 8 0
OIU_STD_CT_FL Standard Contract Flag OIU_STD_CT_FL CHAR 1 0
X Active
NULL Inactive
OIU_PREV_CT_NO Old / Previous Contract Number OIU_PREV_CT_NO CHAR 10 0
OIU_GPLT_COMPANY Gas Plant Company OIU_GPLT_BUKRS T001 CHAR 4 0
OIU_GPLT_VNAME Gas Plant Venture OIU_GPLT_VNAME OIU_DO_JV CHAR 6 0
OIU_GPLT_DOI_NO Gasplant DOI No OIU_GPLT_DOI_NO CHAR 5 0
OIU_MK_REP_NO Marketing Representative No OIU_MK_REP_NO CHAR 10 0
OIU_MK_REP_ISQ Marketing Representative Interest Sequence No OIU_MK_REP_ISQ_NO CHAR 2 0
OIU_DEST_SALE_CD Plant Destination Of Product Sale Codes OIU_DEST_SALE_CD CHAR 1 0
B Bypass
P Processing
S Straddle
N None
OIU_LIFE_LSE_FL Life Lease Flag OIU_LIFE_LSE_FL CHAR 1 0
X Active
NULL Inactive
OIU_INV_NO Contract Invoice Number OIU_INV_NO CHAR 6 0
OIU_INV_FL Invoice Flag OIU_INV_FL CHAR 1 0
X Active
NULL Inactive
OIU_OBLIG_DT Obligation Date OIU_OBLIG_DT DATS 8 0
OIU_DESK_CD Desk Codes OIU_DESK_CD CHAR 3 0
OIU_EIA_GINA_CD Energy Information Agency Report Code OIU_EIA_GINA_CD CHAR 2 0
OIU_CT_STATUS_CD Contract Status Code OIU_CT_STATUS_CD CHAR 2 0
AC Active
AS Assigned
CO Correction
MO Modified
RE Renewal
RO Rollover
SU Successor
TE Terminated
OIU_SPOT_TERM_CD Spot/Term OIU_SPOT_TERM_CD CHAR 1 0
S Spot
T Term
OIU_STNDEDQ_CD Varying/Equ Daily Qu OIU_STNDEDQ_CD CHAR 1 0
E Equal Daily Quantity
V Varying Daily Quantity
OIU_IOTR_FL Price includes Tax Reimbursement. OIU_IOTR_FL CHAR 1 0
X Active
NULL Inactive
OIU_INTRA_INTER Boundary (Intra/Inter) Codes OIU_INTRA_INTER_CD CHAR 1 0
A Intrastate
B Both
E Interstate
OIU_EXRES_SPLT Excess Residue Return (Before/After) Lease Plant Split Code OIU_EXRES_SPLT_CD CHAR 1 0
B Before
A After
N None
OIU_EVGN_FL Evergreen Flag OIU_EVGN_FL CHAR 1 0
X Active
NULL Inactive
OIU_EVGNPD_BAS Evergreen Period Basis OIU_EVGNPD_BAS_CD CHAR 2 0
DY Days
MO Months
OIU_EVGN_PERD_QY Evergreen Period Duration OIU_EVGN_PERD_QY NUMC 3 0
OIU_PREIM_TM_CD Primary Term Basis OIU_PREIM_TM_CD CHAR 2 0
YR Years
MO Months
OIU_PRIM_TM_QY Primary Term Length OIU_PRIM_TM_QY NUMC 3 0
OIU_SEC_TM_CD Secondary Term Basis OIU_SEC_TM_CD CHAR 2 0
YR Years
MO Months
OIU_SEC_TM_QY Secondary Term Length OIU_SEC_TM_QY NUMC 3 0
OIU_EXP_NOTIF_DT Expiration Notification Date OIU_EXP_NOTIF_DT DATS 8 0
OIU_INTIT_RDT_DT Initial Redetermination Date OIU_INTIT_RDT_DT DATS 8 0
OIU_NEXT_RDT_DT Next redetermination date OIU_NEXT_RDT_DT DATS 8 0
OIU_RTC_DT Right to cancel date OIU_RTC_DT DATS 8 0
OIU_RDT_N_PERD Re-determination Notification Period (in Days) OIU_RDT_N_PERD_QY QUAN 13 3
OIU_RDT_REFQ_CD Redetermination Frequency Code OIU_RDT_REFQ_CD CHAR 2 0
AN Annually
BM Bi-monthly
MT Monthly
QT Quarterly
SA Semi-annually
OIU_RTF_CD Ratification Date OIU_RTF_DT DATS 8 0
OIU_IMB_PRVSN_FL Imbalance Provision Flag OIU_IMB_PRVSN_FL CHAR 1 0
X Active
NULL Inactive
OIU_FFEE_RMB_FL Filing Fee Reimbursement Flag OIU_FFEE_RMB_FL CHAR 1 0
X Active
NULL Inactive
OIU_FIRM_INTRPT Firm/Interruptable Code OIU_FIRM_INTRPT_CD CHAR 1 0
F Firm
I Interruptable
OIU_BAL_BAS_CD Balancing Basis Code OIU_BAL_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_PNTY_BAS_CD Penalty Basis Code OIU_PNTY_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_TRANSP_BA Transportation Basis Code OIU_TRANSP_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_DLY_MAX_T_QY Daily Maximum Transport Quantity OIU_DLY_MAX_T_QY QUAN 13 3
OIU_PRCS_FL Processing Flag OIU_PRCS_FL CHAR 1 0
X Active
NULL Inactive
OIU_SPR_FL Separation Flag OIU_SPR_FL CHAR 1 0
X Active
NULL Inactive
OIU_DEHYD_FL Dehydration Flag OIU_DEHYD_FL CHAR 1 0
X Active
NULL Inactive
OIU_COMPR_FL Compression Flag OIU_COMPR_FL CHAR 1 0
X Active
NULL Inactive
OIU_PYMT_METH_CD Payment Method Code OIU_PYMT_METH_CD CHAR 1 0
C Check
E Electronic File Transfers
J Joint Interest
N Non-wire Payments
W Wire
OIU_CON_MATNR Contaminant material OIU_CON_MATNR CHAR 18 0
OIU_CON_MAX_QY Contaminant Percent OIU_CON_MAX_QY NUMC 3 0
OIU_AFFIL_FL Affiliate Flag OIU_AFFIL_FL CHAR 1 0
X Active
NULL Inactive
OIU_MMS_TYPE_CD Production: MMS-2014 - Sales Type Code OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_SALESTY CHAR 4 0
OIU_MMS_ETPAY_FL MMS-2014: Contracts with Estimated Payment OIUREP_MMS_2014_CT_EST_PAY_FL CHAR 1 0
X Yes
NULL No
OIUH_CT_NO Contract Number OIUH_CT_NO CHAR 6 0
OIU_CRUSER Name of Person who Created the Object ERNAM CHAR 12 0
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0

OIUCM_CONTRACT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIUCM_CONTRACT AUART OIUCM_CONTRACT MANDT TVAK Sales Document Types MANDT
OIUCM_CONTRACT AUART OIUCM_CONTRACT AUART TVAK Sales Document Types AUART
OIUCM_CONTRACT BUKRS_VF OIUCM_CONTRACT MANDT T001 Company Codes MANDT
OIUCM_CONTRACT BUKRS_VF OIUCM_CONTRACT BUKRS_VF T001 Company Codes BUKRS
OIUCM_CONTRACT FKARA OIUCM_CONTRACT FKARA TVFK Billing: Document Types FKART
OIUCM_CONTRACT FKARA OIUCM_CONTRACT MANDT TVFK Billing: Document Types MANDT
OIUCM_CONTRACT KALSM OIUCM_CONTRACT MANDT T683 Pricing procedures MANDT
OIUCM_CONTRACT KALSM T681V KVEWE T683 Pricing procedures KVEWE
OIUCM_CONTRACT KALSM T681A KAPPL T683 Pricing procedures KAPPL
OIUCM_CONTRACT KALSM OIUCM_CONTRACT KALSM T683 Pricing procedures KALSM
OIUCM_CONTRACT KOKRS OIUCM_CONTRACT MANDT TKA01 Controlling Areas MANDT
OIUCM_CONTRACT KOKRS OIUCM_CONTRACT KOKRS TKA01 Controlling Areas KOKRS
OIUCM_CONTRACT KUNNR OIUCM_CONTRACT MANDT KNA1 General Data in Customer Master MANDT
OIUCM_CONTRACT KUNNR OIUCM_CONTRACT KUNNR KNA1 General Data in Customer Master KUNNR
OIUCM_CONTRACT MANDT OIUCM_CONTRACT MANDT T000 Clients MANDT
OIUCM_CONTRACT OIU_CT_TYPE_CD OIUCM_CONTRACT OIU_CT_TYPE_CD OIU_CM_CTTYP Contract Type (TBLCS007) CT_TYPE_CD
OIUCM_CONTRACT OIU_GPLT_COMPANY OIUCM_CONTRACT OIU_GPLT_COMPANY T001 Company Codes BUKRS
OIUCM_CONTRACT OIU_GPLT_COMPANY SYST MANDT T001 Company Codes MANDT
OIUCM_CONTRACT OIU_GPLT_VNAME OIUCM_CONTRACT OIU_GPLT_VNAME OIU_DO_JV PRA venture extension VNAME
OIUCM_CONTRACT OIU_GPLT_VNAME SYST MANDT OIU_DO_JV PRA venture extension MANDT
OIUCM_CONTRACT OIU_GPLT_VNAME OIUCM_CONTRACT OIU_GPLT_COMPANY OIU_DO_JV PRA venture extension BUKRS
OIUCM_CONTRACT OIU_MMS_TYPE_CD SYST MANDT OIUREP_SALESTY MMS-2014: Sales Type Control Table MANDT
OIUCM_CONTRACT OIU_MMS_TYPE_CD OIUCM_CONTRACT OIU_MMS_TYPE_CD OIUREP_SALESTY MMS-2014: Sales Type Control Table SALES_TYPE_CD
OIUCM_CONTRACT SPART OIUCM_CONTRACT MANDT TSPA Organizational Unit: Sales Divisions MANDT
OIUCM_CONTRACT SPART OIUCM_CONTRACT SPART TSPA Organizational Unit: Sales Divisions SPART
OIUCM_CONTRACT STWAE OIUCM_CONTRACT STWAE TCURC Currency Codes WAERS
OIUCM_CONTRACT STWAE OIUCM_CONTRACT MANDT TCURC Currency Codes MANDT
OIUCM_CONTRACT VKORG OIUCM_CONTRACT MANDT TVKO Organizational Unit: Sales Organizations MANDT
OIUCM_CONTRACT VKORG OIUCM_CONTRACT VKORG TVKO Organizational Unit: Sales Organizations VKORG
OIUCM_CONTRACT VTWEG OIUCM_CONTRACT MANDT TVTW Organizational Unit: Distribution Channels MANDT
OIUCM_CONTRACT VTWEG OIUCM_CONTRACT VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
OIUCM_CONTRACT WAERK OIUCM_CONTRACT MANDT TCURC Currency Codes MANDT
OIUCM_CONTRACT WAERK OIUCM_CONTRACT WAERK TCURC Currency Codes WAERS