SAP ABAP Table OIU_DO_JV (PRA venture extension)

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

Table Category	TRANSP	Transparent table
Transparent table	OIU_DO_JV	Table Relationship Diagram
Short Description	PRA venture extension

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

History

Last changed by/on	SAP	20130529
SAP Release Created in