SAP ABAP Table OIUCM_CONTRACT (PRA Contracts)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU_CM (Package) PRA common objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUCM_CONTRACT	Table Relationship Diagram
Short Description	PRA Contracts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number
3	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
4	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
7	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
8	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
11	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
12	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
13	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
16	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
17	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
18	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
19	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
20	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
21	VPRGR	☐	PRGRS_VBAK	PRGRS	CHAR	1	0	Proposed Period for Date
22	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
23	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
24	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
25	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
26	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
27	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
28	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
29	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
30	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
31	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
32	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
33	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
34	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
35	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
36	.INCLUDE	☐				0	0	E&P Contract Table Header
37	OIU_CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	OIU_CM_CTTYP
38	OIU_CUST_VEND_CD	☐	OIU_CUST_VEND_CD	OIU_CUST_VEND_CD	CHAR	1	0	Customer/Vendor Indicator
39	OIU_APPR_FL	☐	OIU_APPL_FL	OIU_X_FLAG	CHAR	1	0	Approval indicator
40	OIU_APPR_DT	☐	OIU_APPR_DT	DATUM	DATS	8	0	Approval Date
41	OIU_EXEC_DT	☐	OIU_EXEC_DT	DATUM	DATS	8	0	Contract Execution Date
42	OIU_STD_CT_FL	☐	OIU_STD_CT_FL	OIU_X_FLAG	CHAR	1	0	Standard Contract Flag
43	OIU_PREV_CT_NO	☐	OIU_PREV_CT_NO	VBELN	CHAR	10	0	Old / Previous Contract Number	*
44	OIU_GPLT_COMPANY	☐	OIU_GPLT_BUKRS	BUKRS	CHAR	4	0	Gas Plant Company	T001
45	OIU_GPLT_VNAME	☐	OIU_GPLT_VNAME	JV_NAME	CHAR	6	0	Gas Plant Venture	OIU_DO_JV
46	OIU_GPLT_DOI_NO	☐	OIU_GPLT_DOI_NO	OIU_DOI_NO	CHAR	5	0	Gasplant DOI No	*
47	OIU_MK_REP_NO	☐	OIU_MK_REP_NO	KUNNR	CHAR	10	0	Marketing Representative No	*
48	OIU_MK_REP_ISQ	☐	OIU_MK_REP_ISQ_NO	OIU_MK_REP_ISQ_NO	CHAR	2	0	Marketing Representative Interest Sequence No
49	OIU_DEST_SALE_CD	☐	OIU_DEST_SALE_CD	OIU_DEST_SALE_CD	CHAR	1	0	Plant Destination Of Product Sale Codes
50	OIU_LIFE_LSE_FL	☐	OIU_LIFE_LSE_FL	OIU_X_FLAG	CHAR	1	0	Life Lease Flag
51	OIU_INV_NO	☐	OIU_INV_NO	OIU_INV_NO	CHAR	6	0	Contract Invoice Number
52	OIU_INV_FL	☐	OIU_INV_FL	OIU_X_FLAG	CHAR	1	0	Invoice Flag
53	OIU_OBLIG_DT	☐	OIU_OBLIG_DT	DATUM	DATS	8	0	Obligation Date
54	OIU_DESK_CD	☐	OIU_DESK_CD	OIU_DESK_CD	CHAR	3	0	Desk Codes	*
55	OIU_EIA_GINA_CD	☐	OIU_EIA_GINA_CD	OIU_EIA_GINA_CD	CHAR	2	0	Energy Information Agency Report Code	*
56	OIU_CT_STATUS_CD	☐	OIU_CT_STATUS_CD	OIU_CT_STATUS_CD	CHAR	2	0	Contract Status Code
57	OIU_SPOT_TERM_CD	☐	OIU_SPOT_TERM_CD	OIU_SPOT_TERM_CD	CHAR	1	0	Spot/Term
58	OIU_STNDEDQ_CD	☐	OIU_STNDEDQ_CD	OIU_STNDEDQ_CD	CHAR	1	0	Varying/Equ Daily Qu
59	OIU_IOTR_FL	☐	OIU_IOTR_FL	OIU_X_FLAG	CHAR	1	0	Price includes Tax Reimbursement.
60	.INCLUDE	☐				0	0	E&P Contract Table Long Term
61	OIU_INTRA_INTER	☐	OIU_INTRA_INTER_CD	OIU_INTRA_INTER_CD	CHAR	1	0	Boundary (Intra/Inter) Codes
62	OIU_EXRES_SPLT	☐	OIU_EXRES_SPLT_CD	OIU_EXRES_SPLT_CD	CHAR	1	0	Excess Residue Return (Before/After) Lease Plant Split Code
63	OIU_EVGN_FL	☐	OIU_EVGN_FL	OIU_X_FLAG	CHAR	1	0	Evergreen Flag
64	OIU_EVGNPD_BAS	☐	OIU_EVGNPD_BAS_CD	OIU_EVGNPD_BAS_CD	CHAR	2	0	Evergreen Period Basis
65	OIU_EVGN_PERD_QY	☐	OIU_EVGN_PERD_QY	NUMC03	NUMC	3	0	Evergreen Period Duration
66	OIU_PREIM_TM_CD	☐	OIU_PREIM_TM_CD	OIU_CT_TM_BASIS	CHAR	2	0	Primary Term Basis
67	OIU_PRIM_TM_QY	☐	OIU_PRIM_TM_QY	NUMC03	NUMC	3	0	Primary Term Length
68	OIU_SEC_TM_CD	☐	OIU_SEC_TM_CD	OIU_CT_TM_BASIS	CHAR	2	0	Secondary Term Basis
69	OIU_SEC_TM_QY	☐	OIU_SEC_TM_QY	NUMC03	NUMC	3	0	Secondary Term Length
70	OIU_EXP_NOTIF_DT	☐	OIU_EXP_NOTIF_DT	DATUM	DATS	8	0	Expiration Notification Date
71	OIU_INTIT_RDT_DT	☐	OIU_INTIT_RDT_DT	DATUM	DATS	8	0	Initial Redetermination Date
72	OIU_NEXT_RDT_DT	☐	OIU_NEXT_RDT_DT	DATUM	DATS	8	0	Next redetermination date
73	OIU_RTC_DT	☐	OIU_RTC_DT	DATUM	DATS	8	0	Right to cancel date
74	OIU_RDT_N_PERD	☐	OIU_RDT_N_PERD_QY	MENGE	QUAN	13	3	Re-determination Notification Period (in Days)
75	OIU_RDT_REFQ_CD	☐	OIU_RDT_REFQ_CD	OIU_RDT_REFQ_CD	CHAR	2	0	Redetermination Frequency Code
76	OIU_RTF_CD	☐	OIU_RTF_DT	DATUM	DATS	8	0	Ratification Date
77	OIU_IMB_PRVSN_FL	☐	OIU_IMB_PRVSN_FL	OIU_X_FLAG	CHAR	1	0	Imbalance Provision Flag
78	OIU_FFEE_RMB_FL	☐	OIU_FFEE_RMB_FL	OIU_X_FLAG	CHAR	1	0	Filing Fee Reimbursement Flag
79	OIU_FIRM_INTRPT	☐	OIU_FIRM_INTRPT_CD	OIU_FIRM_INTRPT_CD	CHAR	1	0	Firm/Interruptable Code
80	OIU_BAL_BAS_CD	☐	OIU_BAL_BAS_CD	OIU_VBAS_CD	CHAR	1	0	Balancing Basis Code
81	OIU_PNTY_BAS_CD	☐	OIU_PNTY_BAS_CD	OIU_VBAS_CD	CHAR	1	0	Penalty Basis Code
82	OIU_TRANSP_BA	☐	OIU_TRANSP_BAS_CD	OIU_VBAS_CD	CHAR	1	0	Transportation Basis Code
83	OIU_DLY_MAX_T_QY	☐	OIU_DLY_MAX_T_QY	MENGE	QUAN	13	3	Daily Maximum Transport Quantity
84	OIU_PRCS_FL	☐	OIU_PRCS_FL	OIU_X_FLAG	CHAR	1	0	Processing Flag
85	OIU_SPR_FL	☐	OIU_SPR_FL	OIU_X_FLAG	CHAR	1	0	Separation Flag
86	OIU_DEHYD_FL	☐	OIU_DEHYD_FL	OIU_X_FLAG	CHAR	1	0	Dehydration Flag
87	OIU_COMPR_FL	☐	OIU_COMPR_FL	OIU_X_FLAG	CHAR	1	0	Compression Flag
88	OIU_PYMT_METH_CD	☐	OIU_PYMT_METH_CD	OIU_PYMT_METH_CD	CHAR	1	0	Payment Method Code
89	OIU_CON_MATNR	☐	OIU_CON_MATNR	MATNR	CHAR	18	0	Contaminant material	*
90	OIU_CON_MAX_QY	☐	OIU_CON_MAX_QY	OIU_CON_MAX_QY	NUMC	3	0	Contaminant Percent
91	OIU_AFFIL_FL	☐	OIU_AFFIL_FL	OIU_X_FLAG	CHAR	1	0	Affiliate Flag
92	OIU_MMS_TYPE_CD	☐	OIUREP_MMS_2014_SALES_TYPE_CD	OIUREP_MMS_2014_SALES_TYPE_CD	CHAR	4	0	Production: MMS-2014 - Sales Type Code	OIUREP_SALESTY
93	OIU_MMS_ETPAY_FL	☐	OIUREP_MMS_2014_CT_EST_PAY_FL	YESNO	CHAR	1	0	MMS-2014: Contracts with Estimated Payment
94	OIUH_CT_NO	☐	OIUH_CT_NO	CHAR6	CHAR	6	0	Contract Number
95	.INCLUDE	☐				0	0	Creator and date/time created
96	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
97	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUCM_CONTRACT	AUART	TVAK	AUART	REF
2	OIUCM_CONTRACT	BUKRS_VF	T001	BUKRS	REF
3	OIUCM_CONTRACT	FKARA	TVFK	FKART	REF
4	OIUCM_CONTRACT	KALSM	T683	KALSM
5	OIUCM_CONTRACT	KOKRS	TKA01	KOKRS	REF
6	OIUCM_CONTRACT	KUNNR	KNA1	KUNNR	REF
7	OIUCM_CONTRACT	MANDT	T000	MANDT	KEY
8	OIUCM_CONTRACT	OIU_CT_TYPE_CD	OIU_CM_CTTYP	CT_TYPE_CD
9	OIUCM_CONTRACT	OIU_GPLT_COMPANY	T001	BUKRS
10	OIUCM_CONTRACT	OIU_GPLT_VNAME	OIU_DO_JV	VNAME
11	OIUCM_CONTRACT	OIU_MMS_TYPE_CD	OIUREP_SALESTY	SALES_TYPE_CD
12	OIUCM_CONTRACT	SPART	TSPA	SPART	REF
13	OIUCM_CONTRACT	STWAE	TCURC	WAERS	REF
14	OIUCM_CONTRACT	VKORG	TVKO	VKORG	REF
15	OIUCM_CONTRACT	VTWEG	TVTW	VTWEG	REF
16	OIUCM_CONTRACT	WAERK	TCURC	WAERS	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in	600