ETXDCI

Transparent Table Application Table
121 Fields 3 CDS Views

External tax document: line item info

ETXDCI is an SAP database table in S/4HANA. External tax document: line item info. It contains 121 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FISVD_EXTERNALTAX_ITEM_BASE view left_outer External Tax Document Line Item Info
I_US_TaxPartnerTaxDocumentItem view from BASIC US TaxPartnerTaxDocumentItem
US_TaxPartnerTaxDocumentItem view_entity from US TaxPartnerTaxDocumentItem

Fields (121)

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
taxps TAX_POSNR Tax doc. item number
mwskz MWSKZ Tax Code
shpto TXJCD Tax Jur.
pos_no TAX_POSNR Tax doc. item number
group_id TAX_GROUP_ID Grouping code
country LANDTX Tax Depar. C/R
division DIVISION Business area
matnr TAX_MATNR Material Number
prod_code PROCD_TTXP Product Code
group_prod_code GRP_PROCD group product code
quantity ETD_QUANTITY Material quantity
unit TAX_UNIT UNIT
upmat UPMAT Pr.Ref.Material
matkl MATKL Material Group
apar_ind APAR_IND Ind. A/P or A/R
tax_type TAXTYPEXT Ext. Tax Type
exemp_ind EXTEXMTFLG Tax Exempt Flag
tax_date ETDTXDAT Tax date
txjcd_st TXJCD_ST Jurisd. Code Ship-to
txjcd_sf TXJCD_SF Jurisd. Code Ship-fr
txjcd_poa TXJCD_POA Jurisdict. code POA
txjcd_poo TXJCD_POO Jurisdict. code POO
amount ETDTAXBASE Tax base amount
gross_amount ETDGROSS_AMOUNT Tax base gross.
freight_am ETDFRTAMOUNT Freight amount
exempt_amt ETDEXMTAMOUNT Exempt amount
billed_amount FOT_BILLED_AMOUNT_D Billed Amount
accnt_no TAX_ACCNT_NO Account number
accnt_cls TAX_ACCNT_CLS CustomerClass
cost_object TAX_COST_OBJECT Cost object
ptp_ind PTP_IND PTP
excertif EXCERTIF Int. Exempt Certif.
exreason EXDETCODE Tax. Exempt reason
user_data USER_DATA Comment
soldto KUNAG Sold-to Party
shipto KUNWE Ship-to Party
gl_account SAKAN G/L Account
kostl KOSTL Cost Center
doc_date BLDAT Document Date
post_date BUDAT Posting Date
sr_date FIS_ETXDC_SRDAT Service Render Date
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
vbeln VBELN SD Document
vbtyp VBTYPL Document Cat.
cont_val FIS_ETXDC_CONVAL Total Contract Value
wbs_element PS_PSP_PNR WBS Element
btt_code FOT_TDT_TXDAT_DET_BTT_CODE_E TxDt Determn BTT Cd
billto KUNRE Bill-to Party
supplier LIFNR Supplier
extension_field001 TEXT100 Text
extension_field002 TEXT100 Text
extension_field003 TEXT100 Text
extension_field004 TEXT100 Text
extension_field005 TEXT100 Text
extension_field006 TEXT100 Text
extension_field007 TEXT100 Text
extension_field008 TEXT100 Text
extension_field009 TEXT100 Text
extension_field010 TEXT100 Text
extension_field011 TEXT100 Text
extension_field012 TEXT100 Text
extension_field013 TEXT100 Text
extension_field014 TEXT100 Text
extension_field015 TEXT100 Text
extension_field016 TEXT100 Text
extension_field017 TEXT100 Text
extension_field018 TEXT100 Text
extension_field019 TEXT100 Text
extension_field020 TEXT100 Text
extension_field021 TEXT100 Text
extension_field022 TEXT100 Text
extension_field023 TEXT100 Text
extension_field024 TEXT100 Text
extension_field025 TEXT100 Text
extension_field026 TEXT100 Text
extension_field027 TEXT100 Text
extension_field028 TEXT100 Text
extension_field029 TEXT100 Text
extension_field030 TEXT100 Text
extension_field031 TEXT100 Text
extension_field032 TEXT100 Text
extension_field033 TEXT100 Text
extension_field034 TEXT100 Text
extension_field035 TEXT100 Text
extension_field036 TEXT100 Text
extension_field037 TEXT100 Text
extension_field038 TEXT100 Text
extension_field039 TEXT100 Text
extension_field040 TEXT100 Text
extension_field041 TEXT100 Text
extension_field042 TEXT100 Text
extension_field043 TEXT100 Text
extension_field044 TEXT100 Text
extension_field045 TEXT100 Text
extension_field046 TEXT100 Text
extension_field047 TEXT100 Text
extension_field048 TEXT100 Text
extension_field049 TEXT100 Text
extension_field050 TEXT100 Text
store_code STORE_CODE Store Code
user_rept_data USER_REPT_DATA User reporting data
default_reason TAX_DEFAULT_REASON Tax Default Reason
txjcd_ind TXJCDIND TxJCd Indicator
taxpcov ETDTAXPERCNTG Total tax rate
tax_date_return TAX_DATE Date for tax calc.
taxamov ETDTAXAMOUNTG Total tax amount
exmatflag EXMATCODE Mat. Exmt. Code
excusflg EXCUSCODE Cus. Exmt. Code
ext_excertif EXT_EXCERTIF exempt certificate
ext_exreason EXT_DETCODE Ext. Exempt reason
gl_taxpcov GL_TAXPERCNT G/L Tax rate
gl_taxamov GL_TAXAMOUNT G/L Tax amount
tax_state FIS_ETXDC_REGION Tax State
gl_taxbas GL_TAXBASE G/L Tax base amount
rep_date EXTREPDATE posting date
credit_ind EXTCREDFLG Tax Credit Flag
_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: line item info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ETXDCI (
    MANDT,               -- Client [MANDT]
    DOCNR,               -- tax document number [XTAX_DOCUMENT_NUMBER]
    ITEMNR,              -- tax item number [XTAX_DOC_ITEM_NUMBER]
    TAXPS,               -- Tax doc. item number [TAX_POSNR]
    MWSKZ,               -- Tax Code [MWSKZ]
    SHPTO,               -- Tax Jur. [TXJCD]
    POS_NO,              -- Tax doc. item number [TAX_POSNR]
    GROUP_ID,            -- Grouping code [TAX_GROUP_ID]
    COUNTRY,             -- Tax Depar. C/R [LANDTX]
    DIVISION,            -- Business area [DIVISION]
    MATNR,               -- Material Number [TAX_MATNR]
    PROD_CODE,           -- Product Code [PROCD_TTXP]
    GROUP_PROD_CODE,     -- group product code [GRP_PROCD]
    QUANTITY,            -- Material quantity [ETD_QUANTITY]
    UNIT,                -- UNIT [TAX_UNIT]
    UPMAT,               -- Pr.Ref.Material [UPMAT]
    MATKL,               -- Material Group [MATKL]
    APAR_IND,            -- Ind. A/P or A/R [APAR_IND]
    TAX_TYPE,            -- Ext. Tax Type [TAXTYPEXT]
    EXEMP_IND,           -- Tax Exempt Flag [EXTEXMTFLG]
    TAX_DATE,            -- Tax date [ETDTXDAT]
    TXJCD_ST,            -- Jurisd. Code Ship-to [TXJCD_ST]
    TXJCD_SF,            -- Jurisd. Code Ship-fr [TXJCD_SF]
    TXJCD_POA,           -- Jurisdict. code POA [TXJCD_POA]
    TXJCD_POO,           -- Jurisdict. code POO [TXJCD_POO]
    AMOUNT,              -- Tax base amount [ETDTAXBASE]
    GROSS_AMOUNT,        -- Tax base gross. [ETDGROSS_AMOUNT]
    FREIGHT_AM,          -- Freight amount [ETDFRTAMOUNT]
    EXEMPT_AMT,          -- Exempt amount [ETDEXMTAMOUNT]
    BILLED_AMOUNT,       -- Billed Amount [FOT_BILLED_AMOUNT_D]
    ACCNT_NO,            -- Account number [TAX_ACCNT_NO]
    ACCNT_CLS,           -- CustomerClass [TAX_ACCNT_CLS]
    COST_OBJECT,         -- Cost object [TAX_COST_OBJECT]
    PTP_IND,             -- PTP [PTP_IND]
    EXCERTIF,            -- Int. Exempt Certif. [EXCERTIF]
    EXREASON,            -- Tax. Exempt reason [EXDETCODE]
    USER_DATA,           -- Comment [USER_DATA]
    SOLDTO,              -- Sold-to Party [KUNAG]
    SHIPTO,              -- Ship-to Party [KUNWE]
    GL_ACCOUNT,          -- G/L Account [SAKAN]
    KOSTL,               -- Cost Center [KOSTL]
    DOC_DATE,            -- Document Date [BLDAT]
    POST_DATE,           -- Posting Date [BUDAT]
    SR_DATE,             -- Service Render Date [FIS_ETXDC_SRDAT]
    EBELN,               -- Purchasing Doc. [EBELN]
    EBELP,               -- Item [EBELP]
    VBELN,               -- SD Document [VBELN]
    VBTYP,               -- Document Cat. [VBTYPL]
    CONT_VAL,            -- Total Contract Value [FIS_ETXDC_CONVAL]
    WBS_ELEMENT,         -- WBS Element [PS_PSP_PNR]
    BTT_CODE,            -- TxDt Determn BTT Cd [FOT_TDT_TXDAT_DET_BTT_CODE_E]
    BILLTO,              -- Bill-to Party [KUNRE]
    SUPPLIER,            -- Supplier [LIFNR]
    EXTENSION_FIELD001,  -- Text [TEXT100]
    EXTENSION_FIELD002,  -- Text [TEXT100]
    EXTENSION_FIELD003,  -- Text [TEXT100]
    EXTENSION_FIELD004,  -- Text [TEXT100]
    EXTENSION_FIELD005,  -- Text [TEXT100]
    EXTENSION_FIELD006,  -- Text [TEXT100]
    EXTENSION_FIELD007,  -- Text [TEXT100]
    EXTENSION_FIELD008,  -- Text [TEXT100]
    EXTENSION_FIELD009,  -- Text [TEXT100]
    EXTENSION_FIELD010,  -- Text [TEXT100]
    EXTENSION_FIELD011,  -- Text [TEXT100]
    EXTENSION_FIELD012,  -- Text [TEXT100]
    EXTENSION_FIELD013,  -- Text [TEXT100]
    EXTENSION_FIELD014,  -- Text [TEXT100]
    EXTENSION_FIELD015,  -- Text [TEXT100]
    EXTENSION_FIELD016,  -- Text [TEXT100]
    EXTENSION_FIELD017,  -- Text [TEXT100]
    EXTENSION_FIELD018,  -- Text [TEXT100]
    EXTENSION_FIELD019,  -- Text [TEXT100]
    EXTENSION_FIELD020,  -- Text [TEXT100]
    EXTENSION_FIELD021,  -- Text [TEXT100]
    EXTENSION_FIELD022,  -- Text [TEXT100]
    EXTENSION_FIELD023,  -- Text [TEXT100]
    EXTENSION_FIELD024,  -- Text [TEXT100]
    EXTENSION_FIELD025,  -- Text [TEXT100]
    EXTENSION_FIELD026,  -- Text [TEXT100]
    EXTENSION_FIELD027,  -- Text [TEXT100]
    EXTENSION_FIELD028,  -- Text [TEXT100]
    EXTENSION_FIELD029,  -- Text [TEXT100]
    EXTENSION_FIELD030,  -- Text [TEXT100]
    EXTENSION_FIELD031,  -- Text [TEXT100]
    EXTENSION_FIELD032,  -- Text [TEXT100]
    EXTENSION_FIELD033,  -- Text [TEXT100]
    EXTENSION_FIELD034,  -- Text [TEXT100]
    EXTENSION_FIELD035,  -- Text [TEXT100]
    EXTENSION_FIELD036,  -- Text [TEXT100]
    EXTENSION_FIELD037,  -- Text [TEXT100]
    EXTENSION_FIELD038,  -- Text [TEXT100]
    EXTENSION_FIELD039,  -- Text [TEXT100]
    EXTENSION_FIELD040,  -- Text [TEXT100]
    EXTENSION_FIELD041,  -- Text [TEXT100]
    EXTENSION_FIELD042,  -- Text [TEXT100]
    EXTENSION_FIELD043,  -- Text [TEXT100]
    EXTENSION_FIELD044,  -- Text [TEXT100]
    EXTENSION_FIELD045,  -- Text [TEXT100]
    EXTENSION_FIELD046,  -- Text [TEXT100]
    EXTENSION_FIELD047,  -- Text [TEXT100]
    EXTENSION_FIELD048,  -- Text [TEXT100]
    EXTENSION_FIELD049,  -- Text [TEXT100]
    EXTENSION_FIELD050,  -- Text [TEXT100]
    STORE_CODE,          -- Store Code [STORE_CODE]
    USER_REPT_DATA,      -- User reporting data [USER_REPT_DATA]
    DEFAULT_REASON,      -- Tax Default Reason [TAX_DEFAULT_REASON]
    TXJCD_IND,           -- TxJCd Indicator [TXJCDIND]
    TAXPCOV,             -- Total tax rate [ETDTAXPERCNTG]
    TAX_DATE_RETURN,     -- Date for tax calc. [TAX_DATE]
    TAXAMOV,             -- Total tax amount [ETDTAXAMOUNTG]
    EXMATFLAG,           -- Mat. Exmt. Code [EXMATCODE]
    EXCUSFLG,            -- Cus. Exmt. Code [EXCUSCODE]
    EXT_EXCERTIF,        -- exempt certificate [EXT_EXCERTIF]
    EXT_EXREASON,        -- Ext. Exempt reason [EXT_DETCODE]
    GL_TAXPCOV,          -- G/L Tax rate [GL_TAXPERCNT]
    GL_TAXAMOV,          -- G/L Tax amount [GL_TAXAMOUNT]
    TAX_STATE,           -- Tax State [FIS_ETXDC_REGION]
    GL_TAXBAS,           -- G/L Tax base amount [GL_TAXBASE]
    REP_DATE,            -- posting date [EXTREPDATE]
    CREDIT_IND,          -- Tax Credit Flag [EXTCREDFLG]
    _DATAAGING,          -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DOCNR, ITEMNR)
);

Learn More