SAP ABAP Table ROIU_DO_JV (Maintenance Structure: OIU_DO_JV)

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	INTTAB	Structure
Structure	ROIU_DO_JV	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_DO_JV

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	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
31	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
32	VNAME_CREATE	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
33	VNAME_NM_CREATE	☐	OIU_VNAME_NM	OIU_TEXT35	CHAR	35	0	venture name
34	REF_BUKRS	☐	REF_BUKRS	BUKRS	CHAR	4	0	Reference Company Code	T001
35	REF_BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
36	REF_VNAME	☐	OIU_JV_NAME_REF	JV_NAME	CHAR	6	0	Reference Joint Venture	OIU_DO_JV
37	REF_VNAME_NM	☐	OIU_VNAME_NM	OIU_TEXT35	CHAR	35	0	venture name
38	VACTIVE	☐	OIU_VACTIVE	OIU_X_FLAG	CHAR	1	0	Venture status
39	VNAME_INT_CD_DE	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
40	VNAME_STATUS_DE	☐	OIU_VNAME_STATUS_DE	OIU_TEXT50	CHAR	50	0	Description
41	TYPE_CD_DE	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
42	VTYPE	☐	OIU_VTYPE	OIU_X_FLAG	CHAR	1	0	Venture Type
43	OPERATOR	☐	JV_OPERAT	KUNNR	CHAR	10	0	Operator for Non-Operated Venture	KNA1
44	OPER_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
45	FIELD_NM	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
46	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
47	UN_VOL_FL	☐	OIU_UN_VOL_FL	OIU_X_FLAG	CHAR	1	0	Maintain Unit/Venture Volume
48	CNTRY_DE	☐	LANDX	TEXT15	CHAR	15	0	Country Name
49	PRI_GEO_DE	☐	OIU_PRI_GEO_DESC	CHAR30	CHAR	30	0	Primary geographical location description
50	SEC_GEO_DE	☐	OIU_SEC_GEO_DESC	CHAR30	CHAR	30	0	Secondary Geographical Location Description
51	ONS_OFS_DE	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
52	AQR_FROM_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
53	SOLD_TO_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_DO_JV	ACQ_FROM_KUNNR	KNA1	KUNNR		1	CN
2	ROIU_DO_JV	BUKRS	T001	BUKRS	KEY	1	CN
3	ROIU_DO_JV	COUNTRY	T005	LAND1		1	CN
4	ROIU_DO_JV	FIELD	OIU_PR_FIELD	FIELD
5	ROIU_DO_JV	OPERATOR	KNA1	KUNNR	KEY	1	CN
6	ROIU_DO_JV	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
7	ROIU_DO_JV	REF_BUKRS	T001	BUKRS	KEY	1	CN
8	ROIU_DO_JV	REF_VNAME	OIU_DO_JV	VNAME	KEY	1	CN
9	ROIU_DO_JV	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC		1	CN
10	ROIU_DO_JV	SLD_TO_KUNNR	KNA1	KUNNR		1	CN
11	ROIU_DO_JV	STS_CODE	OIU_CM_VNAMST	VNAME_STATUS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in