C_CA_StRpWhldgTxItmQuery

Canada Withholding Tax Reporting - Query | view: CSRCAWHLDGTXITMQ | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
AccountingDocumentItem Number of Line Item Within Accounting Document
FiscalYear Fiscal Year
WithholdingTaxType FK Indicator for Withholding Tax Type
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (ReportingCurrency):
TravelCostInCoCodeCrcy Travel Expenses
WhldgTaxBaseAmtInCoCodeCrcy null
WhldgTaxAmtInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
Column Name Description Domain name
ClearingAccountingDocument Clearing Journal Entry BELNR
CompanyCodeName null
CompanyHouseNumber House Number TEXT10
CompanyStreetName Street TEXT60
CompanyCodeCityName City TEXT40
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
TaxFilingAgencyAddress Address Text
CompanyCodeParameterValue Parameter value TEXT48
BusinessPartner Customer Number KUNNR
CA_SocialInsuranceNumber Canadian Social Insurance Number CHAR9
CA_ForeignAccountNumber Non-Resident's Account Number CHAR15
CA_FrgnTaxIdentificationNumber Non-Resident's Foreign Tax Identification Number CHAR60
CA_ForeignIndividualTaxNumber Non-Resident's Individual Tax Number CHAR9
SupplierIndustry Supplier Industry Type CHAR4
CA_ForeignTemporaryTaxNumber Non-Resident's Temporary Tax Number CHAR9
TaxNumber1 Tax Number 1 STCD1
FirstName null
LastName null
OrganizationBPName1 null
OrganizationBPName2 null
BusinessPartnerName1 Name 1 TEXT40
POBox null
BusinessPartnerHouseNumber House Number TEXT10
BusinessPartnerStreetName null
CityName null
Region null
PostalCode null
BusinessPartnerCountry null
AddressLine1Text null
AddressLine3Text null
BusinessPartnerCountryName Country/Region Name TEXT50
CountryThreeLetterISOCode ISO Country/Region Code 3 Characters INTCA3
PhysDocFileName null
NumberOfDaysPresentAtSite Number of Days Spent in Canada
ServiceRenderedCityName City of Service TEXT40
ServiceRenderedRegion Province/Territory of Service REGIO
WhldgTaxDocumentType null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CA_STRPWHLDGTXITMQUERY.COMPANYCODE == T001.BUKRS
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T001.MANDT
Region code
  • ?
  • Client
  • Region (State, Province, County)
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T005S.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T005S.MANDT
  • C_CA_STRPWHLDGTXITMQUERY.COMPANYREGION == T005S.BLAND
Reason for Exemption
  • ?
  • Reason for Exemption
  • Client
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T059V.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.EXEMPTIONREASON == T059V.WT_WTEXRS
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T059V.MANDT
Language Key C_CA_STRPWHLDGTXITMQUERY.LANGUAGE == T002.SPRAS
Official Withholding Tax Key
  • ?
  • Official Withholding Tax Key
  • Client
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T059O.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T059O.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_CA_STRPWHLDGTXITMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == SRF_RPG_ENT.MANDT
Type of Recipient
  • ?
  • Indicator for Withholding Tax Type
  • Client
  • Type of Recipient
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T059C.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.WITHHOLDINGTAXTYPE == T059C.WITHT
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T059C.MANDT
  • C_CA_STRPWHLDGTXITMQUERY.SUPPLIERRECIPIENTTYPE == T059C.QSREC
Withholding Tax Code
  • ?
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T059Z.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T059Z.MANDT
  • C_CA_STRPWHLDGTXITMQUERY.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • ?
  • Indicator for Withholding Tax Type
  • Client
  • C_CA_STRPWHLDGTXITMQUERY.[column in domain "LAND1"] == T059P.LAND1
  • C_CA_STRPWHLDGTXITMQUERY.WITHHOLDINGTAXTYPE == T059P.WITHT
  • C_CA_STRPWHLDGTXITMQUERY.MANDT == T059P.MANDT