What is C_CA_StRpGSTItemCube in SAP S/4HANA?

C_CA_StRpGSTItemCube is a consumption CDS view in SAP S/4HANA. Canada GST Tax Item Details It contains 89 fields.

Which tables does C_CA_StRpGSTItemCube read from?

C_CA_StRpGSTItemCube reads data from: I_CA_FedGvmntTaxJxRelevant, I_StRpTaxItemBoxCube, I_TaxItem.

What VDM layer is C_CA_StRpGSTItemCube?

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

C_CA_StRpGSTItemCube

DDL: C_CA_STRPGSTITEMCUBE SQL: CCASRGSTITMC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_CA

89 Fields 3 Data Sources

Canada GST Tax Item Details

C_CA_StRpGSTItemCube is a Consumption CDS View (Cube) that provides data about "Canada GST Tax Item Details" in SAP S/4HANA. It reads from 3 data sources (I_CA_FedGvmntTaxJxRelevant, I_StRpTaxItemBoxCube, I_TaxItem) and exposes 89 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. Part of development package GLO_FIN_IS_VAT_CA.

Data Sources (3)

Source	Alias	Join Type
I_CA_FedGvmntTaxJxRelevant	I_CA_FedGvmntTaxJxRelevant	inner
I_StRpTaxItemBoxCube	I_StRpTaxItemBoxCube	from
I_TaxItem	I_TaxItem	left_outer

Annotations (12)

Name	Value	Level
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CCASRGSTITMC	view
EndUserText.label	Canada GST Tax Item Details	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.dataCategory	#CUBE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Metadata.allowExtensions	true	view
AccessControl.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (89)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_StRpTaxItemBoxCube	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxItemBoxCube	AccountingDocument	Journal Entry
KEY	FiscalYear	I_StRpTaxItemBoxCube	FiscalYear	G/L Fiscal Year
KEY	TaxItem	I_StRpTaxItemBoxCube	TaxItem	Tax Item
KEY	TaxCode	I_StRpTaxItemBoxCube	TaxCode	Tax Code
KEY	TransactionTypeDetermination	I_StRpTaxItemBoxCube	TransactionTypeDetermination	Transaction Key
KEY	TaxGroup	I_StRpTaxItemBoxCube	TaxGroup	Tax Group
KEY	TaxBox		TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType		TaxDeclnAmountType
KEY	TaxItemGroupingVersion		TaxItemGroupingVersion	Tax Grping Ver.
KEY	ValidFrom		ValidFrom	Vers.Valid From
KEY	TaxBoxStructureType		TaxBoxStructureType
KEY	StatryRptgEntity	_ReportedItemsLog	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	_ReportedItemsLog	StatryRptCategory	Report ID
KEY	StatryRptRunID	_ReportedItemsLog	StatryRptRunID	Report Run ID
	StatryRptRun
	TxJxIsFedGvmntTaxRelevant		TxJxIsFedGvmntTaxRelevant	Federal Indicator
	DebitCreditCodeendasDebitCreditCode
	TaxRate	I_StRpTaxItemBoxCube	TaxRate	Tax Rate
	GLAccount	I_StRpTaxItemBoxCube	GLAccount	General Ledger
	TaxItemGroup	I_StRpTaxItemBoxCube	TaxItemGroup	Tax doc. item number
	BusinessPlace	I_StRpTaxItemBoxCube	BusinessPlace	Business place
	TaxJurisdiction	I_StRpTaxItemBoxCube	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	I_StRpTaxItemBoxCube	LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	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	I_StRpTaxItemBoxCube	TaxReportingDate	Tax Reporting Date
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry	I_StRpTaxItemBoxCube	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry	I_StRpTaxItemBoxCube	TaxReturnCountry	Reporting C/R
	ReportingDate		ReportingDate
	CompanyCodeCurrency	I_StRpTaxItemBoxCube	CompanyCodeCurrency	Local Currency
	CountryCurrency	I_StRpTaxItemBoxCube	CountryCurrency	Currency
	DocumentCurrency	I_StRpTaxItemBoxCube	DocumentCurrency	Document Currency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1	I_StRpTaxItemBoxCube	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	I_StRpTaxItemBoxCube	AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy	I_StRpTaxItemBoxCube	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	I_StRpTaxItemBoxCube	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	I_StRpTaxItemBoxCube	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	I_StRpTaxItemBoxCube	TaxAmount	Tax Amt in Rptg Crcy
	TaxType		TaxType	Tax Type
	TaxCalculationProcedure		TaxCalculationProcedure	Tax Procedure
	TargetTaxCode		TargetTaxCode
	ConditionType	I_StRpTaxItemBoxCube	ConditionType	Condition type
	EUTaxClassification		EUTaxClassification
	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
	MiniOneStopShopTxRptgCntry		MiniOneStopShopTxRptgCntry
	Supplier		Supplier	Supplier
	Customer		Customer	Sold-to Party
	TaxBoxStructure		TaxBoxStructure
	TaxBoxStructureName		TaxBoxStructureName
	TaxBoxName		TaxBoxName
	TaxBoxCondition		TaxBoxCondition
	SupplierAccountGroup		SupplierAccountGroup	Account group
	TaxBoxAggregationOperation		TaxBoxAggregationOperation
	TaxGroupOperation		TaxGroupOperation
	TaxCountry	I_StRpTaxItemBoxCube	TaxCountry	Tax Ctry/Reg.
	CAReconciliationKey		CAReconciliationKey	Reconcil. Key
	_AccountingDocument	I_StRpTaxItemBoxCube	_AccountingDocument
	_DebtorCreditorRblsPyblsItem	I_StRpTaxItemBoxCube	_DebtorCreditorRblsPyblsItem
	_GLAccount	I_StRpTaxItemBoxCube	_GLAccount
	_ReceivablesPayablesItem	I_StRpTaxItemBoxCube	_ReceivablesPayablesItem
	_ReportedItemsLog	I_StRpTaxItemBoxCube	_ReportedItemsLog
	_ReportingCurrency	I_StRpTaxItemBoxCube	_ReportingCurrency
	_TaxCodeText		_TaxCodeText
	_TaxJurisdiction	I_StRpTaxItemBoxCube	_TaxJurisdiction
	_TaxReceivablesPayablesItem	I_StRpTaxItemBoxCube	_TaxReceivablesPayablesItem
	_TaxTypeText		_TaxTypeText

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_CA_StRpGSTItemCube.
-- 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: CCASRGSTITMC

