/PRA/ND_TAXHST

Transparent Table Application Table
59 Fields 1 CDS Views

Tax 2.0 - ND Tax History Transactions

/PRA/ND_TAXHST is an SAP database table in S/4HANA. Tax 2.0 - ND Tax History Transactions. It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRATaxRptgHistoryND view from BASIC PRA Tax Reporting History North Dakota

Fields (59)

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 /PRA/ND_REV_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
brl_oil_pur_sld /PRA/ND_BARREL_OIL_PUR_SOL Oil Barrel Pur/Sold
val_oil_pur_sld /PRA/ND_OIL_VALUE Oil Value Pur/Sold
exempt_value /PRA/ND_EXEMPT_VALUE Exm Val Pur/Sold
tax_value_oil /PRA/ND_TAX_VALUE Oil Tax Value
pr_tax_due /PRA/ND_PR_TAX_DUE Prod Tax Due
pr_tax_prev /PRA/ND_PR_TAX_PREV Prod Tax Prev
pr_tax_others /PRA/ND_PR_TAX_OTHERS Prod Tax Others
pr_tax_paid /PRA/ND_PR_TAX_REPORT Prod Tax Report
ex_tax_due /PRA/ND_EX_TAX_DUE Extract Tax Due
ex_tax_prev /PRA/ND_EX_TAX_PREV Extract Tax Prev
ex_tax_others /PRA/ND_EX_TAX_OTHERS Extract Tax Others
ex_tax_paid /PRA/ND_EX_TAX_REPORT Extract Tax Report
additional_val /PRA/ND_ADDITIONAL_VAL Additional Val
mkt_cost_01 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_02 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_03 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_04 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_05 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_06 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_07 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_08 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_09 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_10 OIUX3_MARKETING_COST Marketing Cost
mkt_cost_reimb OIUX3_MARKETING_COST_REIMB Mkt Cost Reimb
well_code /PRA/ND_WELL_CODE Well Code
posting_code /PRA/ND_POSTING_CODE Posting Code
api_number /PRA/ND_API_NUMBER API Number
api_name /PRA/ND_API_NAME Name
oil_gravity /PRA/ND_OIL_GRAVITY oil_gravity
other_no /PRA/CM_CUSTOMER_VENDOR_NUMBER Customer/Vendor
oth_fed_id_no_1 /PRA/ND_FEDERAL_ID_NO Othr Prty Fed
taxpayer_number /PRA/ND_TAX_PAYER_NO Tax Payer No
option1 abap.char
option2 abap.char
option3 abap.char
pool_code /PRA/ND_POOL_CODE Pool Code
doc_no OIURV_DOCNR DocNr
doc_year OIU_DOC_YEAR Document year
oiu_cruser ERNAM Created By
oiu_timestamp /PRA/ND_TMP Timestamp

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 - ND Tax History Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PRA/ND_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]
    REV_BOOK_ADJ_IND,  -- Rev/Book/Adj [/PRA/ND_REV_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]
    BRL_OIL_PUR_SLD,   -- Oil Barrel Pur/Sold [/PRA/ND_BARREL_OIL_PUR_SOL]
    VAL_OIL_PUR_SLD,   -- Oil Value Pur/Sold [/PRA/ND_OIL_VALUE]
    EXEMPT_VALUE,      -- Exm Val Pur/Sold [/PRA/ND_EXEMPT_VALUE]
    TAX_VALUE_OIL,     -- Oil Tax Value [/PRA/ND_TAX_VALUE]
    PR_TAX_DUE,        -- Prod Tax Due [/PRA/ND_PR_TAX_DUE]
    PR_TAX_PREV,       -- Prod Tax Prev [/PRA/ND_PR_TAX_PREV]
    PR_TAX_OTHERS,     -- Prod Tax Others [/PRA/ND_PR_TAX_OTHERS]
    PR_TAX_PAID,       -- Prod Tax Report [/PRA/ND_PR_TAX_REPORT]
    EX_TAX_DUE,        -- Extract Tax Due [/PRA/ND_EX_TAX_DUE]
    EX_TAX_PREV,       -- Extract Tax Prev [/PRA/ND_EX_TAX_PREV]
    EX_TAX_OTHERS,     -- Extract Tax Others [/PRA/ND_EX_TAX_OTHERS]
    EX_TAX_PAID,       -- Extract Tax Report [/PRA/ND_EX_TAX_REPORT]
    ADDITIONAL_VAL,    -- Additional Val [/PRA/ND_ADDITIONAL_VAL]
    MKT_COST_01,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_02,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_03,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_04,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_05,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_06,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_07,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_08,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_09,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_10,       -- Marketing Cost [OIUX3_MARKETING_COST]
    MKT_COST_REIMB,    -- Mkt Cost Reimb [OIUX3_MARKETING_COST_REIMB]
    WELL_CODE,         -- Well Code [/PRA/ND_WELL_CODE]
    POSTING_CODE,      -- Posting Code [/PRA/ND_POSTING_CODE]
    API_NUMBER,        -- API Number [/PRA/ND_API_NUMBER]
    API_NAME,          -- Name [/PRA/ND_API_NAME]
    OIL_GRAVITY,       -- oil_gravity [/PRA/ND_OIL_GRAVITY]
    OTHER_NO,          -- Customer/Vendor [/PRA/CM_CUSTOMER_VENDOR_NUMBER]
    OTH_FED_ID_NO_1,   -- Othr Prty Fed [/PRA/ND_FEDERAL_ID_NO]
    TAXPAYER_NUMBER,   -- Tax Payer No [/PRA/ND_TAX_PAYER_NO]
    OPTION1,           -- abap.char
    OPTION2,           -- abap.char
    OPTION3,           -- abap.char
    POOL_CODE,         -- Pool Code [/PRA/ND_POOL_CODE]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Timestamp [/PRA/ND_TMP]
    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