EXT_TAX_ITEM_D

Transparent Table Application Table
67 Fields 2 CDS Views

Draft table for entity R_EXTERNALTAXITEMTP

EXT_TAX_ITEM_D is an SAP database table in S/4HANA. Draft table for entity R_EXTERNALTAXITEMTP. It contains 67 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExternalTaxItemDraft view_entity from BASIC Ext Tax Item - Draft
R_ExternalTaxItemDraft view_entity from BASIC Ext Tax Item for Statry Rptng - Draft

Fields (67)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY externaltaxheaderuuid ettx_header_uuid
KEY externaltaxitemuuid ettx_item_uuid
KEY companycode bukrs Company Code
KEY accountingdocument belnr_d Document Number
KEY fiscalyear fis_gjahr_no_conv Fiscal Year
KEY accountingdocumentitem buzei Item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
taxationtype ettx_taxation_type
taxsection secco Section Code
businessplace bupla Business place
debitcreditcode shkzg Debit/Credit
financialaccounttype koart Account type
supplier lifnr Supplier
customer kunnr Customer
businesspartner bu_partner Busn. Partner
documentitemtext sgtxt Text
clearingdate augdt Clearing
clearingjournalentry augbl Clrng doc.
clearingjournalentryfiscalyear auggj Clrg Fiscal Yr
clearingitem agzei Clearing Item
ledger fins_ledger Ledger
ledgergroup fagl_ldgrp Ledger Group
glaccount hkont G/L Acct
specialglcode umskz Special G/L Ind
specialgltransactiontype umsks Transact.Type
reference3idbybusinesspartner xref3 Reference Key 3
invoicereference rebzg Invoice Ref.
invoicereferencefiscalyear rebzj Fiscal Year
invoiceitemreference rebzz Item
companycodecurrency fins_currh CompanyCode Currency
transactioncurrency fins_currw Transaction Currency
additionalcurrency1 hwae2 Local curr. 2
additionalcurrency2 hwae3 Local curr. 3
amountincompanycodecurrency dmbtr Amount in LC
amountintransactioncurrency wrbtr Amount
cashdiscountamtincocodecrcy sknto Discount Amt
cashdiscountamount wskto CD Amount
taxcode mwskz Tax Code
vatregistration stceg VAT Reg. No.
taxjurisdiction txjcd Tax Jur.
taxrate fitaxrate Tax Rate
taxratevaliditystartdate fot_txdat_from Tax Rate Valid-From
taxcountry fot_tax_country Tax Ctry/Reg.
taxreturncountry land1_stml Reporting C/R
lowestleveltaxjurisdiction txjcd_deep Jurisdict. Code
conditiontype kschl Condition Type
taxitemacctgdocitemref taxps Tax doc. item number
taxitemgroup txgrp Group Indicator
countrycurrency waers Currency
taxbaseamountincocodecrcy hwbas_bses LC Base
taxbaseamountintranscrcy fwbas_bses Base Amount
taxamountincocodecrcy hwste LC Tax
taxamount fwste Amount
taxamountinadditionalcurrency1 h2ste LC 2 Tax
taxamountinadditionalcurrency2 h3ste LC 3 Tax
taxbaseamtinadditionalcrcy1 h2bas_bses LC 2 Base
taxbaseamtinadditionalcrcy2 h3bas_bses LC 3 Base
transactiontypedetermination ktosl Transaction
taxbaseamountincountrycrcy lwbas_bset Base Amount
taxamountincountrycrcy lwste_bset Tax Rept. Crcy
creationdatetime abp_creation_tstmpl Created On
createdbyuser abp_creation_user Created By
loclinstancelastchangedatetime abp_locinst_lastchange_tstmpl Changed On
lastchangedatetime abp_lastchange_tstmpl Changed On
lastchangedbyuser abp_lastchange_user Changed By

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.

