OIUX6_WY_CTAXHST

Transparent Table Application Table
57 Fields 1 CDS Views

Tax 2.0 - Wyoming Conservation Tax Transactions History

OIUX6_WY_CTAXHST is an SAP database table in S/4HANA. Tax 2.0 - Wyoming Conservation Tax Transactions History. It contains 57 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATaxRptgHistWYConsvn view from BASIC PRA Tax Reporting Hist WY Conservation

Fields (57)

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 rev_book_adj_ind OIUX6_REV_BOOK_REVADJ_ADJ_IND RvBkRvAjAj
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
gross_vol OIUX3_GROSS_VOLUME Gross Volume
tax_vol OIUX3_TAXABLE_VOLUME Taxable Volume
tax_val OIUX3_TAXABLE_VALUE Taxable Value
exempt_vol OIUX3_EXEMPT_VOLUME Exempt Volume
tax_amt OIUX3_TAX_AMOUNT Tax Amount
tax_reimb OIUX3_TAX_REIMBURSEMENT Tax Reimburse
wet_less_res OIUX6_WET_LESS_RES_VOLUME Wet Less Res
blps_gross_vol OIUX6_WY_BLPS_GROSS_VOLUME BLPS Gross Vol
ret_lse_pc OIUCA_RET_LSE_PC % Ret. to Lease
plant_proc_vol OIUX6_WY_PLANT_PROC_VOLUME Plant Proc Vol
county OIUX6_WY_COUNTY Wyoming County
api_well_number OIUX6_WY_API_WELL_NUMBER API Well No.
side_track_no OIUX6_WY_SIDE_TRACK_NUMBER Side Track No
reservoir OIUX6_WY_RESERVOIR Reservoir
rpt_grp_no OIUX6_WY_REPORT_GROUP_NUMBER Report Grp No
field_name OIUX6_WY_FIELD_NAME Field Name
lease_unit_name OIUX6_WY_LEASE_UNIT_NAME Lse Unit API
operated_flag OIUX6_OPERATED_FLAG Operated Flag
tax_district OIUX6_WY_TAX_DISTRICT Tax District
gas_plant_name OIUX6_GAS_PL_NAME Gas Plant Name
master_level OIUX3_TX_MASTER_LEVEL Master Level
operator_id OIUX6_WY_OPERATOR_ID Operator ID
operator_no OIUCM_BUS_ASSOC Business Assoc
operator_seq_no OIUCM_SEQ_NO Sequence Number
operator_name OIUX6_OPERATOR_NAME Operator Name
purchaser_no OIUCM_BUS_ASSOC Business Assoc
purchaser_seq_no OIUCM_SEQ_NO Sequence Number
purchaser_name OIUX6_PURCHASER_NAME Purchaser Name
ogind OIUREP_OIL_GAS_IND Oil/Gas Ind.
doc_no OIURV_DOCNR DocNr
doc_year OIU_DOC_YEAR Document year
option1 abap.char
option2 abap.char
option3 OIUX6_EXT_UPDATE External data
operator OIUCM_MASTER Master Record
purchaser OIUCM_MASTER Master Record
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 - Wyoming Conservation Tax Transactions History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIUX6_WY_CTAXHST (
    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]
    REV_BOOK_ADJ_IND,  -- RvBkRvAjAj [OIUX6_REV_BOOK_REVADJ_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]
    GROSS_VOL,         -- Gross Volume [OIUX3_GROSS_VOLUME]
    TAX_VOL,           -- Taxable Volume [OIUX3_TAXABLE_VOLUME]
    TAX_VAL,           -- Taxable Value [OIUX3_TAXABLE_VALUE]
    EXEMPT_VOL,        -- Exempt Volume [OIUX3_EXEMPT_VOLUME]
    TAX_AMT,           -- Tax Amount [OIUX3_TAX_AMOUNT]
    TAX_REIMB,         -- Tax Reimburse [OIUX3_TAX_REIMBURSEMENT]
    WET_LESS_RES,      -- Wet Less Res [OIUX6_WET_LESS_RES_VOLUME]
    BLPS_GROSS_VOL,    -- BLPS Gross Vol [OIUX6_WY_BLPS_GROSS_VOLUME]
    RET_LSE_PC,        -- % Ret. to Lease [OIUCA_RET_LSE_PC]
    PLANT_PROC_VOL,    -- Plant Proc Vol [OIUX6_WY_PLANT_PROC_VOLUME]
    COUNTY,            -- Wyoming County [OIUX6_WY_COUNTY]
    API_WELL_NUMBER,   -- API Well No. [OIUX6_WY_API_WELL_NUMBER]
    SIDE_TRACK_NO,     -- Side Track No [OIUX6_WY_SIDE_TRACK_NUMBER]
    RESERVOIR,         -- Reservoir [OIUX6_WY_RESERVOIR]
    RPT_GRP_NO,        -- Report Grp No [OIUX6_WY_REPORT_GROUP_NUMBER]
    FIELD_NAME,        -- Field Name [OIUX6_WY_FIELD_NAME]
    LEASE_UNIT_NAME,   -- Lse Unit API [OIUX6_WY_LEASE_UNIT_NAME]
    OPERATED_FLAG,     -- Operated Flag [OIUX6_OPERATED_FLAG]
    TAX_DISTRICT,      -- Tax District [OIUX6_WY_TAX_DISTRICT]
    GAS_PLANT_NAME,    -- Gas Plant Name [OIUX6_GAS_PL_NAME]
    MASTER_LEVEL,      -- Master Level [OIUX3_TX_MASTER_LEVEL]
    OPERATOR_ID,       -- Operator ID [OIUX6_WY_OPERATOR_ID]
    OPERATOR_NO,       -- Business Assoc [OIUCM_BUS_ASSOC]
    OPERATOR_SEQ_NO,   -- Sequence Number [OIUCM_SEQ_NO]
    OPERATOR_NAME,     -- Operator Name [OIUX6_OPERATOR_NAME]
    PURCHASER_NO,      -- Business Assoc [OIUCM_BUS_ASSOC]
    PURCHASER_SEQ_NO,  -- Sequence Number [OIUCM_SEQ_NO]
    PURCHASER_NAME,    -- Purchaser Name [OIUX6_PURCHASER_NAME]
    OGIND,             -- Oil/Gas Ind. [OIUREP_OIL_GAS_IND]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    OPTION1,           -- abap.char
    OPTION2,           -- abap.char
    OPTION3,           -- External data [OIUX6_EXT_UPDATE]
    OPERATOR,          -- Master Record [OIUCM_MASTER]
    PURCHASER,         -- Master Record [OIUCM_MASTER]
    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, REV_BOOK_ADJ_IND)
);

Learn More