- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_LstMiRoute
Last Mile Distr. Colltd Payments Route
| view: PLMROUTE | TRAN
| Extraction:
Not supported
| Component: Last Mile Distribution
Tables used:
LMD_COM_ROUTES, LMD_COM_STOPS, LMD_COM_COCIPAYS, LMD_COM_COL_PAYS, LMD_SM_DEF, LMD_SM_OBJ_STAT
| Column Name | Description | |
|---|---|---|
| LastMileRouteUUID | Route UUID |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Code (LstMiRteCheckInPaymentCurrency): | ||
| LstMiRteCheckInPaymentAmount | Total Check-In Amount | |
| 💲 Currency Code (LstMiRteColltdPaytCurrByRte): | ||
| LstMiRteCollectedPaymentAmount | Total Amount of Collected Payments | |
| LstMiRteColltdPaytCashAmount | Total Amount of Collected Cash | |
| LstMiRteColltdPaytCheckAmount | Total Amount of Collected Checks | |
| 💲 Currency Code (LastMileRouteCurrency): | ||
| LstMiRteChkInDifferenceAmount | Total Amount of Check-In Difference | |
| Column Name | Description | |
|---|---|---|
| 📏 Distance Unit of Measure (LstMiRteOdometerUnitOfMeasure): | ||
| LstMiRteDeptrOdometerQuantity | Odometer Reading at Departure | |
| LstMiRteArrvlOdometerQuantity | Odometer Reading at Arrival | |
| Column Name | Description | |
|---|---|---|
| TranspOrdDepartureDate | Departure Date | |
| TranspOrdArrivalDate | Arrival Date |
| Column Name | Description | |
|---|---|---|
| LastMileRouteCategory | Route Category | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LastMileRoute | Route ID | ||
| LastMileRouteType | Route Type | ||
| LstMiRouteSourceLocation | Source Location | VSTEL | |
| LastMileRouteDepartureLocation | Departure Location | /SAPAPO/LOCNO | |
| LastMileRouteArrivalLocation | Arrival Location | /SAPAPO/LOCNO | |
| LstMiRteExecutionOrganization | Execution Organization | ||
| TransportationVehicleDriver | Driver | BU_PARTNER | |
| ResourceSecondDriver | Driver | BU_PARTNER | |
| EquipmentType | Vehicle Type | CHAR10 | |
| ResourceID | Vehicle ID | ||
| RsceRegistrationNumber | License Plate | ||
| ResourceDefaultTrailer | Vehicle ID | ||
| TrailerRsceRegistrationNumber | License Plate | ||
| LastMileRouteStockIdentifier | Route Stock Identifier | LMD_COM_ROUTE_STOCK_IDENTIFIER | |
| LastMileRouteTimeZone | Time Zone | TZNZONE | |
| CountryCode | Country/Region Key | LAND1 | |
| LstMiRouteReferenceRouteType | Reference Route Type | ||
| TranspOrdReqDepartureDteTme | Timestamp | TZNTSTMPS | |
| TranspOrdReqArrivalDteTme | Timestamp | TZNTSTMPS | |
| TranspOrdDepartureDateTime | Departure Timestamp | TZNTSTMPS | |
| TranspOrdArrivalDateTime | Arrival Timestamp | TZNTSTMPS | |
| LastMileRteSetlCommentsText | Comments | ||
| LastMileRouteReasonCode | Reason Code | ||
| LstMiRteDepartureShippingPoint | Departure Shipping Point | VSTEL | |
| LstMiRteArrivalShippingPoint | Arrival Shipping Point | VSTEL | |
| LastMileRouteMessageDateTime | UTC-Timestamp Long YYYYMMDDhhmmssmmmuuun | TZNTSTMPL | |
| CreationDateTime | Timestamp | TZNTSTMPS | |
| LastChangeDateTime | Timestamp | TZNTSTMPS |
| Master Data Relations | Join Conditions |
|---|---|
Route Life Cycle Status
|
|
Settlement Status
|
|