I_EXTERNALTAXITEMDRAFT

CDS View
62 Fields 1 CDS Views

Ext Tax Item - Draft

I_EXTERNALTAXITEMDRAFT is a CDS View in S/4HANA. Ext Tax Item - Draft. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StRpExternalTaxItemDraftC view_entity from COMPOSITE Ext Tx Itm for Statry Rptng - Cube

Fields (62)

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

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 - Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXTERNALTAXITEMDRAFT (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    DRAFTUUID,
    EXTERNALTAXHEADERUUID,
    EXTERNALTAXITEMUUID,
    FISCALYEAR,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSPARTNER,
    BUSINESSPLACE,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTAMTINCOCODECRCY,
    CLEARINGDATE,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CONDITIONTYPE,
    COUNTRYCURRENCY,
    CREATEDBYUSER,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    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 (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, DRAFTUUID, EXTERNALTAXHEADERUUID, EXTERNALTAXITEMUUID, FISCALYEAR)
);

Learn More