SAP ABAP Table ROIUREP_OK_CLO108_D (Structure for the Detail Part of CLO-108 Report (OK 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_OK_CLO108_D	Table Relationship Diagram
Short Description	Structure for the Detail Part of CLO-108 Report (OK 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	OIU_PR_FIELD
2	AGENCY_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
3	YEAR_MONTH	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
4	YEAR_MONTH_AMND	☐	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
5	AGENCY	☐	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
6	REP_IND	☐	OIUREP_REPORT_IND	OIUREP_REPORT_IND	CHAR	1	0	Indicator (Current or Amended) Report
7	STK_BEG_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
8	STK_BEG_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
9	GRO_PRD_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
10	GRO_PRD_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
11	NSLS_VAL_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
12	NSLS_VAL_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
13	OTDISP_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
14	OTDISP_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
15	STK_CLS_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
16	STK_CLS_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
17	GRO_SLS_1W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
18	GRO_SLS_1S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
19	BARL_1W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
20	BARL_1S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
21	PRICE_1W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
22	PRICE_1S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
23	VAL_1W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
24	VAL_1S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
25	GRO_SLS_2W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
26	GRO_SLS_2S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
27	BARL_2W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
28	BARL_2S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
29	PRICE_2W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
30	PRICE_2S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
31	VAL_2W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
32	VAL_2S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
33	GRO_SLS_3W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
34	GRO_SLS_3S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
35	BARL_3W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
36	BARL_3S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
37	PRICE_3W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
38	PRICE_3S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
39	VAL_3W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
40	VAL_3S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
41	GRO_SLS_4W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
42	GRO_SLS_4S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
43	BARL_4W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
44	BARL_4S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
45	PRICE_4W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
46	PRICE_4S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
47	VAL_4W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
48	VAL_4S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
49	TOT_BARL_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
50	TOT_BARL_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
51	TOTVAL_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
52	TOTVAL_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
53	ROYINT_W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
54	ROYINT_S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
55	ROYDUE_ST_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
56	ROYDUE_ST_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
57	SEC	☐	OIUY1_SECTION_NO	CHAR6	CHAR	6	0	Section Number
58	TWP	☐	OIU_TWP_NO	CHAR3	CHAR	3	0	Township number
59	RGE	☐	OIUY1_RGE	CHAR3	CHAR	3	0	RGE
60	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
61	DESCPN	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUREP_OK_CLO108_D	FIELD	OIU_PR_FIELD	FIELD

History

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