C_CA_StRpInputTaxCrdtItemQ

Analytical Query for Canada RITC items | view: CCASRRITCITMQ | Extraction: Not supported | Component: Localization Financials
Column Name Description
CompanyCode Company Code
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
TaxGroup FK Tax Group
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxBox01AmtInReportingCurrency Canada specific Data element for RITC reporting
TaxBox02AmtInReportingCurrency Canada specific Data element for RITC reporting
TaxBox03AmtInReportingCurrency Canada specific Data element for RITC reporting
Column Name Description
Column Name Description
ReportingDate Reporting Date
Column Name Description
Column Name Description Domain name
TaxJurisdiction Tax Jurisdiction TXJCD
TaxJurisdictionName Description TEXT50
Master Data Relations Join Conditions
Reporting Entity
  • Client
  • Reporting Entity
  • C_CA_STRPINPUTTAXCRDTITEMQ.MANDT == SRF_RPG_ENT.MANDT
  • C_CA_STRPINPUTTAXCRDTITEMQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Other Relations Join Conditions
Tax Group
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • Client
  • ?
  • ?
  • Tax Group
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "BLART"] == VGTAXGR.BLART
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "SHKZG_UMSV"] == VGTAXGR.SHKZG_UMSV
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "KTOSL"] == VGTAXGR.KTOSL
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "KTOKK"] == VGTAXGR.KTOKK
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "MWSKZ"] == VGTAXGR.MWSKZ
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "UMSKZ"] == VGTAXGR.UMSKZ
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "FOTFDATE"] == VGTAXGR.FDATE
  • C_CA_STRPINPUTTAXCRDTITEMQ.MANDT == VGTAXGR.MANDT
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "TBSTYPE"] == VGTAXGR.TBSTYP
  • C_CA_STRPINPUTTAXCRDTITEMQ.[column in domain "LAND1"] == VGTAXGR.LAND1
  • C_CA_STRPINPUTTAXCRDTITEMQ.TAXGROUP == VGTAXGR.ACR_TG