CDS Views for Last Mile Distribution (LE-LMD)

CDS View NameDescriptionSQL View Name
C_LSTMIRTEDOCUMENTSROUTEVISITLst Mile Docs Settled Routes Route VisitCLSTMIRDRTEVST
C_LSTMISETTLMTOVWROUTELast Mile Settlement Ovw RouteCLMSETTLOVWRT
C_LSTMISETTLMTOVWRTECHKINDIFFLast Mile Distr Settlmnt Ovw ChkIn DiffsCLMDSORCD
C_LSTMISETTLMTOVWRTEINVCDIFFLast Mile Settlement Ovw Rte Invc DiffsCLMDSORID
C_LSTMISETTLMTOVWRTELFCYCSTSLast Mile Settlement Ovw Route LifecycleCLMSETTLOVWRTLC
C_LSTMISETTLMTOVWRTESETTLMTSTSLast Mile Settlement Ovw Rte SettlementCLMSETTLOVWRTS
C_LSTMISETTLMTOVWUNCMPLTDDOCSLast Mile Settlmt Ovw Visit Uncmpltd DocCLMDSOVUDS
I_LSTMICOLLTDPAYMENTSROUTEIDVHLast Mile Collected Payments Route ID VHILMDCPRTIDVH
I_LSTMICOLLTDPAYTBYRTEPAYTTYPELMD Collected Payments by Rte Payt TypeILSTMIRTCOPBRTPT
I_LSTMIDIFFERENCESTATUSLast Mile Distribution Difference StatusILSTMIDIFFS
I_LSTMIDIFFERENCESTATUSTEXTLast Mile Distribution Diff. Status TextILSTMIDIFFST
I_LSTMIEXTDOCINCOMPLTNSTATUSLMD Ext Doc Incompletion StatusILSTMIEDICS
I_LSTMIEXTDOCINCOMPLTNSTSTEXTLMD Ext Doc Incompletion Status TextILSTMIEDICST
I_LSTMIEXTDOCUMENTSTATUSLast Mile Distr. External Doc. StatusILSTMIRTDS
I_LSTMIEXTDOCUMENTSTATUSTEXTLast Mile Distr. Ext. Doc. Status TextILSTMIRTDST
I_LSTMIFINCLRGDOCSTATUSTEXTLast Mile Clearing Document Status TextILSTMICDST
I_LSTMIFINCLRGDOCUMENTSTATUSLast Mile Clearing Document StatusILSTMICDS
I_LSTMIFININVOICELast Mile FI InvoiceILSTMIFININV
I_LSTMIMMGOODSISSUELast Mile Distribution MM Goods IssueILSTMIMMGI
I_LSTMIOVWROUTEERRORSTATUSTEXTLast Mile Ovw Rte Error Status TextILSTMIOVWREST
I_LSTMIPROCESSMAINTENANCEProcess Framework Process MaintenanceILSTMIPFRWPRCMNT
I_LSTMIPRODUCTPACKAGESIZETEXTProduct Package Size TextILSTMICPCKGSZTXT
I_LSTMIPRODUCTPACKAGESIZEVHProduct Package Size Value HelpILSTMICPCKGSZVH
I_LSTMIPRODUCTPACKAGETYPETEXTProduct Package Type TextILSTMICPCKGTYTXT
I_LSTMIPRODUCTPACKAGETYPEVHProduct Package Type Value HelpILSTMICPCKGTYVH
I_LSTMIPRODUCTTOLERANCETYTEXTProduct Tolerance Type TextILSTMICTLRCTYTXT
I_LSTMIPRODUCTTOLERANCETYVHProduct Tolerance Type Value HelpILSTMICTLRCTYVH
I_LSTMIROUTELast Mile Distribution RouteILMROUTE
I_LSTMIROUTECHECKINPAYMENTLast Mile Route Basic View CheckIn PaymILSTMIRTCIPAYM
I_LSTMIROUTECOCIPAYMENTLast Mile Route Basic View for COCI PaymILSTMIRTCOCIPAYM
I_LSTMIROUTECOCIPRODUCTLast Mile Distribution Route COCI ProducILSTMIRTECOCIPRD
I_LSTMIROUTECOLLECTEDPAYMENTBasic View for Collected PaymentsILSTMIRTECOLPAY
I_LSTMIROUTECOLLECTIONLast Mile Distribution Route CollectionILSTMIRTCOLLECT
I_LSTMIROUTEDOCUMENTLast Mile Distribution Route DocumentILSTMIDOC
I_LSTMIROUTEDOCUMENTITEMLast Mile Distribution Route Doc ItemILSTMIDOCITM
I_LSTMIROUTEDOCUMENTTYPELast Mile Distribution Document TypeILSTMIRTDT
I_LSTMIROUTEDOCUMENTTYPETEXTLast Mile Distribution Doc. Type TextILSTMIRTDTT
I_LSTMIROUTEDRIVERVHLast Mile Route Driver VHILMDRTEDRIVERVH
I_LSTMIROUTEENHANCEDLast Mile Distr. Colltd Payts Route Enh.ILMROUTEENHCD
I_LSTMIROUTEIDVHLast Mile Route ID VHILMDROUTEIDVH
I_LSTMIROUTELICENSEPLATEVHLast Mile Route License Plate VHILMDROUTELICPLVH
I_LSTMIROUTELIFECYCLESTATUSLast Mile Route Lifecycle StatusILMROUTELFCYST
I_LSTMIROUTEOUTBOUNDDELIVERYBasic View for Outbound DeliveriesILSTMIRTODEL
I_LSTMIROUTEOUTBOUNDDELIVERYVHLst Mi Route Outbound Delivery Number VHILSTMIRTEOBDELVH
I_LSTMIROUTESETTLEMENTSTATUSLast Mile Route Settlement StatusILMROUTESETLST
I_LSTMIROUTESOURCELOCATIONTEXTLast Mile Route Source Location TextILMDRTSRCLOCT
I_LSTMIROUTESOURCELOCATIONVHLast Mile Route Source Location VHILMDRTSRCLOCVH
I_LSTMIROUTESTATUSTEXTLast Mile Route Status TextILMRTSTATUSTXT
I_LSTMIROUTESTOPBasic View for Route StopsILSTMIRTESTOP
I_LSTMIROUTETYPETEXTLast Mile UI Route Type TextILMDRTTYPETEXT
I_LSTMIROUTETYPEVHLast Mile UI Route Type Value HelpILMDRTTYPEVH
I_LSTMIROUTEVISITBasic View for Route VisitsILSTMIRTEVISIT
I_LSTMIROUTEVISITENHANCEDLast Mile Distribution Route VisitsILSTMIRTEVISITE
I_LSTMIROUTEVISITENHCDBYROUTELMD Route Visits grp by Route,CurrencyILSTMIRTVSENBYRT
I_LSTMIROUTEVISITSHIPTOPARTYVHLast Mile Route Ship-To Party VHILSTMIRVCUSTVH
I_LSTMIROUTEVISITTOSDINVOICELast Mile Distribution Map Invc to VisitILSTMIVSTOINV
I_LSTMIRPTGDOCUMENTTYPELast Mile Distribution Rep Doc TypeILSTMIRRTDT
I_LSTMIRPTGDOCUMENTTYPETEXTLast Mile Distr Rep Doc Type - TextILSTMIRRTDTT
I_LSTMIRPTGSETLDROUTEDOCUMENTLast Mile Distr Rptg Setl Route DocILSTMIRRTSDOC
I_LSTMIRTECHKINPAYTAMTBYROUTELast Mile Route CheckIn Pays by RouteILSTMIRTCIPMABYR
I_LSTMIRTECOLLTDPAYTAMTBYROUTELMD Collected Payments by RouteILSTMIRTCOLPBYRT
I_LSTMIRTECOLLTDPAYTASSIGNMENTLast Mile Distr. Payment AssignmentsILSTMIRTEPASS
I_LSTMIRTECOLLTDPAYTBYRTEVISITLast Mile Collected Payments Route VisitILSTMIRTCPBYVIS
I_LSTMIRTEDOCSCLEARINGSTATUSLast Mile Clearing Document StatusILSTMIDCSTS
I_LSTMIRTEDOCSHIPTOPARTYVHLast Mile Route Document ShiptoParty VHILSTMIRDDOCSTVH
I_LSTMIRTEDOCSOLDTOPARTYVHLast Mile Route Document SoldToParty VHILSTMIRDDOCSOTVH
I_LSTMIRTEEXECORGANIZATIONVHLast Mile Route Exec Organization VHILMDEXECORGVH
I_LSTMIRTEVISITTOSDSALESORDERLast Mile Distribution Map SlOr to VisitILSTMIVSTOSORDR
I_LSTMISDINVOICELast Mile Distribution SD InvoiceILSTMISDINV
I_LSTMISDINVOICEBYROUTEVISITGroup Billing Documents by Route VisitILSTMISDINVBYRTE
I_LSTMISDOUTBDELIVTOSDINVOICELast Mile Distribution Map Del to InvcILSTMISDODSDINV
I_LSTMISDOUTBDELIVTOSDSLSORDLast Mile Distr. Map Delvry to SlsOrdILSTMISDODSDSO
I_LSTMISDSALESORDERLast Mile Distribution SD SalesOrderILSTMISDSORD
I_LSTMISDSALESORDERTOSDINVOICELast Mile Distribution Map Invc to VisitILSTMISDSOSDINV
I_LSTMISDSLSORDTOMMGOODSISSUELast Mile Distr Map SlsOrd to Gds IssueILSTMISOTOMMGI
I_LSTMISETTLEDROUTEIDVHLast Mile RouteIDILMDSETLRTEIDVH
I_LSTMISETTLMTOVWRTESTATUSTEXTLast Mile Settlement Ovw Status TextILMSOVWRSTVH
I_LSTMISTATUSMGMTDEFINITIONStatus Management Status DefinitionsILMSMDEF
I_LSTMISTATUSMGMTDEFTEXTStatus Mgmt Status Definition TextsILMSMDEFT
I_LSTMISTATUSMGMTHISTORYStatus Management HistoryILMSMHISTORY
I_LSTMISTATUSMGMTOBJECTSTATUSStatus Management Object StatusesILMSMOBJSTAT
I_LSTMITRANSPMGMTFREIGHTORDERLast Mile Distribution TM Freight OrderILSTMIFROR
I_LSTMITRANSPMGMTFREIGHTUNITLast Mile Distribution TM Freight UnitILSTMIFRUN
P_LSTMICOLLTDPAYTSROUTELast Mile Distr. Colltd Payts Route Enh.PLMCOLLTDPAYTSRT
P_LSTMICOLLTDPAYTSRTEHIERDATACollected Payments Visit Inv Hier DataPLSTMICTPTSRTEHD
P_LSTMICOLLTDPAYTSRTEHIERDIRCollected Payments DirectoryPLSTMICTPTSDIR
P_LSTMICOLLTDPAYTSRTENODERLTNCollected Payments DirectoryPLSTMICTPTSRLTN
P_LSTMICOLLTDPAYTSRTEUNIONCollected Payments Visit Inv UnionPLSTMICTPTSRTEUN
P_LSTMIEXTDOCUMENTSTATUSLast Mile Distr. External Doc. StatusPLSTMIRTDS
P_LSTMIEXTDOCUMENTSTATUSTEXTLast Mile Distr. Ext. Doc. Status TextPLSTMIRTDST
P_LSTMIEXTERNALDOCUMENTSLast Mile External DocumentsPLSTMIEXTDOC
P_LSTMIEXTERNALDOCUMENTSENHCDLst Mi Rte Vst Ext Doc Completion StatusPLSTMIEXDOCE
P_LSTMIFIACCTGDOCITMBYDOCUMENTLast Mile FI Accounting Item by DocumentPLSTMIRTACCDOC
P_LSTMIROUTELast Mile Distr. Colltd Payments RoutePLMROUTE
P_LSTMIROUTEVISITLast Mile Distribution Route Visits Helper ViewPLSTMIRTEVISITE
P_LSTMIRTEDOCSEXTDOCCLRGSTATUSCollected Payments Visit Inv Hier DataPLSTMIRDEDCSTS
P_LSTMIRTEDOCSNODERELATIONCollected Payments DirectoryPLSTMIRDNR
P_LSTMIRTEDOCSROUTEVISITLast Mile Distribution Route VisitsPLSTMIRTDCSRTEV
P_LSTMIRTEDOCSRTEVISITHIERDIRDocuments for Settled Route DirectoryPLSTMIRDRVHIDIR
P_LSTMIRTEDOCSVISITWSTATUSLast Mile Distribution Route VisitsPLSTMIRTEDVIST
P_LSTMIRTEEXTDOCUNCOMPLTNSTSLst Mi Rte Ext Doc Uncompletion StatusPLSTMIEDUCS
P_LSTMIRTEVSTTOBILLINGDOCUMENTLast Mile Distribution Visit to Bil.Doc.PLSTMIVSTOBD
P_LSTMISDDOCUMENTPROCESSFLOWLast Mile SD Document Process FlowPLSTMISDDOCPRFL
P_LSTMISETTLMOVWVISITWDOCSTSLast Mile Distribution Route VisitsPLSTMIRTEVISITS
P_LSTMISETTLMTOVWRTEDIFFERENCELast Mile Settlement Ovw.Rte.Invc.Diff.PLMDSORD
P_LSTMISETTLMTOVWRTELFCYCSTSLast Mile Settlmt Overview Route Lifecycle StatusPLSTMIOVWRTLCST
P_LSTMISETTLMTOVWRTESETTLMTSTSLast Mile Settlmt Overview Route StatusPLSTMIOVWRTST
P_LSTMISETTLMTOVWRTESTATUSTEXTLast Mile UI Route Status TextPLMSOVWRSTXT
P_LSTMISETTLMTOVWUNCMPLTDDOCSLast Mile Settlmt Ovw Visit Uncmpltd DocPLMDSOVUDS
P_LSTMITRANSPMGMTFREIGHTORDERLast Mile Distribution TM Freight UnitPLSTMIFROD
P_LSTMITRANSPMGMTFREIGHTUNITLast Mile Distribution TM Freight UnitPLSTMIFRUN
P_LSTMITRANSPORTATIONORDERLast Mile Distribution TM Freight UnitPLSTMITROR