SAP ABAP Table ROIUY1_ROY_FILE (Structure for uploading royalty values from flat file)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY1_ROY_FILE	Table Relationship Diagram
Short Description	Structure for uploading royalty values from flat file

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	YEAR_MONTH	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
2	ORG_LEVEL1_NO	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	AGENCY	☐	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
4	OIL_GAS_IND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
5	YEAR_MONTH_AMND	☐	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
6	AGENCY_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
7	PROPERTY_NO	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
8	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
9	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
10	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	*
11	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
12	AGENCY_PROD_CODE	☐	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code
13	AGENCY_VOL_TYPE	☐	OIUREP_AGENCY_VOL_TYPE	CHAR2	CHAR	2	0	Agency defined Volume type
14	GRAVITY_QTY	☐	OIUREP_GRV_QY_NUMC4	NUMC4	NUMC	4	0	Gravity Quantity
15	UNIT_PROPERTY_NO	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
16	GROSS_VOLUME	☐	OIUREP_GROSS_VOLUME	MENGE	QUAN	13	3	Gross Volume
17	NET_VOLUME	☐	OIUREP_NET_VOLUME	MENGE	QUAN	13	3	Net Volume
18	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	*
19	GROSS_VALUE	☐	OIUREP_GROSS_VALUE	OIUREP_VALUE	CURR	13	2	Gross Value From a Contract/Well
20	NET_VALUE	☐	OIUREP_NET_VALUE	OIUREP_VALUE	CURR	13	2	Net Value From a Contract/Well
21	TRANSPORT_COST	☐	OIUREP_TRANSPORT_COST	OIUREP_VALUE	CURR	13	2	Transportation Cost
22	TAX_AMT	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
23	MARKETING_TOT	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
24	DEDUCTION_AMT1	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
25	DEDUCTION_AMT2	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
26	DEDUCTION_AMT3	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
27	DEDUCTION_AMT4	☐	OIUREP_DED_AMOUNT	OIUH_CURR11_2	CURR	11	2	Deduction Amount
28	ROYALTY_DUE	☐	OIUREP_ROYALTY_DUE	OIUREP_VALUE	CURR	13	2	Royalty Amount due to the State Agency
29	CURRENCY	☐	OIUREP_CURRENCY	WAERS	CUKY	5	0	Currency	*
30	ENERGY	☐	OIU_ENERGY	MENGE	QUAN	13	3	Energy quantity
31	ENERGY_U	☐	OIU_ENERGY_U	MEINS	UNIT	3	0	Energy quantity unit	*
32	TRACT_PF	☐	OIU_TR_PART_FACT_PC	OIU_PERCENT98	DEC	9	8	Tract Participation Factor Decimal
33	API_GRV	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions

History

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