OIUT5_TAXHSTP

Transparent Table Application Table
69 Fields 1 CDS Views

Tax 2.0 OK - Tax Transaction History (PUN Level)

OIUT5_TAXHSTP is an SAP database table in S/4HANA. Tax 2.0 OK - Tax Transaction History (PUN Level). It contains 69 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATaxRptgHistoryOK view from BASIC PRA Tax Reporting History Oklahoma

Fields (69)

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 pun OIUT5_PRODUCTION_UNIT_NO Prod Unit No
KEY rev_book_adj_ind OIUX5_REV_BOOK_REVADJ_ADJ_IND RvBkRvAjAj
alloc_percent OIUX5_ALLOCATION_PERCENTAGE Allocation %
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
val_tax_rat OIUVL_VAL_TAX_RAT Val tax rate
other_party OIUCM_MASTER Master Record
doc_no OIURV_DOCNR DocNr
doc_year OIU_DOC_YEAR Document year
option1 CHAR1 Single-Character Flag
option2 CHAR1 Single-Character Flag
option3 CHAR1 Single-Character Flag
interface_fl CHAR1 Single-Character Flag
oos_fl OIUX3_OUT_OF_STATUTE Out of Statute
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
exe_enttype1_vol OIUX5_EXEMPT_ENTITY_TYPE_1_VOL Exempt Ty 1 Vol
exe_enttype1_val OIUX5_EXEMPT_ENTITY_TYPE_1_VAL Exempt Ty 1 Val
exe_enttype2_vol OIUX5_EXEMPT_ENTITY_TYPE_2_VOL Exempt Ty 2 Vol
exe_enttype2_val OIUX5_EXEMPT_ENTITY_TYPE_2_VAL Exempt Ty 2 Val
exe_enttype3_vol OIUX5_EXEMPT_ENTITY_TYPE_3_VOL Exempt Ty 3 Vol
exe_enttype3_val OIUX5_EXEMPT_ENTITY_TYPE_3_VAL Exempt Ty 3 Val
exe_enttype4_vol OIUX5_EXEMPT_ENTITY_TYPE_4_VOL Exempt Ty 4 Vol
exe_enttype4_val OIUX5_EXEMPT_ENTITY_TYPE_4_VAL Exempt Ty 4 Val
exe_enttype5_vol OIUX5_EXEMPT_ENTITY_TYPE_5_VOL Exempt Ty 5 Vol
exe_enttype5_val OIUX5_EXEMPT_ENTITY_TYPE_5_VAL Exempt Ty 5 Val
eor_vol OIU_EOR_VL EOR Vl
eor_val OIU_EOR_VAL EOR Value
mkt_cost OIUX3_MARKETING_COST Marketing Cost
mkt_cost_reimb OIUX3_MARKETING_COST_REIMB Mkt Cost Reimb
gp_tax_amt OIUX5_GROSS_PROD_TAX_AMOUNT Gross Prd Tax
pe_tax_amt OIUX5_PETRO_EXCISE_TAX_AMOUNT Petro Exc Tax
rf_tax_amt OIUX5_REVOLVE_FUND_TAX_AMOUNT Rev Fund Tax
mp_tax_amt OIUX5_MARGINAL_PROD_TAX_AMOUNT Margin Prd Tax
kw_tax_amt OIUX5_KIOWA_TAX_AMOUNT Kiowa Tax Amt
ca_tax_amt OIUX5_CHEYENNE_ARAPAHO_TAX_AMT Chey/Arapaho Tx
xx_tax_amt OIUX5_XX_TAX_AMT XX Tax Amount
exempt_code_1 OIUT5_EXEMPT_CODE_1 OK Exempt Cd 1
exempt_code_2 OIUT5_EXEMPT_CODE_2 OK Exempt Cd 2
exempt_code_3 OIUT5_EXEMPT_CODE_3 OK Exempt Cd 3
exempt_code_4 OIUT5_EXEMPT_CODE_4 OK Exempt Cd 4
exempt_code_5 OIUT5_EXEMPT_CODE_5 OK Exempt Cd 5
master_level OIUX5_MASTER_LEVEL Master Level
prod_purch_no OIUX5_OK_PROD_PURCH_NUMBER Prod/Purch No.
ok_product_code OIUX5_OK_PRODUCT_CODE Product Code
taxpayer_number OIUX5_OK_TAXPAYER_NUMBER Taxpayer No
fein_ssn OIUX3_FEIN_SSN FEIN/SSN
reference_run_id OIUX3_RUN_ID Run ID
production_date OIUT5_PRODUCTION_DATE Production Date
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 2.0 OK - Tax Transaction History (PUN Level)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUT5_TAXHSTP (
    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]
    PUN,               -- Prod Unit No [OIUT5_PRODUCTION_UNIT_NO]
    REV_BOOK_ADJ_IND,  -- RvBkRvAjAj [OIUX5_REV_BOOK_REVADJ_ADJ_IND]
    ALLOC_PERCENT,     -- Allocation % [OIUX5_ALLOCATION_PERCENTAGE]
    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]
    VAL_TAX_RAT,       -- Val tax rate [OIUVL_VAL_TAX_RAT]
    OTHER_PARTY,       -- Master Record [OIUCM_MASTER]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    OPTION1,           -- Single-Character Flag [CHAR1]
    OPTION2,           -- Single-Character Flag [CHAR1]
    OPTION3,           -- Single-Character Flag [CHAR1]
    INTERFACE_FL,      -- Single-Character Flag [CHAR1]
    OOS_FL,            -- Out of Statute [OIUX3_OUT_OF_STATUTE]
    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]
    EXE_ENTTYPE1_VOL,  -- Exempt Ty 1 Vol [OIUX5_EXEMPT_ENTITY_TYPE_1_VOL]
    EXE_ENTTYPE1_VAL,  -- Exempt Ty 1 Val [OIUX5_EXEMPT_ENTITY_TYPE_1_VAL]
    EXE_ENTTYPE2_VOL,  -- Exempt Ty 2 Vol [OIUX5_EXEMPT_ENTITY_TYPE_2_VOL]
    EXE_ENTTYPE2_VAL,  -- Exempt Ty 2 Val [OIUX5_EXEMPT_ENTITY_TYPE_2_VAL]
    EXE_ENTTYPE3_VOL,  -- Exempt Ty 3 Vol [OIUX5_EXEMPT_ENTITY_TYPE_3_VOL]
    EXE_ENTTYPE3_VAL,  -- Exempt Ty 3 Val [OIUX5_EXEMPT_ENTITY_TYPE_3_VAL]
    EXE_ENTTYPE4_VOL,  -- Exempt Ty 4 Vol [OIUX5_EXEMPT_ENTITY_TYPE_4_VOL]
    EXE_ENTTYPE4_VAL,  -- Exempt Ty 4 Val [OIUX5_EXEMPT_ENTITY_TYPE_4_VAL]
    EXE_ENTTYPE5_VOL,  -- Exempt Ty 5 Vol [OIUX5_EXEMPT_ENTITY_TYPE_5_VOL]
    EXE_ENTTYPE5_VAL,  -- Exempt Ty 5 Val [OIUX5_EXEMPT_ENTITY_TYPE_5_VAL]
    EOR_VOL,           -- EOR Vl [OIU_EOR_VL]
    EOR_VAL,           -- EOR Value [OIU_EOR_VAL]
    MKT_COST,          -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_REIMB,    -- Mkt Cost Reimb [OIUX3_MARKETING_COST_REIMB]
    GP_TAX_AMT,        -- Gross Prd Tax [OIUX5_GROSS_PROD_TAX_AMOUNT]
    PE_TAX_AMT,        -- Petro Exc Tax [OIUX5_PETRO_EXCISE_TAX_AMOUNT]
    RF_TAX_AMT,        -- Rev Fund Tax [OIUX5_REVOLVE_FUND_TAX_AMOUNT]
    MP_TAX_AMT,        -- Margin Prd Tax [OIUX5_MARGINAL_PROD_TAX_AMOUNT]
    KW_TAX_AMT,        -- Kiowa Tax Amt [OIUX5_KIOWA_TAX_AMOUNT]
    CA_TAX_AMT,        -- Chey/Arapaho Tx [OIUX5_CHEYENNE_ARAPAHO_TAX_AMT]
    XX_TAX_AMT,        -- XX Tax Amount [OIUX5_XX_TAX_AMT]
    EXEMPT_CODE_1,     -- OK Exempt Cd 1 [OIUT5_EXEMPT_CODE_1]
    EXEMPT_CODE_2,     -- OK Exempt Cd 2 [OIUT5_EXEMPT_CODE_2]
    EXEMPT_CODE_3,     -- OK Exempt Cd 3 [OIUT5_EXEMPT_CODE_3]
    EXEMPT_CODE_4,     -- OK Exempt Cd 4 [OIUT5_EXEMPT_CODE_4]
    EXEMPT_CODE_5,     -- OK Exempt Cd 5 [OIUT5_EXEMPT_CODE_5]
    MASTER_LEVEL,      -- Master Level [OIUX5_MASTER_LEVEL]
    PROD_PURCH_NO,     -- Prod/Purch No. [OIUX5_OK_PROD_PURCH_NUMBER]
    OK_PRODUCT_CODE,   -- Product Code [OIUX5_OK_PRODUCT_CODE]
    TAXPAYER_NUMBER,   -- Taxpayer No [OIUX5_OK_TAXPAYER_NUMBER]
    FEIN_SSN,          -- FEIN/SSN [OIUX3_FEIN_SSN]
    REFERENCE_RUN_ID,  -- Run ID [OIUX3_RUN_ID]
    PRODUCTION_DATE,   -- Production Date [OIUT5_PRODUCTION_DATE]
    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, PUN, REV_BOOK_ADJ_IND)
);

Learn More