SAP ABAP Table OIU_PR_WC (PRA: Well Completion)

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_PR_WC	Table Relationship Diagram
Short Description	PRA: Well Completion

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	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
3	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number
4	API_WC_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
5	NAME	☐	OIU_WC_NM_CONV	OIU_TEXT35_CONV	CHAR	35	0	Well completion name
6	SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
7	UOM_GRP	☐	OIU_ME_UOMGR	OIU_ME_UOMGR	CHAR	3	0	unit of measure group	OIU_ME_UOM_GR
8	DEV_PGM_NO	☐	OIU_DEV_PGM_NO	OIU_DEV_PGMNO	CHAR	2	0	Development program number	OIU_PR_WLPROG
9	LAT_NO	☐	OIU_LAT_NO	OIU_LATIT_NO	DEC	8	6	Latitude number
10	LAT_DIR_CD	☐	OIU_LAT_DIR_CD	OIU_LATIT_DIR_CD	CHAR	1	0	Latitude direction code
11	LNG_NO	☐	OIU_LNG_NO	OIU_LONG_NO	DEC	9	6	Longitude
12	LNG_DIR_CD	☐	OIU_LNG_DIR_CD	OIU_LONG_DIR_CD	CHAR	1	0	Longitude Direction Code
13	ELEV_DPH_U	☐	OIU_ELEV_DPH_U	MEINS	UNIT	3	0	Elevation/Depth Unit	*
14	PLG_BCK_DPTH	☐	OIU_PLG_DPTH	OIU_QUANTITY_17_3	QUAN	17	3	Plug hole depth
15	DATUM_DPTH	☐	OIU_DATUM_DPTH	OIU_QUANTITY_17_3	QUAN	17	3	Datum depth
16	KB_ELEV	☐	OIU_KB_ELEV	OIU_QUANTITY_17_3	QUAN	17	3	KB elevation
17	BASE_BHP_U	☐	OIU_BASE_BHP_U	MEINS	UNIT	3	0	Base bottom hole pressure	*
18	BASE_BHP	☐	OIU_BASE_BHP	OIU_QUANTITY_17_3	QUAN	17	3	Base bottom hole pressure (BHP)
19	CNTRY_CD	☐	OIU_COUNTRY	LAND1	CHAR	3	0	Country	T005
20	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
21	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
22	RESRV	☐	OIU_RESRVID	OIU_RESRVID	CHAR	10	0	Reservoir ID	OIU_PR_RESRV
23	RESZN	☐	OIU_RESZNID	OIU_RESZNID	CHAR	10	0	Reservoir zone	OIU_PR_RESZN
24	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	OIU_PR_FIELD
25	PF_NO	☐	OIU_PF_NO	OIU_PF_NO	CHAR	10	0	Platform number	OIU_PR_PF
26	PUR_CD	☐	OIU_WL_PUR_CD	OIU_WL_PUR_CD	CHAR	1	0	Well purpose code	OIU_PR_WLPUR
27	LSE_LE_WL_FL	☐	OIU_LE_WL_FL	OIU_X_FLAG	CHAR	1	0	Lease line well flag
28	BEG_PRF_DPH	☐	OIU_BEG_PRF	OIU_QUANTITY_17_3	QUAN	17	3	Begin Perforation Depth
29	END_PRF_DPH	☐	OIU_END_PRF	OIU_QUANTITY_17_3	QUAN	17	3	End Performation Depth
30	ALT_WC_KEY	☐	OIU_ALT_WC_KEY	CHAR20	CHAR	20	0	Alternate WC Key
31	LCL_WL_NO	☐	OIU_LCL_WL_NO		CHAR	15	0	Local Well Number
32	WC_SET	☐	OIU_WC_SET	CHAR15	CHAR	15	0	Well Completion Hierarchy Group
33	DOCNR	☐	OIUPR_WC_DOCNR	OIU_DOCNR	CHAR	10	0	Well completion document number
34	DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
35	OR1_OR_LVL_1_NO	☐	OIUH_CHAR3_ORGLVL1	OIUH_OR_LVL_1_NO	CHAR	3	0	Org. Level 1 - Company	OIUH_CM_OR1
36	OR2_OR_LVL_2_NO	☐	OIUH_CHAR1_ORGLVL2	CHAR1	CHAR	1	0	Second-highest organization level number ( Company Code)	OIUH_CM_OR2
37	OR3_OR_LVL_3_NO	☐	OIUH_CHAR3_ORGLVL3	CHAR3	CHAR	3	0	Third-highest organization level number ( Company Code)	OIUH_CM_OR3
38	OR4_OR_LVL_4_NO	☐	OIUH_CHAR2_ORGLVL4	CHAR2	CHAR	2	0	Fourth-highest organization level number ( Company Code)	OIUH_CM_OR4
39	.INCLUDE	☐				0	0	Creator and date/time created
40	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
41	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_PR_WC	CNTRY_CD	T005	LAND1	KEY	1	CN
2	OIU_PR_WC	DEV_PGM_NO	OIU_PR_WLPROG	DEV_PGM_NO		1	CN
3	OIU_PR_WC	FIELD	OIU_PR_FIELD	FIELD	KEY	1	CN
4	OIU_PR_WC	OR1_OR_LVL_1_NO	OIUH_CM_OR1	OR1_OR_LVL_1_NO	KEY	1	CN
5	OIU_PR_WC	OR2_OR_LVL_2_NO	OIUH_CM_OR2	OR2_OR_LVL_2_NO	KEY	1	CN
6	OIU_PR_WC	OR3_OR_LVL_3_NO	OIUH_CM_OR3	OR3_OR_LVL_3_NO	KEY	1	CN
7	OIU_PR_WC	OR4_OR_LVL_4_NO	OIUH_CM_OR4	OR4_OR_LVL_4_NO	KEY	1	CN
8	OIU_PR_WC	PF_NO	OIU_PR_PF	PF_NO	KEY	1	CN
9	OIU_PR_WC	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC	KEY	1	CN
10	OIU_PR_WC	PUR_CD	OIU_PR_WLPUR	WL_PUR_CD		1	CN
11	OIU_PR_WC	RESRV	OIU_PR_RESRV	RESRV	KEY	1	CN
12	OIU_PR_WC	RESZN	OIU_PR_RESZN	RESZN	KEY	1	CN
13	OIU_PR_WC	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC	KEY	1	CN
14	OIU_PR_WC	UOM_GRP	OIU_ME_UOM_GR	UOMGR	KEY	1	CN
15	OIU_PR_WC	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in