I_EXTERNALTAXITEM

CDS View
61 Fields 3 CDS Views

Ext Tax Item for Statutory Reporting

I_EXTERNALTAXITEM is a CDS View in S/4HANA. Ext Tax Item for Statutory Reporting. It contains 61 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ExternalVATItemCube view_entity from COMPOSITE Ext VAT Items for Statry Rprtng - Cube
I_StRpExternalTaxItemCube view_entity from COMPOSITE Ext Tax Item for Statry Reprtng - Cube
R_ExternalTaxItemTP view_entity from TRANSACTIONAL External Tax Items - TP

Fields (61)

KeyField CDS FieldsUsed in Views
KEY ExternalTaxHeaderUUID ExternalTaxHeaderUUID 2
KEY ExternalTaxItemUUID ExternalTaxItemUUID 2
AccountingDocument AccountingDocument 2
AccountingDocumentItem AccountingDocumentItem 2
AdditionalCurrency1 AdditionalCurrency1 2
AdditionalCurrency2 AdditionalCurrency2 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
BusinessPartner BusinessPartner 2
BusinessPlace BusinessPlace 2
CashDiscountAmount CashDiscountAmount 2
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy 2
ClearingDate ClearingDate 2
ClearingItem ClearingItem 2
ClearingJournalEntry ClearingJournalEntry 2
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 2
CompanyCode CompanyCode 2
CompanyCodeCurrency CompanyCodeCurrency 2
ConditionType ConditionType 2
CountryCurrency CountryCurrency 2
CreatedByUser CreatedByUser 1
Customer Customer 2
DebitCreditCode DebitCreditCode 2
DocumentItemText DocumentItemText 2
FinancialAccountType FinancialAccountType 2
FiscalYear FiscalYear 2
GLAccount GLAccount 2
InvoiceItemReference InvoiceItemReference 2
InvoiceReference InvoiceReference 2
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 2
LastChangedByUser LastChangedByUser 1
Ledger Ledger 2
LedgerGroup LedgerGroup 2
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction 2
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 2
SpecialGLCode SpecialGLCode 2
SpecialGLTransactionType SpecialGLTransactionType 2
Supplier Supplier 2
TaxAmount TaxAmount 2
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 2
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 2
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 2
TaxAmountInCountryCrcy TaxAmountInCountryCrcy 2
TaxationType TaxationType 2
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 2
TaxBaseAmountInCountryCrcy TaxBaseAmountInCountryCrcy 2
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 2
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 2
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 2
TaxCode TaxCode 2
TaxCountry TaxCountry 2
TaxItemAcctgDocItemRef TaxItemAcctgDocItemRef 2
TaxItemGroup TaxItemGroup 2
TaxJurisdiction TaxJurisdiction 2
TaxRate TaxRate 2
TaxRateValidityStartDate TaxRateValidityStartDate 2
TaxReturnCountry TaxReturnCountry 2
TaxSection TaxSection 2
TransactionCurrency TransactionCurrency 2
TransactionTypeDetermination TransactionTypeDetermination 2
VATRegistration VATRegistration 2

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 Item for Statutory Reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXTERNALTAXITEM (
    EXTERNALTAXHEADERUUID,
    EXTERNALTAXITEMUUID,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPLACE,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTAMTINCOCODECRCY,
    CLEARINGDATE,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    CREATEDBYUSER,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FISCALYEAR,
    GLACCOUNT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    LASTCHANGEDBYUSER,
    LEDGER,
    LEDGERGROUP,
    LOWESTLEVELTAXJURISDICTION,
    REFERENCE3IDBYBUSINESSPARTNER,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    SUPPLIER,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINCOUNTRYCRCY,
    TAXATIONTYPE,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOUNTRYCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXCODE,
    TAXCOUNTRY,
    TAXITEMACCTGDOCITEMREF,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXRETURNCOUNTRY,
    TAXSECTION,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VATREGISTRATION,
    PRIMARY KEY (EXTERNALTAXHEADERUUID, EXTERNALTAXITEMUUID)
);

Learn More