1. SAP Tutorial
  2. Oil & Gas

OIUREP_XTRCT_ROY SAP table for – Extract Royaty Data for the current reporting period

Here we would like to draw your attention to OIUREP_XTRCT_ROY table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUREP_XTRCT_ROY is a SAP standard transp table used for storing Extract Royaty Data for the current reporting period related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_XTRCT_ROY table

Table OIUREP_XTRCT_ROY technical data

TableOIUREP_XTRCT_ROY
Data storingExtract Royaty Data for the current reporting period
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_XTRCT_ROY Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUREP_XTRCT_ROY table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • YEAR_MONTH : Reporting Year and Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • OIL_GAS_IND : Oil and Gas Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • GL_OR_LVL_1_NO : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • OPSL_GL_SYS_NO : OIUH_NUMC18
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 18
  • GL_ACCT_PERD_DT : Accounting Period Date
    Its data type is CHAR (Character String) with field length 14
  • GL_ACCT_NO : GL Account No.
    Its data type is CHAR (Character String) with field length 10
  • BTCH_TYPE_CODE : Batch Type
    Its data type is CHAR (Character String) with field length 2
  • GL_TRANS_AM : GL Transaction Amount
    Its data type is CURR (Currency Field) with field length 11
  • GL_TRANS_QY : GL Transaction Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GL_GR_AM : GL Gross Amount
    Its data type is CURR (Currency Field) with field length 11
  • GL_GR_QY : GL Gross Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GL_PD_CD : Material Number
    Its data type is CHAR (Character String) with field length 18
  • GL_VL_TYPE_CD : GL Volume Type Code
    Its data type is CHAR (Character String) with field length 2
  • GL_PU_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • GL_PU_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • GL_CT_NO : Contract No.
    Its data type is CHAR (Character String) with field length 6
  • GL_CT_TYPE_CD : GL Contract Type Code
    Its data type is CHAR (Character String) with field length 2
  • GL_PR_NO : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • GL_DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • GL_WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • GL_WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • GL_SA_MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • GL_SA_DT : GL Sales Date
    Its data type is CHAR (Character String) with field length 14
  • GL_DN_NO : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • GL_SUB_NWK_NO : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • GL_CHV_RPT_CD : GL Cost Center
    Its data type is CHAR (Character String) with field length 10
  • OPSL_BTU_QY : OPSL BTU Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • OPSL_PS_BASE_QY : OPSL Pressure Base Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • OPSL_GRV_QY : Gravity Quantity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPSL_OWN_NO : Master Record
    Its data type is CHAR (Character String) with field length 10
  • OPSL_PRDR_NO : OPSL Producer No.
    Its data type is CHAR (Character String) with field length 6
  • PSL_PRDR_SEQ_NO : OPSL Producer Sequence No.
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_DECM_QY : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OWN_INT_TYPE_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • PSL_RVRS_RSN_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • UNIT_OF_MEAS_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • OPSL_SUS_RSN_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OPSL_ORIG_MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • OPSL_DED_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_DED_GR_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OPSL_TAX_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_TAX_GR_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OPSL_PAY_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OPSL_ST_CD : OPSL State Code
    Its data type is CHAR (Character String) with field length 2
  • OWN_BAL_DECM_QY : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OPSL_UNIT_PR_NO : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • L_NET_TRANSP_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_NET_OTH_MK_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • SL_GR_TRANSP_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • SL_GR_OTH_MK_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OPSL_AES_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OPSL_TXN_VAL_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • OPSL_GR_PVR_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • OPSL_OWN_PVR_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_OWN_VL_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PSL_SPC_PYMT_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OPSL_LGND_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OPSL_ESCH_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OPSL_CMT_SYS_NO : OIUH_DEC18
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • PSL_INT_PAID_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • SL_OP_NON_OP_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • OTAX_TAX_AM1 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM2 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM3 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM4 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM5 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM6 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM7 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM8 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM9 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTAX_TAX_AM10 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM1 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM2 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM3 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM4 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM5 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM6 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM7 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM8 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM9 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • GTAX_TAX_AM10 : Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM1 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM2 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM3 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM4 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM5 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM6 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM7 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM8 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM9 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM10 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM11 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM12 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM13 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM14 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM15 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM16 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM17 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • ODED_DED_AM18 : Deduction Amount
    Its data type is CURR (Currency Field) with field length 11
  • REJECT_FLAG : Reject flag
    Its data type is CHAR (Character String) with field length 1
  • GL_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14

    • OIUREP_XTRCT_ROY related tables

    • OIUREP_RUN_GROUP : Reg.Reporting – Report Submission grouping
    • OIUREP_ROY_PRFL : Royalty Reporting Profiles
    • OIUREP_ADD_DATA : Regulatory Reporting Config for Additional Master Data
    • OIUREP_VL_VOL : Gross Volume and Value after VL/RD
    • OIUREP_VLTP_XREF : Cross reference between Agency defined & PRA volume types
    • OIUREP_REG_OPERA : Regulatory Reporting Operator and Contact Xref
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_ROY_AGY : Reporting Agencies for Tax and Royalty
    • OIUREP_AGY_LSETX : Text Table for Agency assigned Leases
    • OIUREP_LGL_RPTTX : Text Table for Legal Reports (Tax and Royalty)
    • OIUREP_2014_REP : MMS-2014 – Supplemental Reports From Report Executions
    • OIUREP_TEXT_XREF : Regulatory Reporting Texts for Diff Reporting Levels
    • OIUREP_CODE_XREF : Reg Reporting Product/Volume Type to Report Code Cross Ref
    • OIUREP_EXEC_COMB : Possible Combinations of Royalty Executions
    • OIUREP_FIN_LEVEL : Regulatory Reporting Operator and Contact Xref
    • OIUREP_REG_OPER : Regulatory Reporting Operator and Contact Xref EFF Dated
    • OIUREP_CODE_COMN : Common table for converting SAP codes to Agency codes
    • OIUREP_AGY_PDCD : Agency defined Product Code
    • OIUREP_ROY_AGYTX : Regulatory Reporting Agencies
    • OIUREPP_WCPAYXRF : MMS-2014 – Well Completion / Payor XRef PPA

    OIUREP_XTRCT_ROY related transaction codes under SAP package OIU_REP

    • S_SO7_65001107 : Generated Text
    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • O5UREP_COMMON : Regulatory Reporting Setup
    • S_SO7_65001114 : Generated Text
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • O3UREP_MMS_2014 : MMS-2014 Workplace
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • S_SOG_81000049 : IMG activity: OIUREP_MAINTAIN_NRIV
    • S_SO7_65001143 : Generated Text
    • S_SO7_65001264 : Generated Text
    • S_SO7_65001116 : Generated Text
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance
    • S_SOG_81000123 : IMG activity: SIMG_OIUREP_SUBMIT
    • O3UREP_MMS_RTHIST : Historic Extract Report
    • S_SO7_65001134 : Generated Text
    • S_SO7_65001131 : Generated Text
    • O3UREP_ROY_REPORTING : Royalty Reporting
    • S_SO7_65001135 : Generated Text
    • S_SOG_81000029 : IMG activity: SIMG_OIUREP_013
    • O3UREP_MMS_MRTPEND : MMS Level Pending Royalty Trans Rep

    Related References

    Related Tutorials

    OIUREP_ROYHIST SAP table for – Reported Royalty and Volume Data by Reporting Entities

    OIUREP_ROYHIST table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_ROY_DATA SAP table for – Reported Royalty and Volume Data by Reporting Entities

    OIUREP_ROY_DATA table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_RPT_MKTH SAP table for – Reporting history for marketing costs for reporting

    OIUX1_RPT_MKTH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_PUID_MKTH SAP table for – Reporting history for marketing costs for reporting

    OIUX1_PUID_MKTH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_ADJ_TAXDC SAP table for – Tax adjustments detail for reporting

    OIUX1_ADJ_TAXDC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_TRN_TAXDC SAP table for – Tax transaction detail for reporting

    OIUX1_TRN_TAXDC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_RPT_VOLH SAP table for – Reported Volume Data by Reporting Entities

    OIUX1_RPT_VOLH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »