E_CustSlsAreaAddrDepdntInfo

Ext: Info Depdnt on Cust Addr Sls Area | view: ECUSTSLSADDRDEP | Extraction: Not supported | Component: Business Partners
Tables used: KNVV_ADDR
Column Name Description
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
AddressID FK Business Partner Address Number (from BUT020)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Client
  • E_CUSTSLSAREAADDRDEPDNTINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • E_CUSTSLSAREAADDRDEPDNTINFO.ADDRESSID == BUT020.ADDRNUMBER
  • E_CUSTSLSAREAADDRDEPDNTINFO.MANDT == BUT020.CLIENT
Customer key
  • Client
  • Customer Number
  • E_CUSTSLSAREAADDRDEPDNTINFO.MANDT == KNA1.MANDT
  • E_CUSTSLSAREAADDRDEPDNTINFO.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Distribution Channel
  • Client
  • E_CUSTSLSAREAADDRDEPDNTINFO.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • E_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • E_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TSPA.MANDT
  • E_CUSTSLSAREAADDRDEPDNTINFO.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • E_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TVKO.MANDT
  • E_CUSTSLSAREAADDRDEPDNTINFO.SALESORGANIZATION == TVKO.VKORG