SAP ABAP Table ROIUY1_TX_UT1_DL (Download for UT1 oil 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_UT1_DL	Table Relationship Diagram
Short Description	Download for UT1 oil 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	OPERATOR_NO	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
2	PROD_YYYYMM	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
3	ST_LEASE	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
4	RRC_LEASE_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
5	RRC_DIST_CD	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
6	RRC_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
7	REC_TYPE	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
8	PAYOR_NUMBER	☐			NUMC	11	0
9	SW_SWEET_FL	☐	OIUY1_SW_FLAG	OIUY1_SR	CHAR	1	0	Sweet or Sour Flag(Y/N)
10	PER_PROD	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
11	BEG_STK	☐			NUMC	7	0
12	GROSS_PROD	☐			NUMC	7	0
13	PIPELINE	☐			NUMC	6	0
14	TRUCKS	☐			NUMC	6	0
15	CIR_OIL	☐			NUMC	6	0
16	CODE1	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
17	CODE2	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
18	END_STK	☐			NUMC	7	0
19	NET_BARLS	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
20	NET_OTHER_DISP1	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
21	NET_OTHER_DISP2	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
22	API	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
23	API_OTHER_DISP1	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
24	API_OTHER_DISP2	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
25	MAR_VALUE	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
26	MAR_OTHER_DISP_1	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
27	MAR_OTHER_DISP_2	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
28	ROY_DUE	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
29	ROYDUE_OTH_DISP1	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
30	ROYDUE_OTH_DISP2	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
31	EXCEEDS_PRD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
32	PURCHASER	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
33	AFFILIATED	☐	OIUY1_AFFILIATED	CHAR1	CHAR	1	0	Affiliated Y/N
34	PURCHASER_STATMENT_NO	☐			CHAR	21	0
35	TRACT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
36	PROPERTY_NO	☐	OIUH_CHAR15	CHAR15	CHAR	15	0	OIUH_CHAR15
37	MAR_VALUE_COMMENT1	☐			CHAR	75	0
38	MAR_VALUE_COMMENT2	☐			CHAR	75	0
39	MAR_VALUE_COMMENT3	☐			CHAR	75	0
40	MAR_VALUE_COMMENT4	☐			CHAR	75	0
41	MAR_VALUE_COMMENT5	☐			CHAR	75	0
42	GEN_COMMENT_1	☐			CHAR	75	0
43	GEN_COMMENT_2	☐			CHAR	75	0
44	GEN_COMMENT_3	☐			CHAR	75	0
45	GEN_COMMENT_4	☐			CHAR	75	0
46	GEN_COMMENT_5	☐			CHAR	75	0

History

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