LMD_COM_ROUTES - Last Mile Distribution Routes

Last Mile Distribution Routes information is stored in SAP table LMD_COM_ROUTES.
It is part of development package LMD_COM_PERSIST in software component LE-LMD. This development package consists of objects that can be grouped under "Last Mile Distribution Route Persistence".

Fields for table LMD_COM_ROUTES

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
ROUTE_UUID	Route UUID	X	LMD_ROUTE_UUID	RAW	16
.INCLUDE				LMD_COM_ROUTE_DATA	0
ROUTE_ID	Route ID		LMD_COM_ROUTE_ID	CHAR	70
MAIN_DRIVER_ID	Driver		LMD_COM_DRIVER_ID	CHAR	20
CO_DRIVER_ID	Driver		LMD_COM_DRIVER_ID	CHAR	20
VEHICLE_TYPE	Vehicle Type		LMD_COM_VEHICLE_TYPE	CHAR	20
VEHICLE_ID	Vehicle ID		LMD_COM_VEHICLE_ID	CHAR	80
VEHICLE_LICENSE_PLATE	License Plate		LMD_COM_LICENSE_PLATE	CHAR	40
TRAILER_ID	Vehicle ID		LMD_COM_VEHICLE_ID	CHAR	80
TRAILER_LICENSE_PLATE	License Plate		LMD_COM_LICENSE_PLATE	CHAR	40
ROUTE_STOCK_IDENTIFIER	Route Stock Identifier		LMD_COM_ROUTE_STOCK_IDENTIFIER	CHAR	80
ROUTE_DEPARTURE_TIMEZONE	Time Zone		LMD_COM_TIMEZONE	CHAR	12	*
COUNTRY_REGION	Country/Region Key		LAND1	CHAR	6	*
CURRENCY	Currency Code		LMD_COM_CURRENCY	CUKY	10	*
REF_ROUTE_TYPE	Reference Route Type		LMD_COM_REF_ROUTE_TYPE	CHAR	8
ROUTE_TYPE	Route Type		LMD_COM_ROUTE_TYPE	CHAR	4
ROUTE_CATEGORY	Route Category		LMD_COM_ROUTE_CATEGORY	CHAR	4
PLANNED_DEPARTURE_TIMESTAMP	Timestamp		LMD_COM_TIMESTAMP	DEC	8
PLANNED_ARRIVAL_TIMESTAMP	Timestamp		LMD_COM_TIMESTAMP	DEC	8
ACTUAL_DEPARTURE_TIMESTAMP	Departure Timestamp		LMD_COM_TIMESTAMP_DEPARTURE	DEC	8
ARRIVAL_LOCATION_ID	Arrival Location		LMD_COM_ARRIVAL_LOCATION	CHAR	40
DEPARTURE_LOCATION_ID	Departure Location		LMD_COM_DEPARTURE_LOCATION	CHAR	40
ACTUAL_ARRIVAL_TIMESTAMP	Arrival Timestamp		LMD_COM_TIMESTAMP_ARRIVAL	DEC	8
ACTUAL_ODOMETER_START	Odometer Reading at Departure		LMD_COM_ODOMETER_DEPARTURE	QUAN	16
ACTUAL_ODOMETER_END	Odometer Reading at Arrival		LMD_COM_ODOMETER_ARRIVAL	QUAN	16
ODOMETER_UOM	Distance Unit of Measure		LMD_COM_UOM_DISTANCE	UNIT	6	*
SETTLEMENT_COMMENTS	Comments		LMD_COM_COMMENTS	SSTR	8
DIFFERENCES	Settlement Differences Containing Products / Money Items		LMD_COM_DIFFERENCES	CHAR	2
REASON_CODE	Reason Code		LMD_COM_REASON_CODE	CHAR	4
DEPARTURE_SHIPPING_POINT	Departure Shipping Point		LMD_COM_DEPARTURE_SHIPG_POINT	CHAR	8	*
ARRIVAL_SHIPPING_POINT	Arrival Shipping Point		LMD_COM_ARRIVAL_SHIPPING_POINT	CHAR	8	*
EXECUTION_ORGANIZATION	Execution Organization		LMD_COM_EXECUTION_ORGANIZATION	CHAR	40
MESSAGE_CREATION_TIMESTAMP	UTC-Timestamp Long YYYYMMDDhhmmssmmmuuun		LMD_COM_TIMESTAMP_LONG	DEC	11
CREATION_TIMESTAMP	Timestamp		LMD_COM_TIMESTAMP	DEC	8
LAST_CHANGE_TIMESTAMP	Timestamp		LMD_COM_TIMESTAMP	DEC	8
SELECTION_DEPARTURE_DATE	Departure Date		LMD_COM_SELECTN_DEPARTURE_DATE	DATS	16
SELECTION_ARRIVAL_DATE	Arrival Date		LMD_COM_SELECTN_ARRIVAL_DATE	DATS	16
CHECK_SUM_UPL_STOPS	Checksum for Number of Uploaded Stops		LMD_COM_CHECK_SUM_UPL_STOPS	INT2	2
GENERIC_BATCH	Generic Batch		LMD_COM_GENERIC_BATCH	CHAR	20
MOBILE_ACCESS_TYPE	Mobile Access Type		LMD_COM_MOBILE_ACCESS_TYPE	CHAR	4
.INCLUDE				INCL_EEW_LMD_COM_ROUTE_PS	0
EEW_LMD_COM_ROUTE	Dummy function in length 1		DUMMY	CHAR	2