WMFU

Markdown planning - price phases per material/un | #masterdata | Component: Seasonal / Promotion Planning
Column Name Description
MANDT FK Client
MFCNR FK Document no. of markdown plan
POSNR Item number
UPOSN Sub-item number for item number
Column Name Description
💲 Sales price currency (CURVP):
MDWRT Markdown value
PSALW Planned sales at retail price
PSALC Planned sales at purchase price
VKPBR Sales price (gross)
ENDPR Final price
SPWRT Gross margin
VSPAN Net warehouse margin
VSPAB Gross warehouse margin
VAUFS Warehouse markup
VABGP Transfer price, distribution center
PSALA Markdown value
💲 Purchase price currency (CUREP):
PSALP Planned sales at delivered price/net/net purchase price
EKPGR Purchase Price Calculation: (Basic Purchase Price)
EKPNN Sales Pricing: Purchase Price (Net/Net)
SPANE Margin (net) in Sales Price Calculation
SPABR Margin (gross) in Sales Price Calculation
AUFSG Markup in Sales Price Calculation
PRESW Planned Remaining Stock (Value)
MAHIT Margin Loss
Column Name Description
📏 Sales unit (VRKME):
PSALM Planned sales quantity in sales unit
PANFM Planned initial stock
PRESM Planned Remaining Quantity
Column Name Description
DATAB Starting date of sales price in a price phase
ERDAT Date on which the record was created
AEDAT Last Changed On
Column Name Description
VKKPS Maintenance status of sales prices Show values
SPANS Status of the retail margin displayed Show values
Column Name Description Domain name
MDPRZ Markdown planning: percentage of initial sales price PROZV8
MDROS Sales within a price phase as percentage of overall season PROZV8
EPEIN Price unit DEC5
MDPER Markdown period in calendar days INT2
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Order Price Unit (Purchasing)
  • WMFU.MANDT == T006.MANDT
  • WMFU.BBPRM == T006.MSEHI
Purchase price currency
  • WMFU.MANDT == TCURC.MANDT
  • WMFU.CUREP == TCURC.WAERS
Sales price currency
  • WMFU.MANDT == TCURC.MANDT
  • WMFU.CURVP == TCURC.WAERS
Client WMFU.MANDT == T000.MANDT
Document no. of markdown plan
  • Document no. of markdown plan
  • Client
  • WMFU.MFCNR == WMFH.MFCNR
  • WMFU.MANDT == WMFH.MANDT
Sales unit
  • WMFU.MANDT == T006.MANDT
  • WMFU.VRKME == T006.MSEHI