OIUX3_TX_TAXHST SAP (Tax Reporting - Texas Tax History Transactions) Table details

Dictionary Type: Table
Description: Tax Reporting - Texas Tax History Transactions




ABAP Code to SELECT data from OIUX3_TX_TAXHST
Related tables to OIUX3_TX_TAXHST
Access table OIUX3_TX_TAXHST




Table field list including key, data, relationships and ABAP select examples

OIUX3_TX_TAXHST is a standard SAP Table which is used to store Tax Reporting - Texas Tax History Transactions data and is available within R/3 SAP systems depending on the version and release level.

The OIUX3_TX_TAXHST table consists of various fields, each holding specific information or linking keys about Tax Reporting - Texas Tax History Transactions data available in SAP. These include BUKRS (Company Code), SALES_DT (Sales Date / Month), PDCD (Full three char. product code (Major and Detail Products)), WL_NO (Well ID number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIUX3_TX_TAXHST table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SALES_DTSales Date / Month OIU_SALE_DTDATS8DATUM
PDCDFull three char. product code (Major and Detail Products) OIU_FULL_PD_CDCHAR3Assigned to domainOIU_FULL_PD_CD
WL_NOWell ID number OIU_WL_NOCHAR15Assigned to domainALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5Assigned to domainALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
MP_NOMeasurement point number OIU_MP_NOCHAR20Assigned to domainALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5Assigned to domainALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
DN_NODelivery network number OIU_DN_NOCHAR20Assigned to domainALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
CT_NOContract Number OIU_CT_NOCHAR10Assigned to domainALPHAOIUCM_CONTRACT_NUMBEROIU_CID
VL_TYPE_CDVolume type code OIU_VT_CDCHAR2Assigned to domainOIU_VL_TYPE_CDOIU_VTCD
TAX_CLSTax Class OIU_TAX_CLSCHAR4OIU_CM_TAXCLSOIU_TAX_CLSOIU_TAX_CLS
TAX_TYPESeverance Tax Type OIU_SEVT_TAX_TYCHAR2OIU_CM_SEVTTYOIU_SEVT_TAX_TYOIU_SEVT_TAX_TY
TIER_TAX_INDTier Tax OIUX3_TIER_TAX_INDICATORCHAR1OIUX3_TIER_TAX_INDICATOR
REV_BOOK_ADJ_INDReversal/Booking/Adjustment OIUX3_REVERSE_BOOKING_ADJ_INDCHAR1OIUX3_REVERSE_BOOKING_ADJ_IND
PROD_PURC_INDProducer or Purchaser OIUX3_PRODUCER_PURCHASER_INDCHAR1OIUX3_PRODUCER_PURCHASER_IND
UNIT_VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
PAY_FLTax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FLCHAR1OIU_SEVT_PAY_FL
RPT_FLState Severance Tax Reporting Indicators OIU_SEVT_RPT_FLCHAR1CHAR1
UOMMeasurement unit OIU_MEAS_UUNIT3T006CUNITMEINS
LEASE_GROSS_VOLLease Gross Volume OIUX3_LEASE_GROSS_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
GROSS_VOLGross Volume OIUX3_GROSS_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
GROSS_VALGross Value OIUX3_GROSS_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
TAX_VOLTaxable Volume OIUX3_TAXABLE_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
TAX_VALTaxable Value OIUX3_TAXABLE_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
EXEMPT_VOLExempt Volume OIUX3_EXEMPT_VOLUMEDEC11(2) OIUX3_SIGNED_DEC_11_2
EXEMPT_VALExempt Value OIUX3_EXEMPT_VALUECURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COSTMarketing Cost OIUX3_MARKETING_COSTCURR11(2) OIUX3_SIGNED_CURR_11_2
MKT_COST_REIMBMarketing Cost Reimbursement OIUX3_MARKETING_COST_REIMBCURR11(2) OIUX3_SIGNED_CURR_11_2
TAX_AMTTax Amount OIUX3_TAX_AMOUNTCURR11(2) OIUX3_SIGNED_CURR_11_2
TAX_REIMBTax Reimbursement OIUX3_TAX_REIMBURSEMENTCURR11(2) OIUX3_SIGNED_CURR_11_2
TAX_RATE_VOLVolume tax rate OIUVL_VL_TAX_RATDEC7(6) OIUVL_PERCENT76
TAX_RATE_VALValue tax rate OIUVL_VAL_TAX_RATDEC7(6) OIUVL_PERCENT76
GRAVITYGravity OIUH_GRAVITYDEC3(1) OIUH_DEC3_1
API_WELL_NUMBERAPI Well Number OIUX3_TX_API_WELL_NUMBERCHAR8CHAR8
COUNTYTexas County Identifier OIUX3_TX_COUNTYNUMC3OIUX3_TX_CNTXRFNUMC3
LEASE_NUMBERTexas Lease Number OIUX3_TX_LEASE_NUMBERCHAR7OIUX3_TX_LEASECHAR7
OFF_LEASE_CDTexas On-/Off-Lease Sale Code OIUX3_TX_OFF_LEASE_CODECHAR1OIUX3_TX_OFF_LEASE_CODE
MASTER_LEVELTexas Master Data Level OIUX3_TX_MASTER_LEVELCHAR1OIUX3_TX_MASTER_LEVEL
OTHER_NOBusiness Associate OIUCM_BUS_ASSOCCHAR6OIUCM_BA_LINKALPHAOIUCM_BUS_ASSOCOIUCM_BUS_ASSOC
OTHER_SEQ_NOSequence Number OIUCM_SEQ_NOCHAR2OIUCM_BA_LINKALPHAOIUCM_SEQ_NOOIUCM_SEQ_NO
OTHER_PARTY_NOTexas Taxpayer Number of Other Party OIUX3_TX_OTHER_PARTY_NUMBERCHAR11TEXT11
COMMODITY_TYPETexas Commodity Type OIUX3_TX_COMMODITY_TYPECHAR3OIUX3_TX_COMMODITY_TYPE
EXEMPTION_TYPETexas Exemption Type OIUX3_TX_EXEMPTION_TYPENUMC2NUMC2
TAXPAYER_NUMBERTexas Taxpayer Number OIUX3_TX_TAXPAYER_NUMBERNUMC11
TAXPAYER_NAMETaxpayer Name OIUX3_TAXPAYER_NAMECHAR100TEXT100
OPTION1 0
OPTION2 PPN Flag0
OPTION3 0
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table OIUX3_TX_TAXHST using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIUX3_TX_TAXHST to SELECT all data from the table
DATA: WA_OIUX3_TX_TAXHST TYPE OIUX3_TX_TAXHST.

SELECT SINGLE *
FROM OIUX3_TX_TAXHST
INTO CORRESPONDING FIELDS OF WA_OIUX3_TX_TAXHST
WHERE...

How to access SAP table OIUX3_TX_TAXHST

Within an ECC or HANA version of SAP you can also view further information about OIUX3_TX_TAXHST and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!