SAP ABAP Table WMFP (Markdown Planning - item data (materials))

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	WMFP	Table Relationship Diagram
Short Description	Markdown Planning - item data (materials)

Delivery and Maintenance

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

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	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	VTLCU	☐	W_VTLCU	WAERS	CUKY	5	0	Currency of distribution chain	TCURC
9	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
10	MPRNR	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
11	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
12	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
13	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
14	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
15	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
16	DATAB	☐	F_DATFR	DATUM	DATS	8	0	Start date for first price in a markdown plan
17	PSALM	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
18	PANFM	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
19	CUREP	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
20	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
21	BBPRM	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
22	CURVP	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
23	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
24	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
25	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
26	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
27	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
28	PRESM	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
29	PSALC	☐	W_PSALC	WERT	CURR	13	2	Planned sales at purchase price
30	PSALP	☐	W_PSALP	WERT	CURR	13	2	Planned sales at delivered price/net/net purchase price
31	PSALW	☐	W_PSALW	WERT	CURR	13	2	Planned sales at retail price
32	PRESW	☐	W_PRESW	WERT	CURR	13	2	Planned Remaining Stock (Value)
33	CMUIV	☐	W_CMUIV	WERTV6	CURR	11	2	Weighted stock margin for all price phases
34	MAHIT	☐	W_MAHIT	WERT	CURR	13	2	Margin Loss
35	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
36	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
37	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
38	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
39	LIFNR	☐	W_LIFNR	LIFNR	CHAR	10	0	Vendor number	LFA1
40	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
41	VKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
42	SPWRT	☐	W_SPWRT	WERT	CURR	13	2	Gross margin

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WMFP	AKTNR	WAKH	AKTNR		1	CN
2	WMFP	ARTNR	MARA	MATNR		1	N
3	WMFP	BBPRM	T006	MSEHI		C	N
4	WMFP	CUREP	TCURC	WAERS		C	N
5	WMFP	CURVP	TCURC	WAERS		C	N
6	WMFP	LIFNR	LFA1	LIFNR		1	CN
7	WMFP	MANDT	T000	MANDT		1	N
8	WMFP	MFCNR	WMFH	MFCNR		1	N
9	WMFP	MPRNR	WMPK	MPRNR		1	CN
10	WMFP	PMATN	MARA	MATNR	REF	1	CN
11	WMFP	SAISO	T6WSP	SAISO		1	CN
12	WMFP	SAITY	T6WSA	SAITY
13	WMFP	SATNR	MARA	MATNR		C	N
14	WMFP	VKORG	TVKO	VKORG		1	N
15	WMFP	VRKME	T006	MSEHI		C	N
16	WMFP	VTLCU	TCURC	WAERS		1	CN
17	WMFP	VTWEG	TVTW	VTWEG		1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in