I_LASTMILEVISIT

CDS View
15 Fields 5 CDS Views

LMD Visit Basic

I_LASTMILEVISIT is a CDS View in S/4HANA. LMD Visit Basic. It contains 15 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_LastMileVisitDEX view from CONSUMPTION Last Mile Distribution Visit Data Extr
I_LastMilePlannedDeliv view_entity from COMPOSITE LMD Planned Deliveries and Returns
I_LastMilePlannedDeliv view_entity union_all COMPOSITE LMD Planned Deliveries and Returns
I_LastMileVisitCalculated view from COMPOSITE LMD Visit - Calculated fields
R_LastMileVisitTP view_entity from TRANSACTIONAL LMD Visit - Transactional View

Fields (15)

KeyField CDS FieldsUsed in Views
KEY LastMileVisitUUID LastMileVisitUUID 2
Customer Customer 1
LastMileVisitActEndDteTme LastMileVisitActEndDteTme 1
LastMileVisitActStartDteTme LastMileVisitActStartDteTme 1
LastMileVisitClosingTime LastMileVisitClosingTime 1
LastMileVisitExecutionStatus LastMileVisitExecutionStatus 1
LastMileVisitExtUUID LastMileVisitExtUUID 1
LastMileVisitID LastMileVisitID 1
LastMileVisitIsPlannedStop LastMileVisitIsPlannedStop 1
LastMileVisitListUUID LastMileVisitListUUID 1
LastMileVisitOpeningTime LastMileVisitOpeningTime 1
LastMileVisitPlnEndTime LastMileVisitPlnEndTime 1
LastMileVisitPlnStartTime LastMileVisitPlnStartTime 1
LastMileVisitProposalUnitID LastMileVisitProposalUnitID 1
LastMileVisitSequence LastMileVisitSequence 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.

-- LMD Visit Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LASTMILEVISIT (
    LASTMILEVISITUUID,
    CUSTOMER,
    LASTMILEVISITACTENDDTETME,
    LASTMILEVISITACTSTARTDTETME,
    LASTMILEVISITCLOSINGTIME,
    LASTMILEVISITEXECUTIONSTATUS,
    LASTMILEVISITEXTUUID,
    LASTMILEVISITID,
    LASTMILEVISITISPLANNEDSTOP,
    LASTMILEVISITLISTUUID,
    LASTMILEVISITOPENINGTIME,
    LASTMILEVISITPLNENDTIME,
    LASTMILEVISITPLNSTARTTIME,
    LASTMILEVISITPROPOSALUNITID,
    LASTMILEVISITSEQUENCE,
    PRIMARY KEY (LASTMILEVISITUUID)
);

Learn More