SAP Table MYPL
LIFO Pool Layer (Annual)
MYPL (LIFO Pool Layer (Annual)) 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 MYPL to other SAP tables.
MYPL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| MYVER | LIFO Layer Version | MYVER | TMY05 | CHAR | 1 | 0 | ||
| MYKEY | LIFO valuation level | MYKEY | T001Y | CHAR | 4 | 0 | ||
| MYPOOL | Pool number for LIFO valuation | MYPOOL | TPOOL | CHAR | 4 | 0 | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||
| MYWRT | LIFO layer value (gross) | MYWRT | CURR | 13 | 2 | |||
| MYWRN | LIFO layer value (net) | MYWRN | CURR | 13 | 2 | |||
| MYMNG | LIFO layer quantity | MYMNG | QUAN | 13 | 3 | |||
| ABS01 | Devaluation 1 for value adjustment (pool LIFO) | ABS01 | CURR | 13 | 2 | |||
| ABS02 | Devaluation 2 for value adjustment (pool LIFO) | ABS02 | CURR | 13 | 2 | |||
| ABS03 | Devaluation 3 for value adjustment (pool LIFO) | ABS03 | CURR | 13 | 2 | |||
| MYPIX | Price Index for Index LIFO Valuation | MYPIX | DEC | 11 | 5 | |||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||
| MYBAS | Layer base value | MYBAS | CURR | 13 | 2 | |||
MYPL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MYPL | MANDT | MYPL | MANDT | T000 | Clients | MANDT |
| MYPL | MEINS | MYPL | MEINS | T006 | Units of Measurement | MSEHI |
| MYPL | MEINS | MYPL | MANDT | T006 | Units of Measurement | MANDT |
| MYPL | MYKEY | MYPL | MANDT | T001Y | Valuation Levels for LIFO Inventory Valuation | MANDT |
| MYPL | MYKEY | MYPL | MYKEY | T001Y | Valuation Levels for LIFO Inventory Valuation | MYKEY |
| MYPL | MYPOOL | MYPL | MYPOOL | TPOOL | Master Record, LIFO Pools | MYPOOL |
| MYPL | MYPOOL | MYPL | MANDT | TPOOL | Master Record, LIFO Pools | MANDT |
| MYPL | MYPOOL | MYPL | MYKEY | TPOOL | Master Record, LIFO Pools | MYKEY |
| MYPL | MYVER | MYPL | MANDT | TMY05 | Directory for Versions for LIFO Valuation | MANDT |
| MYPL | MYVER | MYPL | MYKEY | TMY05 | Directory for Versions for LIFO Valuation | MYKEY |
| MYPL | MYVER | MYPL | MYVER | TMY05 | Directory for Versions for LIFO Valuation | MYVER |
