KOTE004

Customer Hierarchy | #masterdata | Component: Rebate Processing
Column Name Description
MANDT FK Client
KAPPL FK Application
KSCHL FK Condition Type
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
HIENR FK Customer
DATBI Validity end date of the condition record
KNUMA FK Agreement (various conditions grouped together)
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
Customer
  • KOTE004.MANDT == KNA1.MANDT
  • KOTE004.HIENR == KNA1.KUNNR
Application KOTE004.KAPPL == T681A.KAPPL
Agreement (various conditions grouped together)
  • Agreement (various conditions grouped together)
  • Client
  • KOTE004.KNUMA == KONA.KNUMA
  • KOTE004.MANDT == KONA.MANDT
Condition Type
  • Condition Type
  • Client
  • ?
  • Application
  • KOTE004.KSCHL == T685.KSCHL
  • KOTE004.MANDT == T685.MANDT
  • KOTE004.[column in domain "KVEWE"] == T685.KVEWE
  • KOTE004.KAPPL == T685.KAPPL
Client KOTE004.MANDT == T000.MANDT
Division
  • KOTE004.MANDT == TSPA.MANDT
  • KOTE004.SPART == TSPA.SPART
Sales Organization
  • KOTE004.MANDT == TVKO.MANDT
  • KOTE004.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KOTE004.VTWEG == TVTW.VTWEG
  • KOTE004.MANDT == TVTW.MANDT