A_CustSlsAreaAddrDepdntInfo

Customer Sales Area Address Dependent Information | view: ACUSTSLSADDRDEP | 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
Column Name Description Domain name
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
DeliveryIsBlocked Customer delivery block (sales area) LIFSP
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ShippingCondition Shipping Conditions VSBED
SupplyingPlant Delivering Plant (Own or External) WERKS
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Client
  • ?
  • Business Partner Address Number (from BUT020)
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == BUT020.CLIENT
  • A_CUSTSLSAREAADDRDEPDNTINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • A_CUSTSLSAREAADDRDEPDNTINFO.ADDRESSID == BUT020.ADDRNUMBER
Customer key
  • Customer Number
  • Client
  • A_CUSTSLSAREAADDRDEPDNTINFO.CUSTOMER == KNA1.KUNNR
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TVTW.MANDT
  • A_CUSTSLSAREAADDRDEPDNTINFO.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Division
  • Client
  • A_CUSTSLSAREAADDRDEPDNTINFO.DIVISION == TSPA.SPART
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TSPA.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • A_CUSTSLSAREAADDRDEPDNTINFO.INCOTERMSVERSION == TINCV.INCOV
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TINCV.MANDT
Sales Organization
  • Client
  • Sales Organization
  • A_CUSTSLSAREAADDRDEPDNTINFO.MANDT == TVKO.MANDT
  • A_CUSTSLSAREAADDRDEPDNTINFO.SALESORGANIZATION == TVKO.VKORG