1. SAP Tutorial
  2. Oil & Gas

OIUX3Y_TX_MASTER SAP table for – Tax Reporting – Texas Master Data PPN

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

SAP OIUX3Y_TX_MASTER table

Table OIUX3Y_TX_MASTER technical data

TableOIUX3Y_TX_MASTER
Data storingTax Reporting – Texas Master Data PPN
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X3
Delivery ClassL – Table for storing temporary data
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUX3Y_TX_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 OIUX3Y_TX_MASTER table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax Reporting – Texas Master Data Key Fields
    Its a key field.
  • RPT_ID : Tax Reporting – Report ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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
  • BEFORE_CURRENT
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Tax Reporting – Texas Master Data Nonkey Fields
  • API_WELL_NUMBER : Tax Reporting – Texas API Well Number
    Its data type is CHAR (Character String) with field length 8
  • COUNTY : Tax Reporting – Texas County
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LEASE_NUMBER : Tax Reporting – Texas Lease
    Its data type is CHAR (Character String) with field length 7
  • OFF_LEASE_CD : Tax Reporting – Texas On/Off Lease Code
    Its data type is CHAR (Character String) with field length 1
  • OVERRIDE_EXISTS : Tax Reporting – Override Exists?
    Its data type is CHAR (Character String) with field length 1
  • DELETE_FL : Indicator for Meta Data in System Component Repository
    Its data type is CHAR (Character String) with field length 1

    • OIUX3Y_TX_MASTER related tables

    • OIUX3_TX_RPGSM : Tax Reporting – Texas Gas Report Summary
    • OIUX3_TX_RPOSM : Tax Reporting – Texas Oil Report Summary
    • OIUX3_RPT_GRPT : Tax Reporting – Report Group Text
    • OIUX3_PORTGRP1T : Tax Reporting – Node Group 1 Text Table
    • OIUX3_TX_PRDTN : Tax Reporting – Texas PRA Detail Txns – No Tier Tax
    • OIUX3_TX_ASU_HD : Tax Reporting – Auto Suspend Header
    • OIUX3_TX_COMXRF : Tax Reporting – Texas Commodity XRef
    • OIUX3_RUN_JE : Tax Reporting – Report Run JE Batch Info
    • OIUX3_TX_RP_EDT1 : OBSOLETE – Tax 2.0 – Texas Report Field Attribute Edits
    • OIUX3_TX_TAXHST : Tax Reporting – Texas Tax History Transactions
    • OIUX3Y_TX_MASTER : Tax Reporting – Texas Master Data PPN
    • OIUX3_RUN_HDR : Tax Reporting – Run Header
    • OIUX3_RPT_STEPT : Tax Reporting – Reporting Step Text
    • OIUX3_MIG_GRP : Tax Reporting – Migration Group
    • OIUX3_TX_REJ : Tax Reporting – Texas Reject Codes
    • OIUX3_TX_OOSWO : Tax Reporting – Texas Out Of Statute Write Off
    • OIUX3_TX_LEASE : Tax Reporting – Texas Lease
    • OIUX3_TX_TXCLEX : Tax Reporting – Texas Tax Class Exemption Type XRef
    • OIUX3_PDCD_TX : Tax Reporting – 3 Character Product Code Text
    • OIUX3_TX_TAXTXN : Tax Reporting – Texas Tax Transactions

    OIUX3Y_TX_MASTER related transaction codes under SAP package OIU_X3

    • S_SOG_81000166 : IMG activity: OIUX3_CONF
    • S_SOG_81000194 : IMG activity: OIUX3_TX_RP_EDT2_2
    • S_SOG_81000170 : IMG activity: OIUX3_EDIT_SRV_GRP
    • O3UX3_DISP_TX_EDTERR : Texas Additional Edit Errors
    • O3UX3_TX_SOL : Texas Statute of Limitation Maint
    • O3UX3_DISP_TX_RPVAR : Texas Tax Variance Report
    • O3UX3_MIG_LOAD_VLDOC : Tax 2.0 – Load VL Docs for Migration
    • S_SOG_81000181 : IMG activity: OIUX3_RPT
    • S_SOG_81000182 : IMG activity: OIUX3_RPT_STEP
    • S_SOG_81000180 : IMG activity: OIUX3_RPT_GRP
    • S_SOG_81000184 : IMG activity: OIUX3_STEPX_ST
    • O3UX3_RPT_PROF : Reporting Profile Maintenance
    • O3UX3_TX_OOS_WO : Texas Out Of Statute Write Off
    • S_SOG_81000183 : IMG activity: OIUX3_RPT_STEPX
    • S_SOG_81000187 : IMG activity: OIUX3_MIG_ITEM
    • O3UX3_WORKPLACE : Tax 2.0 Workplace
    • S_SOG_81000192 : IMG activity: OIUX3_TX_RP_EDT1
    • O3UX3_MIGRATION_001 : Texas Migration Workbench
    • O3UX3_TX_MASTER : Texas Master Data Maintenance
    • O3UX3_PORTAL : Generic Portal

    Related References

    Related Tutorials

    OIUX3_TX_MSTOVR SAP table for – Tax Reporting – Texas Master Data Overrides

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

    OIUX3Y_TX_BATXID SAP table for – Tax Reporting – Texas BA Tax ID PPN

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

    OIUX3_TX_MASTER SAP table for – Tax Reporting – Texas Master Data

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

    OIUX3Y_TX_MSTOVR SAP table for – Tax Reporting – Texas Master Data Overrides

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

    OIUX3_TX_COMXRF SAP table for – Tax Reporting – Texas Commodity XRef

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

    OIUX3_TX_LEASE_D SAP table for – Tax Reporting – Texas Lease Description

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

    OIUX3_TX_REVSTG SAP table for – Tax Reporting – Texas Tax Transaction Reversal Staging

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

    «
    »