C_CA_StRpTaxItemCube

DDL: C_CA_STRPTAXITEMCUBE SQL: CCASRTAXITEMC Type: view CONSUMPTION
27 Fields 1 Data Sources

Consumption view for Canada GST Return

C_CA_StRpTaxItemCube is a Consumption CDS View (Cube) that provides data about "Consumption view for Canada GST Return" in SAP S/4HANA. It reads from 1 data source (I_StRpBPTaxItem) and exposes 27 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptgEntity, StatryRptCategory.

Data Sources (1)

SourceAliasJoin Type
I_StRpBPTaxItem I_StRpBPTaxItem from

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCASRTAXITEMC view
EndUserText.label Consumption view for Canada GST Return 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 (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID
KEY TaxCode TaxCode Tax Code
KEY TaxItem TaxItem Tax Item
AccountingDocumentType AccountingDocumentType Journal Entry Type
GLAccount GLAccount General Ledger
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
GLAccountName
TaxJurisdictionName
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
DocumentDate DocumentDate Journal Entry Date
BusinessPartner _BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
FiscalPeriod _AccountingDocument FiscalPeriod Tax period
TaxType TaxType Tax Type
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AdditionalCurrency1 _AccountingDocument AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 _AccountingDocument AdditionalCurrency2 Local curr. 3
DocumentCurrency DocumentCurrency Document Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax

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_StRpTaxItemCube.
-- 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: CCASRTAXITEMC

CREATE VIEW C_CA_StRpTaxItemCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  TaxCode,
  TaxItem,
  AccountingDocumentType,
  GLAccount,
  TaxJurisdiction,
  _GLAccount._Text[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  _TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
  PostingDate,
  ReportingDate,
  DocumentDate,
  _BusinessPartner.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _AccountingDocument.FiscalPeriod AS FiscalPeriod,
  TaxType,
  CompanyCodeCurrency,
  _AccountingDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _AccountingDocument.AdditionalCurrency2 AS AdditionalCurrency2,
  DocumentCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy
FROM I_StRpBPTaxItem
;

Learn More