I_LSTMIROUTEDOCUMENTENHANCED

CDS View

Last Mile Distribution Document Enhanced

I_LSTMIROUTEDOCUMENTENHANCED is a CDS View in S/4HANA. Last Mile Distribution Document Enhanced. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_LstMiUIRouteDocument view_entity union_all COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
AddressId AddressId 1
CustomerPaymentTerms LastMileRoutePaymentTerms 1
CustomerReferenceNumber CustomerReferenceNumber 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentReferenceID DocumentReferenceID 1
LastMileReferenceRoute LastMileReferenceRoute 1
LastMileRouteCurrency LastMileRouteCurrency 1
LastMileRouteDocumentAmount LastMileRouteDocumentAmount 1
LastMileRouteDocumentDate LastMileRouteDocumentDate 1
LastMileRouteDocumentIsReturn LstMiRteIsOnlyRetsPosAllowed 1
LastMileRouteDocumentType LastMileRouteDocumentType 1
LastMileRouteIsMnllyAddedRecd LastMileRouteIsMnllyAddedRecd 1
LastMileRouteOriginCode LastMileRouteOriginCode 1
LastMileRouteRequestedDelivDte LastMileRouteRequestedDelivDte 1
LastMileRouteStopUUID LastMileRouteStopUUID 1
LastMileRouteUUID LastMileRouteUUID 1
LastMileStockTransferType LastMileStockTransferType 1
LstMiRouteDocumentReasonCode LstMiRouteDocumentReasonCode 1
LstMiRteCustRlvtOrderNumber LstMiRteCustRlvtOrderNumber 1
LstMiRteDocIsCancldByRsnCode LstMiRteDocIsCancldByRsnCode 1
LstMiRteDocumentSignatureDate LstMiRteDocumentSignatureDate 1
LstMiRteVstIsCancldByRsnCode LstMiRteVstIsCancldByRsnCode 1
SalesOrganization SalesOrganization 1
SDDocument SalesDocument 1
ShiptoParty ShiptoParty 1
SoldToParty SoldToParty 1
SoldtoPartyId SoldToParty 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.

-- Last Mile Distribution Document Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LSTMIROUTEDOCUMENTENHANCED (
    ADDRESSID,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERREFERENCENUMBER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    LASTMILEREFERENCEROUTE,
    LASTMILEROUTECURRENCY,
    LASTMILEROUTEDOCUMENTAMOUNT,
    LASTMILEROUTEDOCUMENTDATE,
    LASTMILEROUTEDOCUMENTISRETURN,
    LASTMILEROUTEDOCUMENTTYPE,
    LASTMILEROUTEISMNLLYADDEDRECD,
    LASTMILEROUTEORIGINCODE,
    LASTMILEROUTEREQUESTEDDELIVDTE,
    LASTMILEROUTESTOPUUID,
    LASTMILEROUTEUUID,
    LASTMILESTOCKTRANSFERTYPE,
    LSTMIROUTEDOCUMENTREASONCODE,
    LSTMIRTECUSTRLVTORDERNUMBER,
    LSTMIRTEDOCISCANCLDBYRSNCODE,
    LSTMIRTEDOCUMENTSIGNATUREDATE,
    LSTMIRTEVSTISCANCLDBYRSNCODE,
    SALESORGANIZATION,
    SDDOCUMENT,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SOLDTOPARTYID
);