I_LSTMIROUTEDOCUMENT

CDS View
42 Fields 9 CDS Views

Last Mile Distribution Route Document

I_LSTMIROUTEDOCUMENT is a CDS View in S/4HANA. Last Mile Distribution Route Document. It contains 42 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_LastMileRouteBillingDocument view_entity from COMPOSITE Last Mile Route Billing Doc
I_LstMiRouteDocumentEnhanced view_entity from COMPOSITE Last Mile Distribution Document Enhanced
I_LstMiRouteDocumentEnhanced view_entity union_all COMPOSITE Last Mile Distribution Document Enhanced
I_LstMiRouteLoad view_entity from COMPOSITE LMD Route Load Document
I_LstMiRouteOutboundDelivery view from BASIC Basic View for Outbound Deliveries
I_LstMiRteCustDocType view_entity from BASIC LMD Custom Document Types
I_LstMiRteMblBillingDocument view from COMPOSITE Last Mile Route Mobile Billing Doc
I_LstMiRteProductProposal view_entity from BASIC LMD Product Proposals
P_LstMiRouteDocumentEnhcdDEX view_entity from CONSUMPTION

Fields (42)

KeyField CDS FieldsUsed in Views
KEY LstMiRouteDocumentHeaderUUID LstMiRouteDocumentHeaderUUID 2
_Item _Item 2
_Route _Route 2
_ShipToPartyVH _ShipToPartyVH 1
_SoldToPartyVH _SoldToPartyVH 1
_Stop _Stop 2
AddressID AddressID 2
CustomerPaymentTerms CustomerPaymentTerms 2
CustomerReferenceNumber CustomerReferenceNumber 2
DistributionChannel DistributionChannel 2
Division Division 2
DocumentReferenceID DocumentReferenceID 2
LastMileReferenceRoute LastMileReferenceRoute 2
LastMileRouteCurrency LastMileRouteCurrency 2
LastMileRouteDocumentAmount LastMileRouteDocumentAmount 2
LastMileRouteDocumentDate LastMileRouteDocumentDate 2
LastMileRouteDocumentIsReturn LastMileRouteDocumentIsReturn 2
LastMileRouteDocumentNumber LastMileRouteDocumentNumber 2
LastMileRouteDocumentType LastMileRouteDocumentType 2
LastMileRouteDocumentYear LastMileRouteDocumentYear 2
LastMileRouteIsMnllyAddedRecd LastMileRouteIsMnllyAddedRecd 2
LastMileRouteOriginCode LastMileRouteOriginCode 2
LastMileRouteRequestedDelivDte LastMileRouteRequestedDelivDte 2
LastMileRouteSDDocumentType LastMileRouteSDDocumentType 2
LastMileRouteStopUUID LastMileRouteStopUUID 2
LastMileRouteUUID LastMileRouteUUID 5
LastMileRouteVisitUUID LastMileRouteVisitUUID 2
LastMileStockTransferType LastMileStockTransferType 2
LstMiIsDocCreatedBySettlement LstMiIsDocCreatedBySettlement 2
LstMiRouteDocumentReasonCode LstMiRouteDocumentReasonCode 2
LstMiRteAssgdPaytColltdAmount LstMiRteAssgdPaytColltdAmount 2
LstMiRteCustRlvtOrderNumber LstMiRteCustRlvtOrderNumber 2
LstMiRteDocumentSignatureDate LstMiRteDocumentSignatureDate 2
LstMiRteIsUpdtdInTranspMgmt LstMiRteIsUpdtdInTranspMgmt 2
LstMiRtePriceCondition1Value LstMiRtePriceCondition1Value 2
LstMiRtePriceCondition2Value LstMiRtePriceCondition2Value 2
LstMiRtePriceCondition3Value LstMiRtePriceCondition3Value 2
LstMiRtePriceCondition4Value LstMiRtePriceCondition4Value 2
SalesOrganization SalesOrganization 2
SDDocument SDDocument 2
ShiptoParty ShiptoParty 2
SoldToParty SoldToParty 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.

-- Last Mile Distribution Route Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LSTMIROUTEDOCUMENT (
    LSTMIROUTEDOCUMENTHEADERUUID,
    _ITEM,
    _ROUTE,
    _SHIPTOPARTYVH,
    _SOLDTOPARTYVH,
    _STOP,
    ADDRESSID,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERREFERENCENUMBER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    LASTMILEREFERENCEROUTE,
    LASTMILEROUTECURRENCY,
    LASTMILEROUTEDOCUMENTAMOUNT,
    LASTMILEROUTEDOCUMENTDATE,
    LASTMILEROUTEDOCUMENTISRETURN,
    LASTMILEROUTEDOCUMENTNUMBER,
    LASTMILEROUTEDOCUMENTTYPE,
    LASTMILEROUTEDOCUMENTYEAR,
    LASTMILEROUTEISMNLLYADDEDRECD,
    LASTMILEROUTEORIGINCODE,
    LASTMILEROUTEREQUESTEDDELIVDTE,
    LASTMILEROUTESDDOCUMENTTYPE,
    LASTMILEROUTESTOPUUID,
    LASTMILEROUTEUUID,
    LASTMILEROUTEVISITUUID,
    LASTMILESTOCKTRANSFERTYPE,
    LSTMIISDOCCREATEDBYSETTLEMENT,
    LSTMIROUTEDOCUMENTREASONCODE,
    LSTMIRTEASSGDPAYTCOLLTDAMOUNT,
    LSTMIRTECUSTRLVTORDERNUMBER,
    LSTMIRTEDOCUMENTSIGNATUREDATE,
    LSTMIRTEISUPDTDINTRANSPMGMT,
    LSTMIRTEPRICECONDITION1VALUE,
    LSTMIRTEPRICECONDITION2VALUE,
    LSTMIRTEPRICECONDITION3VALUE,
    LSTMIRTEPRICECONDITION4VALUE,
    SALESORGANIZATION,
    SDDOCUMENT,
    SHIPTOPARTY,
    SOLDTOPARTY,
    PRIMARY KEY (LSTMIROUTEDOCUMENTHEADERUUID)
);

Learn More