C_CA_StRpTaxItemCube

Consumption view for Canada GST Return | view: CCASRTAXITEMC | TRAN | Extraction: Not supported | Component: Localization Financials
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
TaxCode FK Tax on sales/purchases code
TaxItem Number of Tax Line Item
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
ReportingDate Reporting Date
DocumentDate Journal Entry Date
Column Name Description
TaxType Tax Type Show values
Column Name Description Domain name
GLAccountName G/L Account Name TEXT20
TaxJurisdictionName Description TEXT50
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName null
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_CA_STRPTAXITEMCUBE.MANDT == T003.MANDT
  • C_CA_STRPTAXITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • C_CA_STRPTAXITEMCUBE.COMPANYCODE == T001.BUKRS
  • C_CA_STRPTAXITEMCUBE.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_CA_STRPTAXITEMCUBE.MANDT == TCURC.MANDT
  • C_CA_STRPTAXITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CA_STRPTAXITEMCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_CA_STRPTAXITEMCUBE.MANDT == TCURC.MANDT
  • C_CA_STRPTAXITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_CA_STRPTAXITEMCUBE.DOCUMENTCURRENCY == TCURC.WAERS
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • C_CA_STRPTAXITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • C_CA_STRPTAXITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • C_CA_STRPTAXITEMCUBE.MANDT == SKB1.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_CA_STRPTAXITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_CA_STRPTAXITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • C_CA_STRPTAXITEMCUBE.TAXCODE == T007A.MWSKZ
  • C_CA_STRPTAXITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • C_CA_STRPTAXITEMCUBE.MANDT == T007A.MANDT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • C_CA_STRPTAXITEMCUBE.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • C_CA_STRPTAXITEMCUBE.MANDT == TTXJ.MANDT
  • C_CA_STRPTAXITEMCUBE.TAXJURISDICTION == TTXJ.TXJCD