1. SAP Tutorial
  2. Oil & Gas

OIUX7_WY_GTAXHST SAP table for – Tax 2.0 – Wyoming Gross Prod Tax Transactions History

Here we would like to draw your attention to OIUX7_WY_GTAXHST 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). OIUX7_WY_GTAXHST is a SAP standard transp table used for storing Tax 2.0 – Wyoming Gross Prod Tax Transactions History related data in SAP. It comes under the package OIU_X7.

SAP OIUX7_WY_GTAXHST table

Table OIUX7_WY_GTAXHST technical data

TableOIUX7_WY_GTAXHST
Data storingTax 2.0 – Wyoming Gross Prod Tax Transactions History
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X7
Delivery ClassL – Table for storing temporary data
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax 2.0 – Wyoming Severance Tax Transactions Key Fields
    Its a key field.
  • .INCLUDE : Tax 2.0 – Wyoming Severance Tax Reversal Key Fields
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SALES_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PDCD : Full three char. product code (Major and Detail Products)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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
  • 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
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VL_TYPE_CD : Volume type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TAX_CLS : Tax Class
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Tax 2.0 – Wyoming Severance Tax Transactions Non-Key Fields
  • FORM_TYPE : Tax 2.0 – Original / Amended / Unknown Indicator
    Its data type is CHAR (Character String) with field length 1
  • UNIT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • PAY_FL : Tax Severance Tax Calculation Payment Obligations Types
    Its data type is CHAR (Character String) with field length 1
  • RPT_FL : State Severance Tax Reporting Indicators
    Its data type is CHAR (Character String) with field length 1
  • UOM : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GROSS_VOL : Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GROSS_VAL : Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • TAX_VAL : Taxable Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VAL_01 : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VAL_02 : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VAL_03 : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VAL_04 : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VAL_05 : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_01 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_02 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_03 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_04 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_05 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_06 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_07 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_08 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_09 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_10 : Marketing Cost
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST_REIMB : Marketing Cost Reimbursement
    Its data type is CURR (Currency Field) with field length 11
  • SV_TAX_AMT : Tax 2.0 – Severance Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • SA_TAX_AMT : Tax 2.0 – Wyoming Shoshone Arapaho Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • AV_TAX_AMT : Tax 2.0 – Wyoming Ad Valorem Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • XX_TAX_AMT : Tax 2.0 – XX Tax Amount
    Its data type is CURR (Currency Field) with field length 11
  • PREV_TAX_PAID : Tax 2.0 – Previous Tax Paid
    Its data type is CURR (Currency Field) with field length 11
  • TAX_REIMB : Tax Reporting – Tax Reimbursement
    Its data type is CURR (Currency Field) with field length 11
  • WET_LESS_RES : Tax 2.0 – Wet Less Residue Volume (MCF)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • BLPS_GROSS_VOL : Tax 2.0 – Wyoming Before Lease Plant Split Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • BLPS_GROSS_VAL : Tax 2.0 – Wyoming Before Lease Plant Split Gross Value
    Its data type is CURR (Currency Field) with field length 11
  • RET_LSE_PC : Percent Returned to Lease
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • PLANT_PROC_ALLOW : Tax 2.0 – Wyoming Plant Processing Allowance
    Its data type is CURR (Currency Field) with field length 11
  • .INCLUDE : Tax 2.0 – Wyoming Master Data Nonkey Fields
  • COUNTY : Tax 2.0 – Wyoming County Identifier
    Its data type is CHAR (Character String) with field length 3
  • API_WELL_NUMBER : Tax 2.0 – Wyoming API Well Number
    Its data type is CHAR (Character String) with field length 5
  • SIDE_TRACK_NO : Tax 2.0 – Wyoming Side Track Number
    Its data type is CHAR (Character String) with field length 2
  • RESERVOIR : Tax 2.0 – Wyoming Reservoir
    Its data type is CHAR (Character String) with field length 3
  • RPT_GRP_NO : Tax 2.0 – Wyoming Report Group Number
    Its data type is CHAR (Character String) with field length 5
  • FIELD_NAME : Tax 2.0 – Wyoming Field Name
    Its data type is CHAR (Character String) with field length 35
  • LEASE_UNIT_NAME : Tax 2.0 – Wyoming Lease Unit Name / API
    Its data type is CHAR (Character String) with field length 35
  • OPERATED_FLAG : Tax 2.0 – Operated Flag
    Its data type is CHAR (Character String) with field length 1
  • TAX_DISTRICT : Tax 2.0 – Wyoming Tax District
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • MASTER_LEVEL : Tax Reporting – Texas Master Level
    Its data type is CHAR (Character String) with field length 1
  • OPERATOR_ID : Tax 2.0 – Wyoming Operator ID
    Its data type is CHAR (Character String) with field length 4
  • RATE_CODE : Tax 2.0 – Wyoming Rate Code
    Its data type is CHAR (Character String) with field length 3
  • OGIND : Oil and Gas Indicator
    Its data type is CHAR (Character String) with field length 1
  • DOC_NO : Val. document number
    Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPTION1 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION2 : CSI Char-field of length 200
    Its data type is CHAR (Character String) with field length 1
  • OPTION3 : Tax 2.0 – Indicator to identify external data update
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : 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

    • OIUX7_WY_GTAXHST related tables

    • OIUX7_WY_REJT : Tax 2.0 – WYGP Reject Code Text
    • OIUX7_WY_4231HST : Tax 2.0 – WYGP 4231 Up To Date History
    • OIUX7_WY_GSALHST : Tax 2.0 – WYGP Sales History
    • OIUX7_WY_MPALLOC : Tax 2.0 – WYGP MP Allocation
    • OIUX7_WY_MKTOVR : Tax 2.0 – WYGP Marketing Type Xref Override
    • OIUX7_WY_REJ : Tax 2.0 – WYGP Reject Codes
    • OIUX7_WY_MKT_TX : Tax 2.0 – WYGP Marketing Type Descriptions
    • OIUX7_WY_4101HST : Tax 2.0 – WYGP 4101 Up To Date History
    • OIUX7_WY_4111 : Tax 2.0 – WYGP 4111
    • OIUX7_WY_4231 : Tax 2.0 – WYGP 4231
    • OIUX7_WY_GVOL : Tax 2.0 – WYGP Volume
    • OIUX7_WY_GVOLHST : Tax 2.0 – WYGP Volume History
    • OIUX7_CONFIG : Tax 2.0 – WYGP Config
    • OIUX7_WY_GTAXHST : Tax 2.0 – Wyoming Gross Prod Tax Transactions History
    • OIUX7_WY_GTAX : Tax 2.0 – Wyoming Gross Prod Tax Transactions
    • OIUX7_WY_GVOLTXN : Tax 2.0 – WYGP Volumes
    • OIUX7_WY_MKT : Tax 2.0 – WYGP Marketing Types
    • OIUX7_WY_4201HST : Tax 2.0 – WYGP 4201 Up To Date History
    • OIUX7_WY_4121 : Tax 2.0 – WYGP 4121
    • OIUX7_WY_DN_CON : Tax 2.0 – WYGP DN Consistency

    OIUX7_WY_GTAXHST related transaction codes under SAP package OIU_X7

    • S_YEP_98000001 : IMG activity: OIUX7_WY_PDVLXRF
    • O3UX7_WY_MPALLOC : Tax 2.0 – WYGP MP Allocation
    • O3UX7_WY_MKTOVR : Tax 2.0 – WYGP Mkt XRef Override
    • S_YEP_98000002 : IMG activity: OIUX7_WY_VLXRF
    • O3UX7_WORKPLACE : Tax 2.0 – WYGP Workplace
    • S_YEP_98000004 : IMG activity: OIUX7_CONFIG
    • S_YEP_98000003 : IMG activity: OIUX7_WY_MKTXRF

    Related References

    Related Tutorials

    OIUX7_WY_GTAX SAP table for – Tax 2.0 – Wyoming Gross Prod Tax Transactions

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

    OIUX6_WY_GTAXTXN SAP table for – Tax 2.0 – Wyoming Gross Prod Tax Transactions

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

    OIUX6_WY_GTAXSTG SAP table for – Tax 2.0 – Wyoming Gross Prod Tax Transactions Staging

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

    OIUX6_WY_STAXHST SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions History

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

    OIUX6_WY_CTAXHST SAP table for – Tax 2.0 – Wyoming Conservation Tax Transactions History

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

    OIUX6_WY_STAXSTG SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions Staging

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

    OIUX6_WY_STAXTXN SAP table for – Tax 2.0 – Wyoming Severance Tax Transactions

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

    «
    »