MYML1Q SAP table for – LIFO: Transaction-Related Material Layer (Quantity)

Here we would like to draw your attention to MYML1Q table in SAP. As we know it is being mainly used with the SAP MM-IM (Inventory Management in MM) component which is coming under MM module (Material Management). MYML1Q is a SAP standard transparent table used for storing LIFO: Transaction-Related Material Layer (Quantity) related data in SAP. It comes under the package MRY.

SAP MYML1Q table

Table MYML1Q technical data

TableMYML1Q
Data storingLIFO: Transaction-Related Material Layer (Quantity)
ModuleMM
ComponentMM-IM
SAP PackageMRY
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MYML1Q Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MYML1Q table.

  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • AWSYS : Logical System
    Its data type is C (Character String) with field length 10
  • MYVER
    Its a key field. Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • MJAHR : Year of material document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8