C_MDQltyCustSalesAreaDetail

Customer Sales Area Details | view: CMDQCUSTSADETL | Extraction: Not supported | Component: Analysis and Remediation of Data Quality.
Tables used: KNA1TVKTTT151TKNVVTVTWTTSPATT171TTVGRTTVKBTTVKOT
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
Customer FK Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
SalesOrganizationName Sales Organization Description
DistributionChannelName Distribution Channel Description
DivisionName Division Description
AuthorizationGroup Authorization Group
CustomerAccountAssgmtGrpName Description
SalesDistrictName Name of the district
CustomerGroupName Name
SalesOfficeName Sales Office Description TEXT20
SalesGroupName Sales Group Description TEXT20
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.CUSTOMER == KNA1.KUNNR
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == KNA1.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TVKT.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == T077D.MANDT
Customer Group
  • Customer Group
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.CUSTOMERGROUP == T151.KDGRP
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TSPA.MANDT
  • C_MDQLTYCUSTSALESAREADETAIL.DIVISION == TSPA.SPART
Sales District
  • Sales District
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.SALESDISTRICT == T171.BZIRK
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == T171.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • C_MDQLTYCUSTSALESAREADETAIL.SALESOFFICE == TVBVK.VKBUR
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TVBVK.MANDT
  • C_MDQLTYCUSTSALESAREADETAIL.SALESGROUP == TVBVK.VKGRP
Sales office
  • Sales office
  • Client
  • C_MDQLTYCUSTSALESAREADETAIL.SALESOFFICE == TVBUR.VKBUR
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TVBUR.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_MDQLTYCUSTSALESAREADETAIL.MANDT == TVKO.MANDT
  • C_MDQLTYCUSTSALESAREADETAIL.SALESORGANIZATION == TVKO.VKORG