LMD_COM_STOPS

Transparent Table Application Table
27 Fields 2 CDS Views

Last Mile Distribution Stops

LMD_COM_STOPS is an SAP database table in S/4HANA. Last Mile Distribution Stops. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LstMiRouteStop view_entity from BASIC Basic View for Route Stops
P_LstMiUIRouteDocument view_entity from COMPOSITE

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY stop_uuid LMD_ROUTE_STOP_UUID Stop UUID
stop_id LMD_COM_STOP_ID Stop ID
stop_type LMD_COM_STOP_TYPE Stop Type
stop_stage_id LMD_COM_STAGE_ID Stage ID
vl_visit_uuid LMD_VL_VISIT_UUID Visit UUID
route_uuid LMD_ROUTE_UUID Route UUID
sequence LMD_COM_SEQUENCE Sequence Number
location_id LMD_COM_LOCATION Location
shipto_party_id LMD_COM_SHIPTO_PARTY_ID Ship-To Party ID
planned_arrival_timestamp LMD_COM_TIMESTAMP Timestamp
planned_departure_timestamp LMD_COM_TIMESTAMP Timestamp
actual_arrival_timestamp LMD_COM_TIMESTAMP Timestamp
actual_departure_timestamp LMD_COM_TIMESTAMP Timestamp
odometer LMD_COM_ODOMETER Odometer
clerk_name LMD_COM_CHECKER_NAME Checker
is_manually_added LMD_COM_IS_MANUALLY_ADDED Manually Added
execution_reason_code LMD_COM_REASON_CODE Reason
is_reversal_in_process LMD_COM_IS_REVERSAL_IN_PROCESS Reversal in Process
processing_status LMD_COM_STOP_STATUS Route Stop Status
location_address_id LMD_COM_LOCATION_ADDRESS_ID Location Address ID
coci_behavior LMD_COM_COCI_BEHAVIOUR COCI Behavior
is_removed LMD_COM_IS_REMOVED Removed
origin_code LMD_COM_ORIGIN_CODE Origin
replication_request_status LMD_COM_REPLICATION_REQ_STATUS Replication Request Status
settled_on_timestamp LMD_COM_SETTLED_ON_TIMESTAMP Set to "Settled" On
eew_lmd_com_stop DUMMY Dummy function in length 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Last Mile Distribution Stops
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_COM_STOPS (
    CLIENT,                       -- abap.clnt
    STOP_UUID,                    -- Stop UUID [LMD_ROUTE_STOP_UUID]
    STOP_ID,                      -- Stop ID [LMD_COM_STOP_ID]
    STOP_TYPE,                    -- Stop Type [LMD_COM_STOP_TYPE]
    STOP_STAGE_ID,                -- Stage ID [LMD_COM_STAGE_ID]
    VL_VISIT_UUID,                -- Visit UUID [LMD_VL_VISIT_UUID]
    ROUTE_UUID,                   -- Route UUID [LMD_ROUTE_UUID]
    SEQUENCE,                     -- Sequence Number [LMD_COM_SEQUENCE]
    LOCATION_ID,                  -- Location [LMD_COM_LOCATION]
    SHIPTO_PARTY_ID,              -- Ship-To Party ID [LMD_COM_SHIPTO_PARTY_ID]
    PLANNED_ARRIVAL_TIMESTAMP,    -- Timestamp [LMD_COM_TIMESTAMP]
    PLANNED_DEPARTURE_TIMESTAMP,  -- Timestamp [LMD_COM_TIMESTAMP]
    ACTUAL_ARRIVAL_TIMESTAMP,     -- Timestamp [LMD_COM_TIMESTAMP]
    ACTUAL_DEPARTURE_TIMESTAMP,   -- Timestamp [LMD_COM_TIMESTAMP]
    ODOMETER,                     -- Odometer [LMD_COM_ODOMETER]
    CLERK_NAME,                   -- Checker [LMD_COM_CHECKER_NAME]
    IS_MANUALLY_ADDED,            -- Manually Added [LMD_COM_IS_MANUALLY_ADDED]
    EXECUTION_REASON_CODE,        -- Reason [LMD_COM_REASON_CODE]
    IS_REVERSAL_IN_PROCESS,       -- Reversal in Process [LMD_COM_IS_REVERSAL_IN_PROCESS]
    PROCESSING_STATUS,            -- Route Stop Status [LMD_COM_STOP_STATUS]
    LOCATION_ADDRESS_ID,          -- Location Address ID [LMD_COM_LOCATION_ADDRESS_ID]
    COCI_BEHAVIOR,                -- COCI Behavior [LMD_COM_COCI_BEHAVIOUR]
    IS_REMOVED,                   -- Removed [LMD_COM_IS_REMOVED]
    ORIGIN_CODE,                  -- Origin [LMD_COM_ORIGIN_CODE]
    REPLICATION_REQUEST_STATUS,   -- Replication Request Status [LMD_COM_REPLICATION_REQ_STATUS]
    SETTLED_ON_TIMESTAMP,         -- Set to "Settled" On [LMD_COM_SETTLED_ON_TIMESTAMP]
    EEW_LMD_COM_STOP,             -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, STOP_UUID)
);

Learn More