SAP Table TMFA
Markdown Planning - Markdown type
TMFA (Markdown Planning - Markdown type) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TMFA to other SAP tables.
TMFA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MFART | Markdown Type in Markdown Planning | W_MFART | CHAR | 4 | 0 | |||||||
| MPRNR | Markdown rule | W_MPRNR | WMPK | CHAR | 10 | 0 | ||||||
| SPVKO | Sales Organization for Suggested Sales Price | W_MDSPVKO | TVKO | CHAR | 4 | 0 | ||||||
| SPVTW | Distribution Channel for Suggested Sales Price | W_MDSPVTW | TVTW | CHAR | 2 | 0 | ||||||
| SPPLT | Price List of Default Sales Price | W_MDSPPLT | T189 | CHAR | 2 | 0 | ||||||
| SPKNR | Plant-Based Customer no. for Suggested Sales Price | W_MDSPKNR | KNA1 | CHAR | 10 | 0 | ||||||
| NPERI | Number of Previous Periods for Analysis Period | W_MCPER | NUMC | 3 | 0 | |||||||
| NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | 0 | |||||||
| NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | 0 | |||||||
| VKPKZ | Indicates whether price point tables should override price | F_VKPKZ | CHAR | 1 | 0 |
Possible values
|
||||||
| ROUND | Indicator: Always Round Down Prices in Markdown Plan | W_ROUNDOFF | CHAR | 1 | 0 |
Possible values
|
||||||
TMFA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TMFA | MANDT | TMFA | MANDT | T000 | Clients | MANDT |
| TMFA | MPRNR | TMFA | MPRNR | WMPK | Markdown rule header | MPRNR |
| TMFA | MPRNR | TMFA | MANDT | WMPK | Markdown rule header | MANDT |
| TMFA | SPKNR | TMFA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| TMFA | SPKNR | TMFA | SPKNR | KNA1 | General Data in Customer Master | KUNNR |
| TMFA | SPPLT | TMFA | SPPLT | T189 | Conditions: Price List Categories | PLTYP |
| TMFA | SPPLT | TMFA | MANDT | T189 | Conditions: Price List Categories | MANDT |
| TMFA | SPVKO | TMFA | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TMFA | SPVKO | TMFA | SPVKO | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TMFA | SPVTW | TMFA | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TMFA | SPVTW | TMFA | SPVTW | TVTW | Organizational Unit: Distribution Channels | VTWEG |
