SAP table TMY05 (Directory for Versions for LIFO Valuation)
SAP table TMY05 has 3 primary key fields being MANDT,MYKEY,MYVER.
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 | |||||||||||
| MYKEY | LIFO valuation level | CHAR | 4 | 0 | T001Y | MYKEY | |||||||||||
| MYVER | LIFO Layer Version | CHAR | 1 | 0 | MYVER | ||||||||||||
| METHOD | LIFO/FIFO Method | CHAR | 6 | 0 | TMY02 | MYMETHOD | |||||||||||
| MYFREQ | LIFO valuation: frequency of LIFO method | CHAR | 1 | 0 | MYFREQ |
|
|||||||||||
| MYCOPY | Layer Version Created Automatically | CHAR | 1 | 0 | LIFOCOPY | ||||||||||||
| SAFEV | Layer Version with Security Status | CHAR | 1 | 0 | MY_SAFE_VERSION | ||||||||||||
| VALCAL | Valuation Principle for Creating LIFO Layers | CHAR | 3 | 0 | MY_VAL_CALC |
|
|||||||||||
| SDTVON | LIFO layer value from pre-defined period: lower limit | DATS | 8 | 0 | MY_SDT_VON | ||||||||||||
| SDTBIS | LIFO layer value from pre-defined period: upper limit | DATS | 8 | 0 | MY_SDT_BIS |
TMY05 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TMY05 | METHOD | TMY02 | Balance Sheet Valuation Method (LIFO/FIFO) | MANDT |
| 0 TMY05 | METHOD | TMY02 | Balance Sheet Valuation Method (LIFO/FIFO) | METHOD |
| 1 TMY05 | MYKEY | T001Y | Valuation Levels for LIFO Inventory Valuation | MANDT |
| 1 TMY05 | MYKEY | T001Y | Valuation Levels for LIFO Inventory Valuation | MYKEY |