1. SAP Tutorial
  2. Oil & Gas

OIUX3_TX_RPGDT SAP table for – Tax Reporting – Texas Gas Report Details

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

SAP OIUX3_TX_RPGDT table

Table OIUX3_TX_RPGDT technical data

TableOIUX3_TX_RPGDT
Data storingTax Reporting – Texas Gas 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_RPGDT 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_RPGDT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Tax Reporting – Texas Gas Report Details Key Fields
    Its a key field.
  • .INCLUDE : Tax Reporting – Texas Gas 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
  • COMMODITY_TYPE : Tax Reporting – Texas Commodity Type
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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
  • OFF_LEASE_CD : Tax Reporting – Texas On/Off Lease Code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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
  • TAX_LIABILITY : Tax Reporting – Texas Tax Liability Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • TYPE_5_TAX_RATE : Tax Reporting – Texas Reduced Type 5 Rate
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • .INCLUDE : Tax Reporting – Texas Gas Report Details Non Key Fields
  • LEASE_TYPE : Tax Reporting – Texas Lease Type
    Its data type is CHAR (Character String) with field length 1
  • DRILL_PERMIT : Tax Reporting – Texas Drill Permit?
    Its data type is CHAR (Character String) with field length 1
  • LEASE_GROSS_VOL : Tax Reporting – Total Lease Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TAX_REIMB_IND : Tax Reporting – Texas Tax Reimbursement Indicator
    Its data type is CHAR (Character String) with field length 1
  • GROSS_VOL : Tax Reporting – Texas Your Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • GROSS_VAL : Tax Reporting – Texas Your Value
    Its data type is CURR (Currency Field) with field length 11
  • EXEMPT_VOL : Tax Reporting – Exempt Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • EXEMPT_VAL : Tax Reporting – Exempt Value
    Its data type is CURR (Currency Field) with field length 11
  • MKT_COST : 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
  • TYPE_5_TAX_AMT : Tax Reporting – Texas Tax Due On Type 5 Lease
    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

    • OIUX3_TX_RPGDT related tables

    • OIUX3_TX_TAXSTG : Tax Reporting – Texas Tax Transaction Staging
    • OIUX3_JEINTF : Tax Reporting – JE Interface Table
    • OIUX3_TX_ASU_DT : Tax Reporting – Auto Suspend Detail
    • OIUX3_TX_CNTXRF : Tax Reporting – Texas County XRef
    • OIUX3Y_TX_MASTER : Tax Reporting – Texas Master Data PPN
    • OIUX3_TX_TAXHST : Tax Reporting – Texas Tax History Transactions
    • OIUX3_MIG_VLDOC : Tax Reporting – Migration Loaded VL Docs
    • OIUX3_ITEM_ST : Tax Reporting – Migration Item Prerequisite Status
    • OIUX3_PORTGRP2T : Tax Reporting – Node Group 2 Text Table
    • OIUX3_TX_TXCLEX : Tax Reporting – Texas Tax Class Exemption Type XRef
    • OIUX3_TX_BATXID : Tax Reporting – Texas BA Tax ID
    • OIUX3_TX_RPODTE : Tax Reporting – Texas Oil Report Details Errors
    • OIUX3_TX_LEASE : Tax Reporting – Texas Lease
    • OIUX3_TX_PRDTN : Tax Reporting – Texas PRA Detail Txns – No Tier Tax
    • OIUX3_TX_REJ : Tax Reporting – Texas Reject Codes
    • OIUX3_TX_EXEMPT : Tax Reporting – Texas Exemption Type
    • OIUX3_TX_ASU_HD : Tax Reporting – Auto Suspend Header
    • OIUX3_RPT_GRPPX : Tax Reporting – Report Group Product Code XRef
    • OIUX3_RPT_COMP : Tax Reporting – Reporting Company
    • OIUX3_PDCD_TX : Tax Reporting – 3 Character Product Code Text

    OIUX3_TX_RPGDT related transaction codes under SAP package OIU_X3

    • O3UX3_TX_MASTER : Texas Master Data Maintenance
    • S_SOG_81000179 : IMG activity: V_OIUX3_RPTCFGD
    • S_SOG_81000166 : IMG activity: OIUX3_CONF
    • O3UX3_UPD_TX_TAXHST : Texas Maintain Tax History
    • S_SOG_81000178 : IMG activity: V_OIUX3_RPT_CFG
    • S_SOG_81000170 : IMG activity: OIUX3_EDIT_SRV_GRP
    • S_SOG_81000187 : IMG activity: OIUX3_MIG_ITEM
    • S_SOG_81000188 : IMG activity: OIUX3_ITEM_ST
    • O3UX3_DISP_TX_RPVAR : Texas Tax Variance Report
    • S_SOG_81000193 : IMG activity: OIUX3_TX_RP_EDT2
    • S_SOG_81000184 : IMG activity: OIUX3_STEPX_ST
    • S_SOG_81000172 : IMG activity: OIUX3_RPT_GRPPX
    • O3UX3_TX_BATXID : Texas BA Tax ID Maintenance
    • S_SOG_81000173 : IMG activity: OIUX3_SN_NR_TX
    • O3UX3_DISP_TX_EDTERR : Texas Additional Edit Errors
    • O3UX3_TX_TAXHST : Texas Up To Date Reported Trans
    • S_SOG_81000176 : IMG activity: V_OIUX3_TX_REJ
    • S_SOG_81000181 : IMG activity: OIUX3_RPT
    • S_SOG_81000182 : IMG activity: OIUX3_RPT_STEP
    • O3UX3_WORKPLACE : Tax 2.0 Workplace

    Related References

    Related Tutorials

    OIUX3_TX_RPGDTE SAP table for – Tax Reporting – Texas Gas Report Details Errors

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

    OIUX3_TX_RPGSM SAP table for – Tax Reporting – Texas Gas Report Summary

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

    OIUX3_TX_RPGSME SAP table for – Tax Reporting – Texas Gas Report Summary Errors

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

    OIUX3_TX_RPODTE SAP table for – Tax Reporting – Texas Oil Report Details Errors

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

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

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

    OIUX3_TX_RPOSM SAP table for – Tax Reporting – Texas Oil Report Summary

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

    OIUX3_TX_RPOSME SAP table for – Tax Reporting – Texas Oil Report Summary Errors

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

    «
    »