OIUREP_XTRCT_ROY

Extract Royaty Data for the current reporting period | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
YEAR_MONTH Reporting Year and Month
AGENCY Agency for Reporting
OIL_GAS_IND Oil and Gas Indicator Show values
GL_OR_LVL_1_NO Company Code
OPSL_GL_SYS_NO OIUH_NUMC18
Column Name Description
💲 Currency Key (T001.WAERS):
GL_TRANS_AM GL Transaction Amount
GL_GR_AM GL Gross Amount
OPSL_DED_RMB_AM Local amount
L_DED_GR_RMB_AM Local amount
OPSL_TAX_RMB_AM Local amount
L_TAX_GR_RMB_AM Local amount
L_NET_TRANSP_AM Local amount
L_NET_OTH_MK_AM Local amount
SL_GR_TRANSP_AM Local amount
SL_GR_OTH_MK_AM Local amount
OPSL_TXN_VAL_AM Local amount
OTAX_TAX_AM1 Tax Amount
OTAX_TAX_AM2 Tax Amount
OTAX_TAX_AM3 Tax Amount
OTAX_TAX_AM4 Tax Amount
OTAX_TAX_AM5 Tax Amount
OTAX_TAX_AM6 Tax Amount
OTAX_TAX_AM7 Tax Amount
OTAX_TAX_AM8 Tax Amount
OTAX_TAX_AM9 Tax Amount
OTAX_TAX_AM10 Tax Amount
GTAX_TAX_AM1 Tax Amount
GTAX_TAX_AM2 Tax Amount
GTAX_TAX_AM3 Tax Amount
GTAX_TAX_AM4 Tax Amount
GTAX_TAX_AM5 Tax Amount
GTAX_TAX_AM6 Tax Amount
GTAX_TAX_AM7 Tax Amount
GTAX_TAX_AM8 Tax Amount
GTAX_TAX_AM9 Tax Amount
GTAX_TAX_AM10 Tax Amount
ODED_DED_AM1 Deduction Amount
ODED_DED_AM2 Deduction Amount
ODED_DED_AM3 Deduction Amount
ODED_DED_AM4 Deduction Amount
ODED_DED_AM5 Deduction Amount
ODED_DED_AM6 Deduction Amount
ODED_DED_AM7 Deduction Amount
ODED_DED_AM8 Deduction Amount
ODED_DED_AM9 Deduction Amount
ODED_DED_AM10 Deduction Amount
ODED_DED_AM11 Deduction Amount
ODED_DED_AM12 Deduction Amount
ODED_DED_AM13 Deduction Amount
ODED_DED_AM14 Deduction Amount
ODED_DED_AM15 Deduction Amount
ODED_DED_AM16 Deduction Amount
ODED_DED_AM17 Deduction Amount
ODED_DED_AM18 Deduction Amount
O_INT_1_AM Owner internal mkt amt 1
O_INT_2_AM Owner internal mkt amt 2
O_INT_3_AM Owner internal mkt amt 3
O_INT_4_AM Owner internal mkt amt 4
O_INT_5_AM Owner internal mkt amt 5
O_INT_6_AM Owner internal mkt amt 6
O_INT_7_AM Owner internal mkt amt 7
O_INT_8_AM Owner internal mkt amt 8
O_INT_9_AM Owner internal mkt amt 9
O_INT_10_AM Owner internal mkt amt10
O_EXT_1_AM Owner external mkt amt 1
O_EXT_2_AM Owner external mkt amt 2
O_EXT_3_AM Owner external mkt amt 3
O_EXT_4_AM Owner external mkt amt 4
O_EXT_5_AM Owner external mkt amt 5
O_EXT_6_AM Owner external mkt amt 6
O_EXT_7_AM Owner external mkt amt 7
O_EXT_8_AM Owner external mkt amt 8
O_EXT_9_AM Owner external mkt amt 9
O_EXT_10_AM Owner external mkt amt10
G_INT_1_AM Gross internal mkt amt 1
G_INT_2_AM Gross internal mkt amt 2
G_INT_3_AM Gross internal mkt amt 3
G_INT_4_AM Gross internal mkt amt 4
G_INT_5_AM Gross internal mkt amt 5
G_INT_6_AM Gross internal mkt amt 6
G_INT_7_AM Gross internal mkt amt 7
G_INT_8_AM Gross internal mkt amt 8
G_INT_9_AM Gross internal mkt amt 9
G_INT_10_AM Gross internal mkt amt10
G_EXT_1_AM Gross external mkt amt 1
G_EXT_2_AM Gross external mkt amt 2
G_EXT_3_AM Gross external mkt amt 3
G_EXT_4_AM Gross external mkt amt 4
G_EXT_5_AM Gross external mkt amt 5
G_EXT_6_AM Gross external mkt amt 6
G_EXT_7_AM Gross external mkt amt 7
G_EXT_8_AM Gross external mkt amt 8
G_EXT_9_AM Gross external mkt amt 9
G_EXT_10_AM Gross external mkt amt 10
Column Name Description
Column Name Description
Column Name Description
OIL_GAS_IND Oil and Gas Indicator Show values
REJECT_FLAG Reject flag Show values
Column Name Description Domain name
GL_ACCT_PERD_DT Accounting Period Date CHAR14
GL_ACCT_NO GL Account No. CHAR10
BTCH_TYPE_CODE Batch Type CHAR2
GL_TRANS_QY GL Transaction Quantity OIUH_DEC11_2
GL_GR_QY GL Gross Quantity OIUH_DEC11_2
GL_PD_CD Material Number MATNR
GL_VL_TYPE_CD GL Volume Type Code CHAR2
GL_PU_NO OIUH_CHAR6 CHAR6
GL_PU_SEQ_NO OIUH_CHAR2 CHAR2
GL_CT_NO Contract No. CHAR6
GL_CT_TYPE_CD GL Contract Type Code CHAR2
GL_PR_NO Joint venture JV_NAME
GL_DOI_NO Division of interest (DOI) OIU_DOI_NO
GL_WL_NO Well ID number OIU_WL_NO
GL_WC_NO Well Completion Number OIU_WC_NO
GL_SA_MP_NO Measurement point number OIU_MP_NO
GL_SA_DT GL Sales Date CHAR14
GL_DN_NO OIUH_CHAR4 CHAR4
GL_SUB_NWK_NO OIUH_CHAR4 CHAR4
GL_CHV_RPT_CD GL Cost Center CHAR10
OPSL_BTU_QY OPSL BTU Quantity OIUH_DEC7_3
OPSL_PS_BASE_QY OPSL Pressure Base Quantity OIUH_DEC6_3
OPSL_GRV_QY Gravity Quantity NUMC4
OPSL_OWN_NO Master Record OIUCM_MASTER
OPSL_PRDR_NO OPSL Producer No. CHAR6
PSL_PRDR_SEQ_NO OPSL Producer Sequence No. CHAR2
OWN_INT_DECM_QY OIUH_DEC9_8 OIUH_DEC9_8
OWN_INT_TYPE_CD OIUH_CHAR2 CHAR2
OWN_INT_SEQ_NO OIUH_CHAR2 CHAR2
PSL_RVRS_RSN_CD OIUH_CHAR2 CHAR2
UNIT_OF_MEAS_CD OIUH_CHAR3 CHAR3
OPSL_SUS_RSN_CD OIUH_CHAR2 CHAR2
OPSL_ORIG_MP_NO Measurement point number OIU_MP_NO
OPSL_PAY_CD OIUH_CHAR2 CHAR2
OPSL_ST_CD OPSL State Code CHAR2
OWN_BAL_DECM_QY OIUH_DEC9_8 OIUH_DEC9_8
OPSL_UNIT_PR_NO Joint venture JV_NAME
OPSL_AES_FL OIUH_CHAR1 CHAR1
OPSL_GR_PVR_AM OIUH_DEC11_2 OIUH_DEC11_2
OPSL_OWN_PVR_AM OIUH_DEC11_2 OIUH_DEC11_2
MMBTU_OWN_VL_AM OIUH_DEC11_2 OIUH_DEC11_2
PSL_SPC_PYMT_CD OIUH_CHAR1 CHAR1
OPSL_LGND_CD OIUH_CHAR2 CHAR2
OPSL_ESCH_FL OIUH_CHAR1 CHAR1
OPSL_CMT_SYS_NO OIUH_DEC18 DEC18
PSL_INT_PAID_FL OIUH_CHAR1 CHAR1
SL_OP_NON_OP_FL OIUH_CHAR1 CHAR1
GL_TIMESTAMP OIUH_CHAR14 CHAR14
OPSL_GR_PTR_AM OIUH_DEC11_2 OIUH_DEC11_2
OPSL_OWN_PTR_AM OIUH_DEC11_2 OIUH_DEC11_2
Master Data Relations Join Conditions
Client OIUREP_XTRCT_ROY.MANDT == T000.MANDT