ETXDCJ

Transparent Table Application Table
18 Fields 3 CDS Views

Ext. tax document: tax rates and amounts by Jurisdict. level

ETXDCJ is an SAP database table in S/4HANA. Ext. tax document: tax rates and amounts by Jurisdict. level. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FISVD_EXTERNALTAX_ITEM_BASE view from External Tax Document Line Item Info
I_US_TxPartTxJurisdictionLevel view from BASIC US Tax Partner Tax Jurisdiction Level
US_TxPartTxJurisdictionLevel view_entity from US TaxPartnerTaxDocument

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docnr XTAX_DOCUMENT_NUMBER tax document number
KEY itemnr XTAX_DOC_ITEM_NUMBER tax item number
KEY txjlv TXJCD_LEVEL Jurisdiction level
txjcd TXJCD Tax Jur.
taxpct ETDTAXPERCNT Tax rate (KBETR)
taxamt ETDTAXAMOUNT Tax amount (FWSTE)
taxbas ETDTAXBASE Tax base amount
examt ETDEXAMT Exempt amount
excode EXDETCODE Tax. Exempt reason
gl_taxpct GL_TAXPERCNT G/L Tax rate
gl_taxamt GL_TAXAMOUNT G/L Tax amount
gl_taxbas GL_TAXBASE G/L Tax base amount
gl_shkzg GL_SHKZG G/L Debit/credit ind
hkont HKONT G/L Acct
tax_state FIS_ETXDC_REGION Tax State
sourcing FIS_ETXDC_SOURCING Tax Sourcing
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Ext. tax document: tax rates and amounts by Jurisdict. level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETXDCJ (
    MANDT,       -- Client [MANDT]
    DOCNR,       -- tax document number [XTAX_DOCUMENT_NUMBER]
    ITEMNR,      -- tax item number [XTAX_DOC_ITEM_NUMBER]
    TXJLV,       -- Jurisdiction level [TXJCD_LEVEL]
    TXJCD,       -- Tax Jur. [TXJCD]
    TAXPCT,      -- Tax rate (KBETR) [ETDTAXPERCNT]
    TAXAMT,      -- Tax amount (FWSTE) [ETDTAXAMOUNT]
    TAXBAS,      -- Tax base amount [ETDTAXBASE]
    EXAMT,       -- Exempt amount [ETDEXAMT]
    EXCODE,      -- Tax. Exempt reason [EXDETCODE]
    GL_TAXPCT,   -- G/L Tax rate [GL_TAXPERCNT]
    GL_TAXAMT,   -- G/L Tax amount [GL_TAXAMOUNT]
    GL_TAXBAS,   -- G/L Tax base amount [GL_TAXBASE]
    GL_SHKZG,    -- G/L Debit/credit ind [GL_SHKZG]
    HKONT,       -- G/L Acct [HKONT]
    TAX_STATE,   -- Tax State [FIS_ETXDC_REGION]
    SOURCING,    -- Tax Sourcing [FIS_ETXDC_SOURCING]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DOCNR, ITEMNR, TXJLV)
);

Learn More