SAP WMFU Markdown planning - price phases per material/un Table
Overview
WMFU is a standard SAP S/4HANA table that stores Markdown planning - price phases per material/un data. There are total 41 fields in the WMFU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WMFU belongs to Seasonal / Promotion Planning (LO-RFM-MD-PR) module and is located in the package Application development R/3 Promotions (WAKT).
In addition, following links provide an overview of foreign key relationships, if any, that link WMFU to other SAP tables and standard CDS views available based on WMFU table in S/4HANA 2020.
Techincal Settings of WMFU
Below are technical details of the table WMFU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WMFU Fields
The following table gives you an overview of the fields available in WMFU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| MFCNR | Document no. of markdown plan | W_MFCNR | WMFH | CHAR | 10 |
| POSNR | Item number | W_POSNR | NUMC | 6 | |
| UPOSN | Sub-item number for item number | W_UPOSN | NUMC | 6 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| MDPRZ | Markdown planning: percentage of initial sales price | W_MDPRZ | DEC | 15 | |
| MDWRT | Markdown value | W_MDWRT | CURR | 13 | |
| MDROS | Sales within a price phase as percentage of overall season | W_MDROS | DEC | 15 | |
| DATAB | Starting date of sales price in a price phase | W_DATAB | DATS | 8 | |
| VKKPS | Maintenance status of sales prices | VKKPS | CHAR | 1 | |
| PSALM | Planned sales quantity in sales unit | W_PSALM | QUAN | 13 | |
| PSALW | Planned sales at retail price | W_PSALW | CURR | 13 | |
| PSALC | Planned sales at purchase price | W_PSALC | CURR | 13 | |
| PSALP | Planned sales at delivered price/net/net purchase price | W_PSALP | CURR | 13 | |
| PANFM | Planned initial stock | W_PANFM2 | QUAN | 13 | |
| CUREP | Purchase price currency | W_WAEEK | TCURC | CUKY | 5 |
| EPEIN | Price unit | EPEIN | DEC | 5 | |
| BBPRM | Order Price Unit (Purchasing) | BBPRM | T006 | UNIT | 3 |
| CURVP | Sales price currency | W_CURVP | TCURC | CUKY | 5 |
| EKPGR | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11 | |
| EKPNN | Sales Pricing: Purchase Price (Net/Net) | EKPNN | CURR | 11 | |
| VKPBR | Sales price (gross) | VKPBR | CURR | 11 | |
| ENDPR | Final price | ENDPR | CURR | 11 | |
| SPANE | Margin (net) in Sales Price Calculation | W_MDSPANE | CURR | 11 | |
| SPABR | Margin (gross) in Sales Price Calculation | W_MDSPABR | CURR | 11 | |
| SPWRT | Gross margin | W_SPWRT | CURR | 13 | |
| AUFSG | Markup in Sales Price Calculation | W_MDAUFSG | CURR | 11 | |
| VSPAN | Net warehouse margin | W_SPANE | CURR | 11 | |
| VSPAB | Gross warehouse margin | W_SPABR | CURR | 11 | |
| VAUFS | Warehouse markup | W_AUFSG | CURR | 11 | |
| VABGP | Transfer price distribution center | W_VABGP | CURR | 11 | |
| SPANS | Status of the retail margin displayed | W_SPANS | CHAR | 1 | |
| MDPER | Markdown period in calendar days | W_MDPER | INT2 | 5 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| PRESW | Planned Remaining Stock (Value) | W_PRESW | CURR | 13 | |
| PRESM | Planned Remaining Quantity | W_PRESM2 | QUAN | 13 | |
| MAHIT | Margin Loss | W_MAHIT | CURR | 13 | |
| PSALA | Markdown value | W_MDWRT | CURR | 13 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WMFU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WMFU | BBPRM | C: N | T006 |
| WMFU | CUREP | C: N | TCURC |
| WMFU | CURVP | C: N | TCURC |
| WMFU | MANDT | 1: N | T000 |
| WMFU | MFCNR | 1: N | WMFH |
| WMFU | VRKME | C: N | T006 |