SAP Table WAELD

Screen Field String for Promotion Delivery Phases

WAELD (Screen Field String for Promotion Delivery Phases) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WAELD to other SAP tables.

WAELD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
ARTNR Material Number MATNR MARA CHAR 18 0
MEBME Sales unit W_MEBME T006 UNIT 3 0
KUNNR Customer Number for Plant LOCNR KNA1 CHAR 10 0
LWNUM Serial number LFNR3 NUMC 3 0
WERKS Plant in SAP Retail (store/DC) WERKW CHAR 4 0
WEDAT Delivery date LFDAT DATS 8 0
WETYP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
WEUZT Delivery Date Time-Spot LZEIT TIMS 6 0
WEPRZ Delivery phase in percent of total qty LWPRZ NUMC 3 0
0
AUFME Corrected/confirmed allocation quantity for a promotion item W_BESTM QUAN 13 3
WMNGE Quantity requested by store WMNGE QUAN 13 3
PAUFME Planned allocation quantity for promotion item for a plant W_PAUFME QUAN 13 3
PABBM Planned Sales Qty. of Promotion Material in Sales Units W_PABBM QUAN 13 3
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
RUSTB Status of reply to announcement - plant W_RUSTB CHAR 1 0
X Yes
NULL No
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
UPDKZ Update indicator UPDKZ_D CHAR 1 0
CPRZ Flag Percentage Change CPRZ CHAR 1 0
CMEN Flag Quantity Change CMEN CHAR 1 0
P_WALE Pointer to an entry in an internal table W_TABIX INT4 10 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
PMATA Pricing Reference Material PMATN CHAR 18 0
BEDEB Detailed status of promotion announcement - plant W_BEDEB CHAR 1 0
NULL No announcement made
1 Announcement made, print open
2 Request created, reply open, no reminder necessary
3 Request created, reply open, reminder necessary
4 Request created, reminder created, reply open
5 Request created, reply received, confirmation open
6 Request created, reply received, confirmed qty missing
9 Completely created

WAELD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WAELD AKTNR WAELD MANDT WAKH Promotion Header Data, IS-R MANDT
WAELD AKTNR WAELD AKTNR WAKH Promotion Header Data, IS-R AKTNR
WAELD ARTNR WAELD MANDT MARA General Material Data MANDT
WAELD ARTNR WAELD ARTNR MARA General Material Data MATNR
WAELD KUNNR WAELD KUNNR KNA1 General Data in Customer Master KUNNR
WAELD KUNNR WAELD MANDT KNA1 General Data in Customer Master MANDT
WAELD MANDT WAELD MANDT T000 Clients MANDT
WAELD MEBME WAELD MEBME T006 Units of Measurement MSEHI
WAELD MEBME WAELD MANDT T006 Units of Measurement MANDT