C_ESJISalesAreaQuery

Customer Sales Area | view: CESJISLSAREAQ | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: KNVVTVTWTVTWTTSPATSPATTVKGRTVGRTTVBURTVKBTTVKOTVKOT
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SalesGroupName Sales Group Description TEXT20
SalesOfficeName Sales Office Description TEXT20
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_ESJISALESAREAQUERY.CUSTOMER == KNA1.KUNNR
  • C_ESJISALESAREAQUERY.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_ESJISALESAREAQUERY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_ESJISALESAREAQUERY.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_ESJISALESAREAQUERY.DIVISION == TSPA.SPART
  • C_ESJISALESAREAQUERY.MANDT == TSPA.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_ESJISALESAREAQUERY.SALESOFFICE == TVBVK.VKBUR
  • C_ESJISALESAREAQUERY.SALESGROUP == TVBVK.VKGRP
  • C_ESJISALESAREAQUERY.MANDT == TVBVK.MANDT
Sales office
  • Sales office
  • Client
  • C_ESJISALESAREAQUERY.SALESOFFICE == TVBUR.VKBUR
  • C_ESJISALESAREAQUERY.MANDT == TVBUR.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_ESJISALESAREAQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_ESJISALESAREAQUERY.MANDT == TVKO.MANDT