SAP Table WMFP
Markdown Planning - item data (materials)
WMFP (Markdown Planning - item data (materials)) 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 WMFP to other SAP tables.
WMFP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||
| MFCNR | Document no. of markdown plan | W_MFCNR | WMFH | CHAR | 10 | 0 | ||||||||||||||||||||||||
| POSNR | Item number | W_POSNR | NUMC | 6 | 0 | |||||||||||||||||||||||||
| ARTNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||||||||||||||
| VTLCU | Currency of distribution chain | W_VTLCU | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||
| ATTYP | Material Category | ATTYP | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||
| MPRNR | Markdown rule | W_MPRNR | WMPK | CHAR | 10 | 0 | ||||||||||||||||||||||||
| SATNR | Cross-Plant Configurable Material | SATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 | 0 | ||||||||||||||||||||||||
| SAITY | Rollout in a Season | SAITY | T6WSA | CHAR | 2 | 0 | ||||||||||||||||||||||||
| SAISO | Season Category | SAISO | T6WSP | CHAR | 4 | 0 | ||||||||||||||||||||||||
| SAISJ | Season Year | SAISJ | CHAR | 4 | 0 | |||||||||||||||||||||||||
| DATAB | Start date for first price in a markdown plan | F_DATFR | DATS | 8 | 0 | |||||||||||||||||||||||||
| PSALM | Planned sales quantity in sales unit | W_PSALM | QUAN | 13 | 3 | |||||||||||||||||||||||||
| PANFM | Planned initial stock | W_PANFM2 | QUAN | 13 | 3 | |||||||||||||||||||||||||
| CUREP | Purchase price currency | W_WAEEK | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||
| EPEIN | Price Unit | EPEIN | DEC | 5 | 0 | |||||||||||||||||||||||||
| BBPRM | Order Price Unit (Purchasing) | BBPRM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||
| CURVP | Sales price currency | W_CURVP | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||
| EKPGR | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11 | 2 | |||||||||||||||||||||||||
| EKWVK | Purchase price in sales price currency and sales unit | W_EKWVK | CURR | 11 | 2 | |||||||||||||||||||||||||
| EKPNN | Sales Pricing: Purchase Price (Net/Net) | EKPNN | CURR | 11 | 2 | |||||||||||||||||||||||||
| VKPBR | Sales price (gross) | VKPBR | CURR | 11 | 2 | |||||||||||||||||||||||||
| ENDPR | Final price | ENDPR | CURR | 11 | 2 | |||||||||||||||||||||||||
| PRESM | Planned Remaining Quantity | W_PRESM2 | QUAN | 13 | 3 | |||||||||||||||||||||||||
| PSALC | Planned sales at purchase price | W_PSALC | CURR | 13 | 2 | |||||||||||||||||||||||||
| PSALP | Planned sales at delivered price/net/net purchase price | W_PSALP | CURR | 13 | 2 | |||||||||||||||||||||||||
| PSALW | Planned sales at retail price | W_PSALW | CURR | 13 | 2 | |||||||||||||||||||||||||
| PRESW | Planned Remaining Stock (Value) | W_PRESW | CURR | 13 | 2 | |||||||||||||||||||||||||
| CMUIV | Weighted stock margin for all price phases | W_CMUIV | CURR | 11 | 2 | |||||||||||||||||||||||||
| MAHIT | Margin Loss | W_MAHIT | CURR | 13 | 2 | |||||||||||||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||
| LIFNR | Vendor number | W_LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||
| PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||
| VKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| SPWRT | Gross margin | W_SPWRT | CURR | 13 | 2 | |||||||||||||||||||||||||
WMFP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WMFP | AKTNR | WMFP | MANDT | WAKH | Promotion Header Data, IS-R | MANDT |
| WMFP | AKTNR | WMFP | AKTNR | WAKH | Promotion Header Data, IS-R | AKTNR |
| WMFP | ARTNR | WMFP | MANDT | MARA | General Material Data | MANDT |
| WMFP | ARTNR | WMFP | ARTNR | MARA | General Material Data | MATNR |
| WMFP | BBPRM | WMFP | BBPRM | T006 | Units of Measurement | MSEHI |
| WMFP | BBPRM | WMFP | MANDT | T006 | Units of Measurement | MANDT |
| WMFP | CUREP | WMFP | MANDT | TCURC | Currency Codes | MANDT |
| WMFP | CUREP | WMFP | CUREP | TCURC | Currency Codes | WAERS |
| WMFP | CURVP | WMFP | CURVP | TCURC | Currency Codes | WAERS |
| WMFP | CURVP | WMFP | MANDT | TCURC | Currency Codes | MANDT |
| WMFP | LIFNR | WMFP | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| WMFP | LIFNR | WMFP | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| WMFP | MANDT | WMFP | MANDT | T000 | Clients | MANDT |
| WMFP | MFCNR | WMFP | MANDT | WMFH | Markdown Planning - header data | MANDT |
| WMFP | MFCNR | WMFP | MFCNR | WMFH | Markdown Planning - header data | MFCNR |
| WMFP | MPRNR | WMFP | MANDT | WMPK | Markdown rule header | MANDT |
| WMFP | MPRNR | WMFP | MPRNR | WMPK | Markdown rule header | MPRNR |
| WMFP | PMATN | WMFP | MANDT | MARA | General Material Data | MANDT |
| WMFP | PMATN | WMFP | PMATN | MARA | General Material Data | MATNR |
| WMFP | SAISO | WMFP | MANDT | T6WSP | Check Table for Season Indicator | MANDT |
| WMFP | SAISO | WMFP | SAISO | T6WSP | Check Table for Season Indicator | SAISO |
| WMFP | SAITY | WMFP | MANDT | T6WSA | Categories of seasonal materials | MANDT |
| WMFP | SAITY | WMFP | SAITY | T6WSA | Categories of seasonal materials | SAITY |
| WMFP | SATNR | WMFP | MANDT | MARA | General Material Data | MANDT |
| WMFP | SATNR | WMFP | SATNR | MARA | General Material Data | MATNR |
| WMFP | VKORG | WMFP | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| WMFP | VKORG | WMFP | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| WMFP | VRKME | WMFP | MANDT | T006 | Units of Measurement | MANDT |
| WMFP | VRKME | WMFP | VRKME | T006 | Units of Measurement | MSEHI |
| WMFP | VTLCU | WMFP | MANDT | TCURC | Currency Codes | MANDT |
| WMFP | VTLCU | WMFP | VTLCU | TCURC | Currency Codes | WAERS |
| WMFP | VTWEG | WMFP | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| WMFP | VTWEG | WMFP | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
