OIUX3_TX_OOSTXN SAP (Tax Reporting - Texas Out Of Statute Transactions) Table details

Dictionary Type: Table
Description: Tax Reporting - Texas Out Of Statute Transactions




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




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

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

The OIUX3_TX_OOSTXN table consists of various fields, each holding specific information or linking keys about Tax Reporting - Texas Out Of Statute 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: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIUX3_TX_OOSTXN 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 BUKRSCHAR4OIU_CM_COMPCBUKRSBUKC_T001
SALES_DTSales Date / Month OIU_SALE_DTDATS8DATUM
PDCDFull three char. product code (Major and Detail Products) OIU_FULL_PD_CDCHAR3OIUX3_PDCDOIU_FULL_PD_CD
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
MP_NOMeasurement point number OIU_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
VNAMEJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
DN_NODelivery network number OIU_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
CT_NOContract Number OIU_CT_NOCHAR10OIU_RV_CTALPHAOIUCM_CONTRACT_NUMBEROIU_CID
VL_TYPE_CDVolume type code OIU_VT_CDCHAR2OIU_PR_VLTYPOIU_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_OOSTXN using ABAP code

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

SELECT SINGLE *
FROM OIUX3_TX_OOSTXN
INTO CORRESPONDING FIELDS OF WA_OIUX3_TX_OOSTXN
WHERE...

How to access SAP table OIUX3_TX_OOSTXN

Within an ECC or HANA version of SAP you can also view further information about OIUX3_TX_OOSTXN 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!