SAP ABAP Table TMFA (Markdown Planning - Markdown type)

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	TMFA	Table Relationship Diagram
Short Description	Markdown Planning - Markdown type

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MFART	☑	W_MFART	MFART	CHAR	4	0	Markdown Type in Markdown Planning
3	MPRNR	☐	W_MPRNR	MPRNR	CHAR	10	0	Markdown rule	WMPK
4	SPVKO	☐	W_MDSPVKO	VKORG	CHAR	4	0	Sales Organization for Suggested Sales Price	TVKO
5	SPVTW	☐	W_MDSPVTW	VTWEG	CHAR	2	0	Distribution Channel for Suggested Sales Price	TVTW
6	SPPLT	☐	W_MDSPPLT	PLTYP	CHAR	2	0	Price List of Default Sales Price	T189
7	SPKNR	☐	W_MDSPKNR	KUNNR	CHAR	10	0	Plant-Based Customer no. for Suggested Sales Price	KNA1
8	NPERI	☐	W_MCPER	MCPER	NUMC	3	0	Number of Previous Periods for Analysis Period
9	NUMKI	☐	NUMKI	NUMKR	CHAR	2	0	Number range in the case of internal number assignment
10	NUMKE	☐	NUMKE	NUMKR	CHAR	2	0	Number range in the case of external number assignment
11	VKPKZ	☐	F_VKPKZ	FLAG	CHAR	1	0	Indicates whether price point tables should override price
12	ROUND	☐	W_ROUNDOFF	FLAG	CHAR	1	0	Indicator: Always Round Down Prices in Markdown Plan

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TMFA	MANDT	T000	MANDT		1	N
2	TMFA	MPRNR	WMPK	MPRNR		1	CN
3	TMFA	SPKNR	KNA1	KUNNR		1	CN
4	TMFA	SPPLT	T189	PLTYP
5	TMFA	SPVKO	TVKO	VKORG		1	CN
6	TMFA	SPVTW	TVTW	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in