SAP Table MYML1

LIFO: Transaction-Related Material Layer

MYML1 (LIFO: Transaction-Related Material Layer) 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 MYML1 to other SAP tables.

MYML1 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 CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLPO Item in Material Document MBLPO NUMC 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 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
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
AWSYS Logical system LOGSYS CHAR 10 0
PRGID Balance Sheet Valuation Program ID MY_PROGID CHAR 2 0
N0 Lowest value determination based on market prices
N1 Flat-rate reductions based on range of coverage
N2 Flat-rate reductions based on rate of movement
N3 Loss-free valuation
N8 Price variances
N9 Balance sheet values by account
L1 LIFO valuation for single materials
L2 LIFO valuation for pools
L3 LIFO lowest value comparison
L4 Display of LIFO results for single materials
L5 Display of LIFO results for pools
L6 Select LIFO-relevant materials
L7 Analyze composition of pools
L8 Create LIFO base layer
L9 Create LIFO receipts from document extract
LA Check LIFO indicator
LB Delete LIFO data
LC Adopt LIFO or FIFO data from external source
LD Transfer lowest prices to LIFO table
LE Pool splitting method
LF Copy LIFO layer version
LG Aggregate LIFO layers
LH Change LIFO/FIFO valuation level
LI Allocate pool numbers
LJ Delete LIFO or FIFO data
LK Modify units of measure in LIFO/FIFO tables
LL Reassign LIFO layer
32 Change LIFO data
33 Display LIFO data
39 Display LIFO change documents
F1 Execute FIFO valuation
F2 Display FIFO change documents
F3 Create FIFO receipts from document extract
F4 Select FIFO-relevant materials
F5 Delete FIFO data
34 Change FIFO data
35 Display FIFO data
X0 Collective maint. of phys. inven. prices (material master)
X1 Average receipt price
X2 Transfer physical inventory prices to price table
ML Program from Material Ledger
M1 Cumulation of Periodic Receipt Values from Material Ledger
MD Manual Correction of Per. Receipt Values from Matl Ledger
MK Customer-Specific Correction of Per. Receipt Values from ML
MS Receipt Values from Material Ledger Period-End Closing
TIMEL Time Stamp - Long Format TZNTSTMPLL NUMC 21 0

MYML1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MYML1 MANDT MYML1 MANDT T000 Clients MANDT
MYML1 MEINS MYML1 MANDT T006 Units of Measurement MANDT
MYML1 MEINS MYML1 MEINS T006 Units of Measurement MSEHI
MYML1 MYVER MYML1 MYKEY TMY05 Directory for Versions for LIFO Valuation MYKEY
MYML1 MYVER MYML1 MYVER TMY05 Directory for Versions for LIFO Valuation MYVER
MYML1 MYVER MYML1 MANDT TMY05 Directory for Versions for LIFO Valuation MANDT