OIUREP_XTRCT_ROY - Extract Royaty Data for the current reporting period

Extract Royaty Data for the current reporting period information is stored in SAP table OIUREP_XTRCT_ROY.
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".

Fields for table OIUREP_XTRCT_ROY

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
YEAR_MONTH	Reporting Year and Month	X	OIUREP_RPT_YYYYMM	NUMC	12
AGENCY	Agency for Reporting	X	OIUREP_ROY_AGENCY	CHAR	6
OIL_GAS_IND	Oil and Gas Indicator	X	OIUREP_OIL_GAS_IND	CHAR	2
GL_OR_LVL_1_NO	Company Code	X	BUKRS	CHAR	8
OPSL_GL_SYS_NO	OIUH_NUMC18	X	OIUH_NUMC18	NUMC	36
GL_ACCT_PERD_DT	Accounting Period Date		OIUREP_ACCT_PERD_DT	CHAR	28
GL_ACCT_NO	GL Account No.		OIUREP_GL_ACCT_NO	CHAR	20
BTCH_TYPE_CODE	Batch Type		OIUREP_BTCH_TYPE_CODE	CHAR	4
GL_TRANS_AM	GL Transaction Amount		OIUREP_GL_TRANS_AM	CURR	6
GL_TRANS_QY	GL Transaction Quantity		OIUREP_GL_TRANS_QY	DEC	6
GL_GR_AM	GL Gross Amount		OIUREP_GL_GR_AM	CURR	6
GL_GR_QY	GL Gross Quantity		OIUREP_GL_GR_QY	DEC	6
GL_PD_CD	Material Number		MATNR	CHAR	80
GL_VL_TYPE_CD	GL Volume Type Code		OIUREP_GL_VL_TYPE_CD	CHAR	4
GL_PU_NO	OIUH_CHAR6		OIUH_CHAR6	CHAR	12
GL_PU_SEQ_NO	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
GL_CT_NO	Contract No.		OIUREP_GL_CT_NO	CHAR	12
GL_CT_TYPE_CD	GL Contract Type Code		OIUREP_GL_CT_TYPE_CD	CHAR	4
GL_PR_NO	Joint venture		JV_NAME	CHAR	12
GL_DOI_NO	Division of interest (DOI)		OIU_DOI_NO	CHAR	10
GL_WL_NO	Well ID number		OIU_WL_NO	CHAR	30
GL_WC_NO	Well Completion Number		OIU_WC_NO	CHAR	10
GL_SA_MP_NO	Measurement point number		OIU_MP_NO	CHAR	40
GL_SA_DT	GL Sales Date		OIUREP_GL_SA_DT	CHAR	28
GL_DN_NO	OIUH_CHAR4		OIUH_CHAR4	CHAR	8
GL_SUB_NWK_NO	OIUH_CHAR4		OIUH_CHAR4	CHAR	8
GL_CHV_RPT_CD	GL Cost Center		OIUREP_GL_CHV_RPT_CD	CHAR	20
OPSL_BTU_QY	OPSL BTU Quantity		OIUREP_OPSL_BTU_QY	DEC	4
OPSL_PS_BASE_QY	OPSL Pressure Base Quantity		OIUREP_OPSL_PS_BASE_QY	DEC	4
OPSL_GRV_QY	Gravity Quantity		OIUREP_GRV_QY_NUMC4	NUMC	8
OPSL_OWN_NO	Master Record		OIUCM_MASTER	CHAR	20
OPSL_PRDR_NO	OPSL Producer No.		OIUREP_OPSL_PRDR_NO	CHAR	12
PSL_PRDR_SEQ_NO	OPSL Producer Sequence No.		OIUREP_PSL_PRDR_SEQ_NO	CHAR	4
OWN_INT_DECM_QY	OIUH_DEC9_8		OIUH_DEC9_8	DEC	5
OWN_INT_TYPE_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
OWN_INT_SEQ_NO	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
PSL_RVRS_RSN_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
UNIT_OF_MEAS_CD	OIUH_CHAR3		OIUH_CHAR3	CHAR	6
OPSL_SUS_RSN_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
OPSL_ORIG_MP_NO	Measurement point number		OIU_MP_NO	CHAR	40
OPSL_DED_RMB_AM	Local amount		OIUH_CURR11_2	CURR	6
L_DED_GR_RMB_AM	Local amount		OIUH_CURR11_2	CURR	6
OPSL_TAX_RMB_AM	Local amount		OIUH_CURR11_2	CURR	6
L_TAX_GR_RMB_AM	Local amount		OIUH_CURR11_2	CURR	6
OPSL_PAY_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
OPSL_ST_CD	OPSL State Code		OIUREP_OPSL_ST_CD	CHAR	4
OWN_BAL_DECM_QY	OIUH_DEC9_8		OIUH_DEC9_8	DEC	5
OPSL_UNIT_PR_NO	Joint venture		JV_NAME	CHAR	12
L_NET_TRANSP_AM	Local amount		OIUH_CURR11_2	CURR	6
L_NET_OTH_MK_AM	Local amount		OIUH_CURR11_2	CURR	6
SL_GR_TRANSP_AM	Local amount		OIUH_CURR11_2	CURR	6
SL_GR_OTH_MK_AM	Local amount		OIUH_CURR11_2	CURR	6
OPSL_AES_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
OPSL_TXN_VAL_AM	Local amount		OIUH_CURR11_2	CURR	6
OPSL_GR_PVR_AM	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
OPSL_OWN_PVR_AM	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
MMBTU_OWN_VL_AM	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
PSL_SPC_PYMT_CD	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
OPSL_LGND_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
OPSL_ESCH_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
OPSL_CMT_SYS_NO	OIUH_DEC18		OIUH_DEC18	DEC	10
PSL_INT_PAID_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
SL_OP_NON_OP_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
OTAX_TAX_AM1	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM2	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM3	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM4	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM5	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM6	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM7	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM8	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM9	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
OTAX_TAX_AM10	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM1	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM2	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM3	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM4	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM5	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM6	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM7	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM8	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM9	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
GTAX_TAX_AM10	Tax Amount		OIUREP_TAX_AMOUNT	CURR	6
ODED_DED_AM1	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM2	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM3	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM4	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM5	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM6	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM7	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM8	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM9	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM10	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM11	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM12	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM13	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM14	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM15	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM16	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM17	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
ODED_DED_AM18	Deduction Amount		OIUREP_DED_AMOUNT	CURR	6
REJECT_FLAG	Reject flag		OIUREP_REJECT_FLAG	CHAR	2
GL_TIMESTAMP	OIUH_CHAR14		OIUH_CHAR14	CHAR	28
OPSL_GR_PTR_AM	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
OPSL_OWN_PTR_AM	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
.INCLUDE				OIU_MKTG_DTL	0
O_INT_1_AM	Owner internal mkt amt 1		OIU_O_INT_1_AM	CURR	6
O_INT_2_AM	Owner internal mkt amt 2		OIU_O_INT_2_AM	CURR	6
O_INT_3_AM	Owner internal mkt amt 3		OIU_O_INT_3_AM	CURR	6
O_INT_4_AM	Owner internal mkt amt 4		OIU_O_INT_4_AM	CURR	6
O_INT_5_AM	Owner internal mkt amt 5		OIU_O_INT_5_AM	CURR	6
O_INT_6_AM	Owner internal mkt amt 6		OIU_O_INT_6_AM	CURR	6
O_INT_7_AM	Owner internal mkt amt 7		OIU_O_INT_7_AM	CURR	6
O_INT_8_AM	Owner internal mkt amt 8		OIU_O_INT_8_AM	CURR	6
O_INT_9_AM	Owner internal mkt amt 9		OIU_O_INT_9_AM	CURR	6
O_INT_10_AM	Owner internal mkt amt10		OIU_O_INT_10_AM	CURR	6
O_EXT_1_AM	Owner external mkt amt 1		OIU_O_EXT_1_AM	CURR	6
O_EXT_2_AM	Owner external mkt amt 2		OIU_O_EXT_2_AM	CURR	6
O_EXT_3_AM	Owner external mkt amt 3		OIU_O_EXT_3_AM	CURR	6
O_EXT_4_AM	Owner external mkt amt 4		OIU_O_EXT_4_AM	CURR	6
O_EXT_5_AM	Owner external mkt amt 5		OIU_O_EXT_5_AM	CURR	6
O_EXT_6_AM	Owner external mkt amt 6		OIU_O_EXT_6_AM	CURR	6
O_EXT_7_AM	Owner external mkt amt 7		OIU_O_EXT_7_AM	CURR	6
O_EXT_8_AM	Owner external mkt amt 8		OIU_O_EXT_8_AM	CURR	6
O_EXT_9_AM	Owner external mkt amt 9		OIU_O_EXT_9_AM	CURR	6
O_EXT_10_AM	Owner external mkt amt10		OIU_O_EXT_10_AM	CURR	6
G_INT_1_AM	Gross internal mkt amt 1		OIU_G_INT_1_AM	CURR	6
G_INT_2_AM	Gross internal mkt amt 2		OIU_G_INT_2_AM	CURR	6
G_INT_3_AM	Gross internal mkt amt 3		OIU_G_INT_3_AM	CURR	6
G_INT_4_AM	Gross internal mkt amt 4		OIU_G_INT_4_AM	CURR	6
G_INT_5_AM	Gross internal mkt amt 5		OIU_G_INT_5_AM	CURR	6
G_INT_6_AM	Gross internal mkt amt 6		OIU_G_INT_6_AM	CURR	6
G_INT_7_AM	Gross internal mkt amt 7		OIU_G_INT_7_AM	CURR	6
G_INT_8_AM	Gross internal mkt amt 8		OIU_G_INT_8_AM	CURR	6
G_INT_9_AM	Gross internal mkt amt 9		OIU_G_INT_9_AM	CURR	6
G_INT_10_AM	Gross internal mkt amt10		OIU_G_INT_10_AM	CURR	6
G_EXT_1_AM	Gross external mkt amt 1		OIU_G_EXT_1_AM	CURR	6
G_EXT_2_AM	Gross external mkt amt 2		OIU_G_EXT_2_AM	CURR	6
G_EXT_3_AM	Gross external mkt amt 3		OIU_G_EXT_3_AM	CURR	6
G_EXT_4_AM	Gross external mkt amt 4		OIU_G_EXT_4_AM	CURR	6
G_EXT_5_AM	Gross external mkt amt 5		OIU_G_EXT_5_AM	CURR	6
G_EXT_6_AM	Gross external mkt amt 6		OIU_G_EXT_6_AM	CURR	6
G_EXT_7_AM	Gross external mkt amt 7		OIU_G_EXT_7_AM	CURR	6
G_EXT_8_AM	Gross external mkt amt 8		OIU_G_EXT_8_AM	CURR	6
G_EXT_9_AM	Gross external mkt amt 9		OIU_G_EXT_9_AM	CURR	6
G_EXT_10_AM	Gross external mkt amt 10		OIU_G_EXT_10_AM	CURR	6