LMD_VL_VISIT

Transparent Table Application Table
17 Fields 2 CDS Views

Visit List - Visit

LMD_VL_VISIT is an SAP database table in S/4HANA. Visit List - Visit. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_LastMileVisit view from EXTENSION LMD Extension Include for Visit
I_LastMileVisit view from BASIC LMD Visit Basic

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY visit_uuid LMD_VL_VISIT_UUID Visit UUID
visit_list_uuid LMD_VL_VISIT_LIST_UUID Visit List UUID
visit_id LMD_VL_VISIT_ID Visit ID
visit_ext_uuid LMD_VL_VISIT_EXT_UUID Visit External UUID
customer_number KUNNR Customer
sequence LMD_VL_VISIT_SEQUENCE Visit Sequence
opening_time LMD_VL_OPENING_TIME Opening Time
closing_time LMD_VL_CLOSING_TIME Closing Time
planned_start_time LMD_VL_VISIT_PLN_START_TIME Planned Start Time of Visit
planned_end_time LMD_VL_VISIT_PLN_END_TIME Planned End Time of Visit
actual_start_time LMD_VL_VISIT_ACT_START_TIME Actual Start of Visit
actual_end_time LMD_VL_VISIT_ACT_END_TIME Actual End of Visit
execution_status LMD_VL_VISIT_STATUS Visit Status
planned_stop LMD_VL_VISIT_IS_PLANNED Planned Visit
proposal_unit_id LMD_VL_PROPOSAL_UNIT_ID Prod. Prop. Unit ID
dummy_lmdvlv_incl_eew_ps 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.

-- Visit List - Visit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_VL_VISIT (
    MANDT,                     -- Client [MANDT]
    VISIT_UUID,                -- Visit UUID [LMD_VL_VISIT_UUID]
    VISIT_LIST_UUID,           -- Visit List UUID [LMD_VL_VISIT_LIST_UUID]
    VISIT_ID,                  -- Visit ID [LMD_VL_VISIT_ID]
    VISIT_EXT_UUID,            -- Visit External UUID [LMD_VL_VISIT_EXT_UUID]
    CUSTOMER_NUMBER,           -- Customer [KUNNR]
    SEQUENCE,                  -- Visit Sequence [LMD_VL_VISIT_SEQUENCE]
    OPENING_TIME,              -- Opening Time [LMD_VL_OPENING_TIME]
    CLOSING_TIME,              -- Closing Time [LMD_VL_CLOSING_TIME]
    PLANNED_START_TIME,        -- Planned Start Time of Visit [LMD_VL_VISIT_PLN_START_TIME]
    PLANNED_END_TIME,          -- Planned End Time of Visit [LMD_VL_VISIT_PLN_END_TIME]
    ACTUAL_START_TIME,         -- Actual Start of Visit [LMD_VL_VISIT_ACT_START_TIME]
    ACTUAL_END_TIME,           -- Actual End of Visit [LMD_VL_VISIT_ACT_END_TIME]
    EXECUTION_STATUS,          -- Visit Status [LMD_VL_VISIT_STATUS]
    PLANNED_STOP,              -- Planned Visit [LMD_VL_VISIT_IS_PLANNED]
    PROPOSAL_UNIT_ID,          -- Prod. Prop. Unit ID [LMD_VL_PROPOSAL_UNIT_ID]
    DUMMY_LMDVLV_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, VISIT_UUID)
);

Learn More