C_SoldToSalesAreaVH

Sold-to Party By Sales Area | view: CSDSPBYSLSAREAVH | Extraction: Not supported | Component: Sales Document Creation Based on Unstructured Data
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
PostalCode City postal code CHAR10
CityName City TEXT40
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • C_SOLDTOSALESAREAVH.COUNTRY == T005.LAND1
  • C_SOLDTOSALESAREAVH.MANDT == T005.MANDT
Customer Number
  • Client
  • Customer Number
  • C_SOLDTOSALESAREAVH.MANDT == KNA1.MANDT
  • C_SOLDTOSALESAREAVH.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • C_SOLDTOSALESAREAVH.MANDT == TVTW.MANDT
  • C_SOLDTOSALESAREAVH.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_SOLDTOSALESAREAVH.MANDT == TSPA.MANDT
  • C_SOLDTOSALESAREAVH.DIVISION == TSPA.SPART
Sales Organization
  • Sales Organization
  • Client
  • C_SOLDTOSALESAREAVH.SALESORGANIZATION == TVKO.VKORG
  • C_SOLDTOSALESAREAVH.MANDT == TVKO.MANDT