A065

Customer Hierarchy/Material | #masterdata | Component: Conditions
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
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
KNUMH Number of the Condition Record KNUMH
Master Data Relations Join Conditions
Customer
  • A065.MANDT == KNA1.MANDT
  • A065.HIENR == KNA1.KUNNR
Application A065.KAPPL == T681A.KAPPL
Condition Type
  • Application
  • Condition Type
  • Client
  • A065.KAPPL == T685A.KAPPL
  • A065.KSCHL == T685A.KSCHL
  • A065.MANDT == T685A.MANDT
Client A065.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • A065.MATNR == MARA.MATNR
  • A065.MANDT == MARA.MANDT
Division
  • A065.MANDT == TSPA.MANDT
  • A065.SPART == TSPA.SPART
Sales Organization
  • A065.MANDT == TVKO.MANDT
  • A065.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • A065.VTWEG == TVTW.VTWEG
  • A065.MANDT == TVTW.MANDT