I_CustomerBySalesArea

Customer details by sales area | view: ICUSTBYSLSAREA | ATTR | Extraction: Not supported | Component: Business Partners
Tables used: KNA1KNVV
Column Name Description
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • I_CUSTOMERBYSALESAREA.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERBYSALESAREA.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_CUSTOMERBYSALESAREA.MANDT == TVTW.MANDT
  • I_CUSTOMERBYSALESAREA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_CUSTOMERBYSALESAREA.MANDT == TSPA.MANDT
  • I_CUSTOMERBYSALESAREA.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTOMERBYSALESAREA.MANDT == TVKO.MANDT
  • I_CUSTOMERBYSALESAREA.SALESORGANIZATION == TVKO.VKORG