WAAL SAP table for – Material-to-vendor assignment in price maintenance (promo.)

Here we would like to draw your attention to WAAL table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). WAAL is a SAP standard transparent table used for storing Material-to-vendor assignment in price maintenance (promo.) related data in SAP. It comes under the package WAKT.

SAP WAAL table

Table WAAL technical data

TableWAAL
Data storingMaterial-to-vendor assignment in price maintenance (promo.)
ModuleLO
ComponentLO-MD
SAP PackageWAKT
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WAAL Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in WAAL table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • RELIF
    Its data type is C (Character String) with field length 1
  • VZWRK
    Its data type is C (Character String) with field length 4
  • BZQFI
    Its data type is C (Character String) with field length 1
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • PLEKP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • WAEEK
    Its data type is C (Character String) with field length 5
  • EPEIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MEBPR
    Its data type is C (Character String) with field length 3
  • EKKPS
    Its data type is C (Character String) with field length 1
  • NAME1 : Name 1
    Its data type is C (Character String) with field length 35
  • AKTNR
    Its a key field. Its data type is C (Character String) with field length 10
  • EXTLI
    Its data type is C (Character String) with field length 10
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ARTNR
    Its a key field. Its data type is C (Character String) with field length 18
  • MEBME
    Its a key field. Its data type is C (Character String) with field length 3
  • LIFNR : Vendor’s account number
    Its a key field. Its data type is C (Character String) with field length 10
  • EKORG : Purchasing organization
    Its a key field. Its data type is C (Character String) with field length 4
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • LIFTY
    Its data type is C (Character String) with field length 1