1. SAP Tutorial
  2. Oil & Gas

OIUX5_OK_MASTER SAP table for – Tax 2.0 – Oklahoma Master Data

Here we would like to draw your attention to OIUX5_OK_MASTER 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). OIUX5_OK_MASTER is a SAP standard transp table used for storing Tax 2.0 – Oklahoma Master Data related data in SAP. It comes under the package OIU_X5.

SAP OIUX5_OK_MASTER table

Table OIUX5_OK_MASTER technical data

TableOIUX5_OK_MASTER
Data storingTax 2.0 – Oklahoma Master Data
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X5
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax 2.0 – Oklahoma Master Data Key Fields
    Its a key field.
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Tax 2.0 – Oklahoma Master Data Nonkey Fields
  • PUN : Tax 2.0 – Oklahoma Production Unit Number
    Its data type is CHAR (Character String) with field length 11
  • GAS_CODE : Tax 2.0 – Oklahoma Gas Code
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • OIL_CLASS : Tax 2.0 – Oklahoma Oil Classification
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MULTI_COUNTIES : Tax 2.0 – Multiple Counties?
    Its data type is CHAR (Character String) with field length 1
  • COUNTY : Tax 2.0 – Oklahoma County
    Its data type is CHAR (Character String) with field length 3
  • NGPA_CD : Tax 2.0 OKGP – NGPA Code (Tax Incentive Rate Code)
    Its data type is CHAR (Character String) with field length 3
  • .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

    • OIUX5_OK_MASTER related tables

    • OIUX5_OK_REJT : Tax 2.0 – Oklahoma Reject Code Text
    • OIUX5Y_OK_MASTER : Tax 2.0 – Oklahoma Master Data PPN
    • OIUX5_OK_PRDTC : Tax 2.0 – Oklahoma PRA Detail Tax Transactions Multi Count
    • OIUX5_OK_ASU_HD : Tax 2.0 – Oklahoma Auto Suspend Header
    • OIUX5_OK_TAXTXN : Tax 2.0 – Oklahoma Tax Transactions
    • OIUX5_OK_PDCXRF : Tax 2.0 – Oklahoma Product Code Xref
    • OIUX5_OK_TAX_RT : Tax 2.0 – Oklahoma Tax Rates
    • OIUX5_OK_TAXSTG : Tax 2.0 – Oklahoma Tax Transactions Staging
    • OIUX5_OK_OOSHST : Tax 2.0 – Oklahoma Out Of Statute Transactions History
    • OIUX5_OK_SOLEHD : Tax 2.0 – Statute of Limitation Exception Header
    • OIUX5_OK_MSTCNT : Tax 2.0 – Oklahoma Master Data Multiple Counties
    • OIUX5_OK_CONFL : Tax 2.0 – Oklahoma Exempt Decimal Conflict
    • OIUX5_OK_ZVOL : Tax 2.0 – Oklahoma Zero Volume Reporting Master
    • OIUX5Y_OK_BATXID : Tax 2.0 – Oklahoma BA Tax ID PPN
    • OIUX5Y_OK_MSTCNT : Tax 2.0 – Oklahoma Master Data Counties
    • OIUX5_OK_OOSTXN : Tax 2.0 – Oklahoma Out Of Statute Transactions
    • OIUX5_OK_BATXID : Tax 2.0 – Oklahoma BA Tax ID
    • OIUX5_OK_PRDT : Tax 2.0 – Oklahoma PRA Detail Tax Transactions
    • OIUX5_OK_RPDT : Tax 2.0 – Oklahoma Gross Prod Report Detail
    • OIUX5_OK_REVSTG : Tax 2.0 – Oklahoma Tax Reversals Staging

    OIUX5_OK_MASTER related transaction codes under SAP package OIU_X5

    • O3UX5_UPD_OK_TAXHST : Update Oklahoma Tax History
    • O3UX5_MIGRATION_002 : Oklahoma Migration Workbench
    • O3UX5_OK_PUN_EDIT : Tax 2.0 OK – PUN Edit Report
    • S_YEP_55000007 : IMG activity: OIUX5_SN_NR_OK
    • O3UX5_OK_SOLE : Maintain SOL Exceptions
    • S_YEP_55000001 : IMG activity: OIUX5_OK_PDCXRF
    • S_YEP_55000005 : IMG activity: V_OIUX5_OK_REJC
    • S_YEP_55000002 : IMG activity: OIUX5_OK_EXEXRF
    • O3UX5_DISP_OK_TAXTXN : Oklahoma Tax Transactions
    • O3UX5_DISP_OK_RPVAR : Oklahoma Tax Variance Report
    • O3UX5_OK_MASTER : Oklahoma Master Data Maintenance
    • O3UX5_OK_ASU : Maintain Auto-Suspension Data
    • O3UX5_OK_ZVOL : Maintain Oklahoma Zero Vol Reporting
    • O3UX5_UPD_OK_TAXTXN : Maintain User Tax Transactions
    • O3UX5_OK_SOL : Maintain Statute-of-Limitations Data
    • O3UX5_DISP_OK_TAXHST : Up-to-Date Reported Transactions
    • S_YEP_55000006 : IMG activity: V_OIUX5_RPT_CFG
    • O3UX5_UPD_OK_OOS_WO : Out-of-Statute Write-Off Maintenance
    • O3UX5_OK_TAX_RT : Tax 2.0 – OKGP Tax Rate Maintenance
    • S_YEP_55000004 : IMG activity: V_OIUX5_OK_REJ

    Related References

    Related Tutorials

    OIUX5Y_OK_MSTCNT SAP table for – Tax 2.0 – Oklahoma Master Data Counties

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

    OIUX5Y_OK_MASTER SAP table for – Tax 2.0 – Oklahoma Master Data PPN

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

    OIUX5_OK_MSTCNT SAP table for – Tax 2.0 – Oklahoma Master Data Multiple Counties

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

    OIUX5_OK_ZVOL SAP table for – Tax 2.0 – Oklahoma Zero Volume Reporting Master

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

    OIUX5Y_OK_BATXID SAP table for – Tax 2.0 – Oklahoma BA Tax ID PPN

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

    OIUX5_OK_REVSTG SAP table for – Tax 2.0 – Oklahoma Tax Reversals Staging

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

    OIUX5_OK_TAX_RT SAP table for – Tax 2.0 – Oklahoma Tax Rates

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

    «
    »