OIUCM_CONTRACT - PRA Contracts

PRA Contracts information is stored in SAP table OIUCM_CONTRACT.
It is part of development package OIU_CM in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "PRA common objects".

Fields for table OIUCM_CONTRACT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
VBELN	Contract Number	X	OIU_CT_NO	CHAR	20
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZET	Entry time		ERZET	TIMS	12
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ANGDT	Quotation/Inquiry is Valid From		ANGDT_V	DATS	16
BNDDT	Date Until Which Bid/Quotation is Binding (Valid-To Date)		BNDDT	DATS	16
AUDAT	Document Date (Date Received/Sent)		AUDAT	DATS	16
VBTYP	SD document category		VBTYP	CHAR	2
TRVOG	Transaction Group		TRVOG	CHAR	2
AUART	Sales Document Type		AUART	CHAR	8	TVAK
NETWR	Net Value of the Sales Order in Document Currency		NETWR_AK	CURR	8
WAERK	SD Document Currency		WAERK	CUKY	10	TCURC
VKORG	Sales Organization		VKORG	CHAR	8	TVKO
VTWEG	Distribution Channel		VTWEG	CHAR	4	TVTW
SPART	Division		SPART	CHAR	4	TSPA
GUEBG	Valid-From Date (Outline Agreements, Product Proposals)		GUEBG	DATS	16
GUEEN	Valid-To Date (Outline Agreements, Product Proposals)		GUEEN	DATS	16
KNUMV	Number of the Document Condition		KNUMV	CHAR	20
VDATU	Requested Delivery Date		EDATU_VBAK	DATS	16
VPRGR	Proposed date type		PRGRS_VBAK	CHAR	2
KALSM	Pricing Procedure in Pricing		KALSMASD	CHAR	12	T683
FKARA	Proposed billing type for an order-related billing document		FKARA	CHAR	8	TVFK
AWAHR	Sales probability		AWAHR_AK	NUMC	6
KTEXT	Search term for product proposal		KTEXT_V	CHAR	80
BSTNK	Customer Reference		BSTNK	CHAR	40
BSTDK	Customer Reference Date		BSTDK	DATS	16
BNAME	Name of orderer		BNAME_V	CHAR	70
KUNNR	Sold-to Party		KUNAG	CHAR	20	KNA1
STWAE	Statistics Currency		STWAE	CUKY	10	TCURC
AEDAT	Last Changed On		AEDAT	DATS	16
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
BUKRS_VF	Company Code to Be Billed		BUKRS_VF	CHAR	8	T001
PRSDT	Date for Pricing and Exchange Rate		PRSDT	DATS	16
.INCLUDE				OIU_RV_CT_H	0
OIU_CT_TYPE_CD	Contract Type		OIU_CT_TYPE_CD	CHAR	4	OIU_CM_CTTYP
OIU_CUST_VEND_CD	Customer/Vendor Indicator		OIU_CUST_VEND_CD	CHAR	2
OIU_APPR_FL	Approval indicator		OIU_APPL_FL	CHAR	2
OIU_APPR_DT	Approval Date		OIU_APPR_DT	DATS	16
OIU_EXEC_DT	Contract Execution Date		OIU_EXEC_DT	DATS	16
OIU_STD_CT_FL	Standard Contract Flag		OIU_STD_CT_FL	CHAR	2
OIU_PREV_CT_NO	Old / Previous Contract Number		OIU_PREV_CT_NO	CHAR	20
OIU_GPLT_COMPANY	Gas Plant Company		OIU_GPLT_BUKRS	CHAR	8	T001
OIU_GPLT_VNAME	Gas Plant Venture		OIU_GPLT_VNAME	CHAR	12	OIU_DO_JV
OIU_GPLT_DOI_NO	Gasplant DOI No		OIU_GPLT_DOI_NO	CHAR	10	*
OIU_MK_REP_NO	Marketing Representative No		OIU_MK_REP_NO	CHAR	20	*
OIU_MK_REP_ISQ	Marketing Representative Interest Sequence No		OIU_MK_REP_ISQ_NO	CHAR	4
OIU_DEST_SALE_CD	Plant Destination Of Product Sale Codes		OIU_DEST_SALE_CD	CHAR	2
OIU_LIFE_LSE_FL	Life Lease Flag		OIU_LIFE_LSE_FL	CHAR	2
OIU_INV_NO	Contract Invoice Number		OIU_INV_NO	CHAR	12
OIU_INV_FL	Invoice Flag		OIU_INV_FL	CHAR	2
OIU_OBLIG_DT	Obligation Date		OIU_OBLIG_DT	DATS	16
OIU_DESK_CD	Desk Codes		OIU_DESK_CD	CHAR	6	*
OIU_EIA_GINA_CD	Energy Information Agency Report Code		OIU_EIA_GINA_CD	CHAR	4	*
OIU_CT_STATUS_CD	Contract Status Code		OIU_CT_STATUS_CD	CHAR	4
OIU_SPOT_TERM_CD	Spot/Term		OIU_SPOT_TERM_CD	CHAR	2
OIU_STNDEDQ_CD	Varying/Equ Daily Qu		OIU_STNDEDQ_CD	CHAR	2
OIU_IOTR_FL	Price includes Tax Reimbursement.		OIU_IOTR_FL	CHAR	2
.INCLUDE				OIU_RV_CLT	0
OIU_INTRA_INTER	Boundary (Intra/Inter) Codes		OIU_INTRA_INTER_CD	CHAR	2
OIU_EXRES_SPLT	Excess Residue Return (Before/After) Lease Plant Split Code		OIU_EXRES_SPLT_CD	CHAR	2
OIU_EVGN_FL	Evergreen Flag		OIU_EVGN_FL	CHAR	2
OIU_EVGNPD_BAS	Evergreen Period Basis		OIU_EVGNPD_BAS_CD	CHAR	4
OIU_EVGN_PERD_QY	Evergreen Period Duration		OIU_EVGN_PERD_QY	NUMC	6
OIU_PREIM_TM_CD	Primary Term Basis		OIU_PREIM_TM_CD	CHAR	4
OIU_PRIM_TM_QY	Primary Term Length		OIU_PRIM_TM_QY	NUMC	6
OIU_SEC_TM_CD	Secondary Term Basis		OIU_SEC_TM_CD	CHAR	4
OIU_SEC_TM_QY	Secondary Term Length		OIU_SEC_TM_QY	NUMC	6
OIU_EXP_NOTIF_DT	Expiration Notification Date		OIU_EXP_NOTIF_DT	DATS	16
OIU_INTIT_RDT_DT	Initial Redetermination Date		OIU_INTIT_RDT_DT	DATS	16
OIU_NEXT_RDT_DT	Next redetermination date		OIU_NEXT_RDT_DT	DATS	16
OIU_RTC_DT	Right to cancel date		OIU_RTC_DT	DATS	16
OIU_RDT_N_PERD	Re-determination Notification Period (in Days)		OIU_RDT_N_PERD_QY	QUAN	7
OIU_RDT_REFQ_CD	Redetermination Frequency Code		OIU_RDT_REFQ_CD	CHAR	4
OIU_RTF_CD	Ratification Date		OIU_RTF_DT	DATS	16
OIU_IMB_PRVSN_FL	Imbalance Provision Flag		OIU_IMB_PRVSN_FL	CHAR	2
OIU_FFEE_RMB_FL	Filing Fee Reimbursement Flag		OIU_FFEE_RMB_FL	CHAR	2
OIU_FIRM_INTRPT	Firm/Interruptable Code		OIU_FIRM_INTRPT_CD	CHAR	2
OIU_BAL_BAS_CD	Balancing Basis Code		OIU_BAL_BAS_CD	CHAR	2
OIU_PNTY_BAS_CD	Penalty Basis Code		OIU_PNTY_BAS_CD	CHAR	2
OIU_TRANSP_BA	Transportation Basis Code		OIU_TRANSP_BAS_CD	CHAR	2
OIU_DLY_MAX_T_QY	Daily Maximum Transport Quantity		OIU_DLY_MAX_T_QY	QUAN	7
OIU_PRCS_FL	Processing Flag		OIU_PRCS_FL	CHAR	2
OIU_SPR_FL	Separation Flag		OIU_SPR_FL	CHAR	2
OIU_DEHYD_FL	Dehydration Flag		OIU_DEHYD_FL	CHAR	2
OIU_COMPR_FL	Compression Flag		OIU_COMPR_FL	CHAR	2
OIU_PYMT_METH_CD	Payment Method Code		OIU_PYMT_METH_CD	CHAR	2
OIU_CON_MATNR	Contaminant material		OIU_CON_MATNR	CHAR	80	*
OIU_CON_MAX_QY	Contaminant Percent		OIU_CON_MAX_QY	NUMC	6
OIU_AFFIL_FL	Affiliate Flag		OIU_AFFIL_FL	CHAR	2
OIU_MMS_TYPE_CD	Production: MMS-2014 - Sales Type Code		OIUREP_MMS_2014_SALES_TYPE_CD	CHAR	8	OIUREP_SALESTY
OIU_MMS_ETPAY_FL	MMS-2014: Contracts with Estimated Payment		OIUREP_MMS_2014_CT_EST_PAY_FL	CHAR	2
OIUH_CT_NO	Contract Number		OIUH_CT_NO	CHAR	12
.INCLUDE				OIU_CREATION	0
OIU_CRUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8