1. SAP Tutorial
  2. Oil & Gas

OIUREP_SALESTYPE SAP table for – MMS-2014 – Sales Type

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

SAP OIUREP_SALESTYPE table

Table OIUREP_SALESTYPE technical data

TableOIUREP_SALESTYPE
Data storingMMS-2014 – Sales Type
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_SALESTYPE 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_SALESTYPE table.

  • .INCLUDE : Production: MMS-2014 – Sales Type 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
  • LEASE_RECORD_NO : Production: MMS-2014 – Lease Record Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • SALES_TYPE_CD : Production: MMS-2014 – Sales Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • MMS_PRODUCT_CD : Production: MMS Product Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Production: MMS-2014 – Sales Type Non Key Fields
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TRNSP_ALLW_FAC : MMS-2014 – Transportation Allowance Factor
    Its data type is CURR (Currency Field) with field length 15
  • TRNSP_ALLW_CUR : MMS-2014 – Transportation Allowance Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MFRING_UOM_AMT : Production: MMS-2014 – Manufacturing UOM Amount
    Its data type is CURR (Currency Field) with field length 15
  • MFRING_UOM_CUR : Production: MMS-2014 – Manufacturing UOM Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MFRER_UOM_PC : MMS-2014 – Manufacturer UOM Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • ROYAL_IN_KIND_FL : Production: MMS-2014 – Royalty In Kind Flag
    Its data type is CHAR (Character String) with field length 1
  • SA_TYPE_ALLOC_PC : Production: MMS-2014 – Sales Type Allocation Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TXN_OVERRIDE : Production: MMS-2014 – Transaction Code
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_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
  • .INCLUDE : Change Username & Timestamp
  • CHANGE_USER : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_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

    • OIUREP_SALESTYPE related tables

    • OIUREP_LEASE : MMS-2014 – Lease
    • OIUREP_MASTER_PC : RegID Split table (e.g. LA Parish split)
    • OIUREP_SUPL_REP : MMS-2014 – Supplemental Reports
    • OIUREP_KEY_XREFH : Regulatory Reporting SAP Key Cross Reference Header
    • OIUH_TEMP_GL : Journal Entry General Ledger Table
    • OIUREP_KEY_XREFD : Regulatory Reporting SAP Key Cross Reference Detail
    • OIUREPP_LEASE : MMS-2014 – Lease PPA
    • OIUREP_RRST_DET : Regulatory Reporting Status Table
    • OIUREP_VALTABC : Reporting general value table – Customizing
    • OIUREP_MRT_CRED : MMS-2014: Credits Against Monthly Report
    • OIUREP_EXT_COMP : External Company by State Agency
    • OIUREP_ADD_DATA : Regulatory Reporting Config for Additional Master Data
    • OIUREP_MASTER_MP : Re.Reporting – MP related Reg ID
    • OIUREP_FIN_LEVEL : Regulatory Reporting Operator and Contact Xref
    • OIUREP_XTRCT_ROY : Extract Royaty Data for the current reporting period
    • OIUREP_CODE_FLDS : Fields available for customizing
    • OIUREP_RUN_GROUP : Reg.Reporting – Report Submission grouping
    • OIUREP_REG_HIST : Reporting history (System table INDX)
    • OIUREP_REPORTSTX : Supported Regulatory reports
    • OIUREP_AGY_LSE : Agency assigned Leases

    OIUREP_SALESTYPE related transaction codes under SAP package OIU_REP

    • O3UREP_MMS_RTHIST : Historic Extract Report
    • S_SOG_81000129 : IMG activity: OIUREP_MMS_2014_MESS
    • O3UREP_MMS_MRTHIST : MMS Level Historic Royalty Trans Rep
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • S_SO7_65001114 : Generated Text
    • O5UREP_COMMON : Regulatory Reporting Setup
    • S_SO7_65001144 : Generated Text
    • O3UREP_ROY_REPORTING : Royalty Reporting
    • S_SOG_81000017 : Generated Text
    • O5UREP_MMS_TRANS_VAR : MMS-2014: Transport Suppl Rpt Vars
    • S_SO7_65001116 : Generated Text
    • S_SOG_81000123 : IMG activity: SIMG_OIUREP_SUBMIT
    • S_SOG_81000094 : IMG activity: OIUREP_2014_UOM
    • S_SO7_65001264 : Generated Text
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • S_SO7_65001105 : Generated Text
    • S_SO7_65001143 : Generated Text
    • S_SOG_81000124 : IMG activity: OIUREP_MMS_2014_BADI
    • S_SOG_81000029 : IMG activity: SIMG_OIUREP_013

    Related References

    Related Tutorials

    OIUREP_SALESTY SAP table for – MMS-2014: Sales Type Control Table

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

    OIUREP_SALESTY_T SAP table for – MMS-2014: Sales Type Control Table Description

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

    OIUREPP_SALETYPE SAP table for – MMS-2014 – Sales Type PPA

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

    OIUREP_SUPL_REP SAP table for – MMS-2014 – Supplemental Reports

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

    «
    »