SAP ABAP Table ROIUT1_OIU_DO_JV (Load Structure for E&P Venture)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU_T1 (Package) Batch Upload deliverable for Partner Interface

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUT1_OIU_DO_JV	Table Relationship Diagram
Short Description	Load Structure for E&P Venture

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
3	VNAME_INT_CD	☐	OIU_VNAME_INT_CD	OIU_PR_INT_CD	CHAR	2	0	Venture Interest Code
4	VNAME_NM	☐	OIU_VNAME_NM	OIU_TEXT35	CHAR	35	0	venture name
5	STS_CODE	☐	OIU_VNAME_STATUS	OIU_VNAME_STATUS	CHAR	2	0	Venture Status	OIU_CM_VNAMST
6	STS_EFF_DT	☐	OIU_STS_EFF_DT	DATUM	DATS	8	0	Status Effective Date
7	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
8	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
9	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
10	ACQ_DT	☐	OIU_ACQ_DT	DATUM	DATS	8	0	Acquired Date
11	TYPE_CD	☐	OIU_VNAME_TYPE_CD	OIU_PR_TYPE_CD	CHAR	2	0	Venture Usage Type
12	UNIT_FL	☐	OIU_UNIT_FL	OIU_X_FLAG	CHAR	1	0	Unit venture flag
13	DOI_BY_TR_FL	☐	OIU_DOI_BY_TR_FL	OIU_X_FLAG	CHAR	1	0	DOI by tract flag
14	UN_VOL_FL	☐	OIU_UN_VOL_FL	OIU_X_FLAG	CHAR	1	0	Maintain Unit/Venture Volume
15	DRL_FUND_FL	☐	OIU_DRL_FUND_FL	OIU_X_FLAG	CHAR	1	0	Drill Fund Flag
16	ONS_OFS_CD	☐	OIU_ONS_OFS_CD	OIU_ONS_OFS_CD	CHAR	1	0	Onshore/Offshore codes
17	ACQ_FROM_KUNNR	☐	OIU_ACQ_FROM_KUNNR	KUNNR	CHAR	10	0	Party Acquired From	KNA1
18	SLD_TO_KUNNR	☐	OIU_SLD_TO_KUNNR	KUNNR	CHAR	10	0	Party Sold To	KNA1
19	LPN_NO	☐	OIU_LPN_NO	OIU_LPN_NO	CHAR	9	0	Land Venture Number
20	DOI_PRT_FL	☐	OIU_DOI_PRT_FL	OIU_X_FLAG	CHAR	1	0	DOI Print Flag

Foreign Keys

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

History

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