KNVV_ADDR

Customer Master Sales Data - Address dep. attributes | #masterdata | Component: Customer Master
Column Name Description
MANDT Client
KUNNR FK Customer Number
ADRNR FK Business Partner Address Number (from BUT020)
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
INCO1 Incoterms (Part 1) INCO1
LIFSD Customer delivery block (sales area) LIFSP
VKBUR Sales office VKBUR
VKGRP Sales group VKGRP
VSBED Shipping Conditions VSBED
VWERK Delivering Plant (Own or External) WERKS
INCO2_L Incoterms Location 1 INCO_L
INCO3_L Incoterms Location 2 INCO_L
KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility KNVV_ADDR_EEW_CUST
Master Data Relations Join Conditions
Business Partner Address Number (from BUT020)
  • Business Partner Address Number (from BUT020)
  • ?
  • KNVV_ADDR.MANDT == BUT020.CLIENT
  • KNVV_ADDR.ADRNR == BUT020.ADDRNUMBER
  • KNVV_ADDR.[column in domain "BU_PARTNER"] == BUT020.PARTNER
Incoterms Version
  • Incoterms Version
  • Client
  • KNVV_ADDR.INCOV == TINCV.INCOV
  • KNVV_ADDR.MANDT == TINCV.MANDT
Customer key
  • KNVV_ADDR.MANDT == KNA1.MANDT
  • KNVV_ADDR.KUNNR == KNA1.KUNNR
Division
  • KNVV_ADDR.MANDT == TSPA.MANDT
  • KNVV_ADDR.SPART == TSPA.SPART
Sales Organization
  • KNVV_ADDR.MANDT == TVKO.MANDT
  • KNVV_ADDR.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KNVV_ADDR.VTWEG == TVTW.VTWEG
  • KNVV_ADDR.MANDT == TVTW.MANDT