SAP ABAP Table OIU_PR_WELL (PRA: Well)

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

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
3	API_NO	☐	OIU_WLAPI	OIU_WLAPI	CHAR	12	0	API well number
4	WL_DE	☐	OIU_WL_DE_CONV	OIU_TEXT35_CONV	CHAR	35	0	Well Description
5	SHTXT	☐	OIU_SHTXT	CHAR35	CHAR	35	0	Description
6	DEV_CD	☐	OIU_DEV_CD	OIU_DEV_CD	CHAR	1	0	Well drilled	OIU_PR_WLDEV
7	GLE_U	☐	OIU_GLE_U	MEINS	UNIT	3	0	Ground level elevation unit	T006
8	GLE	☐	OIU_GLE	OIU_VOLUME_SIGN	DEC	13	3	Ground level elevation
9	SLOT_NO	☐	OIU_SLOT_NO	OIU_SLOT_NO	CHAR	5	0	Slot Number (Base Meridian)
10	SUR_LAT_NO	☐	OIU_SUR_LAT_NO	OIU_LATIT_NO	DEC	8	6	Surface Latitude
11	SUR_LAT_D_CD	☐	OIU_SUR_LAT_D_CD	OIU_LATIT_DIR_CD	CHAR	1	0	Surface latitude Direction
12	SUR_LNG_NO	☐	OIU_SUR_LNG_NO	OIU_LONG_NO	DEC	9	6	Surface longitude
13	SUR_LNG_D_CD	☐	OIU_SUR_LNG_D_CD	OIU_LONG_DIR_CD	CHAR	1	0	Surface longitude direction code
14	LEG_DE	☐	OIU_LEG_DE	CHAR60	CHAR	60	0	Legal Description
15	DO_DPTH_U	☐	OIU_DO_DPTH_U	MEINS	UNIT	3	0	Drill-out depth unit	T006
16	DO_DPTH	☐	OIU_DO_DPTH	MENGE	QUAN	13	3	Drill-out depth
17	QTR_1_NO	☐	OIU_QTR_1_NO	CHAR2	CHAR	2	0	Quarter 1 Number
18	QTR_2_NO	☐	OIU_QTR_2_NO	CHAR2	CHAR	2	0	Quarter 2 Number
19	SECTION_NO	☐	OIU_SECTION_NO	CHAR3	CHAR	3	0	Section Number
20	TWP_NO	☐	OIU_TWP_NO	CHAR3	CHAR	3	0	Township number
21	TWP_DIR_CD	☐	OIU_TWP_DIR_CD	CHAR1	CHAR	1	0	Township direction code
22	RNG_NO	☐	OIU_RNG_NO	CHAR3	CHAR	3	0	Range number
23	RNG_DIR_CD	☐	OIU_RNG_DIR_CD	CHAR1	CHAR	1	0	Range Direction Code
24	TARG_DPTH_U	☐	OIU_TARG_DPTH_U	MEINS	UNIT	3	0	Target depth unit of measure	T006
25	TARG_DPTH	☐	OIU_TARG_DPTH	MENGE	QUAN	13	3	Target depth
26	MMS_OWNER_CD	☐	OIU_MMS_OWNER_FL	OIU_OWNER_FLAG	CHAR	1	0	MMS Ownership Code
27	WL_GRP	☐	OIU_WL_GRP	OIU_WL_GRP	CHAR	4	0	Well Number Range Group	OIU_PR_WL_GRP
28	DOCNR	☐	OIUPR_WL_DOCNR	OIU_DOCNR	CHAR	10	0	Well document number
29	DOCYR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
30	.INCLUDE	☐				0	0	Creator and date/time created
31	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	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_WELL	DEV_CD	OIU_PR_WLDEV	DEV_CD		1	CN
2	OIU_PR_WELL	DO_DPTH_U	T006	MSEHI	KEY	1	CN
3	OIU_PR_WELL	GLE_U	T006	MSEHI	KEY	1	CN
4	OIU_PR_WELL	TARG_DPTH_U	T006	MSEHI	KEY	1	CN
5	OIU_PR_WELL	WL_GRP	OIU_PR_WL_GRP	WL_GRP	KEY	1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in