SAP table MYMFT (FIFO Results Table)
SAP table MYMFT has 6 primary key fields being MANDT,MYFKY,MATNR,BWTAR,METHOD,DATLO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| MYFKY | FIFO valuation level | CHAR | 4 | 0 | MYFKY | ||
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| BWTAR | Valuation Type | CHAR | 10 | 0 | BWTAR_D | ||
| METHOD | LIFO/FIFO Method | CHAR | 6 | 0 | TMY02 | MYMETHOD | |
| DATLO | (Local) date for identifying a day's price | DATS | 8 | 0 | MYDATLO | ||
| MYFWRT | FIFO value (gross) | CURR | 13 | 2 | MYFIFOWRT | ||
| MYFWRN | FIFO value (net) | CURR | 13 | 2 | MYFIFOWRN | ||
| MYFMNG | Stock quantity valuated using FIFO | QUAN | 13 | 3 | MYFIFOMNG | ||
| MEINS | Unit of Measure for Material Valuation | UNIT | 3 | 0 | T006 | CKML_MEINS | |
| PEINH | Price unit | DEC | 5 | 0 | PEINH | ||
| PRS01 | Price 1 for value adjustment | CURR | 11 | 2 | PRS01 | ||
| PRS02 | Price 2 for value adjustment | CURR | 11 | 2 | PRS02 | ||
| PRS03 | Price 3 for value adjustment | CURR | 11 | 2 | PRS03 | ||
| SALK3 | Value of Total Valuated Stock | CURR | 13 | 2 | SALK3 |
MYMFT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MYMFT | MANDT | T000 | Clients | MANDT |
| 1 MYMFT | MATNR | MARA | General Material Data | MANDT |
| 1 MYMFT | MATNR | MARA | General Material Data | MATNR |
| 0 MYMFT | MEINS | T006 | Units of Measurement | MANDT |
| 0 MYMFT | MEINS | T006 | Units of Measurement | MSEHI |
| 1 MYMFT | METHOD | TMY02 | Balance Sheet Valuation Method (LIFO/FIFO) | MANDT |
| 1 MYMFT | METHOD | TMY02 | Balance Sheet Valuation Method (LIFO/FIFO) | METHOD |