SAP table LEMOVMAT (Structure for Goods Movements, Material Data)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MARA MATNR
UMMAT Receiving/Issuing Material CHAR 40 0 MARA UMMAT
CHARG Batch Number CHAR 10 0 * CHARG_D
UMCHA Receiving/Issuing Batch CHAR 10 0 * UMCHA
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
UMBAR Valuation Type of Transfer Batch CHAR 10 0 T149D UMBAR
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
UMSOK Special stock indicator for physical stock transfer CHAR 1 0 T148 UMSOK
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
UMBSQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SONUM Special Stock Number CHAR 16 0 LVS_SONUM
USONU Special Stock Number CHAR 16 0 LVS_SONUM
INSMK Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
FOBWA Subsequent movement type CHAR 3 0 T156 FOBWA
BWLVS Movement Type for Warehouse Management NUMC 3 0 T333 BWLVS
RBLVS Reference movement type for WM from material movements NUMC 3 0 RBLVS
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
SHKZG_UM Indicator: UNMAT in main posting CHAR 1 0 SHKZG_UM
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 CHAR 1 0 NOWAB
Item is relevant for goods movements
X Item not relevant for goods movements
GRUND Reason for Movement NUMC 4 0 T157D MB_GRBEW
KONTO G/L Account Number CHAR 10 0 * SAKNR
LIFNR Account Number of Supplier CHAR 10 0 * LIFNR
KUNNR Customer Number CHAR 10 0 * KUNNR
GSBER Business Area CHAR 4 0 * GSBER
KOSTL Cost Center CHAR 10 0 * KOSTL
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 * LGNUM
LBBSA Stock Type of Goods Movement (Primary Posting) CHAR 2 0 * LBBSA

LEMOVMAT foreign key relationships

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