What is I_IndirectTaxItem in SAP S/4HANA?

I_IndirectTaxItem is a basic CDS view in SAP S/4HANA. Indirect Tax Item It contains 60 fields.

Which tables does I_IndirectTaxItem read from?

I_IndirectTaxItem reads data from: I_TransactionalTaxItem.

What VDM layer is I_IndirectTaxItem?

I_IndirectTaxItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_IndirectTaxItem

DDL: I_INDIRECTTAXITEM Type: view_entity BASIC

60 Fields 1 Data Sources 3 Associations

Indirect Tax Item

I_IndirectTaxItem is a Basic CDS View that provides data about "Indirect Tax Item" in SAP S/4HANA. It reads from 1 data source (I_TransactionalTaxItem) and exposes 60 fields with key field TaxItemUUID. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_TransactionalTaxItem	IndirectTaxItem	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_TaxCode	_TaxCode	`$projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure and $projection.TaxCode = _TaxCode.TaxCode`
[0..1]	I_TaxCalculationProcedure	_TaxCalculationProcedure	`$projection.TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure`
[0..1]	I_TaxationType	_TaxationType	`$projection.TaxationType = _TaxationType.TaxationType`

Annotations (8)

Name	Value	Level
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#BASIC	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Indirect Tax Item	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	TaxItemUUID		TaxItemUUID	Tax Item UUID
	CompanyCode	I_TransactionalTaxItem	CompanyCode	Receiver Company Code
	AccountingDocument	I_TransactionalTaxItem	AccountingDocument	Journal Entry
	FiscalYear	I_TransactionalTaxItem	FiscalYear	G/L Fiscal Year
	TaxCode	I_TransactionalTaxItem	TaxCode	Tax Code
	TaxCalculationProcedure
	TaxDueCategory	I_TransactionalTaxItem	TaxDueCategory	Due Category
	TaxCountry	I_TransactionalTaxItem	TaxCountry	Tax Ctry/Reg.
	TaxationType	I_TransactionalTaxItem	TaxationType	Taxation Type
	SourceReferenceDocumentType	I_TransactionalTaxItem	SourceReferenceDocumentType	Ref. procedure
	SourceLogicalSystem	I_TransactionalTaxItem	SourceLogicalSystem
	SourceReferenceDocumentCntxt	I_TransactionalTaxItem	SourceReferenceDocumentCntxt
	SourceReferenceDocument	I_TransactionalTaxItem	SourceReferenceDocument	Reference Doc.
	RvsdReferenceDocumentType	I_TransactionalTaxItem	RvsdReferenceDocumentType
	ReversalReferenceDocument	I_TransactionalTaxItem	ReversalReferenceDocument	Reversal Reference Document
	ReversalReferenceDocumentCntxt	I_TransactionalTaxItem	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	TransactionTypeDetermination	I_TransactionalTaxItem	TransactionTypeDetermination	Transaction Key
	GLAccount	I_TransactionalTaxItem	GLAccount	General Ledger
	ConditionType	I_TransactionalTaxItem	ConditionType	Condition type
	TaxRateInPercent	I_TransactionalTaxItem	TaxRateInPercent	WithholdingRate
	TaxRegisterPercentageUnit	I_TransactionalTaxItem	TaxRegisterPercentageUnit
	PostingDate	I_TransactionalTaxItem	PostingDate	Posting Date for GR
	DocumentDate	I_TransactionalTaxItem	DocumentDate	Journal Entry Date
	TaxFulfillmentDate	I_TransactionalTaxItem	TaxFulfillmentDate	Tax Settlement Date
	TaxReportingDate	I_TransactionalTaxItem	TaxReportingDate	Tax Reporting Date
	TaxRateValidityStartDate	I_TransactionalTaxItem	TaxRateValidityStartDate	Tax Rate Validity Start Date
	TaxItemGroup	I_TransactionalTaxItem	TaxItemGroup	Tax doc. item number
	TaxLineItemStatus	I_TransactionalTaxItem	TaxLineItemStatus	Line Item Status
	IsReversal	I_TransactionalTaxItem	IsReversal	Reversal doc.
	IsReversed	I_TransactionalTaxItem	IsReversed	Reversed?
	TaxPayableDocument	I_TransactionalTaxItem	TaxPayableDocument	Tax Payable Document Number
	TaxPayableDocumentYear	I_TransactionalTaxItem	TaxPayableDocumentYear	Tax Payable Document Year
	TaxBaseAmountInCoCodeCrcy	I_TransactionalTaxItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	I_TransactionalTaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	CompanyCodeCurrency	I_TransactionalTaxItem	CompanyCodeCurrency	Local Currency
	TaxBaseAmountInTransCrcy	I_TransactionalTaxItem	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmountInTransCrcy	I_TransactionalTaxItem	TaxAmountInTransCrcy	TaxAmt in Tran. Crcy
	TransactionCurrency	I_TransactionalTaxItem	TransactionCurrency	Transaction Currency
	TaxBaseAmountInRptgCrcy	I_TransactionalTaxItem	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	I_TransactionalTaxItem	TaxAmountInRptgCrcy	Tax Rept. Crcy
	ReportingCurrency	I_TransactionalTaxItem	ReportingCurrency	Currency
	TaxLineItemPayableStatus	I_TransactionalTaxItem	TaxLineItemPayableStatus	Status
	TaxDeductibility	I_TransactionalTaxItem	TaxDeductibility	Deductibility
	DebitCreditCode	I_TransactionalTaxItem	DebitCreditCode	Single-Character Flag
	TaxItemIsReportingRelevant	I_TransactionalTaxItem	TaxItemIsReportingRelevant	Is Reportable
	TaxRegisterMigrationUUID	I_TransactionalTaxItem	TaxRegisterMigrationUUID	UUID
	CreationDateTime		CreationDateTime	Timestamp
	CreatedByUser		CreatedByUser	User Name
	LastChangeDateTime		LastChangeDateTime	Timestamp
	LastChangedByUser		LastChangedByUser	User Name
	_CompanyCode	I_TransactionalTaxItem	_CompanyCode
	_CompanyCodeCurrency	I_TransactionalTaxItem	_CompanyCodeCurrency
	_DocumentCurrency	I_TransactionalTaxItem	_DocumentCurrency
	_GLAccount	I_TransactionalTaxItem	_GLAccount
	_ReportingCurrency	I_TransactionalTaxItem	_ReportingCurrency
	_TaxCountry	I_TransactionalTaxItem	_TaxCountry
	_TaxRegMigration	I_TransactionalTaxItem	_TaxRegMigration
	_TaxCode		_TaxCode
	_TaxCalculationProcedure		_TaxCalculationProcedure
	_TaxationType		_TaxationType

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_IndirectTaxItem.
-- 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_IndirectTaxItem AS
SELECT
  TaxItemUUID,
  IndirectTaxItem.CompanyCode AS CompanyCode,
  IndirectTaxItem.AccountingDocument AS AccountingDocument,
  IndirectTaxItem.FiscalYear AS FiscalYear,
  IndirectTaxItem.TaxCode AS TaxCode,
  IndirectTaxItem._TaxCountry.TaxCalculationProcedure AS TaxCalculationProcedure,
  IndirectTaxItem.TaxDueCategory AS TaxDueCategory,
  IndirectTaxItem.TaxCountry AS TaxCountry,
  IndirectTaxItem.TaxationType AS TaxationType,
  IndirectTaxItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  IndirectTaxItem.SourceLogicalSystem AS SourceLogicalSystem,
  IndirectTaxItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  IndirectTaxItem.SourceReferenceDocument AS SourceReferenceDocument,
  IndirectTaxItem.RvsdReferenceDocumentType AS RvsdReferenceDocumentType,
  IndirectTaxItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  IndirectTaxItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  IndirectTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  IndirectTaxItem.GLAccount AS GLAccount,
  IndirectTaxItem.ConditionType AS ConditionType,
  IndirectTaxItem.TaxRateInPercent AS TaxRateInPercent,
  IndirectTaxItem.TaxRegisterPercentageUnit AS TaxRegisterPercentageUnit,
  IndirectTaxItem.PostingDate AS PostingDate,
  IndirectTaxItem.DocumentDate AS DocumentDate,
  IndirectTaxItem.TaxFulfillmentDate AS TaxFulfillmentDate,
  IndirectTaxItem.TaxReportingDate AS TaxReportingDate,
  IndirectTaxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  IndirectTaxItem.TaxItemGroup AS TaxItemGroup,
  IndirectTaxItem.TaxLineItemStatus AS TaxLineItemStatus,
  IndirectTaxItem.IsReversal AS IsReversal,
  IndirectTaxItem.IsReversed AS IsReversed,
  IndirectTaxItem.TaxPayableDocument AS TaxPayableDocument,
  IndirectTaxItem.TaxPayableDocumentYear AS TaxPayableDocumentYear,
  IndirectTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  IndirectTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  IndirectTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  IndirectTaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  IndirectTaxItem.TaxAmountInTransCrcy AS TaxAmountInTransCrcy,
  IndirectTaxItem.TransactionCurrency AS TransactionCurrency,
  IndirectTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  IndirectTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  IndirectTaxItem.ReportingCurrency AS ReportingCurrency,
  IndirectTaxItem.TaxLineItemPayableStatus AS TaxLineItemPayableStatus,
  IndirectTaxItem.TaxDeductibility AS TaxDeductibility,
  IndirectTaxItem.DebitCreditCode AS DebitCreditCode,
  IndirectTaxItem.TaxItemIsReportingRelevant AS TaxItemIsReportingRelevant,
  IndirectTaxItem.TaxRegisterMigrationUUID AS TaxRegisterMigrationUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  IndirectTaxItem._CompanyCode AS _CompanyCode,
  IndirectTaxItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  IndirectTaxItem._DocumentCurrency AS _DocumentCurrency,
  IndirectTaxItem._GLAccount AS _GLAccount,
  IndirectTaxItem._ReportingCurrency AS _ReportingCurrency,
  IndirectTaxItem._TaxCountry AS _TaxCountry,
  IndirectTaxItem._TaxRegMigration AS _TaxRegMigration
FROM I_TransactionalTaxItem AS IndirectTaxItem
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure AND TaxCode = _TaxCode.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON TaxCalculationProcedure = _TaxCalculationProcedure.TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxationType AS _TaxationType ON TaxationType = _TaxationType.TaxationType  -- association [0..1]
;

Depth:

I_IndirectTaxItem view_entity

I_TransactionalTaxItem view_entity