I_CA_StRpWhldgTaxItemCube

Canada Withholding Tax Reporting - Cube | view: ISRCAWHLDGTXITMC | TRAN | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
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
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed 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
Supplier Account Number of Supplier LIFNR
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
BusinessPartner Customer Number KUNNR
TaxNumber1 Tax Number 1 STCD1
OrganizationBPName1 null
OrganizationBPName2 null
FirstName null
LastName null
BusinessPartnerName1 Name 1 TEXT40
POBox null
BusinessPartnerHouseNumber House Number TEXT10
BusinessPartnerStreetName null
AddressLine1Text null
CityName null
Region null
PostalCode null
BusinessPartnerCountry 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
ServiceRenderedRegion Province/Territory of Service REGIO
ServiceRenderedCityName City of Service TEXT40
WhldgTaxDocumentType null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T001.MANDT
Region code
  • Client
  • Region (State, Province, County)
  • ?
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T005S.MANDT
  • I_CA_STRPWHLDGTAXITEMCUBE.COMPANYREGION == T005S.BLAND
  • I_CA_STRPWHLDGTAXITEMCUBE.[column in domain "LAND1"] == T005S.LAND1
Country/Region Key
  • Country/Region Key
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T005.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T005.MANDT
Reason for Exemption
  • Country/Region Key
  • Reason for Exemption
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T059V.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.EXEMPTIONREASON == T059V.WT_WTEXRS
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T059V.MANDT
Language Key I_CA_STRPWHLDGTAXITEMCUBE.LANGUAGE == T002.SPRAS
Official Withholding Tax Key
  • Country/Region Key
  • Official Withholding Tax Key
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T059O.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.OFFICIALWHLDGTAXCODE == T059O.WT_QSCOD
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T059O.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == SRF_RPG_ENT.MANDT
  • I_CA_STRPWHLDGTAXITEMCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Type of Recipient
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Type of Recipient
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T059C.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059C.WITHT
  • I_CA_STRPWHLDGTAXITEMCUBE.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T059C.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Withholding Tax Code
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T059Z.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_CA_STRPWHLDGTAXITEMCUBE.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T059Z.MANDT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • I_CA_STRPWHLDGTAXITEMCUBE.COUNTRY == T059P.LAND1
  • I_CA_STRPWHLDGTAXITEMCUBE.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_CA_STRPWHLDGTAXITEMCUBE.MANDT == T059P.MANDT