1. SAP Tutorial
  2. Oil & Gas

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

    • OICF2_MIGR related tables

    • OIC_FO_ITM_MIGR : Formula Structure Pattern – Term Item Pattern
    • OIC_FO_MIGR_REQ : Formula Patterns per Run
    • OIC_FO_PER_MIGR : Formula Structure Pattern – Header and Period Pattern
    • OIC_ANALLVL_FLDS : Fields Used in Pattern Analysis Levels
    • OICF1_MIGR : Results from Pattern Analysis for Structure OICF1
    • OICF2_MIGR : Results from Pattern Analysis for Structure OICF2
    • OICF3_MIGR_REQ : Item Patterns per Run
    • OICF1_MIGR_REQ : Header Patterns per Run
    • OIC_CPE_FO_LINK : Relationship Between F&A Formula and CPE Formula
    • OICF2_MIGR_REQ : Period Patterns per Run
    • OIC_LSMW_PROJ : Used LSMW Project for Data exchange
    • OIC_ANALLVL_T : Description of Level in Pattern Analysis
    • OIC_ANALLVL : Pattern analysis level
    • OIC_FORM_ATTRIB : Attributes of Business Context for F&A Formula
    • OICF3_MIGR : Results from Pattern Analysis for Structure OICF3

    Related References

    Related Tutorials

    OIC_FO_PER_MIGR SAP table for – Formula Structure Pattern – Header and Period Pattern

    OIC_FO_PER_MIGR table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Formula Structure Pattern...

    OICF1_MIGR SAP table for – Results from Pattern Analysis for Structure OICF1

    OICF1_MIGR table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Results from Pattern...

    OIC_FO_ITM_MIGR SAP table for – Formula Structure Pattern – Term Item Pattern

    OIC_FO_ITM_MIGR table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Formula Structure Pattern...

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

    OICF3_MIGR table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Results from Pattern...

    OIC_ANALLVL SAP table for – Pattern analysis level

    OIC_ANALLVL table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Pattern analysis level....

    OIC_ANALLVL_T SAP table for – Description of Level in Pattern Analysis

    OIC_ANALLVL_T table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Description of Level...

    OIC_ANALLVL_FLDS SAP table for – Fields Used in Pattern Analysis Levels

    OIC_ANALLVL_FLDS table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Fields Used in...

    «
    »