1. SAP Tutorial
  2. Oil & Gas

OIUREP_CODE_XREF SAP table for – Reg Reporting Product/Volume Type to Report Code Cross Ref

Here we would like to draw your attention to OIUREP_CODE_XREF 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_CODE_XREF is a SAP standard transp table used for storing Reg Reporting Product/Volume Type to Report Code Cross Ref related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_CODE_XREF table

Table OIUREP_CODE_XREF technical data

TableOIUREP_CODE_XREF
Data storingReg Reporting Product/Volume Type to Report Code Cross Ref
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_CODE_XREF 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_CODE_XREF table.

  • .INCLUDE : Key for regulatory reporting tables
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • REP_NAME : Regulatory Report Name
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Structure for OIUREP_CODE_XREF table key
    Its a key field.
  • OVERRIDE_GRP : Override Group
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MAJPD_CD : Major product code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • VT_CD : Volume type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • PD_CD : Minor Product Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TRNSP_METH_CD : Transporter Method Code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • NEG_IND : Negative Value Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPT_COL_PRI : Reg. Reporting – Fieldname 1
    Its data type is CHAR (Character String) with field length 30
  • CODE_VAL_PRI : Re. Reporting – Value of primary field
    Its data type is CHAR (Character String) with field length 30
  • RPT_COL_SEC : Reg. Reporting – Fieldname 2
    Its data type is CHAR (Character String) with field length 30
  • CODE_VAL_SEC : Re. Reporting – Value of secondary field
    Its data type is CHAR (Character String) with field length 30
  • RPT_COLUMN : Field Name
    Its data type is CHAR (Character String) with field length 30
  • TEXT_ID : Text ID
    Its data type is CHAR (Character String) with field length 4
  • TEXT : Field text
    Its data type is CHAR (Character String) with field length 60
  • INV_IND : Inventory Indicator
    Its data type is CHAR (Character String) with field length 2
  • RPT_COL_3RD : Reg. Reporting – Fieldname 3
    Its data type is CHAR (Character String) with field length 30
  • CODE_VAL_3RD : Re. Reporting – Value of 3rd field
    Its data type is CHAR (Character String) with field length 30

    • OIUREP_CODE_XREF related tables

    • OIUH_TEMP_OPSL : Journal Entry Owner Payable Subledger Table
    • OIUREP_PROWNERS : MMS-2014 – Property w/ Multiple Owners?
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_CODE_RDNG : Reg Reporting Rounding Configuration
    • OIUREP_CODE_COMA : Common table to convert SAP codes to Ag. codes Apl.Table
    • OIUREP_CODE_COMN : Common table for converting SAP codes to Agency codes
    • OIUREP_XTRCT_ROY : Extract Royaty Data for the current reporting period
    • OIUREP_MMS_ACTN : MMS Well Status Reason Code/Action Code Combos (OGOR-A)
    • OIUREP_LEASE : MMS-2014 – Lease
    • OIUREP_ROY_DATA : Reported Royalty and Volume Data by Reporting Entities
    • OIUREP_CODE_FLDS : Fields available for customizing
    • OIUREPP_PRPAYXRF : MMS-2014 – Property / Payor XRef PPA
    • OIUREP_RRST : Regulatory Reporting Status Table
    • OIUREP_TRAN_FLDS : MMS-2014 – Transaction Code Field Requirement XREF
    • OIUREP_VALTABM : Reporting general value table – Customizing
    • OIUREP_FIELDS : Regulatory Report Master Data set up
    • OIUREP_EXEC_COMB : Possible Combinations of Royalty Executions
    • OIUREP_AGY_LSE : Agency assigned Leases
    • OIUREP_AMND_STAT : Report Execution statistics for amended months
    • OIUREP_VOL_DATA : Reported Volume Data by Reporting Entities

    OIUREP_CODE_XREF related transaction codes under SAP package OIU_REP

    • S_SO7_65001152 : Generated Text
    • S_SO7_65001114 : Generated Text
    • S_SO7_65001135 : Generated Text
    • O3UREP_ROY_MASTER : Master Maint. for Royalty Reporting
    • O5UREP_MMS_TRANS_VAR : MMS-2014: Transport Suppl Rpt Vars
    • O3UREP_MMS_RTHIST : Historic Extract Report
    • S_SO7_65001133 : Generated Text
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • O3UREP_MMS_2014 : MMS-2014 Workplace
    • S_SOG_81000027 : IMG activity: OIUREP_ADJCD_XRF
    • S_SO7_65001144 : Generated Text
    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • S_SO7_65001143 : Generated Text
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SOG_81000053 : IMG activity: OIUREP_SALES_TYPE
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • S_SO7_65001116 : Generated Text
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • S_SOG_81000017 : Generated Text
    • O3UREP_MMS_MRTHIST : MMS Level Historic Royalty Trans Rep

    Related References

    Related Tutorials

    OIUREP_CODE_VALS SAP table for – Code Values available for customizing Reg Reporting

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

    OIUREP_RUN_GROUP SAP table for – Reg.Reporting – Report Submission grouping

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

    OIUREP_ACTIVATE SAP table for – Reg./Tax and Royalty Reporting – report activation

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

    OIUREP_RUN_REPNM SAP table for – Reg.Reporting – Report run/submission names

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

    OIUREP_RUNGRPKEY SAP table for – Reg.Reporting – Report Submission groups

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

    OIUX7_WY_PDVLXRF SAP table for – Tax 2.0 – WYGP Product Code/Volume Type/Product Type Xref

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

    OIUREP_CODE_RULE SAP table for – Reg Reporting Rules for Column Data

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

    «
    »