I_LSTMIROUTEDOCUMENTITEM

CDS View
39 Fields 6 CDS Views

Last Mile Distribution Route Doc Item

I_LSTMIROUTEDOCUMENTITEM is a CDS View in S/4HANA. Last Mile Distribution Route Doc Item. It contains 39 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_LstMiRouteLoadItem view_entity from COMPOSITE LMD Route Load Document Item
I_LstMiRouteOutboundDelivItem view_entity from COMPOSITE Outbound Delivery Items
I_LstMiRteDocumentItemEnhanced view from COMPOSITE Lst Mile Rte Doc Item Enhanced
P_LstMiRteDocItemEnhcdDEX view_entity from CONSUMPTION
P_LstMiUIProdLowrLvlBatchCount view_entity from TRANSACTIONAL
P_LstMiUIRteCOCIItem view_entity union_all COMPOSITE

Fields (39)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 3
KEY HigherLevelItem HigherLevelItem 3
KEY LastMileRouteDocumentItemUUID LastMileRouteDocumentItemUUID 2
KEY LastMileRteInventoryGroupCode LastMileRteInventoryGroupCode 3
KEY LstMiRouteDocumentHeaderUUID LstMiRouteDocumentHeaderUUID 3
KEY LstMiRteInvtryGrpDiffCode LastMileRteInventoryGroupCode 1
KEY ProductID ProductID 3
KEY UnitOfMsrOfDelivUnit LstMiRouteProductUnitOfMeasure,UnitOfMsrOfDelivUnit 3
_Document _Document 2
_ProductVH _ProductVH 2
_Route _Route 2
_SalesDocumentItem _SalesDocumentItem 2
_Stop _Stop 2
CustomerReferenceNumber CustomerReferenceNumber 2
LastMileRouteDocumentType LastMileRouteDocumentType 2
LastMileRouteIsMnllyAddedRecd LastMileRouteIsMnllyAddedRecd 2
LastMileRouteItemIsTiedEmpty LastMileRouteItemIsTiedEmpty 2
LastMileRouteItemIsUntiedEmpty LastMileRouteItemIsUntiedEmpty 2
LastMileRouteItemReasonCode LastMileRouteItemReasonCode 2
LastMileRoutePlannedQuantity LastMileRoutePlannedQuantity 2
LastMileRouteProductIsFreeGood LastMileRouteProductIsFreeGood 2
LastMileRouteProductIsReturn LastMileRouteProductIsReturn 2
LastMileRouteRefDocumentType LastMileRouteRefDocumentType 2
LastMileRouteStopUUID LastMileRouteStopUUID 2
LastMileRouteUnloadingLocation LastMileRouteUnloadingLocation 2
LastMileRouteUUID LastMileRouteUUID 2
LstMiRouteDocumentItemAmount LstMiRouteDocumentItemAmount 2
LstMiRouteDocumentItemCurrency LstMiRouteDocumentItemCurrency 2
LstMiRteOmniChannelFreeGoodsID LstMiRteOmniChannelFreeGoodsID 2
LstMiRtePriceCondition1Value LstMiRtePriceCondition1Value 2
LstMiRtePriceCondition2Value LstMiRtePriceCondition2Value 2
LstMiRtePriceCondition3Value LstMiRtePriceCondition3Value 2
LstMiRtePriceCondition4Value LstMiRtePriceCondition4Value 2
OmniChannelSalesPromotion OmniChannelSalesPromotion 2
Plant Plant 3
ReferenceSDDocument ReferenceSDDocument 2
ReferenceSDDocumentItem ReferenceSDDocumentItem 2
SDDocument SDDocument 2
SDDocumentItem SDDocumentItem 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 Doc Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LSTMIROUTEDOCUMENTITEM (
    BATCH,
    HIGHERLEVELITEM,
    LASTMILEROUTEDOCUMENTITEMUUID,
    LASTMILERTEINVENTORYGROUPCODE,
    LSTMIROUTEDOCUMENTHEADERUUID,
    LSTMIRTEINVTRYGRPDIFFCODE,
    PRODUCTID,
    UNITOFMSROFDELIVUNIT,
    _DOCUMENT,
    _PRODUCTVH,
    _ROUTE,
    _SALESDOCUMENTITEM,
    _STOP,
    CUSTOMERREFERENCENUMBER,
    LASTMILEROUTEDOCUMENTTYPE,
    LASTMILEROUTEISMNLLYADDEDRECD,
    LASTMILEROUTEITEMISTIEDEMPTY,
    LASTMILEROUTEITEMISUNTIEDEMPTY,
    LASTMILEROUTEITEMREASONCODE,
    LASTMILEROUTEPLANNEDQUANTITY,
    LASTMILEROUTEPRODUCTISFREEGOOD,
    LASTMILEROUTEPRODUCTISRETURN,
    LASTMILEROUTEREFDOCUMENTTYPE,
    LASTMILEROUTESTOPUUID,
    LASTMILEROUTEUNLOADINGLOCATION,
    LASTMILEROUTEUUID,
    LSTMIROUTEDOCUMENTITEMAMOUNT,
    LSTMIROUTEDOCUMENTITEMCURRENCY,
    LSTMIRTEOMNICHANNELFREEGOODSID,
    LSTMIRTEPRICECONDITION1VALUE,
    LSTMIRTEPRICECONDITION2VALUE,
    LSTMIRTEPRICECONDITION3VALUE,
    LSTMIRTEPRICECONDITION4VALUE,
    OMNICHANNELSALESPROMOTION,
    PLANT,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    SDDOCUMENT,
    SDDOCUMENTITEM,
    PRIMARY KEY (BATCH, HIGHERLEVELITEM, LASTMILEROUTEDOCUMENTITEMUUID, LASTMILERTEINVENTORYGROUPCODE, LSTMIROUTEDOCUMENTHEADERUUID, LSTMIRTEINVTRYGRPDIFFCODE, PRODUCTID, UNITOFMSROFDELIVUNIT)
);

Learn More