SAP ABAP Table ROIUREP_WY_M2_D (Structure for the Detailed part of M2 Report (WY Royalty))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUREP_WY_M2_D	Table Relationship Diagram
Short Description	Structure for the Detailed part of M2 Report (WY Royalty)

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	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	*
2	AGENCY_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
3	AGENCY	☐	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
4	REP_IND	☐	OIUREP_REPORT_IND	OIUREP_REPORT_IND	CHAR	1	0	Indicator (Current or Amended) Report
5	YEAR_MONTH	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
6	YEAR_MONTH_AMND	☐	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
7	OIL_GAS_IND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
8	ST_ROY_PER	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
9	OPR_VOL_W1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
10	OPR_VAL_W1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
11	OPR_ALL_LSE_W1	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
12	OPR_SLS_PPU_W1	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
13	OPR_VOL_BY_PRD_W1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
14	OPR_VAL_BY_PRD_W1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
15	OPR_ROY_AMT_W1	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
16	OPR_VOL_S1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
17	OPR_VAL_S1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
18	OPR_ALL_LSE_S1	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
19	OPR_SLS_PPU_S1	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
20	OPR_VOL_BY_PRD_S1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
21	OPR_VAL_BY_PRD_S1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
22	OPR_ROY_AMT_S1	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
23	OSD_VOL_W1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
24	OSD_VAL_W1	☐	OIUY1_STD_VAL		DEC	13	2	Value
25	OSD_ALL_LSE_W1	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
26	OSD_SLS_PPU_W1	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
27	OSD_VOL_BY_PRD_W1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
28	OSD_VAL_BY_PRD_W1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
29	OSD_ROY_AMT_W1	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
30	OSD_VOL_S1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
31	OSD_VAL_S1	☐	OIUY1_STD_VAL		DEC	13	2	Value
32	OSD_ALL_LSE_S1	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
33	OSD_SLS_PPU_S1	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
34	OSD_VOL_BY_PRD_S1	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
35	OSD_VAL_BY_PRD_S1	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
36	OSD_ROY_AMT_S1	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
37	CPR_VOL_W2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
38	CPR_VAL_W2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
39	CPR_ALL_LSE_W2	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
40	CPR_SLS_PPU_W2	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
41	CPR_VOL_BY_PRD_W2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
42	CPR_VAL_BY_PRD_W2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
43	CPR_ROY_AMT_W2	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
44	CPR_VOL_S2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
45	CPR_VAL_S2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
46	CPR_ALL_LSE_S2	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
47	CPR_SLS_PPU_S2	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
48	CPR_VOL_BY_PRD_S2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
49	CPR_VAL_BY_PRD_S2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
50	CPR_ROY_AMT_S2	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
51	CSD_VOL_W2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
52	CSD_VAL_W2	☐	OIUY1_STD_VAL		DEC	13	2	Value
53	CSD_ALL_LSE_W2	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
54	CSD_SLS_PPU_W2	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
55	CSD_VOL_BY_PRD_W2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
56	CSD_VAL_BY_PRD_W2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
57	CSD_ROY_AMT_W2	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
58	CSD_VOL_S2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
59	CSD_VAL_S2	☐	OIUY1_STD_VAL		DEC	13	2	Value
60	CSD_ALL_LSE_S2	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
61	CSD_SLS_PPU_S2	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
62	CSD_VOL_BY_PRD_S2	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
63	CSD_VAL_BY_PRD_S2	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
64	CSD_ROY_AMT_S2	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
65	GPR_VOL_W3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
66	GPR_VAL_W3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
67	GPR_ALL_LSE_W3	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
68	GPR_SLS_PPU_W3	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
69	GPR_VOL_BY_PRD_W3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
70	GPR_VAL_BY_PRD_W3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
71	GPR_ROY_AMT_W3	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
72	GPR_VOL_S3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
73	GPR_VAL_S3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
74	GPR_ALL_LSE_S3	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
75	GPR_SLS_PPU_S3	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
76	GPR_VOL_BY_PRD_S3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
77	GPR_VAL_BY_PRD_S3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
78	GPR_ROY_AMT_S3	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
79	GSD_VOL_W3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
80	GSD_VAL_W3	☐	OIUY1_STD_VAL		DEC	13	2	Value
81	GSD_ALL_LSE_W3	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
82	GSD_SLS_PPU_W3	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
83	GSD_VOL_BY_PRD_W3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
84	GSD_VAL_BY_PRD_W3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
85	GSD_ROY_AMT_W3	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
86	GSD_VOL_S3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
87	GSD_VAL_S3	☐	OIUY1_STD_VAL		DEC	13	2	Value
88	GSD_ALL_LSE_S3	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
89	GSD_SLS_PPU_S3	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
90	GSD_VOL_BY_PRD_S3	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
91	GSD_VAL_BY_PRD_S3	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
92	GSD_ROY_AMT_S3	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
93	PSD_VOL_W4	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
94	PSD_VAL_W4	☐	OIUY1_STD_VAL		DEC	13	2	Value
95	PSD_ALL_LSE_W4	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
96	PSD_SLS_PPU_W4	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
97	PSD_VOL_BY_PRD_W4	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
98	PSD_VAL_BY_PRD_W4	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
99	PSD_ROY_AMT_W4	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
100	PSD_VOL_S4	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
101	PSD_VAL_S4	☐	OIUY1_STD_VAL		DEC	13	2	Value
102	PSD_ALL_LSE_S4	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
103	PSD_SLS_PPU_S4	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
104	PSD_VOL_BY_PRD_S4	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
105	PSD_VAL_BY_PRD_S4	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
106	PSD_ROY_AMT_S4	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
107	BSD_VOL_W5	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
108	BSD_VAL_W5	☐	OIUY1_STD_VAL		DEC	13	2	Value
109	BSD_ALL_LSE_W5	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
110	BSD_SLS_PPU_W5	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
111	BSD_VOL_BY_PRD_W5	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
112	BSD_VAL_BY_PRD_W5	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
113	BSD_ROY_AMT_W5	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
114	BSD_VOL_S5	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
115	BSD_VAL_S5	☐	OIUY1_STD_VAL		DEC	13	2	Value
116	BSD_ALL_LSE_S5	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
117	BSD_SLS_PPU_S5	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
118	BSD_VOL_BY_PRD_S5	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
119	BSD_VAL_BY_PRD_S5	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
120	BSD_ROY_AMT_S5	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
121	SSD_VOL_W6	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
122	SSD_VAL_W6	☐	OIUY1_STD_VAL		DEC	13	2	Value
123	SSD_ALL_LSE_W6	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
124	SSD_SLS_PPU_W6	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
125	SSD_VOL_BY_PRD_W6	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
126	SSD_VAL_BY_PRD_W6	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
127	SSD_ROY_AMT_W6	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
128	SSD_VOL_S6	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
129	SSD_VAL_S6	☐	OIUY1_STD_VAL		DEC	13	2	Value
130	SSD_ALL_LSE_S6	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
131	SSD_SLS_PPU_S6	☐	OIUREP_OIL_PPU_W_01	OIUH_DEC5_2	DEC	5	2	Generic Price Per Unit for Oil/Gas
132	SSD_VOL_BY_PRD_S6	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
133	SSD_VAL_BY_PRD_S6	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
134	SSD_ROY_AMT_S6	☐	OIUREP_OIL_PROD_W_01_ROY_PER	OIUH_DEC11_2	DEC	11	2	Generic State'sfor Oil/Gas Percentage
135	COUNTY_NM	☐	OIU_SEC_GEO_DESC	CHAR30	CHAR	30	0	Secondary Geographical Location Description

History

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