SAP ABAP View OIU_RV_CT (PRA Contract)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

View Type	D	Database View
Database View	OIU_RV_CT
Short Description	PRA Contract
Root table	OIUCM_CONTRACT	PRA Contracts

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIUCM_CONTRACT	OIUCM_CONTRACT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIUCM_CONTRACT	MANDT		☐	MANDT	☐	Client
2	CT_NO	OIUCM_CONTRACT	VBELN		☐	OIU_CT_NO	☐	Contract Number
3	CT_TYPE_CD	OIUCM_CONTRACT	OIU_CT_TYPE_CD		☐	OIU_CT_TYPE_CD	☐	Contract Type
4	BUKRS	OIUCM_CONTRACT	BUKRS_VF		☐	BUKRS_VF	☐	Company code to be billed
5	CTPTY_CT_NO	OIUCM_CONTRACT	BSTNK		☐	BSTNK	☐	Customer purchase order number
6	CUST_VEND_CD	OIUCM_CONTRACT	OIU_CUST_VEND_CD		☐	OIU_CUST_VEND_CD	☐	Customer/Vendor Indicator
7	CTPTY_NO	OIUCM_CONTRACT	KUNNR		☐	KUNAG	☐	Sold-to party
8	START_DT	OIUCM_CONTRACT	GUEBG		☐	GUEBG	☐	Valid-from date (outline agreements, product proposals)
9	END_DT	OIUCM_CONTRACT	GUEEN		☐	GUEEN	☐	Valid-to date (outline agreements, product proposals)
10	APPR_FL	OIUCM_CONTRACT	OIU_APPR_FL		☐	OIU_APPL_FL	☐	Approval indicator
11	APPR_DATA	OIUCM_CONTRACT	OIU_APPR_DT		☐	OIU_APPR_DT	☐	Approval Date
12	EXEC_DATA	OIUCM_CONTRACT	OIU_EXEC_DT		☐	OIU_EXEC_DT	☐	Contract Execution Date
13	STD_CD_FL	OIUCM_CONTRACT	OIU_STD_CT_FL		☐	OIU_STD_CT_FL	☐	Standard Contract Flag
14	OLD_CT_NO	OIUCM_CONTRACT	OIU_PREV_CT_NO		☐	OIU_PREV_CT_NO	☐	Old / Previous Contract Number
15	GPLT_COMPANY	OIUCM_CONTRACT	OIU_GPLT_COMPANY		☐	OIU_GPLT_BUKRS	☐	Gas Plant Company
16	GPLT_VNAME	OIUCM_CONTRACT	OIU_GPLT_VNAME		☐	OIU_GPLT_VNAME	☐	Gas Plant Venture
17	GPLT_DOI_NOI	OIUCM_CONTRACT	OIU_GPLT_DOI_NO		☐	OIU_GPLT_DOI_NO	☐	Gasplant DOI No
18	MK_REP_NO	OIUCM_CONTRACT	OIU_MK_REP_NO		☐	OIU_MK_REP_NO	☐	Marketing Representative No
19	MK_REP_ISQ_NO	OIUCM_CONTRACT	OIU_MK_REP_ISQ		☐	OIU_MK_REP_ISQ_NO	☐	Marketing Representative Interest Sequence No
20	DEST_SALE_CD	OIUCM_CONTRACT	OIU_DEST_SALE_CD		☐	OIU_DEST_SALE_CD	☐	Plant Destination Of Product Sale Codes
21	INV_NO	OIUCM_CONTRACT	OIU_INV_NO		☐	OIU_INV_NO	☐	Contract Invoice Number
22	LIFE_LSE_FL	OIUCM_CONTRACT	OIU_LIFE_LSE_FL		☐	OIU_LIFE_LSE_FL	☐	Life Lease Flag
23	INV_FL	OIUCM_CONTRACT	OIU_INV_FL		☐	OIU_INV_FL	☐	Invoice Flag
24	OBLIG_DT	OIUCM_CONTRACT	OIU_OBLIG_DT		☐	OIU_OBLIG_DT	☐	Obligation Date
25	DESK_CD	OIUCM_CONTRACT	OIU_DESK_CD		☐	OIU_DESK_CD	☐	Desk Codes
26	EIA_GINA_CD	OIUCM_CONTRACT	OIU_EIA_GINA_CD		☐	OIU_EIA_GINA_CD	☐	Energy Information Agency Report Code
27	CT_STATUS_CD	OIUCM_CONTRACT	OIU_CT_STATUS_CD		☐	OIU_CT_STATUS_CD	☐	Contract Status Code
28	SPOT_TERM_CD	OIUCM_CONTRACT	OIU_SPOT_TERM_CD		☐	OIU_SPOT_TERM_CD	☐	Spot/Term
29	OIU_CRUSER	OIUCM_CONTRACT	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
30	OIU_TIMESTAMP	OIUCM_CONTRACT	ERDAT		☐	ERDAT	☐	Date on which the record was created
31	OIU_STNDEDQ_CD	OIUCM_CONTRACT	OIU_STNDEDQ_CD		☐	OIU_STNDEDQ_CD	☐	Varying/Equ Daily Qu
32	OIU_IOTR_FL	OIUCM_CONTRACT	OIU_IOTR_FL		☐	OIU_IOTR_FL	☐	Price includes Tax Reimbursement.
33	OIU_EXRES_SPLT	OIUCM_CONTRACT	OIU_EXRES_SPLT		☐	OIU_EXRES_SPLT_CD	☐	Excess Residue Return (Before/After) Lease Plant Split Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in