C_CustomerSalesAreaVH

Customer Sales Area | view: CSDCUSTSLSAREAVH | Extraction: Not supported | Component: Basic Functions
Tables used: ADCPADRCKNA1KNVV
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
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
CustomerName Name of Customer
AddressID Address ADRNR
PostalCode City postal code CHAR10
CityName City TEXT40
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_CUSTOMERSALESAREAVH.MANDT == T005.MANDT
  • C_CUSTOMERSALESAREAVH.COUNTRY == T005.LAND1
Customer Number
  • Customer Number
  • Client
  • C_CUSTOMERSALESAREAVH.CUSTOMER == KNA1.KUNNR
  • C_CUSTOMERSALESAREAVH.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_CUSTOMERSALESAREAVH.MANDT == TVTW.MANDT
  • C_CUSTOMERSALESAREAVH.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_CUSTOMERSALESAREAVH.MANDT == TSPA.MANDT
  • C_CUSTOMERSALESAREAVH.DIVISION == TSPA.SPART
Sales Organization
  • Sales Organization
  • Client
  • C_CUSTOMERSALESAREAVH.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERSALESAREAVH.MANDT == TVKO.MANDT