What is I_StRpTaxItemWithRefDocument in SAP S/4HANA?

I_StRpTaxItemWithRefDocument is a composite CDS view in SAP S/4HANA. Tax Items with Reference Documents It contains 79 fields.

Which tables does I_StRpTaxItemWithRefDocument read from?

I_StRpTaxItemWithRefDocument reads data from: I_OperationalAcctgDocItem.

What VDM layer is I_StRpTaxItemWithRefDocument?

I_StRpTaxItemWithRefDocument is classified as a Composite view that combines data from multiple basic views.

I_StRpTaxItemWithRefDocument

DDL: I_STRPTAXITEMWITHREFDOCUMENT SQL: ISRTXITMREFDOC Type: view COMPOSITE Package: GLO_FIN_VAT_MENA

79 Fields 1 Data Sources 1 Associations

Tax Items with Reference Documents

I_StRpTaxItemWithRefDocument is a Composite CDS View that provides data about "Tax Items with Reference Documents" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 79 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, AccountingDocumentItem. It has 1 association to related views. Part of development package GLO_FIN_VAT_MENA.

Data Sources (1)

Source	Alias	Join Type
I_OperationalAcctgDocItem	_DocItem	left_outer

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_JournalEntry	_JournalEntry	`$projection.CompanyCode = _JournalEntry.CompanyCode and $projection.ReferenceDocumentFiscalYear = _JournalEntry.FiscalYear and $projection.ReferenceDocumentNumber = _JournalEntry.AccountingDocument`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ISRTXITMREFDOC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
EndUserText.label	Tax Items with Reference Documents	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_StRpTaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	I_StRpTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	I_StRpTaxItem	TaxItem	Tax Item
KEY	AccountingDocumentItem	I_OperationalAcctgDocItem	AccountingDocumentItem	Posting View Item
KEY	TaxCode	I_StRpTaxItem	TaxCode	Tax Code
KEY	TransactionTypeDetermination	I_StRpTaxItem	TransactionTypeDetermination	Transaction Key
	DebitCreditCode	I_StRpTaxItem	DebitCreditCode	Single-Character Flag
	TaxRate	I_StRpTaxItem	TaxRate	Tax Rate
	GLAccount	I_StRpTaxItem	GLAccount	General Ledger
	TaxItemGroup	I_StRpTaxItem	TaxItemGroup	Tax doc. item number
	BusinessPlace	I_StRpTaxItem	BusinessPlace	Business place
	TaxJurisdiction	I_StRpTaxItem	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	I_StRpTaxItem	LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType	I_StRpTaxItem	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType	I_StRpTaxItem	ReferenceDocumentType	Reference Document Type
	ReverseDocument	I_StRpTaxItem	ReverseDocument	Reversed With
	ReverseDocumentFiscalYear	I_StRpTaxItem	ReverseDocumentFiscalYear	Year
	DocumentReferenceID	I_StRpTaxItem	DocumentReferenceID	Reference
	ConditionType	I_StRpTaxItem	ConditionType	Condition type
	Ledger	I_StRpTaxItem	Ledger	Ledger
	LedgerGroup	I_StRpTaxItem	LedgerGroup	Ledger Group
	PostingDate	I_StRpTaxItem	PostingDate	Posting Date for GR
	DocumentDate	I_StRpTaxItem	DocumentDate	Journal Entry Date
	TaxReportingDate	I_StRpTaxItem	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	I_StRpTaxItem	FiscalPeriod	Tax period
	ExchangeRate	I_StRpTaxItem	ExchangeRate	Exchange rate
	IsReversal	I_StRpTaxItem	IsReversal	Reversal doc.
	IsReversed	I_StRpTaxItem	IsReversed	Reversed?
	AccountingDocumentHeaderText	I_StRpTaxItem	AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry	I_StRpTaxItem	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	I_StRpTaxItem	ReportingCountry
	TaxReturnCountry	I_StRpTaxItem	TaxReturnCountry	Reporting C/R
	ReportingDate	I_StRpTaxItem	ReportingDate
	CompanyCodeCurrency	I_StRpTaxItem	CompanyCodeCurrency	Local Currency
	CountryCurrency	I_StRpTaxItem	CountryCurrency	Currency
	DocumentCurrency	I_StRpTaxItem	DocumentCurrency	Document Currency
	ReportingCurrency	I_StRpTaxItem	ReportingCurrency	Currency
	AdditionalCurrency1	I_StRpTaxItem	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	I_StRpTaxItem	AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy	I_StRpTaxItem	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	I_StRpTaxItem	TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy	I_StRpTaxItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	I_StRpTaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	I_StRpTaxItem	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	I_StRpTaxItem	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy	I_StRpTaxItem	TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy	I_StRpTaxItem	TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1	I_StRpTaxItem	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2	I_StRpTaxItem	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1	I_StRpTaxItem	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2	I_StRpTaxItem	TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxType	I_StRpTaxItem	TaxType	Tax Type
	TaxCalculationProcedure	I_StRpTaxItem	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	I_StRpTaxItem	TargetTaxCode
	EUTaxClassification	I_StRpTaxItem	EUTaxClassification
	TaxNumber1	I_StRpTaxItem	TaxNumber1	VAT Reg. No.
	TaxNumber2	I_StRpTaxItem	TaxNumber2	Tax Number 2
	TaxNumber3	I_StRpTaxItem	TaxNumber3
	BusinessPartner	I_StRpTaxItem	BusinessPartner	Issuing Authority
	BusinessPartnerName	I_StRpTaxItem	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	I_StRpTaxItem	CustomerSupplierAddress
	TaxIsNotDeductible	I_StRpTaxItem	TaxIsNotDeductible	Non-Deductible
	SupplierAccountGroup	I_StRpTaxItem	SupplierAccountGroup	Account group
	MiniOneStopShopTxRptgCntry	I_StRpTaxItem	MiniOneStopShopTxRptgCntry
	BillingDocument	I_OperationalAcctgDocItem	BillingDocument	SD Document
	FinancialAccountType	I_OperationalAcctgDocItem	FinancialAccountType	Fin. Account Type
	TaxCountry	I_StRpTaxItem	TaxCountry	Tax Ctry/Reg.
	_ReportingCurrency		_ReportingCurrency
	_AccountingDocument		_AccountingDocument
	_GLAccount		_GLAccount
	_TaxJurisdiction		_TaxJurisdiction
	_DebtorCreditorRblsPyblsItem		_DebtorCreditorRblsPyblsItem
	_ReceivablesPayablesItem		_ReceivablesPayablesItem
	_TaxReceivablesPayablesItem		_TaxReceivablesPayablesItem
	_TaxTypeText		_TaxTypeText
	_TaxCodeText		_TaxCodeText
	_ReportedItemsLog		_ReportedItemsLog
	_JournalEntry		_JournalEntry

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_StRpTaxItemWithRefDocument.
-- 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.
-- SQL view name: ISRTXITMREFDOC

CREATE VIEW I_StRpTaxItemWithRefDocument AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  I_StRpTaxItem.TaxItem AS TaxItem,
  _DocItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpTaxItem.TaxCode AS TaxCode,
  I_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItem.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItem.TaxRate AS TaxRate,
  I_StRpTaxItem.GLAccount AS GLAccount,
  I_StRpTaxItem.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItem.BusinessPlace AS BusinessPlace,
  I_StRpTaxItem.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItem.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxItem.ReverseDocument AS ReverseDocument,
  I_StRpTaxItem.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_StRpTaxItem.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxItem.ConditionType AS ConditionType,
  I_StRpTaxItem.Ledger AS Ledger,
  I_StRpTaxItem.LedgerGroup AS LedgerGroup,
  I_StRpTaxItem.PostingDate AS PostingDate,
  I_StRpTaxItem.DocumentDate AS DocumentDate,
  I_StRpTaxItem.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItem.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItem.ExchangeRate AS ExchangeRate,
  I_StRpTaxItem.IsReversal AS IsReversal,
  I_StRpTaxItem.IsReversed AS IsReversed,
  I_StRpTaxItem.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxItem.ReportingCountry AS ReportingCountry,
  I_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  I_StRpTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxItem.CountryCurrency AS CountryCurrency,
  I_StRpTaxItem.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxItem.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_StRpTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpTaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItem.TaxAmount AS TaxAmount,
  I_StRpTaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_StRpTaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_StRpTaxItem.TaxType AS TaxType,
  I_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxItem.EUTaxClassification AS EUTaxClassification,
  I_StRpTaxItem.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItem.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItem.TaxNumber3 AS TaxNumber3,
  I_StRpTaxItem.BusinessPartner AS BusinessPartner,
  I_StRpTaxItem.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxItem.CustomerSupplierAddress AS CustomerSupplierAddress,
  I_StRpTaxItem.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxItem.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpTaxItem.MiniOneStopShopTxRptgCntry AS MiniOneStopShopTxRptgCntry,
  _DocItem.BillingDocument AS BillingDocument,
  _DocItem.FinancialAccountType AS FinancialAccountType,
  I_StRpTaxItem.TaxCountry AS TaxCountry
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _DocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND ReferenceDocumentFiscalYear = _JournalEntry.FiscalYear AND ReferenceDocumentNumber = _JournalEntry.AccountingDocument  -- association [1..1]
;

Depth:

I_StRpTaxItemWithRefDocument view

I_OperationalAcctgDocItem view_entity

I_StRpTaxItemWithRefAcctgDoc view