KOTG004

Cust./Material w/ Organiz. Units | #masterdata | Component: Material Listing/Exclusion
Column Name Description
MANDT FK Client
KAPPL FK Application
KSCHL FK Material listing/exclusion type
VKORG FK Sales Organization
VTWEG FK Distribution Channel
KUNNR FK Customer number
MATNR FK Material 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
Master Data Relations Join Conditions
Application KOTG004.KAPPL == T681A.KAPPL
Material listing/exclusion type
  • Material listing/exclusion type
  • Client
  • ?
  • Application
  • KOTG004.KSCHL == T685.KSCHL
  • KOTG004.MANDT == T685.MANDT
  • KOTG004.[column in domain "KVEWE"] == T685.KVEWE
  • KOTG004.KAPPL == T685.KAPPL
Customer number
  • KOTG004.MANDT == KNA1.MANDT
  • KOTG004.KUNNR == KNA1.KUNNR
Client KOTG004.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • KOTG004.MATNR == MARA.MATNR
  • KOTG004.MANDT == MARA.MANDT
Sales Organization
  • KOTG004.MANDT == TVKO.MANDT
  • KOTG004.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KOTG004.VTWEG == TVTW.VTWEG
  • KOTG004.MANDT == TVTW.MANDT