1. SAP Tutorial
  2. Oil & Gas

OIUREP_MASTER_MP SAP table for – Re.Reporting – MP related Reg ID

Here we would like to draw your attention to OIUREP_MASTER_MP 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_MP is a SAP standard transp table used for storing Re.Reporting – MP related Reg ID related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_MASTER_MP table

Table OIUREP_MASTER_MP technical data

TableOIUREP_MASTER_MP
Data storingRe.Reporting – MP related Reg ID
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_MP 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_MP table.

  • .INCLUDE : Reg.Reporting – MP Reg ID Master Data Key
    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
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • 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 : Reg.Reporting – MP RegID MMS specific data
  • FACILITY_CD : OGOR-B Facility Number
    Its data type is CHAR (Character String) with field length 11
  • OUT_FMP_NO : Reg.Reporting MMS PASR Output Facility
    Its data type is CHAR (Character String) with field length 11
  • SALES_FMP_NO : Reg.Reporting MMS PASR Sales Facility
    Its data type is CHAR (Character String) with field length 11
  • ORG1 : Company Level 1 – (ORG1)
    Its data type is CHAR (Character String) with field length 3
  • ORG2 : Second-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 1
  • ORG3 : Third-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 3
  • ORG4 : Fourth-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 2
  • FIELD_NO : Reg. ID specific field number – override
    Its data type is CHAR (Character String) with field length 8
  • 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
  • OVERRIDE_GRP : Override Group
    Its data type is CHAR (Character String) with field length 5

    • OIUREP_MASTER_MP related tables

    • OIUREP_VALTABC : Reporting general value table – Customizing
    • OIUREP_AGY_PCDTX : Agency defined Product Code Text
    • OIUREP_RPT_ENTTY : Entities for Royalty Reporting
    • OIUREP_STAT_SPLT : Regulatory Reporting: Well Status Split table
    • OIUREP_RUN_REPNM : Reg.Reporting – Report run/submission names
    • OIUREP_CODE_CMLB : Regulatory Reporting Common Table List Box Setup
    • OIUREP_MASTER_PC : RegID Split table (e.g. LA Parish split)
    • OIUREP_FIELDS : Regulatory Report Master Data set up
    • OIUREP_CODE_RPTC : Report Columns available for customizing
    • OIUREP_PDCD_XREF : Cross Reference Between State Agency and PRA Material
    • OIUREP_RTPEND : MMS-2014 – Royalty Transaction Pending
    • OIUREP_FIELDSTX : Regulatory Report Master Data set up
    • OIUREP_KEY_XREFH : Regulatory Reporting SAP Key Cross Reference Header
    • OIUREPP_SALETYPE : MMS-2014 – Sales Type PPA
    • OIUREP_AGENCYTX : Regulatory Reporting Agencies
    • OIUREP_PROWNERS : MMS-2014 – Property w/ Multiple Owners?
    • OIUREP_CODE_VLTX : Code Value Texts
    • OIUREP_MP_XREF : Regulatory Reporting X-ref – MP to State Assigned ID
    • OIUREP_VLTP_XREF : Cross reference between Agency defined & PRA volume types
    • OIUREP_CODE_COMA : Common table to convert SAP codes to Ag. codes Apl.Table

    OIUREP_MASTER_MP related transaction codes under SAP package OIU_REP

    • S_SO7_65001114 : Generated Text
    • O3UREP_MMS_2014 : MMS-2014 Workplace
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • O5UREP_COMMON : Regulatory Reporting Setup
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • S_SO7_65001116 : Generated Text
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SO7_65001133 : Generated Text
    • S_SOG_81000094 : IMG activity: OIUREP_2014_UOM
    • S_SOG_81000049 : IMG activity: OIUREP_MAINTAIN_NRIV
    • O3UREP_ROY_MASTER : Master Maint. for Royalty Reporting
    • S_SO7_65001107 : Generated Text
    • S_SO7_65001135 : Generated Text
    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • O5UREP_MMS_TRANS_VAR : MMS-2014: Transport Suppl Rpt Vars
    • S_SOG_81000129 : IMG activity: OIUREP_MMS_2014_MESS
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance
    • S_SO7_65001105 : Generated Text
    • S_SO7_65001152 : Generated Text
    • S_SOG_81000017 : Generated Text

    Related References

    Related Tutorials

    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_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...

    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_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_CODE_RDNG SAP table for – Reg Reporting Rounding Configuration

    OIUREP_CODE_RDNG 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_GEN_DATA SAP table for – Reg. Reporting – Generic Transactional data

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

    «
    »