CREATE VIEW C_CA_StRpGSTItemCube AS
SELECT
  I_StRpTaxItemBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxItemBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxItemBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube.TaxCode AS TaxCode,
  I_StRpTaxItemBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemBoxCube.TaxGroup AS TaxGroup,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  cast(concat_with_space( concat_with_space( _ReportedItemsLog.StatryRptgEntity,_ReportedItemsLog.StatryRptCategory,1),_ReportedItemsLog.StatryRptRunID,1 ) as srf_reportrun) AS StatryRptRun,
  TxJxIsFedGvmntTaxRelevant,
  case when I_StRpTaxItemBoxCube.DebitCreditCode is null or I_StRpTaxItemBoxCube.DebitCreditCode = '' then I_TaxItem.DebitCreditCode else I_StRpTaxItemBoxCube.DebitCreditCode end as DebitCreditCode AS DebitCreditCodeendasDebitCreditCode,
  I_StRpTaxItemBoxCube.TaxRate AS TaxRate,
  I_StRpTaxItemBoxCube.GLAccount AS GLAccount,
  I_StRpTaxItemBoxCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItemBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxItemBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItemBoxCube.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  I_StRpTaxItemBoxCube.TaxReportingDate AS TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  I_StRpTaxItemBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  ReportingCountry,
  I_StRpTaxItemBoxCube.TaxReturnCountry AS TaxReturnCountry,
  ReportingDate,
  I_StRpTaxItemBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxItemBoxCube.CountryCurrency AS CountryCurrency,
  I_StRpTaxItemBoxCube.DocumentCurrency AS DocumentCurrency,
  ReportingCurrency,
  I_StRpTaxItemBoxCube.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItemBoxCube.AdditionalCurrency2 AS AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  I_StRpTaxItemBoxCube.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItemBoxCube.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpTaxItemBoxCube.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItemBoxCube.TaxAmount AS TaxAmount,
  TaxType,
  TaxCalculationProcedure,
  TargetTaxCode,
  I_StRpTaxItemBoxCube.ConditionType AS ConditionType,
  EUTaxClassification,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  MiniOneStopShopTxRptgCntry,
  Supplier,
  Customer,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  I_StRpTaxItemBoxCube.TaxCountry AS TaxCountry,
  CAReconciliationKey,
  I_StRpTaxItemBoxCube._AccountingDocument AS _AccountingDocument,
  I_StRpTaxItemBoxCube._DebtorCreditorRblsPyblsItem AS _DebtorCreditorRblsPyblsItem,
  I_StRpTaxItemBoxCube._GLAccount AS _GLAccount,
  I_StRpTaxItemBoxCube._ReceivablesPayablesItem AS _ReceivablesPayablesItem,
  I_StRpTaxItemBoxCube._ReportedItemsLog AS _ReportedItemsLog,
  I_StRpTaxItemBoxCube._ReportingCurrency AS _ReportingCurrency,
  I_StRpTaxItemBoxCube._TaxJurisdiction AS _TaxJurisdiction,
  I_StRpTaxItemBoxCube._TaxReceivablesPayablesItem AS _TaxReceivablesPayablesItem
FROM I_StRpTaxItemBoxCube
INNER JOIN I_CA_FedGvmntTaxJxRelevant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxItem ON /* join condition not captured in parsed metadata */
;

Depth:

C_CA_StRpGSTItemCube view