1. SAP Tutorial
  2. Oil & Gas

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

    • OIUX3_MIG_CTRL related tables

    • OIUX3_TX_RP_EDT1 : OBSOLETE – Tax 2.0 – Texas Report Field Attribute Edits
    • OIUX3_TX_MASTER : Tax Reporting – Texas Master Data
    • OIUX3_PORTGRP1T : Tax Reporting – Node Group 1 Text Table
    • OIUX3_TX_RPGSM : Tax Reporting – Texas Gas Report Summary
    • OIUX3Y_TX_BATXID : Tax Reporting – Texas BA Tax ID PPN
    • OIUX3_RPT_GRPT : Tax Reporting – Report Group Text
    • OIUX3_TX_ASU_DT : Tax Reporting – Auto Suspend Detail
    • OIUX3_TX_LEASE : Tax Reporting – Texas Lease
    • OIUX3_TX_REJ : Tax Reporting – Texas Reject Codes
    • OIUX3_JEINTF : Tax Reporting – JE Interface Table
    • OIUX3_TX_RPOSME : Tax Reporting – Texas Oil Report Summary Errors
    • OIUX3_RPT_STEPT : Tax Reporting – Reporting Step Text
    • OIUX3_TX_PRDTI : Tax Reporting – Texas PRA Detail Txns-Tier Tax Incremental
    • OIUX3_TX_SOLEDT : Tax Reporting – Statute of Limitation Exception Detail
    • OIUX3_TX_RPODTE : Tax Reporting – Texas Oil Report Details Errors
    • OIUX3_TX_RPGDTE : Tax Reporting – Texas Gas Report Details Errors
    • OIUX3_RPT_TX : Tax Reporting – Reports
    • OIUX3_TX_LEASE_D : Tax Reporting – Texas Lease Description
    • OIUX3_TX_MSTOVR : Tax Reporting – Texas Master Data Overrides
    • OIUX3_TX_TAXTXN : Tax Reporting – Texas Tax Transactions

    OIUX3_MIG_CTRL related transaction codes under SAP package OIU_X3

    • S_SOG_81000185 : IMG activity: OIUX3_MIG_GRP
    • O3UX3_TX_ASU : Texas Auto Suspend Maintenance
    • S_SOG_81000186 : IMG activity: OIUX3_MIG_GRPRX
    • O3UX3_PORTAL : Generic Portal
    • O3UX3_TX_TAXHST : Texas Up To Date Reported Trans
    • S_SOG_81000182 : IMG activity: OIUX3_RPT_STEP
    • S_SOG_81000176 : IMG activity: V_OIUX3_TX_REJ
    • S_SOG_81000168 : IMG activity: OIUX3_RPT_COMP
    • S_SOG_81000180 : IMG activity: OIUX3_RPT_GRP
    • O3UX3_TX_TAXTXN : Display Texas Tax Transactions
    • S_SOG_81000175 : IMG activity: OIUX3_TX_TXCLEX
    • S_SOG_81000179 : IMG activity: V_OIUX3_RPTCFGD
    • S_SOG_81000188 : IMG activity: OIUX3_ITEM_ST
    • S_SOG_81000187 : IMG activity: OIUX3_MIG_ITEM
    • O3UX3_DISP_TX_RPVAR : Texas Tax Variance Report
    • S_SOG_81000173 : IMG activity: OIUX3_SN_NR_TX
    • S_SOG_81000172 : IMG activity: OIUX3_RPT_GRPPX
    • S_SOG_81000169 : IMG activity: OIUX3_RPT_COMPX
    • O3UX3_TX_LEASE : Texas Lease Maintenace
    • S_SOG_81000192 : IMG activity: OIUX3_TX_RP_EDT1

    Related References

    Related Tutorials

    OIUX3_MIG_ITEM SAP table for – Tax Reporting – Migration Item

    OIUX3_MIG_ITEM table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_MIG_VLDOC SAP table for – Tax Reporting – Migration Loaded VL Docs

    OIUX3_MIG_VLDOC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_ITEM_ST SAP table for – Tax Reporting – Migration Item Prerequisite Status

    OIUX3_ITEM_ST table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_MIG_ITEMT SAP table for – Tax Reporting – Migration Item Text

    OIUX3_MIG_ITEMT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_MIG_GRPT SAP table for – Tax Reporting – Migration Group Text

    OIUX3_MIG_GRPT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_MIG_SA_DT SAP table for – Tax Reporting – Migration Loaded Sales Dates

    OIUX3_MIG_SA_DT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_MIG_GRP SAP table for – Tax Reporting – Migration Group

    OIUX3_MIG_GRP table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »