WAAL

Material-to-vendor assignment in price maintenance (promo.) | #masterdata | Component: Seasonal / Promotion Planning
Column Name Description
MANDT FK Client
AKTNR FK Promotion
ARTNR FK Material Number
MEBME FK Sales unit
LIFNR FK Supplier Number
EKORG FK Purchasing organization
KUNNR FK Customer Number for Plant
Column Name Description
💲 Purchase price currency (WAEEK):
PLEKP Purchase price for promotion item
Column Name Description
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
Column Name Description
LIFTY Supplier Category - Retail Show values
RELIF Regular Supplier Show values
BZQFI ID: how source of supply is determined Show values
EKKPS Maintenance status of purchase price conditions Show values
Column Name Description Domain name
EPEIN Price unit DEC5
NAME1 Name 1 NAME
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WAAL.AKTNR == WAKH.AKTNR
  • WAAL.MANDT == WAKH.MANDT
Material Number
  • Material Number
  • Client
  • WAAL.ARTNR == MARA.MATNR
  • WAAL.MANDT == MARA.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • WAAL.EKGRP == T024.EKGRP
  • WAAL.MANDT == T024.MANDT
Purchasing organization
  • WAAL.MANDT == T024E.MANDT
  • WAAL.EKORG == T024E.EKORG
External Supplier
  • WAAL.MANDT == LFA1.MANDT
  • WAAL.EXTLI == LFA1.LIFNR
Customer Number for Plant
  • WAAL.MANDT == KNA1.MANDT
  • WAAL.KUNNR == KNA1.KUNNR
Supplier Number
  • WAAL.MANDT == LFA1.MANDT
  • WAAL.LIFNR == LFA1.LIFNR
Client WAAL.MANDT == T000.MANDT
Sales unit
  • WAAL.MANDT == T006.MANDT
  • WAAL.MEBME == T006.MSEHI
Order Price Unit (Purchasing)
  • WAAL.MANDT == T006.MANDT
  • WAAL.MEBPR == T006.MSEHI
Plant Number for Supplier Number of DC
  • WAAL.MANDT == T001W.MANDT
  • WAAL.VZWRK == T001W.WERKS
Purchase price currency
  • WAAL.MANDT == TCURC.MANDT
  • WAAL.WAEEK == TCURC.WAERS
Plant
  • WAAL.MANDT == T001W.MANDT
  • WAAL.WERKS == T001W.WERKS