C_CA_StRpGSTItemQuery

DDL: C_CA_STRPGSTITEMQUERY SQL: CCASRGSTITMQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_CA
80 Fields 1 Data Sources

Analytical Query for Canada GST Items

C_CA_StRpGSTItemQuery is a Consumption CDS View that provides data about "Analytical Query for Canada GST Items" in SAP S/4HANA. It reads from 1 data source (C_CA_StRpGSTTaxAmtDivisionC) and exposes 80 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. Part of development package GLO_FIN_IS_VAT_CA.

Data Sources (1)

SourceAliasJoin Type
C_CA_StRpGSTTaxAmtDivisionC C_CA_StRpGSTTaxAmtDivisionC from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCASRGSTITMQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Analytical Query for Canada GST Items view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (80)

KeyFieldSource TableSource FieldDescription
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 TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate Vers.Valid From
KEY TaxGroup TaxGroup Tax Group
KEY TaxBoxStructureType TaxBoxStructureType
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptRunID StatryRptRunID Report Run ID
StatryRptRun StatryRptRun
TxJxIsFedGvmntTaxRelevant TxJxIsFedGvmntTaxRelevant
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
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
FiscalPeriod FiscalPeriod Tax period
ExchangeRate ExchangeRate Exchange rate
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
ReportingDate ReportingDate
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CountryCurrency CountryCurrency Currency
DocumentCurrency DocumentCurrency Document Currency
ReportingCurrency ReportingCurrency Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
CalculatedTaxBaseAmtInRptgCrcy CalculatedTaxBaseAmtInRptgCrcy
CalculatedTaxAmountInRptgCrcy CalculatedTaxAmountInRptgCrcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount TaxAmount Tax Amt in Rptg Crcy
CAReconciliationKey CAReconciliationKey Reconcil. Key
TaxType TaxType Tax Type
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TargetTaxCode TargetTaxCode
ConditionType 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

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_StRpGSTItemQuery.
-- 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: CCASRGSTITMQ

CREATE VIEW C_CA_StRpGSTItemQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  TaxBoxStrucValidityStartDate,
  TaxGroup,
  TaxBoxStructureType,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  StatryRptRun,
  TxJxIsFedGvmntTaxRelevant,
  DebitCreditCode,
  TaxRate,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  ReportingDate,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  CalculatedTaxBaseAmtInRptgCrcy,
  CalculatedTaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  CAReconciliationKey,
  TaxType,
  TaxCalculationProcedure,
  TargetTaxCode,
  ConditionType,
  EUTaxClassification,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  MiniOneStopShopTxRptgCntry,
  Supplier,
  Customer,
  TaxBoxStructure,
  TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  SupplierAccountGroup,
  TaxBoxAggregationOperation,
  TaxGroupOperation
FROM C_CA_StRpGSTTaxAmtDivisionC
;

Learn More