SAP ABAP Table ROIUY1_TX_AM2A_DL (Download structure for AM2A)

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_AM2A_DL	Table Relationship Diagram
Short Description	Download structure for AM2A

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	PROGRAM_NM	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
2	BATCH_NO	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
3	REC_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
4	FILLER_0	☐	OIUH_CHAR9	CHAR9	CHAR	9	0	OIUH_CHAR9
5	REC_LENGTH	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
6	REC_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
7	FOLDER	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
8	GROUP_NO	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
9	PROD_YY	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
10	PROD_MM	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
11	LAND_ACCT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
12	ST_LEASE	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
13	TRANS_CODE	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
14	RPT_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
15	UNIT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
16	CODE	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
17	CLASS	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
18	CO_NM	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
19	CO_NO	☐	OIUH_CHAR11	CHAR11	CHAR	11	0	OIUH_CHAR11
20	GAS	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
21	ROYAL_PD_BY	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
22	FIELD_NM	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
23	LEASE_NM_1	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
24	LEASE_NM_2	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
25	LEASE_NM_3	☐	OIUH_CHAR25	CHAR25	CHAR	25	0	OIUH_CHAR25
26	RPT_REC_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
27	PR_VOL_WAS	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
28	FILLER_1	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
29	PR_VOL_SHD	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
30	FILLER_2	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
31	PR_VOL_NET	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
32	FILLER_3	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
33	NS_NO_ROY_CODE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
34	NS_NO_ROY_WAS	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
35	FILLER_4	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
36	NS_NO_ROY_SHD	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
37	FILLER_5	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
38	NS_NO_ROY_NET	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
39	FILLER_6	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
40	NS_ROY_CODE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
41	NS_VOL_WAS	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
42	FILLER_7	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
43	NS_VOL_SHD	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
44	FILLER_8	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
45	NS_VOL_NET	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
46	FILLER_9	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
47	NS_PRC_WAS	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
48	FILLER_10	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
49	NS_PRC_SHD	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
50	FILLER_11	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
51	NS_PRC_NET	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
52	FILLER_12	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
53	NS_BTU_WAS	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
54	FILLER_13	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
55	NS_BTU_SHD	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
56	FILLER_14	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
57	NS_BTU_NET	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
58	FILLER_15	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
59	NS_GR_VAL_WAS	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
60	FILLER_16	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
61	NS_GR_VAL_SHD	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
62	FILLER_17	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
63	NS_GR_VAL_NET	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
64	FILLER_18	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
65	NP_VOL_WAS	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
66	FILLER_19	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
67	NP_VOL_SHD	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
68	FILLER_20	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
69	NP_VOL_NET	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
70	FILLER_21	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
71	NP_PRC_WAS	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
72	FILLER_22	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
73	NP_PRC_SHD	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
74	FILLER_23	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
75	NP_PRC_NET	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
76	FILLER_24	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
77	NP_BTU_WAS	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
78	FILLER_25	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
79	NP_BTU_SHD	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
80	FILLER_26	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
81	NP_BTU_NET	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
82	FILLER_27	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
83	NP_GR_VAL_WAS	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
84	FILLER_28	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
85	NP_GR_VAL_SHD	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
86	FILLER_29	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
87	NP_GR_VAL_NET	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
88	FILLER_30	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
89	RS_VOL_WAS	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
90	FILLER_31	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
91	RS_VOL_SHD	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
92	FILLER_32	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
93	RS_VOL_NET	☐	OIUH_DEC9	DEC9	DEC	9	0	OIUH_DEC9
94	FILLER_33	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
95	RS_PRC_WAS	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
96	FILLER_34	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
97	RS_PRC_SHD	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
98	FILLER_35	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
99	RS_PRC_NET	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
100	FILLER_36	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
101	RS_BTU_WAS	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
102	FILLER_37	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
103	RS_BTU_SHD	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
104	FILLER_38	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
105	RS_BTU_NET	☐	OIUH_DEC5_3	OIUH_DEC5_3	DEC	5	3	OIUH_DEC5_3
106	FILLER_39	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
107	RS_GR_VAL_WAS	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
108	FILLER_40	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
109	RS_GR_VAL_SHD	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
110	FILLER_41	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
111	RS_GR_VAL_NET	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
112	FILLER_42	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
113	REC_TYPE2	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
114	LIQUID_PROD_TBL_DATA	☐			CHAR	304	0
115	ALL_GR_VAL_WAS	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
116	FILLER_43	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
117	ALL_GR_VAL_SHD	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
118	FILLER_44	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
119	ALL_GR_VAL_NET	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
120	FILLER_45	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
121	ADD_VAL_WAS	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
122	FILLER_46	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
123	ADD_VAL_SHD	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
124	FILLER_47	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
125	ADD_VAL_NET	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
126	FILLER_48	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
127	TOT_GR_VAL_WAS	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
128	FILLER_49	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
129	TOT_GR_VAL_SHD	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
130	FILLER_50	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
131	TOT_GR_VAL_NET	☐	OIUH_DEC13_2	OIUH_DEC13_2	DEC	13	2	OIUH_DEC13_2
132	FILLER_51	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
133	ROY_DEC_WAS	☐	OIUH_DEC7_6	OIUH_DEC7_6	DEC	7	6	OIUH_DEC7_6
134	FILLER_52	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
135	ROY_DEC_SHD	☐	OIUH_DEC7_6	OIUH_DEC7_6	DEC	7	6	OIUH_DEC7_6
136	FILLER_53	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
137	ROY_DEC_NET	☐	OIUH_DEC7_6	OIUH_DEC7_6	DEC	7	6	OIUH_DEC7_6
138	FILLER_54	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
139	ROY_DUE_WAS	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
140	FILLER_55	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
141	ROY_DUE_SHD	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
142	FILLER_56	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
143	ROY_DUE_NET	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
144	FILLER_57	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
145	FILLER_58	☐			CHAR	100	0

History

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