LMD_VL_VISITITEM

Transparent Table Application Table
18 Fields 2 CDS Views

Visit List - Visit Item

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_LastMileVisitItem view from EXTENSION LMD Extension Include for Visit Item
I_LastMileVisitItem view from BASIC LMD Visit Item Basic

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY visit_item_uuid LMD_VL_VISIT_ITEM_UUID Visit Item UUID
visit_list_uuid LMD_VL_VISIT_LIST_UUID Visit List UUID
visit_uuid LMD_VL_VISIT_UUID Visit UUID
visit_item_id LMD_VL_VISIT_ITEM_ID Visit Item ID
visit_item_ext_uuid LMD_VL_VISIT_ITEM_EXT_UUID Visit Item Ext. UUID
item_category LMD_VL_VISIT_ITEM_CATEGORY Item Category
visit_duration LMD_VL_VISIT_ITEM_DURATION Visit Duration
description LMD_VL_DESCRIPTION Description
priority LMD_VL_VISIT_ITEM_PRIORITY Priority
execution_status LMD_VL_VISIT_ITEM_STATUS Visit Item Status
actual_driver LMD_COM_DRIVER_ID Driver
sales_organisation VKORG Sales Org.
distribution_channel VTWEG Distr. Channel
division SPART Division
service_product LMD_COM_SERVICE_PRODUCT Service Product
service_unit_id LMD_VL_SERVICE_UNIT_ID Service Unit ID
dummy_lmdvlvi_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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_VL_VISITITEM (
    MANDT,                      -- Client [MANDT]
    VISIT_ITEM_UUID,            -- Visit Item UUID [LMD_VL_VISIT_ITEM_UUID]
    VISIT_LIST_UUID,            -- Visit List UUID [LMD_VL_VISIT_LIST_UUID]
    VISIT_UUID,                 -- Visit UUID [LMD_VL_VISIT_UUID]
    VISIT_ITEM_ID,              -- Visit Item ID [LMD_VL_VISIT_ITEM_ID]
    VISIT_ITEM_EXT_UUID,        -- Visit Item Ext. UUID [LMD_VL_VISIT_ITEM_EXT_UUID]
    ITEM_CATEGORY,              -- Item Category [LMD_VL_VISIT_ITEM_CATEGORY]
    VISIT_DURATION,             -- Visit Duration [LMD_VL_VISIT_ITEM_DURATION]
    DESCRIPTION,                -- Description [LMD_VL_DESCRIPTION]
    PRIORITY,                   -- Priority [LMD_VL_VISIT_ITEM_PRIORITY]
    EXECUTION_STATUS,           -- Visit Item Status [LMD_VL_VISIT_ITEM_STATUS]
    ACTUAL_DRIVER,              -- Driver [LMD_COM_DRIVER_ID]
    SALES_ORGANISATION,         -- Sales Org. [VKORG]
    DISTRIBUTION_CHANNEL,       -- Distr. Channel [VTWEG]
    DIVISION,                   -- Division [SPART]
    SERVICE_PRODUCT,            -- Service Product [LMD_COM_SERVICE_PRODUCT]
    SERVICE_UNIT_ID,            -- Service Unit ID [LMD_VL_SERVICE_UNIT_ID]
    DUMMY_LMDVLVI_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, VISIT_ITEM_UUID)
);

Learn More