SAP ABAP Table OIUREP_ROYHIST (Reported Royalty and Volume Data by Reporting Entities)

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_ROYHIST	Table Relationship Diagram
Short Description	Reported Royalty and Volume Data by Reporting Entities

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	YEAR_MONTH	☑	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	ORG_LEVEL1_NO	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	AGENCY	☑	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
5	OIL_GAS_IND	☑	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
6	YEAR_MONTH_AMND	☑	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
7	AGENCY_LEASE	☑	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
8	AGENCY_PROD_CODE	☑	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code	OIUREP_AGY_PDCD
9	AGENCY_VOL_TYPE	☑	OIUREP_AGENCY_VOL_TYPE	CHAR2	CHAR	2	0	Agency defined Volume type	OIUREP_AGY_VLTP
10	GRAVITY_QTY	☑	OIUREP_GRV_QY_NUMC4	NUMC4	NUMC	4	0	Gravity Quantity
11	UNIT_PROPERTY_NO	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
12	GROSS_VOLUME	☐	OIUREP_GROSS_VOLUME	MENGE	QUAN	13	3	Gross Volume
13	NET_VOLUME	☐	OIUREP_NET_VOLUME	MENGE	QUAN	13	3	Net Volume
14	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	*
15	GROSS_VALUE	☐	OIUREP_GROSS_VALUE	OIUREP_VALUE	CURR	13	2	Gross Value From a Contract/Well
16	NGL_VOLUME	☐	OIUY1_NGL_VOLUME	MENGE	QUAN	13	3	NGL Volume
17	NET_VALUE	☐	OIUREP_NET_VALUE	OIUREP_VALUE	CURR	13	2	Net Value From a Contract/Well
18	TRANSPORT_COST	☐	OIUREP_TRANSPORT_COST	OIUREP_VALUE	CURR	13	2	Transportation Cost
19	TAX_AMT	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
20	MARKETING_TOT	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
21	DEDUCTION_AMT1	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
22	DEDUCTION_AMT2	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
23	DEDUCTION_AMT3	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
24	DEDUCTION_AMT4	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
25	ROYALTY_DUE	☐	OIUREP_ROYALTY_DUE	OIUREP_VALUE	CURR	13	2	Royalty Amount due to the State Agency
26	CURRENCY	☐	OIUREP_CURRENCY	WAERS	CUKY	5	0	Currency	*
27	ENERGY	☐	OIUREP_ENERGY	OIUH_DEC21_8	QUAN	21	8	energy
28	ENERGY_U	☐	OIU_ENERGY_U	MEINS	UNIT	3	0	Energy quantity unit	*
29	TRACT_PF	☐	OIU_TR_PART_FACT_PC	OIU_PERCENT98	DEC	9	8	Tract Participation Factor Decimal
30	API_GRV	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
31	UPLOAD_FLAG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
32	.INCLUDE	☐				0	0	Creator and date/time created
33	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_ROYHIST	AGENCY	OIUREP_ROY_AGY	AGENCY		1	CN
2	OIUREP_ROYHIST	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE
3	OIUREP_ROYHIST	AGENCY_VOL_TYPE	OIUREP_AGY_VLTP	AGENCY_VOL_TYPE		1	CN
4	OIUREP_ROYHIST	MANDT	T000	MANDT
5	OIUREP_ROYHIST	ORG_LEVEL1_NO	T001	BUKRS

History

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