- 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_LstMiRouteDocumentItemDEX
Last Mile Distribution Doc Itm Data Extr
| view: CLMRDOCIDEX | TRAN
| Extraction:
Full or Incremental
| Component: Last Mile Distribution
Tables used:
LMD_COM_DOC_ITMS
- 🔑 Keys (1)
- 💰 Amounts (1)
- ∑ Quantities (2)
- 📅 Dates
- ☰ Categorical (6)
- Other (15)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| LastMileRouteDocumentItemUUID | Document Item UUID |
| Column Name | Description | |
|---|---|---|
| 💲 Currency Code (LstMiRouteDocumentItemCurrency): | ||
| LstMiRouteDocumentItemAmount | Payment Amount | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measurement (UnitOfMsrOfDelivUnit): | ||
| LastMileRoutePlannedQuantity | Quantity | |
| LastMileRouteActualQuantity | Quantity | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| LastMileRouteDocumentType | Document Type | Show values |
| LastMileRouteProductIsReturn | Item Is Return Item | Show values |
| LastMileRouteProductIsFreeGood | Item Is Free Goods Item | Show values |
| LastMileRouteRefDocumentType | Document Type | Show values |
| LastMileRouteItemIsTiedEmpty | Is Tied Empty | Show values |
| LastMileRouteItemIsUntiedEmpty | Is Untied Empty | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LastMileRouteUUID | DB Key | ||
| LastMileRouteStopUUID | DB Key | ||
| LstMiRouteDocumentHeaderUUID | DB Key | ||
| SDDocument | Document No. | LMD_COM_DOC_ID | |
| SDDocumentItem | Item ID | LMD_COM_ITEM_ID | |
| HigherLevelItem | Item ID | LMD_COM_ITEM_ID | |
| ProductID | Product ID | MATNR | |
| Batch | Product Batch | ||
| Plant | Plant | ||
| LastMileRouteItemReasonCode | Reason Code | ||
| ReferenceSDDocument | Document No. | LMD_COM_DOC_ID | |
| ReferenceSDDocumentItem | Item ID | LMD_COM_ITEM_ID | |
| CustomerReferenceNumber | Customer Reference Number | CHAR40 | |
| LastMileRouteUnloadingLocation | Unloading Point | ||
| LastMileRouteIsMnllyAddedRecd | Is Manually Added |