C_BPCustSlsAreaAddrDepdntInfo

Consumption view for sales are adrdep | view: CCUSSLSADDRDEPTP | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, KNA1, CVI_CUST_LINK, KNVV_ADDR
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
AddressID FK Business Partner Address Number (from BUT020)
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
ShippingCondition Shipping Conditions VSBED
SupplyingPlant Delivering Plant (Own or External) WERKS
DeliveryIsBlocked Customer delivery block (sales area) LIFSP
FormattedAddress null
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.ADDRESSID == BUT020.ADDRNUMBER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == BUT020.CLIENT
Business Partner Address Number (from BUT020)
  • ?
  • Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.[column in domain "BU_PARTNER"] == BUT020.PARTNER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.ADDRESSIDFOREDIT == BUT020.ADDRNUMBER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.ADDRESSID == BUT020.ADDRNUMBER
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == BUT020.CLIENT
Customer key
  • Customer Number
  • Customer Number
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.CUSTOMERFOREDIT == KNA1.KUNNR
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.CUSTOMER == KNA1.KUNNR
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == KNA1.MANDT
Customer key
  • Customer Number
  • Customer Number
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.CUSTOMERFOREDIT == KNA1.KUNNR
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.CUSTOMER == KNA1.KUNNR
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == KNA1.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.DIVISION == TSPA.SPART
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == TSPA.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.INCOTERMSVERSION == TINCV.INCOV
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == TINCV.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.MANDT == TVKO.MANDT
  • C_BPCUSTSLSAREAADDRDEPDNTINFO.SALESORGANIZATION == TVKO.VKORG