SAP ABAP Table ROIUT2_LOAD_EPVENTURE (E&P Venture Extension)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU_T2 (Package) Obsolete: PRA Tobin Integration Phase II

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUT2_LOAD_EPVENTURE	Table Relationship Diagram
Short Description	E&P Venture Extension

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	PRA venture extension
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
5	VNAME_INT_CD	☐	OIU_VNAME_INT_CD	OIU_PR_INT_CD	CHAR	2	0	Venture Interest Code
6	VNAME_NM	☐	OIU_VNAME_NM	OIU_TEXT35	CHAR	35	0	venture name
7	SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
8	STS_CODE	☐	OIU_VNAME_STATUS	OIU_VNAME_STATUS	CHAR	2	0	Venture Status	OIU_CM_VNAMST
9	STS_EFF_DT	☐	OIU_STS_EFF_DT	DATUM	DATS	8	0	Status Effective Date
10	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
12	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
13	ACQ_DT	☐	OIU_ACQ_DT	DATUM	DATS	8	0	Acquired Date
14	TYPE_CD	☐	OIU_VNAME_TYPE_CD	OIU_PR_TYPE_CD	CHAR	2	0	Venture Usage Type
15	OLD_VNAME_NO	☐	OIU_OLD_VNAME_NO	OBJNR	CHAR	18	0	Old lease ID
16	UNIT_FL	☐	OIU_UNIT_FL	OIU_X_FLAG	CHAR	1	0	Unit venture flag
17	DOI_BY_TR_FL	☐	OIU_DOI_BY_TR_FL	OIU_X_FLAG	CHAR	1	0	DOI by tract flag
18	DRL_FUND_FL	☐	OIU_DRL_FUND_FL	OIU_X_FLAG	CHAR	1	0	Drill Fund Flag
19	ONS_OFS_CD	☐	OIU_ONS_OFS_CD	OIU_ONS_OFS_CD	CHAR	1	0	Onshore/Offshore codes
20	ACQ_FROM_KUNNR	☐	OIU_ACQ_FROM_KUNNR	KUNNR	CHAR	10	0	Party Acquired From	KNA1
21	SLD_TO_KUNNR	☐	OIU_SLD_TO_KUNNR	KUNNR	CHAR	10	0	Party Sold To	KNA1
22	LEG_DE_CMT_FL	☐	OIU_LEG_DE_CMT_FL	OIU_X_FLAG	CHAR	1	0	Legal description
23	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	OIU_PR_FIELD
24	SPACE_ORD_NO	☐	OIU_SPACE_ORD_NO	CHAR20	CHAR	20	0	Spacing Order Number
25	LPN_NO	☐	OIU_LPN_NO	OIU_LPN_NO	CHAR	9	0	Land Venture Number
26	DOI_PRT_FL	☐	OIU_DOI_PRT_FL	OIU_X_FLAG	CHAR	1	0	DOI Print Flag
27	.INCLUDE	☐				0	0	Creator and date/time created
28	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
29	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	UN_VOL_FL	☐	OIU_UN_VOL_FL	OIU_X_FLAG	CHAR	1	0	Maintain Unit/Venture Volume

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUT2_LOAD_EPVENTURE	ACQ_FROM_KUNNR	KNA1	KUNNR		1	CN
2	ROIUT2_LOAD_EPVENTURE	BUKRS	T001	BUKRS	KEY	1	CN
3	ROIUT2_LOAD_EPVENTURE	COUNTRY	T005	LAND1		1	CN
4	ROIUT2_LOAD_EPVENTURE	FIELD	OIU_PR_FIELD	FIELD
5	ROIUT2_LOAD_EPVENTURE	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
6	ROIUT2_LOAD_EPVENTURE	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC		1	CN
7	ROIUT2_LOAD_EPVENTURE	SLD_TO_KUNNR	KNA1	KUNNR		1	CN
8	ROIUT2_LOAD_EPVENTURE	STS_CODE	OIU_CM_VNAMST	VNAME_STATUS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C