I_LSTMIROUTEDOCUMENTENHANCED
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_LstMiUIRouteDocument | view_entity | union_all | COMPOSITE |
Fields (28)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA