1. Home
  2. Resources
  3. SAP Tables
  4. LEMOVMHD - Structure for Goods Movements, SLED

SAP Table LEMOVMHD

Structure for Goods Movements, SLED

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

LEMOVMHD table fields

Field Data element Checktable Datatype Length Decimals
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
MATNR Material Number MATNR CHAR 18 0
CHARG Batch Number CHARG_D CHAR 10 0
HSDAT Date of Manufacture HSDAT DATS 8 0
MHDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
CHARG_OK Checkbox XFELD CHAR 1 0
X Yes
NULL No
HERKL Country of origin of the material HERKL T005 CHAR 3 0
HERKR Region of origin of material (non-preferential origin) HERKR T005S CHAR 3 0
RBLVS Reference movement type for WM from material movements RBLVS NUMC 3 0
UMRBL Reference movement type for transfer in warehouse mgmt LVS_UMRBL NUMC 3 0
UMRBU Reference movement type for posting change in whse mgmt LVS_UMRBU NUMC 3 0
BSTAR Stock type BSTAR CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
FOBWA Subsequent movement type FOBWA CHAR 3 0
FO_DLVTP Subsequent delivery category FO_DLVTP CHAR 2 0
ID Delivery Category for Inbound Deliveries
OD Delivery Category for Outbound Deliveries
TP Delivery Category for Stock Transfer Delivs/Posting Changes
RL Delivery Category for Return Delivery to Vendor
LB Delivery Category for Subcontracting
RK Delivery Category for Customer Returns
DLVTP Delivery Category DLVTP CHAR 2 0
ID Delivery Category for Inbound Deliveries
OD Delivery Category for Outbound Deliveries
TP Delivery Category for Stock Transfer Delivs/Posting Changes
RL Delivery Category for Return Delivery to Vendor
LB Delivery Category for Subcontracting
RK Delivery Category for Customer Returns
MHDRZ Minimum Remaining Shelf Life MHDRZ DEC 4 0
MHDHB Total shelf life MHDHB DEC 4 0
IPRKZ Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
RDMHD Rounding rule for calculation of SLED RDMHD CHAR 1 0
NULL No rounding off
- Start of chosen period (week, month or year)
+ End of chosen period (week, month or year)
F Start of the following period (week, month, year)
MHDRZ_LT Minimum Remaining Shelf Life (8-Char. Calculation Field) MHDLG DEC 8 0
MTART Material Type MTART CHAR 4 0
MHDAT_GT Minimum Remaining Shelf Life (8-Char. Calculation Field) MHDLG DEC 8 0
CHNEU Batch Creation Control (Automatic/Manual) CHNEU CHAR 1 0
NULL Automatic / manual without check
A Automatic / manual and check against external number range
B Automatic / manual and check in USER EXIT
C Automatic / no manual creation
D Manual without check
E Manual and check against external number range
F Manual and check in USER EXIT
G No creation
KZMHD Check Best Before Date/Production Date KZMHD CHAR 1 0
NULL No check
1 Enter and check
2 Enter only
3 No check at goods issue
KZCLA Option to classify batches KZCLA CHAR 1 0
NULL No branching to batch classification
1 Classification carried out in background (all batches)
2 Classification only in foregr.for mand.charac. (all batches)
3 Classification always in foreground (all batches)
4 Classification in foreground for new batches only
XKCFC Extended classification via CFC XKCFC CHAR 1 0
X Yes
NULL No
XWMHD Check Best Before Date/Production Date XWMHD CHAR 1 0
X Yes
NULL No
KZCHA Determine Batches for Physical Inventory in Background KZCHA CHAR 1 0
X Determine batches in the background
NULL Determine batches in the foreground with correction option
W_VKORG Sales Organization VKORG TVKO CHAR 4 0
W_SPART Division SPART TSPA CHAR 2 0
W_VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
W_VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
W_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
W_KUNNR Customer Number KUNNR KNA1 CHAR 10 0
L_VKORG Sales Organization VKORG TVKO CHAR 4 0
L_SPART Division SPART TSPA CHAR 2 0
L_VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
L_VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
L_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
L_KUNNR Customer Number KUNNR KNA1 CHAR 10 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LICHA Vendor Batch Number LICHN CHAR 15 0
EKORG Purchasing Organization EKORG CHAR 4 0
AUART Order Type AUFART CHAR 4 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
WAGRP Material group WAGRP CHAR 9 0
MATKL Material Group MATKL CHAR 9 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
UMMAT Receiving/Issuing Material UMMAT CHAR 18 0
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
PMATN Material Number for Order CO_MATNR CHAR 18 0
PWERK Planning plant for the order CO_PWERK CHAR 4 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BSART Order Type (Purchasing) BSART CHAR 4 0
CO_POSNR Order Item Number CO_POSNR NUMC 4 0
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
PRWRK Production plant PRWRK CHAR 4 0
KDUMMY Dummy function in length 1 DUMMY CHAR 1 0

LEMOVMHD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LEMOVMHD HERKL SYST MANDT T005 Countries MANDT
LEMOVMHD HERKL LEMOVMHD HERKL T005 Countries LAND1
LEMOVMHD HERKR SYST MANDT T005S Taxes: Region (Province) Key MANDT
LEMOVMHD HERKR LEMOVMHD HERKL T005S Taxes: Region (Province) Key LAND1
LEMOVMHD HERKR LEMOVMHD HERKR T005S Taxes: Region (Province) Key BLAND
LEMOVMHD L_KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
LEMOVMHD L_KUNNR LEMOVMHD L_KUNNR KNA1 General Data in Customer Master KUNNR
LEMOVMHD L_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
LEMOVMHD L_LIFNR LEMOVMHD L_LIFNR LFA1 Vendor Master (General Section) LIFNR
LEMOVMHD L_SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
LEMOVMHD L_SPART LEMOVMHD L_SPART TSPA Organizational Unit: Sales Divisions SPART
LEMOVMHD L_VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
LEMOVMHD L_VKORG LEMOVMHD L_VKORG TVKO Organizational Unit: Sales Organizations VKORG
LEMOVMHD L_VSTEL LEMOVMHD L_VSTEL TVST Organizational Unit: Shipping Points VSTEL
LEMOVMHD L_VSTEL SYST MANDT TVST Organizational Unit: Shipping Points MANDT
LEMOVMHD L_VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
LEMOVMHD L_VTWEG LEMOVMHD L_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
LEMOVMHD MEINS SYST MANDT T006 Units of Measurement MANDT
LEMOVMHD MEINS LEMOVMHD MEINS T006 Units of Measurement MSEHI
LEMOVMHD W_KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
LEMOVMHD W_KUNNR LEMOVMHD W_KUNNR KNA1 General Data in Customer Master KUNNR
LEMOVMHD W_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
LEMOVMHD W_LIFNR LEMOVMHD W_LIFNR LFA1 Vendor Master (General Section) LIFNR
LEMOVMHD W_SPART LEMOVMHD W_SPART TSPA Organizational Unit: Sales Divisions SPART
LEMOVMHD W_SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
LEMOVMHD W_VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
LEMOVMHD W_VKORG LEMOVMHD W_VKORG TVKO Organizational Unit: Sales Organizations VKORG
LEMOVMHD W_VSTEL SYST MANDT TVST Organizational Unit: Shipping Points MANDT
LEMOVMHD W_VSTEL LEMOVMHD W_VSTEL TVST Organizational Unit: Shipping Points VSTEL
LEMOVMHD W_VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
LEMOVMHD W_VTWEG LEMOVMHD W_VTWEG TVTW Organizational Unit: Distribution Channels VTWEG