SAP WMFP Markdown Planning - item data (materials) Table
Overview
WMFP is a standard SAP S/4HANA table that stores Markdown Planning - item data (materials) data. There are total 42 fields in the WMFP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WMFP 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 WMFP to other SAP tables and standard CDS views available based on WMFP table in S/4HANA 2020.
Techincal Settings of WMFP
Below are technical details of the table WMFP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WMFP Fields
The following table gives you an overview of the fields available in WMFP
| 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 | |
| ARTNR | Material Number | MATNR | MARA | CHAR | 40 |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| VTLCU | Currency of distribution chain | W_VTLCU | TCURC | CUKY | 5 |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| MPRNR | Markdown rule | W_MPRNR | WMPK | CHAR | 10 |
| SATNR | Cross-Plant Configurable Material | SATNR | MARA | CHAR | 40 |
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 |
| SAITY | Rollout in a Season | SAITY | T6WSA | CHAR | 2 |
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 |
| SAISJ | Season Year | SAISJ | CHAR | 4 | |
| DATAB | Start date for first price in a markdown plan | F_DATFR | DATS | 8 | |
| PSALM | Planned sales quantity in sales unit | W_PSALM | QUAN | 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 | |
| EKWVK | Purchase price in sales price currency and sales unit | W_EKWVK | 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 | |
| PRESM | Planned Remaining Quantity | W_PRESM2 | QUAN | 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 | |
| PSALW | Planned sales at retail price | W_PSALW | CURR | 13 | |
| PRESW | Planned Remaining Stock (Value) | W_PRESW | CURR | 13 | |
| CMUIV | Weighted stock margin for all price phases | W_CMUIV | CURR | 11 | |
| MAHIT | Margin Loss | W_MAHIT | CURR | 13 | |
| 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 | |
| LIFNR | Supplier Number | W_LIFNR | LFA1 | CHAR | 10 |
| PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 40 |
| VKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | |
| SPWRT | Gross margin | W_SPWRT | 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 WMFP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WMFP | AKTNR | 1: CN | WAKH |
| WMFP | ARTNR | 1: N | MARA |
| WMFP | BBPRM | C: N | T006 |
| WMFP | CUREP | C: N | TCURC |
| WMFP | CURVP | C: N | TCURC |
| WMFP | LIFNR | 1: CN | LFA1 |
| WMFP | MANDT | 1: N | T000 |
| WMFP | MFCNR | 1: N | WMFH |
| WMFP | MPRNR | 1: CN | WMPK |
| WMFP | PMATN | 1: CN | MARA |
| WMFP | SAISO | 1: CN | T6WSP |
| WMFP | SAITY | : | T6WSA |
| WMFP | SATNR | C: N | MARA |
| WMFP | VKORG | 1: N | TVKO |
| WMFP | VRKME | C: N | T006 |
| WMFP | VTLCU | 1: CN | TCURC |
| WMFP | VTWEG | 1: N | TVTW |