OIUX3_TX_TAXHST

Transparent Table Application Table
55 Fields 1 CDS Views

Tax Reporting - Texas Tax History Transactions

OIUX3_TX_TAXHST is an SAP database table in S/4HANA. Tax Reporting - Texas Tax History Transactions. It contains 55 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATaxRptgHistoryTexas view from BASIC PRA Tax Reporting History Texas

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY sales_dt OIU_SALE_DT Sales Date
KEY pdcd OIU_FULL_PD_CD Full Product
KEY wl_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
KEY mp_no OIU_MP_NO Measurement Pt
KEY vname JV_NAME Joint venture
KEY doi_no OIU_DOI_NO Venture/DOI
KEY dn_no OIU_DN_NO Delivery network ID
KEY ct_no OIU_CT_NO Contract
KEY vl_type_cd OIU_VT_CD Volume Type
KEY tax_cls OIU_TAX_CLS Tax Class
KEY tax_type OIU_SEVT_TAX_TY Severance Tax
KEY tier_tax_ind OIUX3_TIER_TAX_INDICATOR Tier Tax
KEY rev_book_adj_ind OIUX3_REVERSE_BOOKING_ADJ_IND Rev/Book/Adj
prod_purc_ind OIUX3_PRODUCER_PURCHASER_IND Prod / Purch
unit_vname JV_NAME Joint venture
pay_fl OIU_SEVT_PAY_FL Sev tax CP obl
rpt_fl OIU_SEVT_RPT_FL Severance tax
uom OIU_MEAS_U UoM
lease_gross_vol OIUX3_LEASE_GROSS_VOLUME Lease Gross Vol
gross_vol OIUX3_GROSS_VOLUME Gross Volume
gross_val OIUX3_GROSS_VALUE Gross Value
tax_vol OIUX3_TAXABLE_VOLUME Taxable Volume
tax_val OIUX3_TAXABLE_VALUE Taxable Value
exempt_vol OIUX3_EXEMPT_VOLUME Exempt Volume
exempt_val OIUX3_EXEMPT_VALUE Exempt Value
mkt_cost OIUX3_MARKETING_COST Marketing Cost
mkt_cost_reimb OIUX3_MARKETING_COST_REIMB Mkt Cost Reimb
tax_amt OIUX3_TAX_AMOUNT Tax Amount
tax_reimb OIUX3_TAX_REIMBURSEMENT Tax Reimburse
tax_rate_vol OIUVL_VL_TAX_RAT Vol tax rate
tax_rate_val OIUVL_VAL_TAX_RAT Val tax rate
gravity OIUH_GRAVITY Gravity
api_well_number OIUX3_TX_API_WELL_NUMBER API Well No.
county OIUX3_TX_COUNTY County
lease_number OIUX3_TX_LEASE_NUMBER Lease No.
off_lease_cd OIUX3_TX_OFF_LEASE_CODE On-/Off-Lease
eor_project OIUX3_TX_PROJECT Project Number
statewide OIUX3_TX_STATEWIDE Statewide Lease
master_level OIUX3_TX_MASTER_LEVEL Master Level
other_no OIUCM_BUS_ASSOC Business Assoc
other_seq_no OIUCM_SEQ_NO Sequence Number
other_party_no OIUX3_TX_OTHER_PARTY_NUMBER Other Party No.
other_party OIUCM_MASTER Master Record
commodity_type OIUX3_TX_COMMODITY_TYPE Commodity Type
exemption_type OIUX3_TX_EXEMPTION_TYPE Exemption Type
taxpayer_number OIUX3_TX_TAXPAYER_NUMBER Taxpayer No.
taxpayer_name OIUX3_TAXPAYER_NAME Taxpayer Name
option1 OIUX3_TX_OPTION1 Option1
option2 OIUX3_TX_OPTION2 Type of PPN Flag
option3 OIUX3_TX_OPTION3 Oil or Gas
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tax Reporting - Texas Tax History Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUX3_TX_TAXHST (
    MANDT,             -- Client [MANDT]
    BUKRS,             -- Company Code [BUKRS]
    SALES_DT,          -- Sales Date [OIU_SALE_DT]
    PDCD,              -- Full Product [OIU_FULL_PD_CD]
    WL_NO,             -- Well [OIU_WL_NO]
    WC_NO,             -- Well Completion [OIU_WC_NO]
    MP_NO,             -- Measurement Pt [OIU_MP_NO]
    VNAME,             -- Joint venture [JV_NAME]
    DOI_NO,            -- Venture/DOI [OIU_DOI_NO]
    DN_NO,             -- Delivery network ID [OIU_DN_NO]
    CT_NO,             -- Contract [OIU_CT_NO]
    VL_TYPE_CD,        -- Volume Type [OIU_VT_CD]
    TAX_CLS,           -- Tax Class [OIU_TAX_CLS]
    TAX_TYPE,          -- Severance Tax [OIU_SEVT_TAX_TY]
    TIER_TAX_IND,      -- Tier Tax [OIUX3_TIER_TAX_INDICATOR]
    REV_BOOK_ADJ_IND,  -- Rev/Book/Adj [OIUX3_REVERSE_BOOKING_ADJ_IND]
    PROD_PURC_IND,     -- Prod / Purch [OIUX3_PRODUCER_PURCHASER_IND]
    UNIT_VNAME,        -- Joint venture [JV_NAME]
    PAY_FL,            -- Sev tax CP obl [OIU_SEVT_PAY_FL]
    RPT_FL,            -- Severance tax [OIU_SEVT_RPT_FL]
    UOM,               -- UoM [OIU_MEAS_U]
    LEASE_GROSS_VOL,   -- Lease Gross Vol [OIUX3_LEASE_GROSS_VOLUME]
    GROSS_VOL,         -- Gross Volume [OIUX3_GROSS_VOLUME]
    GROSS_VAL,         -- Gross Value [OIUX3_GROSS_VALUE]
    TAX_VOL,           -- Taxable Volume [OIUX3_TAXABLE_VOLUME]
    TAX_VAL,           -- Taxable Value [OIUX3_TAXABLE_VALUE]
    EXEMPT_VOL,        -- Exempt Volume [OIUX3_EXEMPT_VOLUME]
    EXEMPT_VAL,        -- Exempt Value [OIUX3_EXEMPT_VALUE]
    MKT_COST,          -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_REIMB,    -- Mkt Cost Reimb [OIUX3_MARKETING_COST_REIMB]
    TAX_AMT,           -- Tax Amount [OIUX3_TAX_AMOUNT]
    TAX_REIMB,         -- Tax Reimburse [OIUX3_TAX_REIMBURSEMENT]
    TAX_RATE_VOL,      -- Vol tax rate [OIUVL_VL_TAX_RAT]
    TAX_RATE_VAL,      -- Val tax rate [OIUVL_VAL_TAX_RAT]
    GRAVITY,           -- Gravity [OIUH_GRAVITY]
    API_WELL_NUMBER,   -- API Well No. [OIUX3_TX_API_WELL_NUMBER]
    COUNTY,            -- County [OIUX3_TX_COUNTY]
    LEASE_NUMBER,      -- Lease No. [OIUX3_TX_LEASE_NUMBER]
    OFF_LEASE_CD,      -- On-/Off-Lease [OIUX3_TX_OFF_LEASE_CODE]
    EOR_PROJECT,       -- Project Number [OIUX3_TX_PROJECT]
    STATEWIDE,         -- Statewide Lease [OIUX3_TX_STATEWIDE]
    MASTER_LEVEL,      -- Master Level [OIUX3_TX_MASTER_LEVEL]
    OTHER_NO,          -- Business Assoc [OIUCM_BUS_ASSOC]
    OTHER_SEQ_NO,      -- Sequence Number [OIUCM_SEQ_NO]
    OTHER_PARTY_NO,    -- Other Party No. [OIUX3_TX_OTHER_PARTY_NUMBER]
    OTHER_PARTY,       -- Master Record [OIUCM_MASTER]
    COMMODITY_TYPE,    -- Commodity Type [OIUX3_TX_COMMODITY_TYPE]
    EXEMPTION_TYPE,    -- Exemption Type [OIUX3_TX_EXEMPTION_TYPE]
    TAXPAYER_NUMBER,   -- Taxpayer No. [OIUX3_TX_TAXPAYER_NUMBER]
    TAXPAYER_NAME,     -- Taxpayer Name [OIUX3_TAXPAYER_NAME]
    OPTION1,           -- Option1 [OIUX3_TX_OPTION1]
    OPTION2,           -- Type of PPN Flag [OIUX3_TX_OPTION2]
    OPTION3,           -- Oil or Gas [OIUX3_TX_OPTION3]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, BUKRS, SALES_DT, PDCD, WL_NO, WC_NO, MP_NO, VNAME, DOI_NO, DN_NO, CT_NO, VL_TYPE_CD, TAX_CLS, TAX_TYPE, TIER_TAX_IND, REV_BOOK_ADJ_IND)
);

Learn More