ETXDCJ

Transparent Table Application Table
8 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 8 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 (8)

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.
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]
    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