SAP ABAP Table OIUREP_MASTER (Regulatory Reporting Master Data)

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	TRANSP	Transparent table
Transparent table	OIUREP_MASTER	Table Relationship Diagram
Short Description	Regulatory Reporting Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	Reg. Reporting - Master Data key fields
2	.INCLUDE	☑				0	0	Key for regulatory reporting tables
3	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
4	AGENCY	☑	OIUREP_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_REPORTS
5	REP_NAME	☑	OIU_REP_REPNAME	PROGNAME	CHAR	40	0	Regulatory Report Name	OIUREP_REPORTS
6	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
7	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
8	EFF_FROM_DT	☑	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
9	.INCLUDE	☐				0	0	Generic Master data fields
10	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
11	EFF_TO_CD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
12	TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	USERID	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
14	.INCLUDE	☐				0	0	Regulatory Reporting Texas
15	DIST_NO	☐	OIU_REP_DIST_NO	CHAR3	CHAR	3	0	District number for Texas Reg ID
16	GAS_WL_NO	☐	OIUREP_GAS_WL_NO		CHAR	6	0	Regulatory Reporting: Gas Well Number
17	CMGL_PRMT_NO	☐	OIUREP_CMGL_PRMT_NO	CHAR8	CHAR	8	0	Commingled Permit Number
18	RPT_CD	☐	OIUREP_RPT_CD	CHAR1	CHAR	1	0	Texas Report Code
19	RRC_GAS_WL_NO	☐	OIUREP_RRCGAS_WL_NO	CHAR16	CHAR	16	0	Texas Railroad Commission Gas Well number
20	RRC_OIL_NO	☐	OIUREP_TX_LEASE_NO	OIUREP_TX_LEASE_NO	CHAR	5	0	Reg Reporting - TX H-10 Lease Number
21	RRC_SP_DSC_TX	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
22	UNITZ_FLG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
23	GAS_RRC_ID_NO	☐	OIUREP_TX_GAS_RRC_ID_NO		NUMC	6	0	Regulatory Reporting: Gas RRC ID
24	P1B_RRC_OIL_LSE	☐	OIUREP_TX_P1B_RRC_OIL_LSE		NUMC	5	0	Texas P-1B RRC Oil Lease
25	PARTIALLY_UNTZ	☐	OIUREP_TX_PARTIALLY_UNITIZED		CHAR	1	0	Texas P-1B Partially Unitized
26	SPECIAL_PROJECT	☐	OIUREP_TX_SPECIAL_PROJECT		CHAR	6	0	Texas P-1B Special Project
27	DRILL_PRMT_NO	☐	OIUREP_TX_DRILL_PERMIT	OIUREP_TX_DRILL_PERMIT	CHAR	6	0	Regulatory Reporting: Texas Drilling Permit Number
28	OPER_LSE_NO	☐	OIUREP_OPER_LSE_NO		CHAR	20	0	Operator Lease Number (internal id)
29	LSE_NO	☐	OIUREP_LSE_NO		CHAR	11	0	Lease Number (Externally-Issued ID)
30	AGY_LSE_NO	☐	OIUREP_AGY_LSE_NO		CHAR	25	0	Agency Lease Number (externally issued id)
31	MMS_ACT_CD	☐	OIUREP_MMS_ACTION_CD	OIUREP_MMS_ACTION_CD	CHAR	1	0	MMS Well Status Action Code (OGOR-A)
32	MMS_GRP_API_WL	☐	OIUREP_WLAPI_GRP	OIU_WLAPI	CHAR	12	0	API well number group
33	MMS_GRP_API_WC	☐	OIUREP_API_WC_NO_GRP	OIU_API_WC_NO	CHAR	3	0	API well completion number group
34	OPER_WELL_NO	☐	OIUREP_OGA_OPER_WELL_NO		CHAR	15	0	OGOR-A Operator Well Number
35	MMS_WELL_STAT	☐	OIUREP_WELL_STAT	OIUREP_WELL_STAT	CHAR	2	0	MMS Well Status Code (OGOR-A)
36	MMS_REAS_CD	☐	OIUREP_MMS_REAS_CD	OIUREP_MMS_REAS_CD	CHAR	2	0	MMS Well Status Reason Code (OGOR-A)
37	.INCLUDE	☐				0	0	Regulatory Reporting - New Mexico specific fields
38	OP_WL_NO	☐	OIU_REP_OP_WL_NO		CHAR	9	0	Operator Well number (9-Character, NM)
39	NM_POOL_CD	☐	OIUREP_NM_POOL		CHAR	6	0	Pool Code (Reg ID)
40	NM_ST_PR_NO	☐	OIUREP_PR_NO		NUMC	6	0	NM State Property Number
41	UNIT_NO	☐	OIUREP_UNIT_NO		CHAR	1	0	Unit No (NM Reg ID)
42	OGRID_NO	☐	OIUREP_OGRID_NO		NUMC	6	0	OGRID number
43	H2O_POD_NO	☐	OIUREP_NM_H2O_POD_CD		CHAR	7	0	Reg.Reporting New Mexico - H2O POD Code
44	CA_H2O_SRCE_CD	☐	OIUREP_CA_H2O_SRCE_CD		CHAR	1	0	Regulatory Rep: California H2O Source Code
45	CA_H2O_DISP_CD	☐	OIUREP_CA_H2O_DISP_CD		CHAR	1	0	Regulatory Rep: California H2O Disposition Code
46	FIELD_NO	☐	OIUREP_FIELD_NO	CHAR8	CHAR	8	0	Reg. ID specific field number - override
47	UNIT_NUMBER	☐	OIUREP_UNIT_NUM		CHAR	11	0	Unit Number (WY Form 2)
48	INJ_SRCE_CD	☐	OIUREP_INJ_SRCE_CD		CHAR	1	0	Injection Source
49	ALLOW_QTY	☐	OIUREP_ALLOW_QTY	MENGE	QUAN	13	3	Daily production allowable quantity
50	ALLOW_UOM	☐	OIUREP_ALLOW_UOM	MEINS	UNIT	3	0	Unit of measure of production allowable	*
51	AGY_WELL_ID	☐	OIUREP_AGY_WELL_ID		CHAR	6	0	Agency well ID
52	START_CUM_ALLOW	☐	OIUREP_START_CUM_ALLOW	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Starting cummulative over/under allowance
53	.INCLUDE	☐				0	0	Regulatory Reporting - North Dakota specific fields
54	ND_WELL_NAME	☐	OIU_WL_DE_CONV	OIU_TEXT35_CONV	CHAR	35	0	Well Description
55	ND_WELL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
56	ND_WL_FILE_NO	☐	OIUREP_ND_WELL_FILE_NO		CHAR	6	0	Regulatory Reporting - North Dakota Well File Number
57	UIC_NO	☐	OIUREP_ND_UIC_NO		CHAR	11	0	Reg. Reporting - ND Undergound Injection Control Number
58	ST_RESVR_CD	☐	OIUREP_WY_RESERVOIR_CD		CHAR	4	0	Regulatory Reporting: Wyoming Form 2 Reservoir Code
59	RESVR_CD	☐	OIUREP_WY_RESERVOIR_CD		CHAR	4	0	Regulatory Reporting: Wyoming Form 2 Reservoir Code
60	PROJ_CD	☐	OIUREP_WY_PROJECT_CD		CHAR	3	0	Regulatory Reporting: Wyoming Form 2 Project Code
61	CONS_DIST_NO	☐	OIUREP_CONS_DIST_NO		CHAR	4	0	Regulatory Reporting - Conservation District Number
62	AREA_CD	☐	OIUREP_AREA_CD		CHAR	1	0	Regulatory Reporting - Area Code
63	WL_SERIAL_NO	☐	OIUREP_WL_SER_NO		CHAR	6	0	Well Serial Number
64	COMNG_FAC_NO	☐	OIUREP_COMM_FAC_NO		CHAR	6	0	Regulatory Reporting - Commingling Facility Number
65	LUW_NO	☐	OIUREP_LUW_NO		CHAR	6	0	Regulatory Reporting - Lease Unit / Well No
66	INAC_STATUS_CD	☐	OIUREP_INAC_STATUS_CD		CHAR	2	0	Inactive Status Code
67	INAC_FUTURE_CD	☐	OIUREP_INAC_FUTURE_CD		CHAR	4	0	Inactive Future Code
68	INAC_ABANDON	☐	OIUREP_INAC_ABANDON		DATS	8	0	Inactive Abandon Date
69	SPLIT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
70	INACTIVE_FLAG	☐	OIUREP_INACTIVE_FLAG	XFELD	CHAR	1	0	Report on inactive well report only
71	OVERRIDE_GRP	☐	OIUREP_OVERRIDE_GRP		CHAR	5	0	Override Group
72	ND_PIPE_OR_TRUCK	☐	OIUREP_ND_PIPE_OR_TRUCK		CHAR	1	0	Regulatory Reporting - North Dakota Pipeline or Truck
73	ND_CTB_NO	☐	OIUREP_ND_CTB_NO		CHAR	11	0	Regulatory Reporting - North Dakorta Central Tank Battery
74	FLPT_CD	☐	OIUREP_FLPT_CD		CHAR	4	0	Regulatory Reporting - Field Plant Code
75	OIU_PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	*
76	.INCLUDE	☐				0	0	Regulatory Reporting - Generic RegID display structure
77	ADD_HDR1	☐	OIU_HDR_DATA		CHAR	35	0	Additional Master Data-Header Data
78	ADD_HDR2	☐	OIU_HDR_DATA		CHAR	35	0	Additional Master Data-Header Data
79	ADD_DTL1	☐	OIU_ADD_DATA2		CHAR	15	0	Additional Master Data
80	ADD_DTL2	☐	OIU_ADD_DATA3		CHAR	30	0	Additional Master Data
81	ADD_DTL3	☐	OIU_ADD_DATA2		CHAR	15	0	Additional Master Data
82	ADD_DTL4	☐	OIU_ADD_DATA3		CHAR	30	0	Additional Master Data
83	ADD_DTL5	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data
84	ADD_DTL6	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data
85	ADD_DTL7	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data
86	ADD_DTL8	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data
87	ADD_DTL9	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data
88	ADD_DTL10	☐	OIU_ADD_DATA1		CHAR	10	0	Additional Master Data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_MASTER	AGENCY	OIUREP_REPORTS	AGENCY
2	OIUREP_MASTER	MANDT	T000	MANDT
3	OIUREP_MASTER	REP_NAME	OIUREP_REPORTS	REP_NAME
4	OIUREP_MASTER	WC_NO	OIU_PR_WC	WC_NO
5	OIUREP_MASTER	WL_NO	OIU_PR_WELL	WL_NO

History

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