What is C_ExternalTaxItemTP in SAP S/4HANA?

C_ExternalTaxItemTP is a consumption CDS view in SAP S/4HANA. External Tax Item for Statutory Rptg It contains 79 fields.

Which tables does C_ExternalTaxItemTP read from?

C_ExternalTaxItemTP reads data from: R_ExternalTaxItemTP.

What VDM layer is C_ExternalTaxItemTP?

C_ExternalTaxItemTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ExternalTaxItemTP

DDL: C_EXTERNALTAXITEMTP Type: view_entity CONSUMPTION Package: GLO_FIN_EXT_TAX_GEN

79 Fields 1 Data Sources 2 OData Services

External Tax Item for Statutory Rptg

C_ExternalTaxItemTP is a Consumption CDS View that provides data about "External Tax Item for Statutory Rptg" in SAP S/4HANA. It reads from 1 data source (R_ExternalTaxItemTP) and exposes 79 fields with key fields ExternalTaxHeaderUUID, ExternalTaxItemUUID, CompanyCode, AccountingDocument, FiscalYear. It is exposed through 2 OData services (ASQL_F8927, UI_EXTERNAL_TAX). Part of development package GLO_FIN_EXT_TAX_GEN.

Data Sources (1)

Source	Alias	Join Type
R_ExternalTaxItemTP	R_ExternalTaxItemTP	projection

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	External Tax Item for Statutory Rptg	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
OData.entityType.name	Item	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F8927	ASQL_F8927		C2	NOT_RELEASED
UI_EXTERNAL_TAX	UI_EXTERNAL_TAX	V4	C1	NOT_RELEASED

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	ExternalTaxHeaderUUID		ExternalTaxHeaderUUID
KEY	ExternalTaxItemUUID		ExternalTaxItemUUID
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	TaxationType		TaxationType
	TaxSection		TaxSection	Tax Section
	BusinessPlace		BusinessPlace	Business place
	BranchName	_BusinessPlaceText	BranchName
	DebitCreditCode		DebitCreditCode	Debit/Credit Indicator
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	SupplierName	Supplier Name
	Customer		Customer	Sold-to Party
	CustomerName	_Customer	CustomerName	Name of Customer
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerName	_BusinessPartner	BusinessPartnerName	Extracted Customer Name
	DocumentItemText		DocumentItemText	Item Text
	ClearingDate		ClearingDate	Clearing Date
	ClearingJournalEntry		ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear		ClearingJournalEntryFiscalYear	Clearing Document Fiscal Year
	ClearingItem		ClearingItem	Clearing Item
	Ledger		Ledger	Ledger
	LedgerName	_LedgerText	LedgerName	Ledger Name
	LedgerGroup		LedgerGroup	Ledger Group
	LedgerGroupName	_LedgerGroupText	LedgerGroupName
	GLAccount		GLAccount	General Ledger
	GLAccountName	_GLAccountTextInCompanyCode	GLAccountName	Short Text
	SpecialGLCode		SpecialGLCode	Special G/L Indicator
	SpecialGLTransactionType		SpecialGLTransactionType	Special G/L Transaction Type
	Reference3IDByBusinessPartner		Reference3IDByBusinessPartner	Reference Key 3
	InvoiceReference		InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear		InvoiceReferenceFiscalYear	Reference Invoice Fiscal Year
	InvoiceItemReference		InvoiceItemReference	Reference Invoice Line Item
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Amount in Company Code Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Amount in Transaction Currency
	CashDiscountAmtInCoCodeCrcy		CashDiscountAmtInCoCodeCrcy	Cash Discount in Company Code Currency
	CashDiscountAmount		CashDiscountAmount	Cash Discount in Transaction Currency
	TaxCode		TaxCode	Tax Code
	VATRegistration		VATRegistration	VAT Registration Number
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	TaxRate		TaxRate	Tax Rate
	TaxRateValidityStartDate		TaxRateValidityStartDate	Tax Rate Validity Start Date
	TaxCountry		TaxCountry	Tax Country/Region
	TaxCountryName	_TaxCountryText	CountryName	Country
	TaxReturnCountry		TaxReturnCountry	Reporting Country/Region
	CountryName	_TaxReturnCountryText	CountryName	Country
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdiction Code
	ConditionType		ConditionType	Condition type
	TaxItemAcctgDocItemRef		TaxItemAcctgDocItemRef	Tax Document Item Number
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	CountryCurrency		CountryCurrency	Currency
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	Tax Base Amount in Company Code Currency
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Tax Base Amount in Transaction Currency
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxAmount		TaxAmount	Tax Amount in Transaction Currency
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	Tax Amount in Additional Currency 1
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	Tax Amount in Additional Currency 2
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	Tax Base Amount in Additional Currency 1
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	Tax Base Amount in Additional Currency 2
	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Tax Base Amount in Reporting Currency
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Amount in Reporting Currency
	CreationDateTime		CreationDateTime	Timestamp
	CreatedByUser		CreatedByUser	User Name
	LoclInstanceLastChangeDateTime		LoclInstanceLastChangeDateTime	Changed On
	LastChangeDateTime		LastChangeDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	CreatedByUserName	_CreatedByContactCard	FullName	Name
	ChangedByUserName	_ChangedByContactCard	FullName	Name
	DebitCreditCodeName	_DebitCreditCodeText	DebitCreditCodeName
	BusinessSectionCodeName	_BusinessPlaceSectionCodeName	BusinessSectionCodeName
	FinancialAccountTypeName	_FinancialAccountTypeText	FinancialAccountTypeName
	SpecialGLCodeName	_SpecialGLCodeText	SpecialGLCodeName

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 C_ExternalTaxItemTP.
-- 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 C_ExternalTaxItemTP AS
SELECT
  ExternalTaxHeaderUUID,
  ExternalTaxItemUUID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  TaxationType,
  TaxSection,
  BusinessPlace,
  _BusinessPlaceText.BranchName AS BranchName,
  DebitCreditCode,
  FinancialAccountType,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  DocumentItemText,
  ClearingDate,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  ClearingItem,
  Ledger,
  _LedgerText.LedgerName AS LedgerName,
  LedgerGroup,
  _LedgerGroupText.LedgerGroupName AS LedgerGroupName,
  GLAccount,
  _GLAccountTextInCompanyCode.GLAccountName AS GLAccountName,
  SpecialGLCode,
  SpecialGLTransactionType,
  Reference3IDByBusinessPartner,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  CompanyCodeCurrency,
  TransactionCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  CashDiscountAmtInCoCodeCrcy,
  CashDiscountAmount,
  TaxCode,
  VATRegistration,
  TaxJurisdiction,
  TaxRate,
  TaxRateValidityStartDate,
  TaxCountry,
  _TaxCountryText.CountryName AS TaxCountryName,
  TaxReturnCountry,
  _TaxReturnCountryText.CountryName AS CountryName,
  LowestLevelTaxJurisdiction,
  ConditionType,
  TaxItemAcctgDocItemRef,
  TaxItemGroup,
  CountryCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmount,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TransactionTypeDetermination,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  CreationDateTime,
  CreatedByUser,
  LoclInstanceLastChangeDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  _CreatedByContactCard.FullName AS CreatedByUserName,
  _ChangedByContactCard.FullName AS ChangedByUserName,
  _DebitCreditCodeText.DebitCreditCodeName AS DebitCreditCodeName,
  _BusinessPlaceSectionCodeName.BusinessSectionCodeName AS BusinessSectionCodeName,
  _FinancialAccountTypeText.FinancialAccountTypeName AS FinancialAccountTypeName,
  _SpecialGLCodeText.SpecialGLCodeName AS SpecialGLCodeName
FROM R_ExternalTaxItemTP
;

Depth:

C_ExternalTaxItemTP view_entity

R_ExternalTaxItemTP view_entity