WALE SAP table for – Material to store assignment to promotion

Here we would like to draw your attention to WALE 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). WALE is a SAP standard transparent table used for storing Material to store assignment to promotion related data in SAP. It comes under the package WAKT.

SAP WALE table

Table WALE technical data

TableWALE
Data storingMaterial to store assignment to promotion
ModuleLO
ComponentLO-MD
SAP PackageWAKT
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WALE 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 WALE table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • GENLI
    Its data type is C (Character String) with field length 1
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • LIFTY
    Its data type is C (Character String) with field length 1
  • VZWRK
    Its data type is C (Character String) with field length 4
  • INFWK
    Its data type is C (Character String) with field length 1
  • AKTNR
    Its a key field. Its data type is C (Character String) with field length 10
  • VZEKO
    Its data type is C (Character String) with field length 4
  • VZVKO
    Its data type is C (Character String) with field length 4
  • VZVTW
    Its data type is C (Character String) with field length 2
  • VZSPA
    Its data type is C (Character String) with field length 2
  • EXTLI
    Its data type is C (Character String) with field length 10
  • BZQFI
    Its data type is C (Character String) with field length 1
  • BEKTB
    Its data type is C (Character String) with field length 4
  • BEKTV
    Its data type is C (Character String) with field length 4
  • ABDTB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • RUDAB
    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
  • RUDAV
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • RUSTB
    Its data type is C (Character String) with field length 1
  • RUSTV
    Its data type is C (Character String) with field length 1
  • BESTB
    Its data type is C (Character String) with field length 1
  • BESTV
    Its data type is C (Character String) with field length 1
  • AENDB
    Its data type is C (Character String) with field length 1
  • AENDV
    Its data type is C (Character String) with field length 1
  • 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
  • PLVKP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • MEBME
    Its a key field. Its data type is C (Character String) with field length 3
  • WAELA
    Its data type is C (Character String) with field length 5
  • EKDAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EKDBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VKDAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VKDBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SPANE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SPABR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • AUFSG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VSPAN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VSPAB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10
  • VAUFS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VABGM
    Its data type is C (Character String) with field length 3
  • VABGP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PARKZ : Indicator: inactive changes
    Its data type is C (Character String) with field length 1
  • EPEIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VZEPE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VPEIN
    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
  • 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
  • CLINT : Internal class number describing effectivity type
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • 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
  • LIGEN
    Its data type is C (Character String) with field length 1
  • AUGEN
    Its data type is C (Character String) with field length 1
  • VKGEN
    Its data type is C (Character String) with field length 1
  • EKGEN
    Its data type is C (Character String) with field length 1
  • BEGEB
    Its data type is C (Character String) with field length 1
  • BEGEV
    Its data type is C (Character String) with field length 1
  • BEDEB
    Its data type is C (Character String) with field length 1
  • BEDEV
    Its data type is C (Character String) with field length 1
  • WALNR
    Its data type is N (Character String with Digits Only) with field length 10
  • RELIF
    Its data type is C (Character String) with field length 1
  • ADGEN
    Its data type is C (Character String) with field length 1
  • WMNGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AUFME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PABBM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MIAMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EKPNN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VKPNN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ECKPKZ
    Its data type is C (Character String) with field length 1
  • PAUFME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AKTHE
    Its data type is C (Character String) with field length 4
  • ALIVO
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ALIBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EPRGR
    Its data type is C (Character String) with field length 6
  • NVKP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SPGRU
    Its data type is C (Character String) with field length 1
  • ERLIS
    Its data type is C (Character String) with field length 1