SAP Table MYMS
LIFO-relevant materials
MYMS (LIFO-relevant materials) 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 MYMS to other SAP tables.
MYMS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| MYKEY | LIFO valuation level | MYKEY | T001Y | CHAR | 4 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| MYPOOL | Pool number for LIFO valuation | MYPOOL | TPOOL | CHAR | 4 | 0 | ||
MYMS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MYMS | MANDT | MYMS | MANDT | T000 | Clients | MANDT |
| MYMS | MATNR | MYMS | MANDT | MARA | General Material Data | MANDT |
| MYMS | MATNR | MYMS | MATNR | MARA | General Material Data | MATNR |
| MYMS | MYKEY | MYMS | MANDT | T001Y | Valuation Levels for LIFO Inventory Valuation | MANDT |
| MYMS | MYKEY | MYMS | MYKEY | T001Y | Valuation Levels for LIFO Inventory Valuation | MYKEY |
| MYMS | MYPOOL | MYMS | MANDT | TPOOL | Master Record, LIFO Pools | MANDT |
| MYMS | MYPOOL | MYMS | MYKEY | TPOOL | Master Record, LIFO Pools | MYKEY |
| MYMS | MYPOOL | MYMS | MYPOOL | TPOOL | Master Record, LIFO Pools | MYPOOL |
