OICF2_MIGR SAP table for – Results from Pattern Analysis for Structure OICF2

Here we would like to draw your attention to OICF2_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). OICF2_MIGR is a SAP standard transp table used for storing Results from Pattern Analysis for Structure OICF2 related data in SAP. It comes under the package OIC_MIGR.

SAP OICF2_MIGR table

Table OICF2_MIGR technical data

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

SAP OICF2_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 OICF2_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
  • PERIODPATTNO : Number of Term Period 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 Period Fields
  • REFDATE : User exit for reference date determination
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TIMUOM : Time unit of measure exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • WERULE : Weekend rule exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NPDAYS : Non-posted days rule exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ERRHAN : Error handling exit, if no quotation found
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RDOFFSET : Offset from reference date
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PERBEF : Period before base date
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PERAFT : Period after base date
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • EXCEX : Exclude Base Date
    Its data type is CHAR (Character String) with field length 1
  • DATFRM : ‘Date from’ for average period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATTO : ‘Date to’ for fixation period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CARULE : Average currency rule
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CDRULE : Daily currency rule
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CREFDATE : Determination exit for currency reference date
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CTIMUOM : Currency time unit of measure exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CWERULE : Currency weekend rule exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CNPDAYS : Currency non-posted days rule exit
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CERRHAN : Error-handling exit (if no exch.rate found)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CRDOFFSET : Offset from reference date for currency
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CPERBEF : Period before base date for currency
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CPERAFT : Period after base date for currency
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CEXCEV : Exclude Base Date for Currency
    Its data type is CHAR (Character String) with field length 1
  • CDATFRM : Date from for fixation period for currency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CDATTO : Date to for fixation period for currency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALID : Factory calendar ID for currency
    Its data type is CHAR (Character String) with field length 2
  • RNDTERM : Rule for rounding formula term value
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RNDCURT : Rule for rounding currency exchange rate
    Its data type is NUMC (Character String with Digits Only) with field length 3