SAP ABAP Table WMFH (Markdown Planning - header data)

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	WMFH	Table Relationship Diagram
Short Description	Markdown Planning - header data

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
3	DATFR	☐	F_DATFR	DATUM	DATS	8	0	Start date for first price in a markdown plan
4	DATTO	☐	F_DATTO	DATUM	DATS	8	0	Final date for last price in a markdown plan
5	MPRNR	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
6	VKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
7	ROUND	☐	W_ROUNDOFF	FLAG	CHAR	1	0	Indicator: Always Round Down Prices in Markdown Plan
8	MFART	☐	W_MFART	MFART	CHAR	4	0	Markdown Type in Markdown Planning	TMFA
9	ISVAR	☐	F_ISVAR	CHAR10	CHAR	10	0	ID for data variant
10	PLWAE	☐	F_PLWAE	WAERS	CUKY	5	0	Planning currency for markdown planning	TCURC
11	SPVKO	☐	W_MDSPVKO	VKORG	CHAR	4	0	Sales Organization for Suggested Sales Price	TVKO
12	SPVTW	☐	W_MDSPVTW	VTWEG	CHAR	2	0	Distribution Channel for Suggested Sales Price	TVTW
13	SPPLT	☐	W_MDSPPLT	PLTYP	CHAR	2	0	Price List of Default Sales Price	T189
14	SPKNR	☐	W_MDSPKNR	KUNNR	CHAR	10	0	Plant-Based Customer no. for Suggested Sales Price	KNA1
15	SPWRK	☐	W_SPWRK	WERKS	CHAR	4	0	Plant for Suggested Sales Price	T001W
16	NPERI	☐	W_MCPER	MCPER	NUMC	3	0	Number of Previous Periods for Analysis Period
17	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
18	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
19	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WMFH	MANDT	T000	MANDT		1	N
2	WMFH	MFART	TMFA	MFART
3	WMFH	MPRNR	WMPK	MPRNR		1	CN
4	WMFH	PLWAE	TCURC	WAERS		1	CN
5	WMFH	SPKNR	KNA1	KUNNR		1	CN
6	WMFH	SPPLT	T189	PLTYP
7	WMFH	SPVKO	TVKO	VKORG		1	CN
8	WMFH	SPVTW	TVTW	VTWEG		1	CN
9	WMFH	SPWRK	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in