I_CustSalesAreaTax

Customer Sales Area Tax | view: ICUSTSALETAX | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: KNA1KNVVKNVIT001WTVKWZTVTA
Column Name Description
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Reference distrib.channel for cust.and material masters
Division FK Division
DepartureCountry FK Departure Country/Region (from which the goods are sent)
CustomerTaxCategory FK Tax category (sales tax, federal sales tax,...)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • I_CUSTSALESAREATAX.CUSTOMER == KNA1.KUNNR
  • I_CUSTSALESAREATAX.MANDT == KNA1.MANDT
Tax category (sales tax, federal sales tax,...)
  • ?
  • Client
  • Tax category (sales tax, federal sales tax,...)
  • I_CUSTSALESAREATAX.[column in domain "KAPPL"] == T685A.KAPPL
  • I_CUSTSALESAREATAX.MANDT == T685A.MANDT
  • I_CUSTSALESAREATAX.CUSTOMERTAXCATEGORY == T685A.KSCHL
Tax classification for customer
  • Client
  • Tax category (sales tax, federal sales tax,...)
  • Tax classification for customer
  • I_CUSTSALESAREATAX.MANDT == TSKD.MANDT
  • I_CUSTSALESAREATAX.CUSTOMERTAXCATEGORY == TSKD.TATYP
  • I_CUSTSALESAREATAX.CUSTOMERTAXCLASSIFICATION == TSKD.TAXKD
Departure Country/Region (from which the goods are sent)
  • Departure Country/Region (from which the goods are sent)
  • Client
  • I_CUSTSALESAREATAX.DEPARTURECOUNTRY == T005.LAND1
  • I_CUSTSALESAREATAX.MANDT == T005.MANDT
Reference distrib.channel for cust.and material masters
  • Reference distrib.channel for cust.and material masters
  • Client
  • Sales Organization
  • I_CUSTSALESAREATAX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CUSTSALESAREATAX.MANDT == TVKOV.MANDT
  • I_CUSTSALESAREATAX.SALESORGANIZATION == TVKOV.VKORG
Division
  • Client
  • Division
  • Sales Organization
  • I_CUSTSALESAREATAX.MANDT == TVKOS.MANDT
  • I_CUSTSALESAREATAX.DIVISION == TVKOS.SPART
  • I_CUSTSALESAREATAX.SALESORGANIZATION == TVKOS.VKORG
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTSALESAREATAX.MANDT == TVKO.MANDT
  • I_CUSTSALESAREATAX.SALESORGANIZATION == TVKO.VKORG