ETXDCH

Transparent Table Application Table
46 Fields 15 CDS Views

External tax document: header info

ETXDCH is an SAP database table in S/4HANA. External tax document: header info. It contains 46 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
FISVD_ETXMISSFROMBSET view left_outer External tax tables missing from BSET
FISVD_EXTERNALTAX_BKPF view left_outer TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_DOCSTATUS view from TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_ETXDCH_BKPF view from TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_ETXDCH_FI view from TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_ETXDCH_NBKPF view from TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_ITEM_BASE view left_outer External Tax Document Line Item Info
FISVD_EXTERNALTAX_MKPF view left_outer TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_NOBKPF view left_outer None bkpf or bkpff block
FISVD_EXTERNALTAX_TERMINATION view left_outer TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_TRFCSSTATE view union tRFC state
FISVD_EXTERNALTAX_UNIONTID view union TAX EXPOSTING MANAGE
FISVD_EXTERNALTAX_VBRK view left_outer TAX EXPOSTING MANAGE
I_US_TaxPartnerTaxDocument view from BASIC US TaxPartnerTaxDocument
US_TaxPartnerTaxDocument view_entity from US TaxPartnerTaxDocument

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docnr XTAX_DOCUMENT_NUMBER tax document number
awtyp AWTYP Ref. procedure
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
awsys AWSYS Logical System
docstatus ETXDC_STATUS_CUR cur tax doc status
docstatuschanged ETXDC_STATUS_CHANGED Date status changed
createdon TAX_CREATEDON Created on
createdby TAX_CREATEDBY Created by
tid TAX_TID Transaction ID for updating external tax system
gltax TAX_GLTAX_ADDED gltax data added
txdef TAX_DEFAULTED Tax amounts default
default_reason TAX_DEFAULT_REASON Tax Default Reason
incon TAX_INCONS_INT Int consistency fail
excon TAX_INCONS_EXT Tax ext. inconsist.
uflag UPDATE_FLG Update ID
udate UPDATE_DAT Update Date
usnam UPDATE_USER user name
syst_name TAX_LOGSYS Logical system taxes
client TAX_CLIENT Tax interface client
comp_code TAX_COMP_CODE Company code
doc_number TAX_DOC_NUMBER Tax document number
currency TAX_CURRENCY Document currency
curr_dec CURDECCHAR Crcy Decimals
txjcd_l1 LENGX_TXD Length
txjcd_l2 LENGX_TXD Length
txjcd_l3 LENGX_TXD Length
txjcd_l4 LENGX_TXD Length
tax_per_item TAX_PER_ITEM Tax calc per item
nr_line_items TAX_NR_LINES number of lines
is_ujcs_active TAX_IND_UNI Actv UJCS Ind
api_version TAX_API_VER API Version
gl_currency TAX_GLCURRENCY G/L currency
gl_curr_dec GL_CURDECCHAR Loc Curr. decimals
rep_date EXTREPDATE posting date
ratedec TAX_RATEDECCHAR Rate Decimals
xextn XEXTN_TXP External tax ID
interf_version TAX_INT_VERSION tax interface vers.
tax_procedure KALSM_D Procedure
errcode ERRNUM Output: Error number
error_line TAX_ERROR_LINE Line number
errmsg TAX_ERROR_MSG Tax error messages
rec_status FIS_ETXDC_ACTION Activity
feed_count FIS_ETXDC_FEEDCOUNT Count of Comments
_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.

-- External tax document: header info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETXDCH (
    MANDT,             -- Client [MANDT]
    DOCNR,             -- tax document number [XTAX_DOCUMENT_NUMBER]
    AWTYP,             -- Ref. procedure [AWTYP]
    AWREF,             -- Reference Doc. [AWREF]
    AWORG,             -- Refer. Org.Unit [AWORG]
    AWSYS,             -- Logical System [AWSYS]
    DOCSTATUS,         -- cur tax doc status [ETXDC_STATUS_CUR]
    DOCSTATUSCHANGED,  -- Date status changed [ETXDC_STATUS_CHANGED]
    CREATEDON,         -- Created on [TAX_CREATEDON]
    CREATEDBY,         -- Created by [TAX_CREATEDBY]
    TID,               -- Transaction ID for updating external tax system [TAX_TID]
    GLTAX,             -- gltax data added [TAX_GLTAX_ADDED]
    TXDEF,             -- Tax amounts default [TAX_DEFAULTED]
    DEFAULT_REASON,    -- Tax Default Reason [TAX_DEFAULT_REASON]
    INCON,             -- Int consistency fail [TAX_INCONS_INT]
    EXCON,             -- Tax ext. inconsist. [TAX_INCONS_EXT]
    UFLAG,             -- Update ID [UPDATE_FLG]
    UDATE,             -- Update Date [UPDATE_DAT]
    USNAM,             -- user name [UPDATE_USER]
    SYST_NAME,         -- Logical system taxes [TAX_LOGSYS]
    CLIENT,            -- Tax interface client [TAX_CLIENT]
    COMP_CODE,         -- Company code [TAX_COMP_CODE]
    DOC_NUMBER,        -- Tax document number [TAX_DOC_NUMBER]
    CURRENCY,          -- Document currency [TAX_CURRENCY]
    CURR_DEC,          -- Crcy Decimals [CURDECCHAR]
    TXJCD_L1,          -- Length [LENGX_TXD]
    TXJCD_L2,          -- Length [LENGX_TXD]
    TXJCD_L3,          -- Length [LENGX_TXD]
    TXJCD_L4,          -- Length [LENGX_TXD]
    TAX_PER_ITEM,      -- Tax calc per item [TAX_PER_ITEM]
    NR_LINE_ITEMS,     -- number of lines [TAX_NR_LINES]
    IS_UJCS_ACTIVE,    -- Actv UJCS Ind [TAX_IND_UNI]
    API_VERSION,       -- API Version [TAX_API_VER]
    GL_CURRENCY,       -- G/L currency [TAX_GLCURRENCY]
    GL_CURR_DEC,       -- Loc Curr. decimals [GL_CURDECCHAR]
    REP_DATE,          -- posting date [EXTREPDATE]
    RATEDEC,           -- Rate Decimals [TAX_RATEDECCHAR]
    XEXTN,             -- External tax ID [XEXTN_TXP]
    INTERF_VERSION,    -- tax interface vers. [TAX_INT_VERSION]
    TAX_PROCEDURE,     -- Procedure [KALSM_D]
    ERRCODE,           -- Output: Error number [ERRNUM]
    ERROR_LINE,        -- Line number [TAX_ERROR_LINE]
    ERRMSG,            -- Tax error messages [TAX_ERROR_MSG]
    REC_STATUS,        -- Activity [FIS_ETXDC_ACTION]
    FEED_COUNT,        -- Count of Comments [FIS_ETXDC_FEEDCOUNT]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DOCNR)
);

Learn More