WALED SAP (Processing of records in WALE table) Structure details

Dictionary Type: Structure
Description: Processing of records in WALE table




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




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

WALED is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Processing of records in WALE table" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_WALED TYPE WALED.

The WALED table consists of various fields, each holding specific information or linking keys about Processing of records in WALE table data available in SAP. These include MANDT (Client), AKTNR (COUPON), ARTNR (Material Number), MEBME (Sales unit).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP WALED structure 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
SELKZSelection flag SELKZCHAR1SELKZ
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ
P_WAKPPointer to an entry in an internal table W_TABIXINT410W_TABIX
P_WAGUPointer to an entry in an internal table W_TABIXINT410W_TABIX
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
PMATAPricing Reference Material PMATNCHAR18Assigned to domainMATN1MATNRMAT
EKKPSMaintenance status of purchase price conditions W_EKKPSCHAR1EKKPS
VKKPSMaintenance status of sales price conditions W_VKKPSCHAR1VKKPS
KALKEActivation type for sales prices W_AKTARTCHAR1AKTART
KALKRReference record for price calculation is used W_KALKRCHAR1XFELD
IMNGUConfirmed qty of plant IMNGUQUAN13(3) MENG13
PMNGUPlanned allocation quantity for an allocation table item W_PMNGUQUAN13(3) MENG13
MEAUFAllocation table unit W_MEAUFUNIT3Assigned to domainCUNITMEINS
VZKPSMaintenance status of DC conditions W_VZKPSCHAR1VZKPS
ADDELAdditional deleted W_ADDELCHAR1CHAR1
REB_STATUSDiscount Status REB_STATUSCHAR1REB_STATUS

Key field Non-key field



How do I retrieve data from SAP structure WALED using ABAP code?

As WALED is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WALED as there is no data to select.

How to access SAP table WALED

Within an ECC or HANA version of SAP you can also view further information about WALED 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!