SAP table LEMOVMHD (Structure for Goods Movements, SLED)

Field Description Data Type Length Decimals Checktable Data Element
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
MATNR Material Number CHAR 40 0 MATNR
CHARG Batch Number CHAR 10 0 * CHARG_D
HSDAT Date of Manufacture DATS 8 0 HSDAT
MHDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
CHARG_OK Checkbox CHAR 1 0 XFELD
No
X Yes
HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 T005S HERKR
RBLVS Reference movement type for WM from material movements NUMC 3 0 RBLVS
UMRBL Reference movement type for transfer in warehouse mgmt NUMC 3 0 LVS_UMRBL
UMRBU Reference movement type for posting change in whse mgmt NUMC 3 0 LVS_UMRBU
BSTAR Stock type CHAR 1 0 * BSTAR
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
FOBWA Subsequent movement type CHAR 3 0 * FOBWA
FO_DLVTP Subsequent delivery category CHAR 2 0 FO_DLVTP
DLVTP Delivery Category CHAR 2 0 DLVTP
ID Delivery Category for Inbound Deliveries
LB Delivery Category for Subcontracting
OD Delivery Category for Outbound Deliveries
RK Delivery Category for Customer Returns
RL Delivery Category for Return Delivery to Supplier
TP Delivery Category for Stock Transfer Delivs/Posting Changes
MHDRZ Minimum Remaining Shelf Life DEC 4 0 MHDRZ
MHDHB Total shelf life DEC 4 0 MHDHB
IPRKZ Period Indicator for Shelf Life Expiration Date CHAR 1 0 DATTP
Day
1 Week
2 Month
3 Year
RDMHD Rounding rule for calculation of SLED CHAR 1 0 RDMHD
No rounding off
+ End of chosen period (week, month or year)
- Start 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) DEC 8 0 MHDLG
MTART Material type CHAR 4 0 * MTART
MHDAT_GT Minimum Remaining Shelf Life (8-Char. Calculation Field) DEC 8 0 MHDLG
CHNEU Batch Creation Control (Automatic/Manual) CHAR 1 0 CHNEU
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 CHAR 1 0 KZMHD
No check
1 Enter and check
2 Enter only
3 No check at goods issue
KZCLA Option to classify batches CHAR 1 0 KZCLA
No Branching to Batch Classification
1 Classification Carried Out in Background (All Batches)
2 Classific. Only in Foreground for Mand. Chars (All Batches)
3 Classification Always Invoked in Foreground (All Batches)
4 Classification Invoked in Foreground for New Batches Only
XKCFC Extended classification via CFC CHAR 1 0 XKCFC
XWMHD Check Best Before Date/Production Date CHAR 1 0 XWMHD
KZCHA Determine Batches for Physical Inventory in Background CHAR 1 0 KZCHA
Determine batches in the foreground with correction option
X Determine batches in the background
W_VKORG Sales Organization CHAR 4 0 TVKO VKORG
W_SPART Division CHAR 2 0 TSPA SPART
W_VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
W_VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
W_LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
W_KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
L_VKORG Sales Organization CHAR 4 0 TVKO VKORG
L_SPART Division CHAR 2 0 TSPA SPART
L_VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
L_VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
L_LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
L_KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
LICHA Supplier Batch Number CHAR 15 0 LICHN
EKORG Purchasing organization CHAR 4 0 EKORG
AUART Order Type CHAR 4 0 AUFART
AUTYP Order category NUMC 2 0 AUFTYP
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
99 Master Planned order
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 LGNUM
WERKS Plant CHAR 4 0 WERKS_D
LGORT Storage location CHAR 4 0 LGORT_D
WAGRP Material group CHAR 9 0 WAGRP
MATKL Material Group CHAR 9 0 MATKL
BWTTY Valuation Category CHAR 1 0 BWTTY_D
BWART Movement type (inventory management) CHAR 3 0 BWART
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
UMMAT Receiving/Issuing Material CHAR 40 0 UMMAT
UMWRK Receiving plant/issuing plant CHAR 4 0 UMWRK
UMLGO Receiving/issuing storage location CHAR 4 0 UMLGO
UMSOK Special stock indicator for physical stock transfer CHAR 1 0 UMSOK
PMATN Material Number for Order CHAR 40 0 CO_MATNR
PWERK Planning Plant for an Order CHAR 4 0 CO_PWERK
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Order Type (Purchasing) CHAR 4 0 BSART
CO_POSNR Order item number NUMC 4 0 CO_POSNR
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
PRWRK Production plant CHAR 4 0 PRWRK
KDUMMY Dummy function in length 1 CHAR 1 0 DUMMY

LEMOVMHD foreign key relationships

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