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