LMD_COM_COCIPRDS
Last Mile Distribution COCI for Products
LMD_COM_COCIPRDS is an SAP database table in S/4HANA. Last Mile Distribution COCI for Products. It contains 16 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LstMiRouteCOCIProduct | view | from | BASIC | Last Mile Distribution Route COCI Produc |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | coci_product_uuid | LMD_ROUTE_PRODUCT_COCI_UUID | Product COCI UUID | |||
| route_uuid | LMD_ROUTE_UUID | Route UUID | ||||
| stop_uuid | LMD_ROUTE_STOP_UUID | Stop UUID | ||||
| plant | LMD_COM_COCIPRDS_PLANT | Plant | ||||
| product_id | LMD_COM_PRODUCT_ID | Product ID | ||||
| actual_uom | LMD_COM_UOM | Unit | ||||
| batch | LMD_COM_PRODUCT_BATCH | Batch | ||||
| actual_quantity | LMD_COM_QUANTITY | Quantity | ||||
| unloaded_quantity | LMD_COM_UNLOADED_QUANTITY | Unloaded Quantity | ||||
| reason_code | LMD_COM_REASON_CODE | Reason | ||||
| is_manually_added | LMD_COM_IS_MANUALLY_ADDED | Manually Added | ||||
| inv_mov_doc_hdr_uuid | LMD_ROUTE_DOCUMENT_HEADER_UUID | Document Header UUID | ||||
| inventory_group | LMD_COM_INVENTORY_GROUP | Inventory Group | ||||
| inventory_group_diff | LMD_COM_INVENTORY_GROUP_DIFF | Difference Inventory Group | ||||
| eew_lmd_com_coci_prod | DUMMY | Dummy function in length 1 |
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 COCI for Products
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_COM_COCIPRDS (
CLIENT, -- abap.clnt
COCI_PRODUCT_UUID, -- Product COCI UUID [LMD_ROUTE_PRODUCT_COCI_UUID]
ROUTE_UUID, -- Route UUID [LMD_ROUTE_UUID]
STOP_UUID, -- Stop UUID [LMD_ROUTE_STOP_UUID]
PLANT, -- Plant [LMD_COM_COCIPRDS_PLANT]
PRODUCT_ID, -- Product ID [LMD_COM_PRODUCT_ID]
ACTUAL_UOM, -- Unit [LMD_COM_UOM]
BATCH, -- Batch [LMD_COM_PRODUCT_BATCH]
ACTUAL_QUANTITY, -- Quantity [LMD_COM_QUANTITY]
UNLOADED_QUANTITY, -- Unloaded Quantity [LMD_COM_UNLOADED_QUANTITY]
REASON_CODE, -- Reason [LMD_COM_REASON_CODE]
IS_MANUALLY_ADDED, -- Manually Added [LMD_COM_IS_MANUALLY_ADDED]
INV_MOV_DOC_HDR_UUID, -- Document Header UUID [LMD_ROUTE_DOCUMENT_HEADER_UUID]
INVENTORY_GROUP, -- Inventory Group [LMD_COM_INVENTORY_GROUP]
INVENTORY_GROUP_DIFF, -- Difference Inventory Group [LMD_COM_INVENTORY_GROUP_DIFF]
EEW_LMD_COM_COCI_PROD, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (CLIENT, COCI_PRODUCT_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA