What is I_StRpTaxItemWithRefAcctgDoc in SAP S/4HANA?

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

Which tables does I_StRpTaxItemWithRefAcctgDoc read from?

I_StRpTaxItemWithRefAcctgDoc reads data from: I_StRpBillingWithRefAcctgDoc, I_StRpTaxItemWithRefDocument.

What VDM layer is I_StRpTaxItemWithRefAcctgDoc?

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

I_StRpTaxItemWithRefAcctgDoc

DDL: I_STRPTAXITEMWITHREFACCTGDOC SQL: ISRTXITMRACDOC Type: view COMPOSITE

81 Fields 2 Data Sources

Tax Items with Reference Accounting Documents

I_StRpTaxItemWithRefAcctgDoc is a Composite CDS View that provides data about "Tax Items with Reference Accounting Documents" in SAP S/4HANA. It reads from 2 data sources (I_StRpBillingWithRefAcctgDoc, I_StRpTaxItemWithRefDocument) and exposes 81 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, TaxItem.

Data Sources (2)

Source	Alias	Join Type
I_StRpBillingWithRefAcctgDoc	_Bill	left_outer
I_StRpTaxItemWithRefDocument	I_StRpTaxItemWithRefDocument	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ISRTXITMRACDOC	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 Accounting Documents	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (81)

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

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_StRpTaxItemWithRefAcctgDoc.
-- 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: ISRTXITMRACDOC

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

Depth:

I_StRpTaxItemWithRefAcctgDoc view

I_StRpTaxItemWithRefDocument view
I_StRpBillingWithRefAcctgDoc view

C_EG_StRpTaxItemWithPricing view