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 |
Possible values
|
||||||||||
UMBSQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
SHKZG_UM | Indicator: UNMAT in main posting | SHKZG_UM | CHAR | 1 | 0 |
Possible values
|
||||||||||
NOWAB | Indicator: Item Not Relevant for Goods Movements | NOWAB | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |