P_CA_StRpWhldgTxItmQ

Canada Withholding Tax | view: PCASTRPWHLDGTX | 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
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
AddressLine3Text null
BusinessPartnerCountryName Country/Region Name TEXT50
CountryThreeLetterISOCode ISO Country/Region Code 3 Characters INTCA3
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
  • Client
  • Company Code
  • P_CA_STRPWHLDGTXITMQ.MANDT == T001.MANDT
  • P_CA_STRPWHLDGTXITMQ.COMPANYCODE == T001.BUKRS
Region code
  • Client
  • ?
  • Region (State, Province, County)
  • P_CA_STRPWHLDGTXITMQ.MANDT == T005S.MANDT
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T005S.LAND1
  • P_CA_STRPWHLDGTXITMQ.COMPANYREGION == T005S.BLAND
Reason for Exemption
  • ?
  • Client
  • Reason for Exemption
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T059V.LAND1
  • P_CA_STRPWHLDGTXITMQ.MANDT == T059V.MANDT
  • P_CA_STRPWHLDGTXITMQ.EXEMPTIONREASON == T059V.WT_WTEXRS
Language Key P_CA_STRPWHLDGTXITMQ.LANGUAGE == T002.SPRAS
Official Withholding Tax Key
  • ?
  • Client
  • Official Withholding Tax Key
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T059O.LAND1
  • P_CA_STRPWHLDGTXITMQ.MANDT == T059O.MANDT
  • P_CA_STRPWHLDGTXITMQ.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
Reporting Entity
  • Reporting Entity
  • Client
  • P_CA_STRPWHLDGTXITMQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_CA_STRPWHLDGTXITMQ.MANDT == SRF_RPG_ENT.MANDT
Type of Recipient
  • ?
  • Type of Recipient
  • Client
  • Indicator for Withholding Tax Type
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T059C.LAND1
  • P_CA_STRPWHLDGTXITMQ.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • P_CA_STRPWHLDGTXITMQ.MANDT == T059C.MANDT
  • P_CA_STRPWHLDGTXITMQ.WITHHOLDINGTAXTYPE == T059C.WITHT
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • Indicator for Withholding Tax Type
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T059Z.LAND1
  • P_CA_STRPWHLDGTXITMQ.MANDT == T059Z.MANDT
  • P_CA_STRPWHLDGTXITMQ.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • P_CA_STRPWHLDGTXITMQ.WITHHOLDINGTAXTYPE == T059Z.WITHT
Indicator for Withholding Tax Type
  • ?
  • Client
  • Indicator for Withholding Tax Type
  • P_CA_STRPWHLDGTXITMQ.[column in domain "LAND1"] == T059P.LAND1
  • P_CA_STRPWHLDGTXITMQ.MANDT == T059P.MANDT
  • P_CA_STRPWHLDGTXITMQ.WITHHOLDINGTAXTYPE == T059P.WITHT