KOTE002

Customer/Rebate Group | #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
KUNNR FK Customer number
BONUS FK Volume rebate group
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
Volume rebate group
  • Volume rebate group
  • Client
  • KOTE002.BONUS == TVBO.BONUS
  • KOTE002.MANDT == TVBO.MANDT
Application KOTE002.KAPPL == T681A.KAPPL
Agreement (various conditions grouped together)
  • Agreement (various conditions grouped together)
  • Client
  • KOTE002.KNUMA == KONA.KNUMA
  • KOTE002.MANDT == KONA.MANDT
Condition Type
  • Condition Type
  • Client
  • ?
  • Application
  • KOTE002.KSCHL == T685.KSCHL
  • KOTE002.MANDT == T685.MANDT
  • KOTE002.[column in domain "KVEWE"] == T685.KVEWE
  • KOTE002.KAPPL == T685.KAPPL
Customer number
  • KOTE002.MANDT == KNA1.MANDT
  • KOTE002.KUNNR == KNA1.KUNNR
Client KOTE002.MANDT == T000.MANDT
Division
  • KOTE002.MANDT == TSPA.MANDT
  • KOTE002.SPART == TSPA.SPART
Sales Organization
  • KOTE002.MANDT == TVKO.MANDT
  • KOTE002.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KOTE002.VTWEG == TVTW.VTWEG
  • KOTE002.MANDT == TVTW.MANDT