KOTE001

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