OIUX3_TX_RPODT SAP table for – Tax Reporting – Texas Oil Report Details

Here we would like to draw your attention to OIUX3_TX_RPODT 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_TX_RPODT is a SAP standard transp table used for storing Tax Reporting – Texas Oil Report Details related data in SAP. It comes under the package OIU_X3.

SAP OIUX3_TX_RPODT table

Table OIUX3_TX_RPODT technical data

TableOIUX3_TX_RPODT
Data storingTax Reporting – Texas Oil Report Details
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_TX_RPODT 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_TX_RPODT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax Reporting – Texas Oil Report Details Key Fields
    Its a key field.
  • .INCLUDE : Tax Reporting – Texas Oil Report Summary Key Fields
    Its a key field.
  • RUN_ID : Tax Reporting – Run ID
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • PROD_PURC_IND : Tax Reporting – Producer/Purchaser Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TAXPAYER_NUMBER : Tax Reporting – Texas Taxpayer Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 11
  • FILING_PERIOD : Tax Reporting – Texas Filing Period (YYMM)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • COUNTY : Tax Reporting – Texas County
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • LEASE_NUMBER : Tax Reporting – Texas Lease
    Its a key field. Its data type is CHAR (Character String) with field length 7
  • EXEMPTION_TYPE : Tax Reporting – Texas Exemption Type
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • API_WELL_NUMBER : Tax Reporting – Texas API Well Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • OTHER_PARTY_NO : Tax Reporting – Texas Other Party Taxpayer Number
    Its a key field. Its data type is CHAR (Character String) with field length 11
  • INCR_EXCEPT_IND : Tax Reporting – Texas Incremental Exception Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TAX_LIABILITY : Tax Reporting – Texas Tax Liability Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Tax Reporting – Texas Oil Report Details Non Key Fields
  • DRILL_PERMIT : Tax Reporting – Texas Drill Permit?
    Its data type is CHAR (Character String) with field length 1
  • LEASE_OPERATOR : Tax Reporting – Texas Lease Operator Indicator
    Its data type is CHAR (Character String) with field length 1
  • GRAVITY : Gravity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • GROSS_VOL : Tax Reporting – Gross Barrels
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXEMPT_VOL : Tax Reporting – Exempt Barrels
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TAX_VOL : Tax Reporting – Taxable Barrels
    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
  • EXEMPT_VAL : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST : Tax Reporting – Trucking (Marketing) Cost
    Its data type is CURR (Currency Field) with field length 11
  • TAX_VAL : Tax Reporting – Net Taxable Value
    Its data type is CURR (Currency Field) with field length 11
  • TAXPAYER_NAME : Taxpayer Name
    Its data type is CHAR (Character String) with field length 100
  • LEASE_NAME : Tax Reporting – Texas Lease Name
    Its data type is CHAR (Character String) with field length 50
  • COUNTY_NAME : Tax Reporting – Texas County Name
    Its data type is CHAR (Character String) with field length 30
  • OTHER_PARTY_NAME : Business Associate Name
    Its data type is CHAR (Character String) with field length 38
  • TAX_RATE_VAL : Value tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ST_TAX_AMT_DUE : Tax Reporting – State Tax Amount Due
    Its data type is CURR (Currency Field) with field length 11
  • .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
  • EDIT_ERROR : Tax 2.0 – Report Edit Error
    Its data type is CHAR (Character String) with field length 1