SAP ABAP Table ROIUREP_ROY_DATA_LASTCURR (Reported Royalty Data (last and current))

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_ROY_DATA_LASTCURR	Table Relationship Diagram
Short Description	Reported Royalty Data (last and current)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUREP_ROY_DATA_LASTCURR	AGENCY	OIUREP_ROY_AGY	AGENCY		1	CN
2	ROIUREP_ROY_DATA_LASTCURR	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE
3	ROIUREP_ROY_DATA_LASTCURR	AGENCY_VOL_TYPE	OIUREP_AGY_VLTP	AGENCY_VOL_TYPE		1	CN
4	ROIUREP_ROY_DATA_LASTCURR	DOI_NO	OIU_DO_DI	DOI_NO		1	CN
5	ROIUREP_ROY_DATA_LASTCURR	MANDT	T000	MANDT
6	ROIUREP_ROY_DATA_LASTCURR	MP_NO	OIU_PR_MP	MP_NO		1	CN
7	ROIUREP_ROY_DATA_LASTCURR	ORG_LEVEL1_NO	T001	BUKRS		1	CN
8	ROIUREP_ROY_DATA_LASTCURR	PROPERTY_NO	OIU_DO_JV	VNAME		1	CN
9	ROIUREP_ROY_DATA_LASTCURR	WC_NO	OIU_PR_WC	WC_NO		1	CN
10	ROIUREP_ROY_DATA_LASTCURR	WL_NO	OIU_PR_WELL	WL_NO		1	CN

History

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