1. SAP Tutorial
  2. Oil & Gas

OIUREP_MASTER SAP table for – Regulatory Reporting Master Data

Here we would like to draw your attention to OIUREP_MASTER 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_MASTER is a SAP standard transp table used for storing Regulatory Reporting Master Data related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_MASTER table

Table OIUREP_MASTER technical data

TableOIUREP_MASTER
Data storingRegulatory Reporting Master Data
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_MASTER 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_MASTER table.

  • .INCLUDE : Reg. Reporting – Master Data key fields
    Its a key field.
  • .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
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Generic Master data fields
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_CD : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • USERID : User Name
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Regulatory Reporting Texas
  • DIST_NO : District number for Texas Reg ID
    Its data type is CHAR (Character String) with field length 3
  • GAS_WL_NO : Regulatory Reporting: Gas Well Number
    Its data type is CHAR (Character String) with field length 6
  • CMGL_PRMT_NO : Commingled Permit Number
    Its data type is CHAR (Character String) with field length 8
  • RPT_CD : Texas Report Code
    Its data type is CHAR (Character String) with field length 1
  • RRC_GAS_WL_NO : Texas Railroad Commission Gas Well number
    Its data type is CHAR (Character String) with field length 16
  • RRC_OIL_NO : Reg Reporting – TX H-10 Lease Number
    Its data type is CHAR (Character String) with field length 5
  • RRC_SP_DSC_TX : 30 Characters
    Its data type is CHAR (Character String) with field length 30
  • UNITZ_FLG : Checkbox
    Its data type is CHAR (Character String) with field length 1
  • GAS_RRC_ID_NO : Regulatory Reporting: Gas RRC ID
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • P1B_RRC_OIL_LSE : Texas P-1B RRC Oil Lease
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • PARTIALLY_UNTZ : Texas P-1B Partially Unitized
    Its data type is CHAR (Character String) with field length 1
  • SPECIAL_PROJECT : Texas P-1B Special Project
    Its data type is CHAR (Character String) with field length 6
  • DRILL_PRMT_NO : Regulatory Reporting: Texas Drilling Permit Number
    Its data type is CHAR (Character String) with field length 6
  • OPER_LSE_NO : Operator Lease Number (internal id)
    Its data type is CHAR (Character String) with field length 20
  • LSE_NO : Lease Number (Externally-Issued ID)
    Its data type is CHAR (Character String) with field length 11
  • AGY_LSE_NO : Agency Lease Number (externally issued id)
    Its data type is CHAR (Character String) with field length 25
  • MMS_ACT_CD : MMS Well Status Action Code (OGOR-A)
    Its data type is CHAR (Character String) with field length 1
  • MMS_GRP_API_WL : API well number group
    Its data type is CHAR (Character String) with field length 12
  • MMS_GRP_API_WC : API well completion number group
    Its data type is CHAR (Character String) with field length 3
  • OPER_WELL_NO : OGOR-A Operator Well Number
    Its data type is CHAR (Character String) with field length 15
  • MMS_WELL_STAT : MMS Well Status Code (OGOR-A)
    Its data type is CHAR (Character String) with field length 2
  • MMS_REAS_CD : MMS Well Status Reason Code (OGOR-A)
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Regulatory Reporting – New Mexico specific fields
  • OP_WL_NO : Operator Well number (9-Character, NM)
    Its data type is CHAR (Character String) with field length 9
  • NM_POOL_CD : Pool Code (Reg ID)
    Its data type is CHAR (Character String) with field length 6
  • NM_ST_PR_NO : NM State Property Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • UNIT_NO : Unit No (NM Reg ID)
    Its data type is CHAR (Character String) with field length 1
  • OGRID_NO : OGRID number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • H2O_POD_NO : Reg.Reporting New Mexico – H2O POD Code
    Its data type is CHAR (Character String) with field length 7
  • CA_H2O_SRCE_CD : Regulatory Rep: California H2O Source Code
    Its data type is CHAR (Character String) with field length 1
  • CA_H2O_DISP_CD : Regulatory Rep: California H2O Disposition Code
    Its data type is CHAR (Character String) with field length 1
  • FIELD_NO : Reg. ID specific field number – override
    Its data type is CHAR (Character String) with field length 8
  • UNIT_NUMBER : Unit Number (WY Form 2)
    Its data type is CHAR (Character String) with field length 11
  • INJ_SRCE_CD : Injection Source
    Its data type is CHAR (Character String) with field length 1
  • ALLOW_QTY : Daily production allowable quantity
    Its data type is QUAN (Quantity field) with field length 13
  • ALLOW_UOM : Unit of measure of production allowable
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AGY_WELL_ID : Agency well ID
    Its data type is CHAR (Character String) with field length 6
  • START_CUM_ALLOW : Starting cummulative over/under allowance
    Its data type is QUAN (Quantity field) with field length 13
  • .INCLUDE : Regulatory Reporting – North Dakota specific fields
  • ND_WELL_NAME : Well Description
    Its data type is CHAR (Character String) with field length 35
  • ND_WELL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • ND_WL_FILE_NO : Regulatory Reporting – North Dakota Well File Number
    Its data type is CHAR (Character String) with field length 6
  • UIC_NO : Reg. Reporting – ND Undergound Injection Control Number
    Its data type is CHAR (Character String) with field length 11
  • ST_RESVR_CD : Regulatory Reporting: Wyoming Form 2 Reservoir Code
    Its data type is CHAR (Character String) with field length 4
  • RESVR_CD : Regulatory Reporting: Wyoming Form 2 Reservoir Code
    Its data type is CHAR (Character String) with field length 4
  • PROJ_CD : Regulatory Reporting: Wyoming Form 2 Project Code
    Its data type is CHAR (Character String) with field length 3
  • CONS_DIST_NO : Regulatory Reporting – Conservation District Number
    Its data type is CHAR (Character String) with field length 4
  • AREA_CD : Regulatory Reporting – Area Code
    Its data type is CHAR (Character String) with field length 1
  • WL_SERIAL_NO : Well Serial Number
    Its data type is CHAR (Character String) with field length 6
  • COMNG_FAC_NO : Regulatory Reporting – Commingling Facility Number
    Its data type is CHAR (Character String) with field length 6
  • LUW_NO : Regulatory Reporting – Lease Unit / Well No
    Its data type is CHAR (Character String) with field length 6
  • INAC_STATUS_CD : Inactive Status Code
    Its data type is CHAR (Character String) with field length 2
  • INAC_FUTURE_CD : Inactive Future Code
    Its data type is CHAR (Character String) with field length 4
  • INAC_ABANDON : Inactive Abandon Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPLIT_GUID : GUID in ‘CHAR’ Format in Uppercase
    Its data type is CHAR (Character String) with field length 32
  • INACTIVE_FLAG : Report on inactive well report only
    Its data type is CHAR (Character String) with field length 1
  • OVERRIDE_GRP : Override Group
    Its data type is CHAR (Character String) with field length 5
  • ND_PIPE_OR_TRUCK : Regulatory Reporting – North Dakota Pipeline or Truck
    Its data type is CHAR (Character String) with field length 1
  • ND_CTB_NO : Regulatory Reporting – North Dakorta Central Tank Battery
    Its data type is CHAR (Character String) with field length 11
  • FLPT_CD : Regulatory Reporting – Field Plant Code
    Its data type is CHAR (Character String) with field length 4
  • OIU_PRI_GEO_LOC : Primary geographical location (PRI geo. loc.)
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Regulatory Reporting – Generic RegID display structure
  • ADD_HDR1 : Additional Master Data-Header Data
    Its data type is CHAR (Character String) with field length 35
  • ADD_HDR2 : Additional Master Data-Header Data
    Its data type is CHAR (Character String) with field length 35
  • ADD_DTL1 : Additional Master Data
    Its data type is CHAR (Character String) with field length 15
  • ADD_DTL2 : Additional Master Data
    Its data type is CHAR (Character String) with field length 30
  • ADD_DTL3 : Additional Master Data
    Its data type is CHAR (Character String) with field length 15
  • ADD_DTL4 : Additional Master Data
    Its data type is CHAR (Character String) with field length 30
  • ADD_DTL5 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10
  • ADD_DTL6 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10
  • ADD_DTL7 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10
  • ADD_DTL8 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10
  • ADD_DTL9 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10
  • ADD_DTL10 : Additional Master Data
    Its data type is CHAR (Character String) with field length 10

    • OIUREP_MASTER related tables

    • OIUREP_LGL_RPTS : Legal Reports for Tax and Royalty Reporting
    • OIUREP_FEDINDIAN : MMS-2014 – Federal or Indian Leases
    • OIUREP_CODE_CMLB : Regulatory Reporting Common Table List Box Setup
    • OIUREP_PRPAYXREF : MMS-2014 – Property / Payor XRef
    • OIUREP_MASTER_PC : RegID Split table (e.g. LA Parish split)
    • OIUREP_TRAN_ERR : Transaction code to error code xref for edits/vals
    • OIUREP_DN_XREF : Regulatory Reporting X-ref for Delivery Networks
    • OIUREP_REPORTS : Supported Regulatory reports
    • OIUREP_RPT_ENTTY : Entities for Royalty Reporting
    • OIUREP_MRT_PEND : MMS-2014 MMS Royalty Transaction Processed – Pending
    • OIUREP_RUN_GROUP : Reg.Reporting – Report Submission grouping
    • OIUREP_SALESTYPE : MMS-2014 – Sales Type
    • OIUREPP_WCPAYXRF : MMS-2014 – Well Completion / Payor XRef PPA
    • OIUREP_VL_VOL : Gross Volume and Value after VL/RD
    • OIUREP_RPT_PRFL : Report Profile
    • OIUREP_CODE_VLTX : Code Value Texts
    • OIUREP_OWNER : MMS-2014 – Owner
    • OIUREP_AGY_LSE : Agency assigned Leases
    • OIUREP_GEN_DATA : Reg. Reporting – Generic Transactional data
    • OIUREP_ADJCD_XRF : MMS-2014 – Reversal Rsn to Adjustment Reason Code XREF

    OIUREP_MASTER related transaction codes under SAP package OIU_REP

    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • S_SO7_65001133 : Generated Text
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SOG_81000053 : IMG activity: OIUREP_SALES_TYPE
    • S_SO7_65001132 : Generated Text
    • O3UREP_ROY_MASTER : Master Maint. for Royalty Reporting
    • S_SO7_65001143 : Generated Text
    • S_SO7_65001264 : Generated Text
    • S_SOG_81000129 : IMG activity: OIUREP_MMS_2014_MESS
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • O5UREP_COMMON : Regulatory Reporting Setup
    • O3UREP_MMS_2014_FORM : MMS 2014 Printable Form
    • O3UREP_MMS_MRTPEND : MMS Level Pending Royalty Trans Rep
    • S_SOG_81000029 : IMG activity: SIMG_OIUREP_013
    • S_SO7_65001134 : Generated Text
    • S_SO7_65001107 : Generated Text
    • O3UREP_MMS_RTHIST : Historic Extract Report
    • S_SO7_65001131 : Generated Text
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance

    Related References

    Related Tutorials

    OIUREP_ADD_DATA SAP table for – Regulatory Reporting Config for Additional Master Data

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

    O3UREP_MASTER SAP tcode for – Regulatory Reporting Master Data

    O3UREP_MASTER tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Regulatory Reporting...

    OIUREP_FIELDS SAP table for – Regulatory Report Master Data set up

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

    OIUREP_FIELDSTX SAP table for – Regulatory Report Master Data set up

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

    OIUREP_TEXT_XREF SAP table for – Regulatory Reporting Texts for Diff Reporting Levels

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

    OIUREP_AGENCIES SAP table for – Regulatory Reporting Agencies

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

    OIUREP_STRUC SAP table for – Regulatory Reporting Structures

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

    «
    »