SAP ABAP Table ROIU_PR_WC (Maintenance Structure: OIU_PR_WC)

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_PR_WC	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_PR_WC

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: Well Completion
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
4	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	*
5	API_WC_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
6	NAME	☐	OIU_WC_NM_CONV	OIU_TEXT35_CONV	CHAR	35	0	Well completion name
7	SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
8	UOM_GRP	☐	OIU_ME_UOMGR	OIU_ME_UOMGR	CHAR	3	0	unit of measure group	OIU_ME_UOM_GR
9	DEV_PGM_NO	☐	OIU_DEV_PGM_NO	OIU_DEV_PGMNO	CHAR	2	0	Development program number	OIU_PR_WLPROG
10	LAT_NO	☐	OIU_LAT_NO	OIU_LATIT_NO	DEC	8	6	Latitude number
11	LAT_DIR_CD	☐	OIU_LAT_DIR_CD	OIU_LATIT_DIR_CD	CHAR	1	0	Latitude direction code
12	LNG_NO	☐	OIU_LNG_NO	OIU_LONG_NO	DEC	9	6	Longitude
13	LNG_DIR_CD	☐	OIU_LNG_DIR_CD	OIU_LONG_DIR_CD	CHAR	1	0	Longitude Direction Code
14	ELEV_DPH_U	☐	OIU_ELEV_DPH_U	MEINS	UNIT	3	0	Elevation/Depth Unit	*
15	PLG_BCK_DPTH	☐	OIU_PLG_DPTH	OIU_QUANTITY_17_3	QUAN	17	3	Plug hole depth
16	DATUM_DPTH	☐	OIU_DATUM_DPTH	OIU_QUANTITY_17_3	QUAN	17	3	Datum depth
17	KB_ELEV	☐	OIU_KB_ELEV	OIU_QUANTITY_17_3	QUAN	17	3	KB elevation
18	BASE_BHP_U	☐	OIU_BASE_BHP_U	MEINS	UNIT	3	0	Base bottom hole pressure	*
19	BASE_BHP	☐	OIU_BASE_BHP	OIU_QUANTITY_17_3	QUAN	17	3	Base bottom hole pressure (BHP)
20	CNTRY_CD	☐	OIU_COUNTRY	LAND1	CHAR	3	0	Country	T005
21	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
22	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
23	RESRV	☐	OIU_RESRVID	OIU_RESRVID	CHAR	10	0	Reservoir ID	OIU_PR_RESRV
24	RESZN	☐	OIU_RESZNID	OIU_RESZNID	CHAR	10	0	Reservoir zone	OIU_PR_RESZN
25	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	OIU_PR_FIELD
26	PF_NO	☐	OIU_PF_NO	OIU_PF_NO	CHAR	10	0	Platform number	OIU_PR_PF
27	PUR_CD	☐	OIU_WL_PUR_CD	OIU_WL_PUR_CD	CHAR	1	0	Well purpose code	OIU_PR_WLPUR
28	LSE_LE_WL_FL	☐	OIU_LE_WL_FL	OIU_X_FLAG	CHAR	1	0	Lease line well flag
29	BEG_PRF_DPH	☐	OIU_BEG_PRF	OIU_QUANTITY_17_3	QUAN	17	3	Begin Perforation Depth
30	END_PRF_DPH	☐	OIU_END_PRF	OIU_QUANTITY_17_3	QUAN	17	3	End Performation Depth
31	ALT_WC_KEY	☐	OIU_ALT_WC_KEY	CHAR20	CHAR	20	0	Alternate WC Key
32	LCL_WL_NO	☐	OIU_LCL_WL_NO		CHAR	15	0	Local Well Number
33	WC_SET	☐	OIU_WC_SET	CHAR15	CHAR	15	0	Well Completion Hierarchy Group
34	DOCNR	☐	OIUPR_WC_DOCNR	OIU_DOCNR	CHAR	10	0	Well completion document number
35	DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
36	OR1_OR_LVL_1_NO	☐	OIUH_CHAR3_ORGLVL1	OIUH_OR_LVL_1_NO	CHAR	3	0	Org. Level 1 - Company	OIUH_CM_OR1
37	OR2_OR_LVL_2_NO	☐	OIUH_CHAR1_ORGLVL2	CHAR1	CHAR	1	0	Second-highest organization level number ( Company Code)	OIUH_CM_OR2
38	OR3_OR_LVL_3_NO	☐	OIUH_CHAR3_ORGLVL3	CHAR3	CHAR	3	0	Third-highest organization level number ( Company Code)	OIUH_CM_OR3
39	OR4_OR_LVL_4_NO	☐	OIUH_CHAR2_ORGLVL4	CHAR2	CHAR	2	0	Fourth-highest organization level number ( Company Code)	OIUH_CM_OR4
40	.INCLUDE	☐				0	0	Creator and date/time created
41	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
42	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
43	WL_DE	☐	OIU_WL_DE	OIU_TEXT35	CHAR	35	0	Well Description
44	WL_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
45	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
46	REF_WL_NO	☐	OIU_WL_NO_REF	OIU_WL_NO	CHAR	15	0	Reference well ID number	OIU_PR_WELL
47	REF_WL_DE	☐	OIU_WL_DE	OIU_TEXT35	CHAR	35	0	Well Description
48	REF_WL_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
49	REF_WC_NO	☐	OIU_WC_NO_REF	OIU_WC_NO	CHAR	5	0	Reference well completion number	OIU_PR_WC
50	REF_NAME	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
51	REF_WC_SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
52	FL_NAME	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
53	PF_NAME	☐	OIU_PF_NAME	OIU_TEXT35	CHAR	35	0	Platform Name
54	RES_NAME	☐	OIU_RES_NAME	OIU_TEXT35	CHAR	35	0	Reservoir name
55	CNTRY_DE	☐	LANDX	TEXT15	CHAR	15	0	Country Name
56	UOMGR_DESCR	☐	OIU_ME_UOMGR_TX	TEXT40	CHAR	40	0	Description of the unit of measure group
57	PRI_GEO_DESC	☐	OIU_PRI_GEO_DESC	CHAR30	CHAR	30	0	Primary geographical location description
58	SEC_GEO_DESC	☐	OIU_SEC_GEO_DESC	CHAR30	CHAR	30	0	Secondary Geographical Location Description
59	ZONE_NAME	☐	OIU_ZONE_NAME	CHAR35	CHAR	35	0	Zone name
60	DEV_PGM_DE	☐	OIU_DEV_PGM_DE	OIU_TEXT50	CHAR	50	0	Well Completion development program description
61	WL_PUR_DE	☐	OIU_WL_PUR_DE	OIU_TEXT50	CHAR	50	0	Well Purpose Description
62	REF_DOCNR	☐	OIUPR_WC_DOCNR	OIU_DOCNR	CHAR	10	0	Well completion document number
63	REF_DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
64	OR1_DE	☐	OIUH_CHAR40	CHAR40	CHAR	40	0	OIUH_CHAR40
65	OR2_DE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
66	OR3_DE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
67	OR4_DE	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_PR_WC	CNTRY_CD	T005	LAND1	KEY	1	CN
2	ROIU_PR_WC	DEV_PGM_NO	OIU_PR_WLPROG	DEV_PGM_NO		1	CN
3	ROIU_PR_WC	FIELD	OIU_PR_FIELD	FIELD	KEY	1	CN
4	ROIU_PR_WC	OR1_OR_LVL_1_NO	OIUH_CM_OR1	OR1_OR_LVL_1_NO	KEY	1	CN
5	ROIU_PR_WC	OR2_OR_LVL_2_NO	OIUH_CM_OR2	OR2_OR_LVL_2_NO	KEY	1	CN
6	ROIU_PR_WC	OR3_OR_LVL_3_NO	OIUH_CM_OR3	OR3_OR_LVL_3_NO	KEY	1	CN
7	ROIU_PR_WC	OR4_OR_LVL_4_NO	OIUH_CM_OR4	OR4_OR_LVL_4_NO	KEY	1	CN
8	ROIU_PR_WC	PF_NO	OIU_PR_PF	PF_NO	KEY	1	CN
9	ROIU_PR_WC	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC	KEY	1	CN
10	ROIU_PR_WC	PUR_CD	OIU_PR_WLPUR	WL_PUR_CD		1	CN
11	ROIU_PR_WC	REF_WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
12	ROIU_PR_WC	REF_WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN
13	ROIU_PR_WC	RESRV	OIU_PR_RESRV	RESRV	KEY	1	CN
14	ROIU_PR_WC	RESZN	OIU_PR_RESZN	RESZN	KEY	1	CN
15	ROIU_PR_WC	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC	KEY	1	CN
16	ROIU_PR_WC	UOM_GRP	OIU_ME_UOM_GR	UOMGR	KEY	1	CN
17	ROIU_PR_WC	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in