A147

Customer Hierarchy (Sales Deal) | #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
VKBUR FK Sales office
VKGRP FK Sales group
KDGRP FK Customer Group
KUNRG FK Payer
KUNAG FK Sold-to Party
KUNWE FK Ship-to Party
KNUMA_AG FK Sales Deal
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
KEXCL_D Indicator condition exclusive Show values
Column Name Description Domain name
KNUMH Number of the Condition Record KNUMH
Master Data Relations Join Conditions
Application A147.KAPPL == T681A.KAPPL
Customer Group
  • Customer Group
  • Client
  • A147.KDGRP == T151.KDGRP
  • A147.MANDT == T151.MANDT
Sales Deal
  • Sales Deal
  • Client
  • A147.KNUMA_AG == KONA.KNUMA
  • A147.MANDT == KONA.MANDT
Condition Type
  • Condition Type
  • Client
  • ?
  • Application
  • A147.KSCHL == T685.KSCHL
  • A147.MANDT == T685.MANDT
  • A147.[column in domain "KVEWE"] == T685.KVEWE
  • A147.KAPPL == T685.KAPPL
Sold-to Party
  • A147.MANDT == KNA1.MANDT
  • A147.KUNAG == KNA1.KUNNR
Payer
  • A147.MANDT == KNA1.MANDT
  • A147.KUNRG == KNA1.KUNNR
Ship-to Party
  • A147.MANDT == KNA1.MANDT
  • A147.KUNWE == KNA1.KUNNR
Client A147.MANDT == T000.MANDT
Division
  • A147.MANDT == TSPA.MANDT
  • A147.SPART == TSPA.SPART
Sales office
  • Sales office
  • Client
  • A147.VKBUR == TVBUR.VKBUR
  • A147.MANDT == TVBUR.MANDT
Sales group
  • A147.MANDT == TVKGR.MANDT
  • A147.VKGRP == TVKGR.VKGRP
Sales Organization
  • A147.MANDT == TVKO.MANDT
  • A147.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • A147.VTWEG == TVTW.VTWEG
  • A147.MANDT == TVTW.MANDT