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