SAP ABAP Table WMFPD (Screen string for markdown planning items)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	WMFPD	Table Relationship Diagram
Short Description	Screen string for markdown planning items

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Markdown Planning - item data (materials)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MFCNR	☐	W_MFCNR	MFCNR	CHAR	10	0	Document no. of markdown plan	WMFH
4	POSNR	☐	W_POSNR	NUMC6	NUMC	6	0	Item number
5	ARTNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	VTLCU	☐	W_VTLCU	WAERS	CUKY	5	0	Currency of distribution chain	TCURC
10	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
11	MPRNR	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
12	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
13	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
14	SAITY	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
15	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
16	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
17	DATAB	☐	F_DATFR	DATUM	DATS	8	0	Start date for first price in a markdown plan
18	PSALM	☐	W_PSALM	MENGE	QUAN	13	3	Planned sales quantity in sales unit
19	PANFM	☐	W_PANFM2	MENGV13	QUAN	13	3	Planned initial stock
20	CUREP	☐	W_WAEEK	WAERS	CUKY	5	0	Purchase price currency	TCURC
21	EPEIN	☐	EPEIN	DEC5	DEC	5	0	Price unit
22	BBPRM	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
23	CURVP	☐	W_CURVP	WAERS	CUKY	5	0	Sales price currency	TCURC
24	EKPGR	☐	EKPGR	WERTV6	CURR	11	2	Purchase Price Calculation: (Basic Purchase Price)
25	EKWVK	☐	W_EKWVK	WERTV6	CURR	11	2	Purchase price in sales price currency and sales unit
26	EKPNN	☐	EKPNN	WERTV6	CURR	11	2	Sales Pricing: Purchase Price (Net/Net)
27	VKPBR	☐	VKPBR	WERTV6	CURR	11	2	Sales price (gross)
28	ENDPR	☐	ENDPR	WERTV6	CURR	11	2	Final price
29	PRESM	☐	W_PRESM2	MENGV13	QUAN	13	3	Planned Remaining Quantity
30	PSALC	☐	W_PSALC	WERT	CURR	13	2	Planned sales at purchase price
31	PSALP	☐	W_PSALP	WERT	CURR	13	2	Planned sales at delivered price/net/net purchase price
32	PSALW	☐	W_PSALW	WERT	CURR	13	2	Planned sales at retail price
33	PRESW	☐	W_PRESW	WERT	CURR	13	2	Planned Remaining Stock (Value)
34	CMUIV	☐	W_CMUIV	WERTV6	CURR	11	2	Weighted stock margin for all price phases
35	MAHIT	☐	W_MAHIT	WERT	CURR	13	2	Margin Loss
36	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
38	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
39	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
40	LIFNR	☐	W_LIFNR	LIFNR	CHAR	10	0	Vendor number	LFA1
41	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
42	VKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
43	SPWRT	☐	W_SPWRT	WERT	CURR	13	2	Gross margin
44	PSALW1	☐	W_PSALW	WERT	CURR	13	2	Planned sales at retail price
45	PSALA	☐	W_MDWRT	WERT	CURR	13	2	Markdown value
46	MDQTE	☐	W_MDQTE	PROZV8	DEC	15	2	Depreciation Quota
47	PCMV	☐	W_PCMV	WERT	CURR	13	2	Remaining profit margin
48	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
49	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
50	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
51	BBKUM	☐	W_BBKUM	MENG13V	QUAN	13	3	Cumulated Open Order Quantity
52	RWMEN	☐	MCW_RWMENG	BCSP4	DEC	7	0	Range of coverage in days (quantity)
53	CHGKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
54	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
55	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
56	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
57	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
58	PRES2	☐	W_PRES2	MENGV13	QUAN	13	3	Remaining stock in pieces
59	LUV	☐	W_SORAT	PROZV8	DEC	15	2	Weekly Inventory Turnover

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in