OICF3_MIGR SAP table for – Results from Pattern Analysis for Structure OICF3

Here we would like to draw your attention to OICF3_MIGR table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OICF3_MIGR is a SAP standard transp table used for storing Results from Pattern Analysis for Structure OICF3 related data in SAP. It comes under the package OIC_MIGR.

SAP OICF3_MIGR table

Table OICF3_MIGR technical data

TableOICF3_MIGR
Data storingResults from Pattern Analysis for Structure OICF3
ModuleIS-OIL
Sub ModuleIS-OIL-DS-MAP
SAP PackageOIC_MIGR
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OICF3_MIGR 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 OICF3_MIGR table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOGSYS : Logical system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ITEMPATTNO : Number of Term Item Pattern
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • ANALYSISLVL : Level of the Pattern Analysis
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Used Pattern Structure for Term Item Fields
  • MULT1 : Calculation factor 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • MULT2 : Calculation factor 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • QUOSRC : Quotation source
    Its data type is CHAR (Character String) with field length 2
  • QUOTYP : Quotation type
    Its data type is CHAR (Character String) with field length 5
  • QUOTNO : Quotation number
    Its data type is CHAR (Character String) with field length 18
  • TRMEXIT : Calculation exit for term item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • EXGRTTY : Exchange rate type
    Its data type is CHAR (Character String) with field length 4
  • SURCHARGE : Surcharge
    Its data type is CURR (Currency Field) with field length 13
  • SURCURR : Surcharge currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SURPRUN : Surcharge per unit
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SURUOM : Surcharge unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RNDQUOT : Rule for rounding quotation price/value
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RNDSUR : Rule for rounding surcharge price/value
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RNDITEM : Rule for rounding term item value
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CALCTYP : Calculation type for formula condition item
    Its data type is CHAR (Character String) with field length 1
  • REFVAL1 : Reference data 1 for formula term item calculation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 17
  • REFUOM1 : UoM for reference data 1 in formula term item calculation
    Its data type is UNIT (Unit key for a Quantity field) with field length 3