P_LSTMIROUTEVISIT

CDS View
14 Fields 2 CDS Views

P_LSTMIROUTEVISIT is a CDS View in S/4HANA. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LstMiRouteVisitEnhanced view from COMPOSITE Last Mile Distribution Route Visits
I_LstMiRteColltdPaymentsVisit view_entity from COMPOSITE Last Mile Route Collected Payments Visit

Fields (14)

KeyField CDS FieldsUsed in Views
KEY LastMileRouteVisitUUID LastMileRouteVisitUUID 2
_CollectedPaymentTotal _CollectedPaymentTotal 1
_OutboundDelivery _OutboundDelivery 1
_Route _Route 2
_RouteCurrency _RouteCurrency 1
_SDInvoiceTotal _SDInvoiceTotal 1
_ShipToPartyVH _ShipToPartyVH 2
LastMileRouteCurrency LastMileRouteCurrency 2
LastMileRouteStopSequenceValue LastMileRouteStopSequenceValue 2
LastMileRouteUUID LastMileRouteUUID 2
LstMiRteAssgdPaytColltdAmount LstMiRteAssgdPaytColltdAmount 1
LstMiRteColltdPaytInvcDiffAmt LstMiRteColltdPaytInvcDiffAmt 1
LstMiRteMblBillgDocGrossAmount LstMiRteMblBillgDocGrossAmount 1
ShipToParty ShipToParty 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_LSTMIROUTEVISIT (
    LASTMILEROUTEVISITUUID,
    _COLLECTEDPAYMENTTOTAL,
    _OUTBOUNDDELIVERY,
    _ROUTE,
    _ROUTECURRENCY,
    _SDINVOICETOTAL,
    _SHIPTOPARTYVH,
    LASTMILEROUTECURRENCY,
    LASTMILEROUTESTOPSEQUENCEVALUE,
    LASTMILEROUTEUUID,
    LSTMIRTEASSGDPAYTCOLLTDAMOUNT,
    LSTMIRTECOLLTDPAYTINVCDIFFAMT,
    LSTMIRTEMBLBILLGDOCGROSSAMOUNT,
    SHIPTOPARTY,
    PRIMARY KEY (LASTMILEROUTEVISITUUID)
);

Learn More