LMD_VL_SLSPROPOS

Transparent Table Application Table
10 Fields 1 CDS Views

Visit List - Product Proposal

LMD_VL_SLSPROPOS is an SAP database table in S/4HANA. Visit List - Product Proposal. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LastMileVisitSalesProposal view_entity from BASIC LMD Visit Sales Proposal Base

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY visit_uuid LMD_VL_VISIT_UUID Visit UUID
KEY proposal_posno LMD_VL_SALES_PROPOSAL_POSNO Product Proposal Item Number
visit_list_uuid LMD_VL_VISIT_LIST_UUID Visit List UUID
product MATNR Material
quantity MENG15 Quantity
uom MEINS Base Unit
sales_organisation VKORG Sales Org.
distribution_channel VTWEG Distr. Channel
division SPART Division

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 - Product Proposal
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_VL_SLSPROPOS (
    MANDT,                 -- Client [MANDT]
    VISIT_UUID,            -- Visit UUID [LMD_VL_VISIT_UUID]
    PROPOSAL_POSNO,        -- Product Proposal Item Number [LMD_VL_SALES_PROPOSAL_POSNO]
    VISIT_LIST_UUID,       -- Visit List UUID [LMD_VL_VISIT_LIST_UUID]
    PRODUCT,               -- Material [MATNR]
    QUANTITY,              -- Quantity [MENG15]
    UOM,                   -- Base Unit [MEINS]
    SALES_ORGANISATION,    -- Sales Org. [VKORG]
    DISTRIBUTION_CHANNEL,  -- Distr. Channel [VTWEG]
    DIVISION,              -- Division [SPART]
    PRIMARY KEY (MANDT, VISIT_UUID, PROPOSAL_POSNO)
);

Learn More