SAP ABAP Table OIUH_TR02 (SAP Oil&Gas)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	OIUH_TR02	Table Relationship Diagram
Short Description	SAP Oil&Gas

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	C_TD_PR_NO	☐	OIUH_PROPERTY_DOI	CHAR8	CHAR	8	0	Property / DOI
2	C_TD_DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
3	C_TD_MP_NO	☐	OIUH_MEASUREMENT_POINT_ID	CHAR6	CHAR	6	0	Measurement Point ID
4	C_MP_MP_DE	☐	OIUH_MP_NAME	CHAR30	CHAR	30	0	Measurement Point Name
5	C_DI_DI_NM	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
6	C_A_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
7	C_TD_EFF_FROM_DT	☐	OIUH_EFFECTIVE_FROM	DATS	DATS	8	0	Effective From Date
8	C_TD_EFF_TO_DT	☐	OIUH_EFFECTIVE_TO	DATS	DATS	8	0	Effective To Date
9	C_TD_ST_RPT_NO	☐	OIUH_STATE_LEASE_ID	CHAR13	CHAR	13	0	RRC State Lease ID
10	C_TD_ST_CD	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
11	C_B_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
12	C_TD_ST_LSE_NO	☐	OIUH_CERTIFICATE_NO	CHAR8	CHAR	8	0	Certificate Number
13	C_TD_ST_PRDR_CD	☐	OIUH_STATE_PRODUCER	CHAR8	CHAR	8	0	State Producer
14	C_C_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
15	C_TD_PLT_PRCS_CD	☐	OIUH_PROCESSING_PLANT	CHAR8	CHAR	8	0	Processing Plant
16	C_D_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
17	C_TD_CONTINUITY_CD	☐	OIUH_CONTINUITY	CHAR1	CHAR	1	0	Continuity Indicator
18	C_E_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
19	C_TD_WL_SER_NO	☐	OIUH_WELL_SERIAL_LA	CHAR6	CHAR	6	0	Well Serial Number LA
20	C_TD_TIK_PC	☐	OIUH_DEC9_8	OIUH_DEC9_8	DEC	9	8	OIUH_DEC9_8
21	C_TD_ST_FL_CD	☐	OIUH_FIELD	CHAR4	CHAR	4	0	Louisiana Field ID
22	C_F_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
23	C_TD_TAX_PAY_CD	☐	OIUH_TAXPAYER	CHAR8	CHAR	8	0	Taxpayer
24	C_G_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
25	C_TD_CONS_WL_NO	☐	OIUH_CONS_WELL_CODE	OIUH_CONS_WL_NO	CHAR	4	0	Conservation Well Code
26	C_TD_ALLOC_PC	☐	OIUH_ALLOCATION_FACTOR	OIUH_DEC9_8	DEC	9	8	Allocation Factor
27	C_TD_EXIN_DEC_AM	☐	OIUH_EXEMPT_ALLOCATION	OIUH_DEC9_8	DEC	9	8	Exempt Allocation
28	C_TD_EX_RE_AL_PC	☐	OIUH_DEC9_8	OIUH_DEC9_8	DEC	9	8	OIUH_DEC9_8
29	C_TD_ENTY_CD	☐	OIUH_ENTITY_TYPE	OIUH_ENTITY_TYPE	CHAR	2	0	Exempt Entity Type
30	C_H_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
31	C_TD_SCHOL_DIST_CD	☐	OIUH_SCHOOL_DISTRICT	CHAR3	CHAR	3	0	School District NM
32	C_I_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
33	C_TD_ND_POOL_NO	☐	OIUH_POOL_NO	CHAR8	CHAR	8	0	Pool ID
34	C_TD_OIL_CLASS_CD	☐	OIUH_OIL_CLASS	CHAR1	CHAR	1	0	Oklahoma Oil Class
35	C_TD_RR_CMSN_LSE_DE	☐	OIUH_RRC_LEASE_NAME	CHAR30	CHAR	30	0	RRC Lease Name
36	C_TD_PRCS_OIL_CND_FL	☐	OIUH_OIL_CONDENSATE_IND	CHAR1	CHAR	1	0	Process Oil / Condensate Indicator
37	C_TD_VER_NO	☐	OIUH_NUMC22	OIUH_NUMC22	NUMC	22	0	OIUH_NUMC22
38	C_TD_WL_NO	☐	OIUH_WELL_NO	CHAR6	CHAR	6	0	Well ID Number
39	C_TD_WC_NO	☐	OIUH_WELL_COMPLETION_ID	CHAR2	CHAR	2	0	Well Completion ID
40	C_WC_WC_NM	☐	OIUH_CHAR35	CHAR35	CHAR	35	0	OIUH_CHAR35
41	C_TD_GAS_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
42	C_TD_PD_CD	☐	OIUH_PRODUCT_CODE	CHAR3	CHAR	3	0	Product Code
43	C_RB_PR_NO	☐	OIUH_RB_MP_PR_WL	CHAR1	CHAR	1	0	Property / Meas Point / WC Radio buttons
44	C_RB_WL_NO	☐	OIUH_RB_MP_PR_WL	CHAR1	CHAR	1	0	Property / Meas Point / WC Radio buttons
45	C_RB_MP_NO	☐	OIUH_RB_MP_PR_WL	CHAR1	CHAR	1	0	Property / Meas Point / WC Radio buttons

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUH_TR02	C_TD_ST_CD	OIU_CM_LXPGL	PRI_GEO_LOC

History

Last changed by/on	SAP	20110901
SAP Release Created in