I_ExternalTaxItemDraft

DDL: I_EXTERNALTAXITEMDRAFT Type: view_entity BASIC Package: GLO_FIN_EXT_TAX_GEN
66 Fields 1 Data Sources

Ext Tax Item - Draft

I_ExternalTaxItemDraft is a Basic CDS View that provides data about "Ext Tax Item - Draft" in SAP S/4HANA. It reads from 1 data source (ext_tax_item_d) and exposes 66 fields with key fields ExternalTaxHeaderUUID, ExternalTaxItemUUID, CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_EXT_TAX_GEN.

Data Sources (1)

SourceAliasJoin Type
ext_tax_item_d ext_tax_item_d from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
EndUserText.label Ext Tax Item - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY ExternalTaxHeaderUUID externaltaxheaderuuid
KEY ExternalTaxItemUUID externaltaxitemuuid
KEY CompanyCode companycode Receiver Company Code
KEY AccountingDocument accountingdocument Journal Entry
KEY FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem accountingdocumentitem Posting View Item
KEY DraftUUID draftuuid UUID
ParentDraftUUID parentdraftuuid NodeID
TaxationType taxationtype
TaxSection taxsection Tax Section
BusinessPlace businessplace Business place
DebitCreditCode debitcreditcode Single-Character Flag
FinancialAccountType financialaccounttype Fin. Account Type
Supplier supplier Supplier
Customer customer Sold-to Party
BusinessPartner businesspartner Issuing Authority
DocumentItemText documentitemtext Text
ClearingDate clearingdate Clearing Date
ClearingJournalEntry clearingjournalentry Clrng doc.
ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingItem clearingitem Clearing Item
Ledger ledger Ledger
LedgerGroup ledgergroup Ledger Group
GLAccount glaccount General Ledger
SpecialGLCode specialglcode Special G/L Ind
SpecialGLTransactionType specialgltransactiontype Transact.Type
Reference3IDByBusinessPartner reference3idbybusinesspartner Reference Key 3
InvoiceReference invoicereference Invoice Reference
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference invoiceitemreference Item
CompanyCodeCurrency companycodecurrency Local Currency
TransactionCurrency transactioncurrency Transaction Currency
AdditionalCurrency1 additionalcurrency1 Local curr. 2
AdditionalCurrency2 additionalcurrency2 Local curr. 3
AmountInCompanyCodeCurrency amountincompanycodecurrency Local Crcy Amt
AmountInTransactionCurrency amountintransactioncurrency Pt Crcy Amt
CashDiscountAmtInCoCodeCrcy cashdiscountamtincocodecrcy Discount Amt
CashDiscountAmount cashdiscountamount CD Amount
TaxCode taxcode Tax Code
VATRegistration vatregistration VAT Registration No.
TaxJurisdiction taxjurisdiction Tax Jurisdiction
TaxRate taxrate Tax Rate
TaxRateValidityStartDate taxratevaliditystartdate Tax Rate Validity Start Date
TaxCountry taxcountry Tax Ctry/Reg.
TaxReturnCountry taxreturncountry Reporting C/R
LowestLevelTaxJurisdiction lowestleveltaxjurisdiction Jurisdict. Code
ConditionType conditiontype Condition type
TaxItemAcctgDocItemRef taxitemacctgdocitemref Tax doc. item number
TaxItemGroup taxitemgroup Tax doc. item number
CountryCurrency countrycurrency Currency
TaxBaseAmountInCoCodeCrcy taxbaseamountincocodecrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInTransCrcy taxbaseamountintranscrcy Value-Added Tax
TaxAmountInCoCodeCrcy taxamountincocodecrcy Tax Amount in Company Code Currency
TaxAmount taxamount Tax Amt in Rptg Crcy
TaxAmountInAdditionalCurrency1 taxamountinadditionalcurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 taxamountinadditionalcurrency2 LC 3 Tax
TaxBaseAmtInAdditionalCrcy1 taxbaseamtinadditionalcrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 taxbaseamtinadditionalcrcy2 LC 3 Base
TransactionTypeDetermination transactiontypedetermination Transaction Key
TaxBaseAmountInCountryCrcy taxbaseamountincountrycrcy Base Amount
TaxAmountInCountryCrcy taxamountincountrycrcy Tax Rept. Crcy
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LoclInstanceLastChangeDateTime loclinstancelastchangedatetime Changed On
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ExternalTaxItemDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ExternalTaxItemDraft AS
SELECT
  ExternalTaxHeaderUUID,
  ExternalTaxItemUUID,
  CompanyCode,
  AccountingDocument,
  cast( fiscalyear as fis_gjahr_no_conv ) AS FiscalYear,
  AccountingDocumentItem,
  DraftUUID,
  ParentDraftUUID,
  TaxationType,
  TaxSection,
  BusinessPlace,
  DebitCreditCode,
  FinancialAccountType,
  Supplier,
  Customer,
  BusinessPartner,
  DocumentItemText,
  ClearingDate,
  ClearingJournalEntry,
  cast( clearingjournalentryfiscalyear as fis_auggj_no_conv ) AS ClearingJournalEntryFiscalYear,
  ClearingItem,
  Ledger,
  LedgerGroup,
  GLAccount,
  SpecialGLCode,
  SpecialGLTransactionType,
  Reference3IDByBusinessPartner,
  InvoiceReference,
  cast( invoicereferencefiscalyear as fis_rebzj_no_conv ) AS InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  CompanyCodeCurrency,
  TransactionCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  CashDiscountAmtInCoCodeCrcy,
  CashDiscountAmount,
  TaxCode,
  VATRegistration,
  TaxJurisdiction,
  TaxRate,
  TaxRateValidityStartDate,
  TaxCountry,
  TaxReturnCountry,
  LowestLevelTaxJurisdiction,
  ConditionType,
  TaxItemAcctgDocItemRef,
  TaxItemGroup,
  CountryCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TransactionTypeDetermination,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  CreationDateTime,
  CreatedByUser,
  LoclInstanceLastChangeDateTime,
  LastChangeDateTime,
  LastChangedByUser
FROM ext_tax_item_d
;

Learn More