SAP Table LEMOVMAT

Structure for Goods Movements, Material Data

LEMOVMAT (Structure for Goods Movements, Material Data) 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 LEMOVMAT to other SAP tables.

LEMOVMAT table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
UMMAT Receiving/Issuing Material UMMAT MARA CHAR 18 0
CHARG Batch Number CHARG_D CHAR 10 0
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
UMBAR Valuation Type of Transfer Batch UMBAR T149D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK T148 CHAR 1 0
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
UMBSQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SONUM Special Stock Number LVS_SONUM CHAR 16 0
USONU Special Stock Number LVS_SONUM CHAR 16 0
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
FOBWA Subsequent movement type FOBWA T156 CHAR 3 0
BWLVS Movement Type for Warehouse Management BWLVS T333 NUMC 3 0
RBLVS Reference movement type for WM from material movements RBLVS NUMC 3 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
SHKZG_UM Indicator: UNMAT in main posting SHKZG_UM CHAR 1 0
NULL No stock transfer
1 Stock transfer and MAINR in primary posting
2 Stock transfer and UNMAT in primary posting
NOWAB Indicator: Item Not Relevant for Goods Movements NOWAB CHAR 1 0
X Item not relevant for goods movements
NULL Item is relevant for goods movements
GRUND Reason for Movement MB_GRBEW T157D NUMC 4 0
KONTO G/L Account Number SAKNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LBBSA Stock Type of Goods Movement (Primary Posting) LBBSA CHAR 2 0

LEMOVMAT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LEMOVMAT BWART SYST MANDT T156 Movement Type MANDT
LEMOVMAT BWART LEMOVMAT BWART T156 Movement Type BWART
LEMOVMAT BWLVS SYST MANDT T333 WM Movement Types MANDT
LEMOVMAT BWLVS LEMOVMAT LGNUM T333 WM Movement Types LGNUM
LEMOVMAT BWLVS LEMOVMAT BWLVS T333 WM Movement Types BWLVS
LEMOVMAT BWTAR SYST MANDT T149D Global Valuation Types MANDT
LEMOVMAT BWTAR LEMOVMAT BWTAR T149D Global Valuation Types BWTAR
LEMOVMAT FOBWA SYST MANDT T156 Movement Type MANDT
LEMOVMAT FOBWA LEMOVMAT FOBWA T156 Movement Type BWART
LEMOVMAT GRUND SYST MANDT T157D Reason for Movement MANDT
LEMOVMAT GRUND LEMOVMAT BWART T157D Reason for Movement BWART
LEMOVMAT GRUND LEMOVMAT GRUND T157D Reason for Movement GRUND
LEMOVMAT MATNR SYST MANDT MARA General Material Data MANDT
LEMOVMAT MATNR LEMOVMAT MATNR MARA General Material Data MATNR
LEMOVMAT SOBKZ SYST MANDT T148 Special Stock Indicator MANDT
LEMOVMAT SOBKZ LEMOVMAT SOBKZ T148 Special Stock Indicator SOBKZ
LEMOVMAT UMBAR SYST MANDT T149D Global Valuation Types MANDT
LEMOVMAT UMBAR LEMOVMAT UMBAR T149D Global Valuation Types BWTAR
LEMOVMAT UMMAT LEMOVMAT UMMAT MARA General Material Data MATNR
LEMOVMAT UMMAT SYST MANDT MARA General Material Data MANDT
LEMOVMAT UMSOK SYST MANDT T148 Special Stock Indicator MANDT
LEMOVMAT UMSOK LEMOVMAT UMSOK T148 Special Stock Indicator SOBKZ