SAP ABAP Table OIUH_PR_WC (Oil and Gas appl table)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV (Application Component) Revenue
     ⤷ OIU_H (Package) PRA Hybrid Solution

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUH_PR_WC	Table Relationship Diagram
Short Description	Oil and Gas appl table

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	WC_WL_NO	☑	OIUREP_WL_NO	CHAR6	CHAR	6	0	Well No.	OIUH_PR_WL
3	WC_WC_NO	☑	OIUREP_WC_NO	CHAR2	CHAR	2	0	Well Completion No.
4	WC_TOW_NO	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
5	WC_API_WC_NO	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
6	WC_WC_ID	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
7	WC_WC_NM9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
8	WC_WC_NM	☐	OIUH_CHAR35	CHAR35	CHAR	35	0	OIUH_CHAR35
9	WC_MEAS_SYS_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
10	WC_DEV_PGM_NO	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
11	WC_GEO_SVY_DE9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
12	WC_GEO_SVY_DE	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
13	WC_LAT_NO	☐	OIUH_DEC8_6	OIUH_DEC8_6	DEC	8	6	OIUH_DEC8_6
14	WC_LAT_DIR_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
15	WC_LNG_NO	☐	OIUH_DEC9_6	OIUH_DEC9_6	DEC	9	6	OIUH_DEC9_6
16	WC_LNG_DIR_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
17	PLG_BCK_DPTH_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
18	C_DATUM_DPTH_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
19	WC_KB_ELEV_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
20	WC_BASE_BHP_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
21	WC_CY_CD	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
22	WC_CNTRY_CD	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
23	WC_ST_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
24	WC_SAND_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
25	WC_FL_NO	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
26	WC_PF_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
27	WC_PF_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
28	WC_DISP_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
29	WC_DISP_DT9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
30	WC_DISP_DT	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
31	WC_JBASG_CD	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
32	WC_PUR_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
33	WC_PUMPER_CD	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
34	WC_FOREMAN_CD	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
35	WC_EXT_COM_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
36	WC_LSE_GRP_NO	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
37	WC_LSE_LE_WL_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
38	BEG_PRF_DPH_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
39	END_PRF_DPH_QY	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
40	WC_SCH_KEY	☐	OIUH_CHAR20	CHAR20	CHAR	20	0	OIUH_CHAR20
41	WC_LCL_WC_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
42	WC_VER_NO	☐	OIUH_DEC5	DEC5	DEC	5	0	OIUH_DEC5
43	WC_USER_ID	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
44	WC_TIMESTAMP	☐	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	OIUH_PR_WC	WC_WL_NO	OIUH_PR_WL	WL_WL_NO

History

Last changed by/on	SAP	20130529
SAP Release Created in