- 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)
C_LstMiRouteDEX
Last Mile Distribution Route Data Extr
| view: CLMROUTEDEX | TRAN
| Extraction:
Full or Incremental
| Component: Last Mile Distribution
Tables used:
LMD_COM_ROUTES
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities (2)
- 📅 Dates (1)
- ☰ Categorical (1)
- Other (27)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| LastMileRouteUUID | Route UUID |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Distance Unit of Measure (LstMiRteOdometerUnitOfMeasure): | ||
| LstMiRteDeptrOdometerQuantity | Odometer Reading at Departure | |
| LstMiRteArrvlOdometerQuantity | Odometer Reading at Arrival | |
| Column Name | Description | |
|---|---|---|
| TranspOrdDepartureDate | Departure Date |
| Column Name | Description | |
|---|---|---|
| LastMileRouteCategory | Route Category | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LastMileRoute | Route ID | ||
| LastMileRouteType | Route Type | ||
| LstMiRouteSourceLocation | Source Location | VSTEL | |
| 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 | ||
| 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 | |
| LastMileRouteDepartureLocation | Departure Location | /SAPAPO/LOCNO | |
| LastMileRouteArrivalLocation | Arrival Location | /SAPAPO/LOCNO | |
| LstMiRteArrivalShippingPoint | Arrival Shipping Point | VSTEL | |
| LastMileRouteMessageDateTime | UTC-Timestamp Long YYYYMMDDhhmmssmmmuuun | TZNTSTMPL | |
| CreationDateTime | Timestamp | TZNTSTMPS | |
| LastChangeDateTime | Timestamp | TZNTSTMPS |