SAP ABAP Table ROIUY1_TX_UT2_D (Structure to store detail records for UT2 report)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY1_TX_UT2_D	Table Relationship Diagram
Short Description	Structure to store detail records for UT2 report

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	ST_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
2	PROD_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	PER_PROD	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
4	GROSS_PROD	☐			DEC	13	3
5	RS_SALES_VOL	☐			DEC	13	3
6	RS_CODE1	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
7	RS_VOL1	☐			DEC	13	3
8	RS_CODE2	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
9	RS_VOL2	☐			DEC	13	3
10	RS_CODE3	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
11	RS_VOL3	☐			DEC	13	3
12	NGL_VOL_SUM	☐			DEC	13	3
13	NP_SALES_VOL	☐			DEC	13	3
14	NP_CODE1	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
15	NP_VOL1	☐			DEC	13	3
16	NP_CODE2	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
17	NP_VOL2	☐			DEC	13	3
18	NP_CODE3	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
19	NP_VOL3	☐			DEC	13	3
20	GAS_PRICE	☐			DEC	13	6
21	BTU	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
22	PRC_MMBTU	☐			DEC	13	6
23	NP_GAS_VALUE	☐	OIUY1_STD_VAL		DEC	13	2	Value
24	RS_GAS_VALUE	☐	OIUY1_STD_VAL		DEC	13	2	Value
25	NGL_VAL_SUM	☐	OIUY1_STD_VAL		DEC	13	2	Value
26	OTHER_VALUE1	☐	OIUY1_STD_VAL		DEC	13	2	Value
27	OTHER_CD1	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
28	OTHER_VALUE2	☐	OIUY1_STD_VAL		DEC	13	2	Value
29	OTHER_CD2	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
30	OTHER_VALUE3	☐	OIUY1_STD_VAL		DEC	13	2	Value
31	OTHER_CD3	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
32	TOT_VALUE	☐	OIUY1_STD_VAL		DEC	13	2	Value
33	EXCEEDS_PRD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
34	ROY_DEC	☐	OIUY1_ROYALTY_DEC	OIUH_DEC9_6	DEC	9	6	Royalty Decimal
35	ROY_DUE	☐	OIUY1_STD_VAL		DEC	13	2	Value
36	REC_COUNT	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
37	SALES_DATE	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
38	PUR_ID	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
39	RRC_LSE_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
40	TIK_WIO	☐	OIUY1_STD_VOL		DEC	13	3	Volumes
41	GEN_COMMENT_1	☐			CHAR	75	0
42	GEN_COMMENT_2	☐			CHAR	75	0
43	GEN_COMMENT_3	☐			CHAR	75	0
44	GEN_COMMENT_4	☐			CHAR	75	0
45	GEN_COMMENT_5	☐			CHAR	75	0

History

Last changed by/on	SAP	20070914
SAP Release Created in	46C