SAP ABAP Table WMFU (Markdown planning - price phases per material/un)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WAKT (Package) Application development R/3 Promotions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WMFU	Table Relationship Diagram
Short Description	Markdown planning - price phases per material/un

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MFCNR	☑	W_MFCNR	MFCNR	CHAR	10	0	Document no. of markdown plan	WMFH
3	POSNR	☑	W_POSNR	NUMC6	NUMC	6	0	Item number
4	UPOSN	☑	W_UPOSN	NUMC6	NUMC	6	0	Sub-item number for item number
5	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
6	MDPRZ	☐	W_MDPRZ	PROZV8	DEC	15	2	Markdown planning: percentage of initial sales price
7	MDWRT	☐	W_MDWRT	WERT	CURR	13	2	Markdown value
8	MDROS	☐	W_MDROS	PROZV8	DEC	15	2	Sales within a price phase as percentage of overall season
9	DATAB	☐	W_DATAB	DATS	DATS	8	0	Starting date of sales price in a price phase
10	VKKPS	☐	VKKPS	VKKPS_MD	CHAR	1	0	Maintenance status of sales prices
11	PSALM	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
12	PSALW	☐	W_PSALW	WERT	CURR	13	2	Planned sales at retail price
13	PSALC	☐	W_PSALC	WERT	CURR	13	2	Planned sales at purchase price
14	PSALP	☐	W_PSALP	WERT	CURR	13	2	Planned sales at delivered price/net/net purchase price
15	PANFM	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
16	CUREP	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
17	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
18	BBPRM	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
19	CURVP	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
20	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
21	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
22	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
23	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
24	SPANE	☐	W_MDSPANE	WERTV6	CURR	11	2	Margin (net) in Sales Price Calculation
25	SPABR	☐	W_MDSPABR	WERTV6	CURR	11	2	Margin (gross) in Sales Price Calculation
26	SPWRT	☐	W_SPWRT	WERT	CURR	13	2	Gross margin
27	AUFSG	☐	W_MDAUFSG	WERTV6	CURR	11	2	Markup in Sales Price Calculation
28	VSPAN	☐	W_SPANE	WERTV6	CURR	11	2	Net warehouse margin
29	VSPAB	☐	W_SPABR	WERTV6	CURR	11	2	Gross warehouse margin
30	VAUFS	☐	W_AUFSG	WERTV6	CURR	11	2	Warehouse markup
31	VABGP	☐	W_VABGP	PREIS	CURR	11	2	Transfer price, distribution center
32	SPANS	☐	W_SPANS	SPANS	CHAR	1	0	Status of the retail margin displayed
33	MDPER	☐	W_MDPER	INT2	INT2	5	0	Markdown period in calendar days
34	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
35	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
36	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
37	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
38	PRESW	☐	W_PRESW	WERT	CURR	13	2	Planned Remaining Stock (Value)
39	PRESM	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
40	MAHIT	☐	W_MAHIT	WERT	CURR	13	2	Margin Loss
41	PSALA	☐	W_MDWRT	WERT	CURR	13	2	Markdown value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WMFU	BBPRM	T006	MSEHI		C	N
2	WMFU	CUREP	TCURC	WAERS		C	N
3	WMFU	CURVP	TCURC	WAERS		C	N
4	WMFU	MANDT	T000	MANDT		1	N
5	WMFU	MFCNR	WMFH	MFCNR		1	N
6	WMFU	VRKME	T006	MSEHI		C	N

History

Last changed by/on	SAP	20130529
SAP Release Created in