-- Draft table for entity R_EXTERNALTAXITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EXT_TAX_ITEM_D (
    MANDT,                           -- Client [mandt]
    EXTERNALTAXHEADERUUID,           -- ettx_header_uuid
    EXTERNALTAXITEMUUID,             -- ettx_item_uuid
    COMPANYCODE,                     -- Company Code [bukrs]
    ACCOUNTINGDOCUMENT,              -- Document Number [belnr_d]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    ACCOUNTINGDOCUMENTITEM,          -- Item [buzei]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    TAXATIONTYPE,                    -- ettx_taxation_type
    TAXSECTION,                      -- Section Code [secco]
    BUSINESSPLACE,                   -- Business place [bupla]
    DEBITCREDITCODE,                 -- Debit/Credit [shkzg]
    FINANCIALACCOUNTTYPE,            -- Account type [koart]
    SUPPLIER,                        -- Supplier [lifnr]
    CUSTOMER,                        -- Customer [kunnr]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    CLEARINGDATE,                    -- Clearing [augdt]
    CLEARINGJOURNALENTRY,            -- Clrng doc. [augbl]
    CLEARINGJOURNALENTRYFISCALYEAR,  -- Clrg Fiscal Yr [auggj]
    CLEARINGITEM,                    -- Clearing Item [agzei]
    LEDGER,                          -- Ledger [fins_ledger]
    LEDGERGROUP,                     -- Ledger Group [fagl_ldgrp]
    GLACCOUNT,                       -- G/L Acct [hkont]
    SPECIALGLCODE,                   -- Special G/L Ind [umskz]
    SPECIALGLTRANSACTIONTYPE,        -- Transact.Type [umsks]
    REFERENCE3IDBYBUSINESSPARTNER,   -- Reference Key 3 [xref3]
    INVOICEREFERENCE,                -- Invoice Ref. [rebzg]
    INVOICEREFERENCEFISCALYEAR,      -- Fiscal Year [rebzj]
    INVOICEITEMREFERENCE,            -- Item [rebzz]
    COMPANYCODECURRENCY,             -- CompanyCode Currency [fins_currh]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fins_currw]
    ADDITIONALCURRENCY1,             -- Local curr. 2 [hwae2]
    ADDITIONALCURRENCY2,             -- Local curr. 3 [hwae3]
    AMOUNTINCOMPANYCODECURRENCY,     -- Amount in LC [dmbtr]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount [wrbtr]
    CASHDISCOUNTAMTINCOCODECRCY,     -- Discount Amt [sknto]
    CASHDISCOUNTAMOUNT,              -- CD Amount [wskto]
    TAXCODE,                         -- Tax Code [mwskz]
    VATREGISTRATION,                 -- VAT Reg. No. [stceg]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    TAXRATE,                         -- Tax Rate [fitaxrate]
    TAXRATEVALIDITYSTARTDATE,        -- Tax Rate Valid-From [fot_txdat_from]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TAXRETURNCOUNTRY,                -- Reporting C/R [land1_stml]
    LOWESTLEVELTAXJURISDICTION,      -- Jurisdict. Code [txjcd_deep]
    CONDITIONTYPE,                   -- Condition Type [kschl]
    TAXITEMACCTGDOCITEMREF,          -- Tax doc. item number [taxps]
    TAXITEMGROUP,                    -- Group Indicator [txgrp]
    COUNTRYCURRENCY,                 -- Currency [waers]
    TAXBASEAMOUNTINCOCODECRCY,       -- LC Base [hwbas_bses]
    TAXBASEAMOUNTINTRANSCRCY,        -- Base Amount [fwbas_bses]
    TAXAMOUNTINCOCODECRCY,           -- LC Tax [hwste]
    TAXAMOUNT,                       -- Amount [fwste]
    TAXAMOUNTINADDITIONALCURRENCY1,  -- LC 2 Tax [h2ste]
    TAXAMOUNTINADDITIONALCURRENCY2,  -- LC 3 Tax [h3ste]
    TAXBASEAMTINADDITIONALCRCY1,     -- LC 2 Base [h2bas_bses]
    TAXBASEAMTINADDITIONALCRCY2,     -- LC 3 Base [h3bas_bses]
    TRANSACTIONTYPEDETERMINATION,    -- Transaction [ktosl]
    TAXBASEAMOUNTINCOUNTRYCRCY,      -- Base Amount [lwbas_bset]
    TAXAMOUNTINCOUNTRYCRCY,          -- Tax Rept. Crcy [lwste_bset]
    CREATIONDATETIME,                -- Created On [abp_creation_tstmpl]
    CREATEDBYUSER,                   -- Created By [abp_creation_user]
    LOCLINSTANCELASTCHANGEDATETIME,  -- Changed On [abp_locinst_lastchange_tstmpl]
    LASTCHANGEDATETIME,              -- Changed On [abp_lastchange_tstmpl]
    LASTCHANGEDBYUSER,               -- Changed By [abp_lastchange_user]
    PRIMARY KEY (MANDT, EXTERNALTAXHEADERUUID, EXTERNALTAXITEMUUID, COMPANYCODE, ACCOUNTINGDOCUMENT, FISCALYEAR, ACCOUNTINGDOCUMENTITEM, DRAFTUUID)
);

Learn More