SAP Table WMFUD

Field string for markdown planning price phases

WMFUD (Field string for markdown planning price 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 WMFUD to other SAP tables.

WMFUD 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
UPOSN Sub-item number for item number W_UPOSN NUMC 6 0
VRKME Sales unit VRKME T006 UNIT 3 0
MDPRZ Markdown planning: percentage of initial sales price W_MDPRZ DEC 15 2
MDWRT Markdown value W_MDWRT CURR 13 2
MDROS Sales within a price phase as percentage of overall season W_MDROS DEC 15 2
DATAB Starting date of sales price in a price phase W_DATAB DATS 8 0
VKKPS Maintenance status of sales prices VKKPS CHAR 1 0
NULL Price not activated
A Price activated,condition created at plant level
B Price activated, condition created at distrib. chain level
C Changed price, not activated
D Price Activated, Conditions Created on Price List Level
PSALM Planned sales quantity in sales unit W_PSALM QUAN 13 3
PSALW Planned sales at retail price W_PSALW CURR 13 2
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
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
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
SPANE Margin (net) in Sales Price Calculation W_MDSPANE CURR 11 2
SPABR Margin (gross) in Sales Price Calculation W_MDSPABR CURR 11 2
SPWRT Gross margin W_SPWRT CURR 13 2
AUFSG Markup in Sales Price Calculation W_MDAUFSG CURR 11 2
VSPAN Net warehouse margin W_SPANE CURR 11 2
VSPAB Gross warehouse margin W_SPABR CURR 11 2
VAUFS Warehouse markup W_AUFSG CURR 11 2
VABGP Transfer price, distribution center W_VABGP CURR 11 2
SPANS Status of the retail margin displayed W_SPANS CHAR 1 0
NULL Still to be calculated
B Calculated
MDPER Markdown period in calendar days W_MDPER INT2 5 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
PRESW Planned Remaining Stock (Value) W_PRESW CURR 13 2
PRESM Planned Remaining Quantity W_PRESM2 QUAN 13 3
MAHIT Margin Loss W_MAHIT CURR 13 2
PSALA Markdown value W_MDWRT CURR 13 2
EKWVK Purchase price in sales price currency and sales unit W_EKWVK CURR 11 2
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
ARTNR Material Number MATNR CHAR 18 0
MDQTE Depreciation Quota W_MDQTE DEC 15 2
PCMV Remaining profit margin W_PCMV CURR 13 2
UPDKZ Update indicator UPDKZ_D CHAR 1 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
PMATN Pricing Reference Material PMATN CHAR 18 0
CUOBF Internal object number CUOBM NUMC 18 0
SATNR Cross-Plant Configurable Material SATNR CHAR 18 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

WMFUD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WMFUD BBPRM WMFUD BBPRM T006 Units of Measurement MSEHI
WMFUD BBPRM WMFUD MANDT T006 Units of Measurement MANDT
WMFUD CUREP WMFUD MANDT TCURC Currency Codes MANDT
WMFUD CUREP WMFUD CUREP TCURC Currency Codes WAERS
WMFUD CURVP WMFUD MANDT TCURC Currency Codes MANDT
WMFUD CURVP WMFUD CURVP TCURC Currency Codes WAERS
WMFUD MANDT WMFUD MANDT T000 Clients MANDT
WMFUD MFCNR WMFUD MANDT WMFH Markdown Planning - header data MANDT
WMFUD MFCNR WMFUD MFCNR WMFH Markdown Planning - header data MFCNR
WMFUD VKORG WMFUD MANDT TVKO Organizational Unit: Sales Organizations MANDT
WMFUD VKORG WMFUD VKORG TVKO Organizational Unit: Sales Organizations VKORG
WMFUD VRKME WMFUD MANDT T006 Units of Measurement MANDT
WMFUD VRKME WMFUD VRKME T006 Units of Measurement MSEHI
WMFUD VTWEG WMFUD VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WMFUD VTWEG WMFUD MANDT TVTW Organizational Unit: Distribution Channels MANDT