KOTD020

EAN/GV Type/Sales org./Distr. Chl/Division/County/Customer | #masterdata | Component: Material Determination
Column Name Description
MANDT FK Client
KAPPL FK Application
KSCHL FK Material Determination Type
GTIN International Article Number (EAN/UPC)
GTIN_V_TYPE FK GTIN Variant Type
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
LAND1 FK Destination Country/Region
KUNNR FK Customer number
DATBI Validity end date of the condition record
Column Name Description
Column Name Description
Column Name Description
DATBI Validity end date of the condition record
DATAB Validity start date of the condition record
Column Name Description
Column Name Description Domain name
KNUMH Number of the Condition Record KNUMH
Master Data Relations Join Conditions
GTIN Variant Type
Application KOTD020.KAPPL == T681A.KAPPL
Material Determination Type
  • Material Determination Type
  • Client
  • ?
  • Application
  • KOTD020.KSCHL == T685.KSCHL
  • KOTD020.MANDT == T685.MANDT
  • KOTD020.[column in domain "KVEWE"] == T685.KVEWE
  • KOTD020.KAPPL == T685.KAPPL
Customer number
  • KOTD020.MANDT == KNA1.MANDT
  • KOTD020.KUNNR == KNA1.KUNNR
Destination Country/Region
  • Destination Country/Region
  • Client
  • KOTD020.LAND1 == T005.LAND1
  • KOTD020.MANDT == T005.MANDT
Client KOTD020.MANDT == T000.MANDT
Division
  • KOTD020.MANDT == TSPA.MANDT
  • KOTD020.SPART == TSPA.SPART
Sales Organization
  • KOTD020.MANDT == TVKO.MANDT
  • KOTD020.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KOTD020.VTWEG == TVTW.VTWEG
  • KOTD020.MANDT == TVTW.MANDT