SAP ABAP Table ROIU_PR_WELL (Maintenance Structure: OIU_PR_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	INTTAB	Structure
Structure	ROIU_PR_WELL	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_PR_WELL

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

History

Last changed by/on	SAP	20050301
SAP Release Created in