What is I_ReportableIndirectTaxItem in SAP S/4HANA?

I_ReportableIndirectTaxItem is a basic CDS view in SAP S/4HANA. Reportable Indirect Tax Item It contains 61 fields.

Which tables does I_ReportableIndirectTaxItem read from?

I_ReportableIndirectTaxItem reads data from: I_RptblTransactionalTaxItem.

What VDM layer is I_ReportableIndirectTaxItem?

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

I_ReportableIndirectTaxItem

DDL: I_REPORTABLEINDIRECTTAXITEM Type: view_entity BASIC Package: FIN_TAXREG_DB

61 Fields 1 Data Sources 3 Associations

Reportable Indirect Tax Item

I_ReportableIndirectTaxItem is a Basic CDS View that provides data about "Reportable Indirect Tax Item" in SAP S/4HANA. It reads from 1 data source (I_RptblTransactionalTaxItem) and exposes 61 fields with key field TaxItemUUID. It has 3 associations to related views. Part of development package FIN_TAXREG_DB.

Data Sources (1)

Source	Alias	Join Type
I_RptblTransactionalTaxItem	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	Reportable Indirect Tax Item	view

Fields (61)

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

I_RptblTransactionalTaxItem view_entity