SAP ABAP Table OIUH_TR03 (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_TR03	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_DI_DI_NM	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
2	C_RDTL_PR_NO	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
3	C_RDT_PR_NO	☐	OIUH_PROPERTY_DOI	CHAR8	CHAR	8	0	Property / DOI
4	C_RDTL_DOI_NO	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
5	C_RDT_DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
6	C_MP_MP_DE	☐	OIUH_CHAR30	CHAR30	CHAR	30	0	OIUH_CHAR30
7	C_RDTL_MP_NO	☐	OIUH_MEASUREMENT_POINT_ID	CHAR6	CHAR	6	0	Measurement Point ID
8	C_MP_MP_NO	☐	OIUH_MEASUREMENT_POINT2	CHAR6	CHAR	6	0	Measurement Point
9	C_WC_WC_NM	☐	OIUH_CHAR35	CHAR35	CHAR	35	0	OIUH_CHAR35
10	C_RDTL_WL_NO	☐	OIUH_WELL_NO	CHAR6	CHAR	6	0	Well ID Number
11	C_RDTL_WC_NO	☐	OIUH_WELL_COMPLETION_ID	CHAR2	CHAR	2	0	Well Completion ID
12	C_WC_WL_NO	☐	OIUH_WELL_NO	CHAR6	CHAR	6	0	Well ID Number
13	C_WC_WC_NO	☐	OIUH_WELL_COMPLETION_ID	CHAR2	CHAR	2	0	Well Completion ID
14	C_A_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
15	C_DI_PD_CD	☐	OIUH_PRODUCT_CODE	CHAR3	CHAR	3	0	Product Code
16	C_B_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
17	C_ST_CD	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
18	C_RDTL_EFF_FROM_DT	☐	OIUH_EFFECTIVE_FROM_DATE	CHAR10	CHAR	10	0	Effective From Date
19	C_RDTL_EFF_TO_DT	☐	OIUH_EFFECTIVE_TO_DATE	CHAR10	CHAR	10	0	Effective To Date
20	C_RDTL_ST_RPT_CD	☐	OIUH_CHAR15	CHAR15	CHAR	15	0	OIUH_CHAR15
21	C_RDTL_ALLOC_PC	☐	OIUH_LEASE_ALLOCATION_FACTOR	OIUH_DEC9_8	DEC	9	8	Lease Allocation Factor
22	C_RDTL_PART_FAC_PC	☐	OIUH_PARTICIPTN_ROYALTY_PCT	OIUH_DEC9_8	DEC	9	8	Participation / Royalty Percent
23	C_RDTL_VER_NO	☐	OIUH_NUMC22	OIUH_NUMC22	NUMC	22	0	OIUH_NUMC22
24	C_RB_GAS	☐	OIUH_RB_GAS_OIL	CHAR1	CHAR	1	0	Oil / Gas / Both Radio Buttons
25	C_RB_OIL	☐	OIUH_RB_GAS_OIL	CHAR1	CHAR	1	0	Oil / Gas / Both Radio Buttons
26	C_RB_BOTH	☐	OIUH_RB_GAS_OIL	CHAR1	CHAR	1	0	Oil / Gas / Both Radio Buttons
27	C_RDT_ST_UNIT_NO	☐	OIUH_UNIT_NO	CHAR4	CHAR	4	0	State Unit Number
28	C_RDT_RRC_DIST_CD	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
29	C_RDT_ST_PR_NM	☐	OIUH_FIELD_NAME	CHAR25	CHAR	25	0	Field Name
30	C_RDT_ST_LSE_NM	☐	OIUH_LEASE_NAME2	CHAR35	CHAR	35	0	Lease Name
31	C_RDT_RRC_OIL_LSE_NO	☐	OIUH_RRC_LEASE_ID	CHAR6	CHAR	6	0	RRC Lease ID
32	C_RDT_RRC_WL_LSE_NO	☐	OIUH_RRC_WELL_ID	CHAR10	CHAR	10	0	RRC Well ID
33	C_RB_SWEET	☐	OIUH_RB_SWEET_SOUR	CHAR1	CHAR	1	0	Sweet / Sour Radio Buttons
34	C_RB_SOUR	☐	OIUH_RB_SWEET_SOUR	CHAR1	CHAR	1	0	Sweet / Sour Radio Buttons
35	C_RDTL_TOT_PC	☐	OIUH_DEC9_8	OIUH_DEC9_8	DEC	9	8	OIUH_DEC9_8
36	C_RDTL_ST_FL_CD	☐	OIUH_FIELD	CHAR4	CHAR	4	0	Louisiana Field ID
37	C_E_TT_ELEM_DE	☐	OIUH_CHAR50	CHAR50	CHAR	50	0	OIUH_CHAR50
38	C_RDTL_LSE_SHR	☐	OIUH_LEASE_SHARE	CHAR25	CHAR	25	0	Lease Share
39	C_RDTL_DPT_NO	☐	OIUH_LA_DEPARTMENT	CHAR10	CHAR	10	0	Louisiana Department
40	C_RDTL_DOC_PLNT	☐	OIUH_DOC_PLANT	CHAR25	CHAR	25	0	DOC Plant
41	C_RDTL_RPT_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
42	C_RDT_AL_PC	☐	OIUH_ALLOCATION_PERCENT	OIUH_DEC9_8	DEC	9	8	Allocation Percent
43	C_RDT_PART_FAC_QY	☐	OIUH_PARTICIPTN_ROYALTY_PCT	OIUH_DEC9_8	DEC	9	8	Participation / Royalty Percent
44	C_SUM_RDT_AL_PC	☐	OIUH_TOTAL_PERCENT	NUMC10	NUMC	10	0	Total Percent
45	C_RDT_ST_LSE_NO	☐	OIUH_STATE_LEASE_NO	CHAR15	CHAR	15	0	State Lease Number
46	C_RDT_EFF_FROM_DT	☐	OIUH_EFFECTIVE_FROM	DATS	DATS	8	0	Effective From Date
47	C_RDT_EFF_TO_DT	☐	OIUH_EFFECTIVE_TO	DATS	DATS	8	0	Effective To Date
48	C_SUM_RDTL_ALLOC_PC	☐	OIUH_TOTAL_LS_ALLOC_FCTR	NUMC10	NUMC	10	0	Total Lease Allocation Factor
49	C_RDTL_WL_FL	☐	OIUH_WELL_INDICATOR	CHAR1	CHAR	1	0	Well Indicator
50	C_RDT_VER_NO	☐	OIUH_NUMC22	OIUH_NUMC22	NUMC	22	0	OIUH_NUMC22
51	C_RDTL_DEST_CD	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUH_TR03	C_ST_CD	OIU_CM_LXPGL	PRI_GEO_LOC

History

Last changed by/on	SAP	20110901
SAP Release Created in