WALE SAP (Material to store assignment to promotion) Table details

Dictionary Type: Table
Description: Material to store assignment to promotion




ABAP Code to SELECT data from WALE
Related tables to WALE
Access table WALE




Table field list including key, data, relationships and ABAP select examples

WALE is a standard SAP Table which is used to store Material to store assignment to promotion data and is available within R/3 SAP systems depending on the version and release level.

The WALE table consists of various fields, each holding specific information or linking keys about Material to store assignment to promotion data available in SAP. These include AKTNR (COUPON), ARTNR (Material Number), MEBME (Sales unit), KUNNR (Customer Number for Plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP WALE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
ARTNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MEBMESales unit W_MEBMEUNIT3T006CUNITMEINS
KUNNRCustomer Number for Plant LOCNRCHAR10KNA1ALPHAKUNNRKUN
CLINTInternal Class Number CLINTNUMC10KLAHCLINT
WALNRPlant - material of promotion in message control WA_WALNRNUMC10WA_NUM10
AKTHEPromotion theme W_AKTHECHAR4TWATTHEMA
ERLISError cat. after listing rule check ERLISCHAR1ERLIS
GENLIExecute generation if listing check error detected W_GENLICHAR1FLAG
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3T024EKGRPEKG
LIFNRVendor number W_LIFNRCHAR10LFA1ALPHALIFNR
LIFTYVendor Category - Retail W_LIFTYCHAR1LIFTY
VZWRKPlant number for vendor number of DC W_VZWERKCHAR4T001WWERKS
INFWKInfo record at plant level INFWKCHAR1XFELD
VZEKOPurchasing organization of distribution center VZEKORGCHAR4T024EEKORG
VZVKOSales organization of distribution center VZVKORGCHAR4TVKOVKORG
VZVTWDistribution channel of distribution center VZVTWEGCHAR2TVTWVTWEG
VZSPADivision of distribution center VZSPARTCHAR2TSPASPART
EXTLIExternal vendor W_EXTLICHAR10LFA1ALPHALIFNR
BZQFISupply Source Determination Status W_BZQFICHAR1BZQFA
BEKTBAnnouncement category - plant W_BEKTBCHAR4T626AAVIT
BEKTVAnnouncement category - distribution center W_BEKTVCHAR4T626AAVIT
ABDTBConfirmation request date AFIDTDATS8DATUM
RUDABReply date plant W_RUDABDATS8DATUM
RUDAVReply date DC W_RUDAVDATS8DATUM
RUSTBStatus of reply to announcement - plant W_RUSTBCHAR1XFELD
RUSTVStatus of reply to announcement - DC W_RUSTVCHAR1XFELD
BESTBConfirmation can be carried out for plant W_BESTBCHAR1XFELD
BESTVConfirmation can be carried out for DC W_BESTVCHAR1XFELD
AENDBSend change to plant W_AENDBCHAR1XFELD
AENDVSend change to DC W_AENDVCHAR1XFELD
PLEKPBasic purchase price (gross) per plant/material W_PLEKP_WALECURR11(2) PREIS
WAEEKPurchase price currency W_WAEEKCUKY5TCURCWAERS
PLVKPSales price for promotion item W_PLVKPCURR11(2) PREIS
WAELACurrency current promotion - planning W_WAELACUKY5TCURCWAERSFWS
EKDABPurchase price conditions valid from W_EKDABDATS8DATUM
EKDBIPurchase price conditions valid to W_EKDBIDATS8DATUM
VKDABOn Sale to Consumers From W_VKDABDATS8DATUM
VKDBIOn Sale To Consumers To W_VKDBIDATS8DATUM
SPANEMargin (net) in sales price calculation SPANECURR11(2) WERTV6
SPABRMargin (gross) in sales price calculation SPABRCURR11(2) WERTV6
AUFSGActual Markup in Sales Price Calculation AUFSGCURR11(2) WERTV6
VSPANNet warehouse margin W_SPANECURR11(2) WERTV6
VSPABGross warehouse margin W_SPABRCURR11(2) WERTV6
VAUFSWarehouse markup W_AUFSGCURR11(2) WERTV6
VABGMSales unit W_MEBMEUNIT3T006CUNITMEINS
VABGPTransfer price, distribution center W_VABGPCURR11(2) PREIS
PARKZPrice type indicator (gross, net) W_PARKZCHAR1W_PARKZ
EPEINPrice Unit EPEINDEC5DEC5
VZEPEPrice unit Transfer price DC W_VZEPEDEC5DEC5
VPEINSales price unit VPEINDEC5DEC5
MEBPROrder Price Unit (Purchasing) BBPRMUNIT3T006CUNITMEINS
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
LIGENListing generation status W_LIGENCHAR1LIGEN
AUGENAllocation table creation status W_AUGENCHAR1AKAST
VKGENSales price generation status W_VKGENCHAR1VKKPS
EKGENPurchase price generation status W_EKGENCHAR1EKKPS
BEGEBGeneration status of announcement - plant W_BEGEBCHAR1BEKST
BEGEVAnnouncement status - DC W_BEGEVCHAR1BEKST
BEDEBDetailed status of promotion announcement - plant W_BEDEBCHAR1BEDEB
BEDEVDetailed status of promotion announcement - DC W_BEDEVCHAR1ABAST
RELIFRegular Vendor RELIFCHAR1XFELD
ADGENAdditionals maintained W_ADGENCHAR1CHAR1
WMNGEQuantity requested by store WMNGEQUAN13(3) MENG13
AUFMECorrected/confirmed allocation quantity for a promotion item W_BESTMQUAN13(3) MENG13
PABBMPlanned Sales Qty. of Promotion Material in Sales Units W_PABBMQUAN13(3) MENGE
MIAMGMinimum order qty for promotional material W_MIAMGQUAN13(3) MENGE
EKPNNPurchase price (net/net) W_EKPNNCURR11(2) WERTV6
VKPNNSales price (net) W_VKPNNCURR11(2) WERTV6
ECKPKZIndicates whether price point tables should override price F_VKPKZCHAR1FLAG
PAUFMEPlanned allocation quantity for promotion item for a plant W_PAUFMEQUAN13(3) MENG13
ALIVOStarting date for activating DC transfer prices ALIVODATS8DATUM
ALIBIFinal date for activating DC transfer prices ALIBIDATS8DATUM
EPRGRPrice point group EPRGRCHAR6Assigned to domainEPRGREPG
NVKPStandard sales price at plant level W_NVKP_WALECURR11(2) PREIS
SPGRUReason for promotion block W_SPGRUCHAR1SPGRU

Key field Non-key field



How do I retrieve data from SAP table WALE using ABAP code

The following ABAP code Example will allow you to do a basic selection on WALE to SELECT all data from the table
DATA: WA_WALE TYPE WALE.

SELECT SINGLE *
FROM WALE
INTO CORRESPONDING FIELDS OF WA_WALE
WHERE...

How to access SAP table WALE

Within an ECC or HANA version of SAP you can also view further information about WALE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!