WMFP

Markdown Planning - item data (materials) | #masterdata | Component: Seasonal / Promotion Planning
Column Name Description
MANDT FK Client
MFCNR FK Document no. of markdown plan
POSNR Item number
Column Name Description
💲 Purchase price currency (CUREP):
EKPGR Purchase Price Calculation: (Basic Purchase Price)
EKPNN Sales Pricing: Purchase Price (Net/Net)
PSALP Planned sales at delivered price/net/net purchase price
EKWVK Purchase price in sales price currency and sales unit
SPWRT Gross margin
💲 Sales price currency (CURVP):
VKPBR Sales price (gross)
ENDPR Final price
PSALC Planned sales at purchase price
PSALW Planned sales at retail price
PRESW Planned Remaining Stock (Value)
CMUIV Weighted stock margin for all price phases
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 Start date for first price in a markdown plan
ERDAT Date on which the record was created
AEDAT Last Changed On
Column Name Description
ATTYP Material Category Show values
VKPKZ Indicates whether price point tables should override price Show values
Column Name Description Domain name
SAISJ Season Year CJAHR
EPEIN Price unit DEC5
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WMFP.AKTNR == WAKH.AKTNR
  • WMFP.MANDT == WAKH.MANDT
Material Number
  • Material Number
  • Client
  • WMFP.ARTNR == MARA.MATNR
  • WMFP.MANDT == MARA.MANDT
Order Price Unit (Purchasing)
  • WMFP.MANDT == T006.MANDT
  • WMFP.BBPRM == T006.MSEHI
Purchase price currency
  • WMFP.MANDT == TCURC.MANDT
  • WMFP.CUREP == TCURC.WAERS
Sales price currency
  • WMFP.MANDT == TCURC.MANDT
  • WMFP.CURVP == TCURC.WAERS
Supplier Number
  • WMFP.MANDT == LFA1.MANDT
  • WMFP.LIFNR == LFA1.LIFNR
Client WMFP.MANDT == T000.MANDT
Document no. of markdown plan
  • Document no. of markdown plan
  • Client
  • WMFP.MFCNR == WMFH.MFCNR
  • WMFP.MANDT == WMFH.MANDT
Markdown rule
  • WMFP.MANDT == WMPK.MANDT
  • WMFP.MPRNR == WMPK.MPRNR
Material no.
  • Pricing Reference Material
  • Client
  • WMFP.PMATN == MARA.MATNR
  • WMFP.MANDT == MARA.MANDT
Season Category
  • WMFP.MANDT == T6WSP.MANDT
  • WMFP.SAISO == T6WSP.SAISO
Categories of seasonal materials
  • WMFP.MANDT == T6WSA.MANDT
  • WMFP.SAITY == T6WSA.SAITY
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • WMFP.SATNR == MARA.MATNR
  • WMFP.MANDT == MARA.MANDT
Sales Organization
  • WMFP.MANDT == TVKO.MANDT
  • WMFP.VKORG == TVKO.VKORG
Sales unit
  • WMFP.MANDT == T006.MANDT
  • WMFP.VRKME == T006.MSEHI
Currency of distribution chain
  • WMFP.MANDT == TCURC.MANDT
  • WMFP.VTLCU == TCURC.WAERS
Distribution Channel
  • Distribution Channel
  • Client
  • WMFP.VTWEG == TVTW.VTWEG
  • WMFP.MANDT == TVTW.MANDT