OIUX3_MIG_CTRL SAP table for – Tax Reporting – Migration Control

Here we would like to draw your attention to OIUX3_MIG_CTRL 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). OIUX3_MIG_CTRL is a SAP standard transp table used for storing Tax Reporting – Migration Control related data in SAP. It comes under the package OIU_X3.

SAP OIUX3_MIG_CTRL table

Table OIUX3_MIG_CTRL technical data

TableOIUX3_MIG_CTRL
Data storingTax Reporting – Migration Control
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X3
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MIG_GRP : Tax Reporting – Migration Group
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • MIG_ITEM : Tax Reporting – Migration Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • MIG_RUN_NO
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • TF_IND : Tax Reporting – Trial/Final Indicator
    Its data type is CHAR (Character String) with field length 1
  • BEGIN_DATE : Tax Reporting – From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_DATE : Tax Reporting – To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DELETE_FIRST : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • LOGNUMBER : Application log: log number
    Its data type is CHAR (Character String) with field length 20
  • STATUS : Tax Reporting – Migration Status
    Its data type is CHAR (Character String) with field length 1
  • START_TS : 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
  • END_TS : 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
  • JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Start data description / Repetition period of background job
  • SDLSTRTDT : Planned Start Date for Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SDLSTRTTM : Planned start time for background Job
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LASTSTRTDT : Latest Execution Date for a Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LASTSTRTTM : Latest Execution Time for Background Job
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PREDJOB : Name of previous job
    Its data type is CHAR (Character String) with field length 32
  • PREDJOBCNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • CHECKSTAT : Job status check indicator for subsequent job start
    Its data type is CHAR (Character String) with field length 1
  • EVENTID : Background Processing Event
    Its data type is CHAR (Character String) with field length 32
  • EVENTPARM : Background Event Parameters (Such as, Jobname/Jobcount)
    Its data type is CHAR (Character String) with field length 64
  • STARTDTTYP : Start date type ID
    Its data type is CHAR (Character String) with field length 1
  • PRDMINS : Duration period (in minutes) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDHOURS : Duration period (in hours) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDDAYS : Duration (in days) of DBA action
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PRDWEEKS : Duration period (in weeks) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDMONTHS : Duration period (in months) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERIODIC : Periodic Jobs Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTNAME : Server name
    Its data type is CHAR (Character String) with field length 20
  • CALENDARID : Factory calendar ID for background processing
    Its data type is CHAR (Character String) with field length 2
  • EOMCORRECT : Correction field for calc. job execution (end-of-mth, cal.)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALCORRECT : Correction field for calc. job execution (end-of-mth, cal.)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • IMSTRTPOS : Flag indicating whether job can be started immediately
    Its data type is CHAR (Character String) with field length 1
  • PRDBEHAV : Period behavior of jobs on non-workdays
    Its data type is CHAR (Character String) with field length 1
  • WDAYNO : No. of workday on which a job is to start
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • WDAYCDIR : Count direction for ‘on workday’ start date of a job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NOTBEFORE : Planned Start Date for Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Tax Reporting – Last Changed Structure
  • CHANGE_USER : Tax Reporting – Last Changed User
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_DATE : Tax Reporting – Last Changed Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGE_TIME : Tax Reporting – Last Changed Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • MIGRATION_TYPE : Tax 2.0 – Migration Type
    Its data type is CHAR (Character String) with field length 1
  • CONT_ON_ERROR : Tax 2.0 – Migration Continue On Error
    Its data type is CHAR (Character String) with field length 1