WELP

Competitor: Price Entry Document (Item) | #transactional | Component: Retail-Pricing
Column Name Description
MANDT FK Client
MBELN FK Competitor: document number of price entry document
MBELP Item number of competitor price entry document
Column Name Description
💲 Currency Key (MWAER):
MBETR Condition Amount or Percentage
Column Name Description
Column Name Description
VKKAB Sales conditions valid from
VKKBI Sales conditions valid to
Column Name Description
BPSTA Item status for competitor price entry document Show values
Column Name Description Domain name
ERWRK Competitor prices: entry plant WERKS
ERLNR Competitor prices: number of entry list NUMC5
MBWNR Customer number of competitor KUNNR
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
WERKS Plant WERKS
KVEWE Usage of the condition table KVEWE
KAPPL Application KAPPL
KSCHL Condition Type KSCHL
KOTABNR Number of the Condition Table KOTABNR
KDUMMY Dummy function in length 1 DUMMY
MATNR Material Number MATNR
MPEIN Condition Pricing Unit KPEIN
KNUMH Number of the Condition Record KNUMH
PDUMMY Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Client WELP.MANDT == T000.MANDT
Condition Unit
  • WELP.MANDT == T006.MANDT
  • WELP.MMEIN == T006.MSEHI
Currency Key
  • WELP.MANDT == TCURC.MANDT
  • WELP.MWAER == TCURC.WAERS
Price List Type
  • WELP.MANDT == T189.MANDT
  • WELP.PLTYP == T189.PLTYP