What is C_ES_StRpVATRetTaxItemQ in SAP S/4HANA?

C_ES_StRpVATRetTaxItemQ is a consumption CDS view in SAP S/4HANA. Tax Items for Statutory Reporting Modelo 303 Spain Query It contains 72 fields.

Which tables does C_ES_StRpVATRetTaxItemQ read from?

C_ES_StRpVATRetTaxItemQ reads data from: I_ES_StRpVATRetTaxItemCube.

What VDM layer is C_ES_StRpVATRetTaxItemQ?

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

C_ES_StRpVATRetTaxItemQ

DDL: C_ES_STRPVATRETTAXITEMQ SQL: CSRESTAXITEMQ Type: view CONSUMPTION

72 Fields 1 Data Sources

Tax Items for Statutory Reporting Modelo 303 Spain Query

C_ES_StRpVATRetTaxItemQ is a Consumption CDS View that provides data about "Tax Items for Statutory Reporting Modelo 303 Spain Query" in SAP S/4HANA. It reads from 1 data source (I_ES_StRpVATRetTaxItemCube) and exposes 72 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (1)

Source	Alias	Join Type
I_ES_StRpVATRetTaxItemCube	I_ES_StRpVATRetTaxItemCube	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CSRESTAXITEMQ	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Tax Items for Statutory Reporting Modelo 303 Spain Query	view
AbapCatalog.preserveKey	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_ES_TaxReturnBoxQuery	view

Fields (72)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	TaxItem		TaxItem	Tax Item
KEY	TaxCode		TaxCode	Tax Code
KEY	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
KEY	TaxBox		TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType		TaxDeclnAmountType
KEY	TaxItemGroupingVersion		TaxItemGroupingVersion	Tax Grping Ver.
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	TaxRate		TaxRate	Tax Rate
	GLAccount		GLAccount	General Ledger
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	BusinessPlace		BusinessPlace	Business place
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	CAReconciliationKey	I_ES_StRpVATRetTaxItemCube	CAReconciliationKey	Reconcil. Key
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	DocumentReferenceID		DocumentReferenceID	Reference
	Ledger		Ledger	Ledger
	LedgerGroup		LedgerGroup	Ledger Group
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	TaxType		TaxType	Tax Type
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	IsCorrectionInvoice		IsCorrectionInvoice
	ReportingDate		ReportingDate
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry		TaxReturnCountry	Reporting C/R
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	CountryCurrency		CountryCurrency	Currency
	DocumentCurrency		DocumentCurrency	Document Currency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	AmountInReportingCurrency		AmountInReportingCurrency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	AmountInAdditionalCurrency1		AmountInAdditionalCurrency1	Amount in Additional Currency 1
	AmountInAdditionalCurrency2		AmountInAdditionalCurrency2	LC2 Amount
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxCalculationProcedure		TaxCalculationProcedure	Tax Procedure
	TargetTaxCode		TargetTaxCode
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress		CustomerSupplierAddress
	TaxIsNotDeductible		TaxIsNotDeductible	Non-Deductible

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_ES_StRpVATRetTaxItemQ.
-- 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: CSRESTAXITEMQ

CREATE VIEW C_ES_StRpVATRetTaxItemQ AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  DebitCreditCode,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  I_ES_StRpVATRetTaxItemCube.CAReconciliationKey AS CAReconciliationKey,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxType,
  IsReversal,
  IsReversed,
  IsCorrectionInvoice,
  ReportingDate,
  FiscalPeriod,
  ExchangeRate,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  AmountInReportingCurrency,
  AmountInTransactionCurrency,
  AmountInAdditionalCurrency1,
  AmountInAdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxCalculationProcedure,
  TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible
FROM I_ES_StRpVATRetTaxItemCube
;

Depth:

C_ES_StRpVATRetTaxItemQ view

I_ES_StRpVATRetTaxItemCube view