SAP table OIUCM_CONTRACT (PRA Contracts)

SAP table OIUCM_CONTRACT has 2 primary key fields being MANDT,VBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

OIUCM_CONTRACT foreign key relationships

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