SAP ABAP Table OIUREP_MASTER_MP (Re.Reporting - MP related Reg ID)

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_MP	Table Relationship Diagram
Short Description	Re.Reporting - MP related Reg ID

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 - MP Reg ID Master Data Key
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	MP_NO	☑	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
7	EFF_FROM_DT	☑	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
8	.INCLUDE	☐				0	0	Generic Master data fields
9	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
10	EFF_TO_CD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
11	TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	USERID	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
13	.INCLUDE	☐				0	0	Reg.Reporting - MP RegID MMS specific data
14	FACILITY_CD	☐	OIUREP_OGB_FACL_NO		CHAR	11	0	OGOR-B Facility Number
15	OUT_FMP_NO	☐	OIUREP_MMS_OUT_FMP		CHAR	11	0	Reg.Reporting MMS PASR Output Facility
16	SALES_FMP_NO	☐	OIUREP_MMS_SALES_FMP		CHAR	11	0	Reg.Reporting MMS PASR Sales Facility
17	ORG1	☐	OIUH_OR1_OR_LVL_1_NO	OIUH_OR_LVL_1_NO	CHAR	3	0	Company Level 1 - (ORG1)	*
18	ORG2	☐	OIUH_OR2_OR_LVL_2_NO	CHAR1	CHAR	1	0	Second-highest organization level number ( Company Code)	*
19	ORG3	☐	OIUH_OR3_OR_LVL_3_NO	CHAR3	CHAR	3	0	Third-highest organization level number ( Company Code)	*
20	ORG4	☐	OIUH_OR4_OR_LVL_4_NO	CHAR2	CHAR	2	0	Fourth-highest organization level number ( Company Code)	*
21	FIELD_NO	☐	OIUREP_FIELD_NO	CHAR8	CHAR	8	0	Reg. ID specific field number - override
22	CONS_DIST_NO	☐	OIUREP_CONS_DIST_NO		CHAR	4	0	Regulatory Reporting - Conservation District Number
23	AREA_CD	☐	OIUREP_AREA_CD		CHAR	1	0	Regulatory Reporting - Area Code
24	WL_SERIAL_NO	☐	OIUREP_WL_SER_NO		CHAR	6	0	Well Serial Number
25	COMNG_FAC_NO	☐	OIUREP_COMM_FAC_NO		CHAR	6	0	Regulatory Reporting - Commingling Facility Number
26	LUW_NO	☐	OIUREP_LUW_NO		CHAR	6	0	Regulatory Reporting - Lease Unit / Well No
27	INAC_STATUS_CD	☐	OIUREP_INAC_STATUS_CD		CHAR	2	0	Inactive Status Code
28	INAC_FUTURE_CD	☐	OIUREP_INAC_FUTURE_CD		CHAR	4	0	Inactive Future Code
29	INAC_ABANDON	☐	OIUREP_INAC_ABANDON		DATS	8	0	Inactive Abandon Date
30	SPLIT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
31	OVERRIDE_GRP	☐	OIUREP_OVERRIDE_GRP		CHAR	5	0	Override Group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_MASTER_MP	AGENCY	OIUREP_REPORTS	AGENCY
2	OIUREP_MASTER_MP	MANDT	T000	MANDT
3	OIUREP_MASTER_MP	REP_NAME	OIUREP_REPORTS	REP_NAME

History

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