SAP Table WMFH
Markdown Planning - header data
WMFH (Markdown Planning - header data) 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 WMFH to other SAP tables.
WMFH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MFCNR | Document no. of markdown plan | W_MFCNR | CHAR | 10 | 0 | |||||||
| DATFR | Start date for first price in a markdown plan | F_DATFR | DATS | 8 | 0 | |||||||
| DATTO | Final date for last price in a markdown plan | F_DATTO | DATS | 8 | 0 | |||||||
| MPRNR | Markdown rule | W_MPRNR | WMPK | CHAR | 10 | 0 | ||||||
| VKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | 0 |
Possible values
|
||||||
| ROUND | Indicator: Always Round Down Prices in Markdown Plan | W_ROUNDOFF | CHAR | 1 | 0 |
Possible values
|
||||||
| MFART | Markdown Type in Markdown Planning | W_MFART | TMFA | CHAR | 4 | 0 | ||||||
| ISVAR | ID for data variant | F_ISVAR | CHAR | 10 | 0 | |||||||
| PLWAE | Planning currency for markdown planning | F_PLWAE | TCURC | CUKY | 5 | 0 | ||||||
| SPVKO | Sales Organization for Suggested Sales Price | W_MDSPVKO | TVKO | CHAR | 4 | 0 | ||||||
| SPVTW | Distribution Channel for Suggested Sales Price | W_MDSPVTW | TVTW | CHAR | 2 | 0 | ||||||
| SPPLT | Price List of Default Sales Price | W_MDSPPLT | T189 | CHAR | 2 | 0 | ||||||
| SPKNR | Plant-Based Customer no. for Suggested Sales Price | W_MDSPKNR | KNA1 | CHAR | 10 | 0 | ||||||
| SPWRK | Plant for Suggested Sales Price | W_SPWRK | T001W | CHAR | 4 | 0 | ||||||
| NPERI | Number of Previous Periods for Analysis Period | W_MCPER | NUMC | 3 | 0 | |||||||
| 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 | |||||||
WMFH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WMFH | MANDT | WMFH | MANDT | T000 | Clients | MANDT |
| WMFH | MFART | WMFH | MANDT | TMFA | Markdown Planning - Markdown type | MANDT |
| WMFH | MFART | WMFH | MFART | TMFA | Markdown Planning - Markdown type | MFART |
| WMFH | MPRNR | WMFH | MPRNR | WMPK | Markdown rule header | MPRNR |
| WMFH | MPRNR | WMFH | MANDT | WMPK | Markdown rule header | MANDT |
| WMFH | PLWAE | WMFH | MANDT | TCURC | Currency Codes | MANDT |
| WMFH | PLWAE | WMFH | PLWAE | TCURC | Currency Codes | WAERS |
| WMFH | SPKNR | WMFH | MANDT | KNA1 | General Data in Customer Master | MANDT |
| WMFH | SPKNR | WMFH | SPKNR | KNA1 | General Data in Customer Master | KUNNR |
| WMFH | SPPLT | WMFH | SPPLT | T189 | Conditions: Price List Categories | PLTYP |
| WMFH | SPPLT | WMFH | MANDT | T189 | Conditions: Price List Categories | MANDT |
| WMFH | SPVKO | WMFH | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| WMFH | SPVKO | WMFH | SPVKO | TVKO | Organizational Unit: Sales Organizations | VKORG |
| WMFH | SPVTW | WMFH | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| WMFH | SPVTW | WMFH | SPVTW | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| WMFH | SPWRK | WMFH | MANDT | T001W | Plants/Branches | MANDT |
| WMFH | SPWRK | WMFH | SPWRK | T001W | Plants/Branches | WERKS |
