1. SAP Tutorial
  2. Oil & Gas

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

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

SAP OIUREPP_SALETYPE table

Table OIUREPP_SALETYPE technical data

TableOIUREPP_SALETYPE
Data storingMMS-2014 – Sales Type PPA
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREPP_SALETYPE 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 OIUREPP_SALETYPE 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

    • OIUREPP_SALETYPE related tables

    • OIUREP_VALTABC : Reporting general value table – Customizing
    • OIUREP_MP_XREF : Regulatory Reporting X-ref – MP to State Assigned ID
    • OIUREP_ROY_PRFL : Royalty Reporting Profiles
    • OIUREP_AGY_PDCD : Agency defined Product Code
    • OIUREP_STRUCTX : Regulatory Reporting Structures
    • OIUREP_CODE_COMA : Common table to convert SAP codes to Ag. codes Apl.Table
    • OIUREP_ROY_AGYTX : Regulatory Reporting Agencies
    • OIUREP_RRST_NEW : NEW Regulatory Reporting Status Table (with Version Number)
    • OIUREP_ACTIVATE : Reg./Tax and Royalty Reporting – report activation
    • OIUREP_ADJCD_XRF : MMS-2014 – Reversal Rsn to Adjustment Reason Code XREF
    • OIUREP_RPT_OWNER : Owners for royalty reporting
    • OIUREP_PRPAYXREF : MMS-2014 – Property / Payor XRef
    • OIUREP_CODE_CMLB : Regulatory Reporting Common Table List Box Setup
    • OIUREP_MRT_PEND : MMS-2014 MMS Royalty Transaction Processed – Pending
    • OIUREP_STRUC : Regulatory Reporting Structures
    • OIUREP_RPT_PRFL : Report Profile
    • OIUREP_VOLHIST : Reported Volume Data by Reporting Entities
    • OIUREP_CODE_XREF : Reg Reporting Product/Volume Type to Report Code Cross Ref
    • OIUREP_RT_HIST : MMS-2014 – Royalty Transaction (Pending) History
    • OIUREP_VLTP_XREF : Cross reference between Agency defined & PRA volume types

    OIUREPP_SALETYPE related transaction codes under SAP package OIU_REP

    • S_SO7_65001133 : Generated Text
    • S_SOG_81000123 : IMG activity: SIMG_OIUREP_SUBMIT
    • O3UREP_MMS_RECOUP : MMS Indian Recoupable Report
    • S_SO7_65001143 : Generated Text
    • S_SO7_65001152 : Generated Text
    • S_SOG_81000094 : IMG activity: OIUREP_2014_UOM
    • S_SOG_81000026 : IMG activity: OIUREP_2014_CONFIG
    • S_SO7_65001107 : Generated Text
    • S_SOG_81000049 : IMG activity: OIUREP_MAINTAIN_NRIV
    • S_SO7_65001264 : Generated Text
    • O3UREP_MASTER : Regulatory Reporting Master Data
    • O3UREP_MMS_2014_FORM : MMS 2014 Printable Form
    • O3UREP_MMS_REJECTS : MMS Extraction Rejects Report
    • S_SO7_65001134 : Generated Text
    • S_SOG_81000027 : IMG activity: OIUREP_ADJCD_XRF
    • O5UREP_COMMON : Regulatory Reporting Setup
    • O3UREP_ROY_REPORTING : Royalty Reporting
    • O3UREP_ROY_BASEDATA : Royalty base data maintenance
    • S_SOG_81000129 : IMG activity: OIUREP_MMS_2014_MESS
    • S_SO7_65001144 : Generated Text

    Related References

    Related Tutorials

    OIUREPP_WCPAYXRF SAP table for – MMS-2014 – Well Completion / Payor XRef PPA

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

    OIUREPP_OWNER SAP table for – MMS-2014 – Owner PPA

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

    OIUREPP_LEASE SAP table for – MMS-2014 – Lease PPA

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

    OIUREPP_PRPAYXRF SAP table for – MMS-2014 – Property / Payor XRef PPA

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

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

    OIUREP_SALESTYPE SAP table for – MMS-2014 – Sales Type

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

    «
    »