1. SAP Tutorial
  2. Oil & Gas

OIUREP_2014_RUNS SAP table for – MMS-2014 – Report Executions

Here we would like to draw your attention to OIUREP_2014_RUNS 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_2014_RUNS is a SAP standard transp table used for storing MMS-2014 – Report Executions related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_2014_RUNS table

Table OIUREP_2014_RUNS technical data

TableOIUREP_2014_RUNS
Data storingMMS-2014 – Report Executions
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_2014_RUNS 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_2014_RUNS table.

  • .INCLUDE : Production: MMS-2014 – Runs Key Fields
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SALES_YEAR : MMS-2014 – Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SALES_MONTH : MMS-2014 – Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Production: MMS-2014 – Runs Non Key Fields
  • STATUS : Production: MMS-2014 – Run Status
    Its data type is CHAR (Character String) with field length 2
  • RUN_TYPE : Defines whether the run is direct pay or not
    Its data type is CHAR (Character String) with field length 1
  • EXTRACTION_START : 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
  • EXTRACTION_STOP : 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
  • EXTRACTION_USER : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • EXT_JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • EXT_JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • EXT_LOGNUMBER : Application log: log number
    Its data type is CHAR (Character String) with field length 20
  • REP_GEN_START : 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
  • REP_GEN_STOP : 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
  • REP_GEN_USER : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • GEN_JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • GEN_JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • GEN_LOGNUMBER : Application log: log number
    Its data type is CHAR (Character String) with field length 20
  • REP_FINAL_START : 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
  • REP_FINAL_STOP : 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
  • REP_FINAL_USER : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • FIN_JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • FIN_JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • FIN_LOGNUMBER : Application log: log number
    Its data type is CHAR (Character String) with field length 20

    • OIUREP_2014_RUNS related tables

    • OIUREP_CODE_VLTX : Code Value Texts
    • OIUREP_MRT_PEND : MMS-2014 MMS Royalty Transaction Processed – Pending
    • OIUREP_AMND_STAT : Report Execution statistics for amended months
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_VALTABM : Reporting general value table – Customizing
    • OIUREP_2014_REP : MMS-2014 – Supplemental Reports From Report Executions
    • OIUREP_2014_RUNS : MMS-2014 – Report Executions
    • OIUREP_AGENCIES : Regulatory Reporting Agencies
    • OIUREP_ACTIVATE : Reg./Tax and Royalty Reporting – report activation
    • OIUREP_STAT_SPLT : Regulatory Reporting: Well Status Split table
    • OIUREP_LEASE : MMS-2014 – Lease
    • OIUREP_MASTER_PC : RegID Split table (e.g. LA Parish split)
    • OIUREP_MMS_REAS : MMS Well Status / Reason Code Combinations (OGOR-A)
    • OIUREP_EXEC_STAT : Report Execution Statistics
    • OIUREP_STRUCTX : Regulatory Reporting Structures
    • OIUREP_CODE_VALS : Code Values available for customizing Reg Reporting
    • OIUREP_VALTABC : Reporting general value table – Customizing
    • OIUREP_AGY_PCDTX : Agency defined Product Code Text
    • OIUREP_OWNER : MMS-2014 – Owner
    • OIUREP_FIELDSTX : Regulatory Report Master Data set up

    OIUREP_2014_RUNS related transaction codes under SAP package OIU_REP

    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • O3UREP_ROY_MASTER : Master Maint. for Royalty Reporting
    • S_SO7_65001143 : Generated Text
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • S_SO7_65001107 : Generated Text
    • O3UREP_MMS_MRTPEND : MMS Level Pending Royalty Trans Rep
    • S_SO7_65001132 : Generated Text
    • S_SO7_65001114 : Generated Text
    • O3UREP_MMS_MRTHIST : MMS Level Historic Royalty Trans Rep
    • S_SOG_81000053 : IMG activity: OIUREP_SALES_TYPE
    • S_SO7_65001133 : Generated Text
    • S_SOG_81000094 : IMG activity: OIUREP_2014_UOM
    • S_SO7_65001135 : Generated Text
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • S_SO7_65001144 : Generated Text
    • S_SO7_65001103 : Generated Text
    • S_SOG_81000027 : IMG activity: OIUREP_ADJCD_XRF
    • S_SO7_65001105 : Generated Text
    • S_SO7_65001264 : Generated Text
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance

    Related References

    Related Tutorials

    OIUREP_2014_REP SAP table for – MMS-2014 – Supplemental Reports From Report Executions

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

    OIUREP_2014_INFO SAP table for – MMS-2014 – Report Executions Start information

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

    OIUREP_MRT_CRED SAP table for – MMS-2014: Credits Against Monthly Report

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

    OIUREP_MRT_HIST SAP table for – MMS-2014 MMS Royalty Transaction Processed History

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

    OIUREP_MRT_PEND SAP table for – MMS-2014 MMS Royalty Transaction Processed – Pending

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

    OIUREP_SUPL_REPT SAP table for – MMS-2014 – Supplemental Reports Description

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

    OIUREP_TRAN_FLDS SAP table for – MMS-2014 – Transaction Code Field Requirement XREF

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

    «
    »