LMD_COM_DOC_ITMS

Transparent Table Application Table
37 Fields 3 CDS Views

Last Mile Distribution Document Items

LMD_COM_DOC_ITMS is an SAP database table in S/4HANA. Last Mile Distribution Document Items. It contains 37 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_LstMiRouteDocumentItem view from BASIC Last Mile Distribution Route Doc Item
I_LstMiUIRouteDocumentItemTP view_entity from TRANSACTIONAL Last Mile UI Route Document Item
I_LstMiUIRteDocItmEditStatus view from BASIC Last Mile UI Route Document Edit Status

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY document_item_uuid LMD_ROUTE_DOCUMENT_ITEM_UUID Document Item UUID
route_uuid LMD_COM_KEY DB Key
stop_uuid LMD_COM_KEY DB Key
document_header_uuid LMD_COM_KEY DB Key
item_number LMD_COM_ITEM_ID Item ID
document_id LMD_COM_DOC_ID Document No.
lmd_document_type LMD_COM_DOC_TYPE Document Type
hl_item_number LMD_COM_ITEM_ID Item ID
product_id LMD_COM_PRODUCT_ID Product ID
quantity LMD_COM_QUANTITY Quantity
actual_quantity LMD_COM_QUANTITY Quantity
uom LMD_COM_UOM Unit
batch LMD_COM_PRODUCT_BATCH Batch
plant LMD_COM_PLANT Plant
is_return_item LMD_COM_IS_RETURN_ITEM Return
is_free_goods_item LMD_COM_IS_FREE_GOODS_ITEM Free Goods Item
reason_code LMD_COM_REASON_CODE Reason
inventory_group LMD_COM_INVENTORY_GROUP Inventory Group
inventory_group_diff LMD_COM_INVENTORY_GROUP_DIFF Difference Inventory Group
ref_lmd_doc_type LMD_COM_DOC_TYPE Document Type
ref_doc_id LMD_COM_DOC_ID Document No.
ref_doc_id_item LMD_COM_ITEM_ID Item ID
customer_reference_number LMD_COM_DOC_CUSTOMER_REFERENCE Customer Reference Number
unloading_point LMD_COM_UNLOADING_POINT Unloading Point
is_manually_added LMD_COM_IS_MANUALLY_ADDED Manually Added
is_tied_empty LMD_COM_IS_TIED_EMPTY Tied Empty
is_untied_empty LMD_COM_IS_UNTIED_EMPTY Untied Empty
total_gross_amount LMD_COM_AMOUNT Amount
condition_value_1 LMD_COM_CONDITION_VALUE_1 Condition Value 1
condition_value_2 LMD_COM_CONDITION_VALUE_2 Condition Value 2
condition_value_3 LMD_COM_CONDITION_VALUE_3 Condition Value 3
condition_value_4 LMD_COM_CONDITION_VALUE_4 Condition Value 4
currency LMD_COM_CURRENCY Currency
bob_promotion_id TDD_BOB_PROMOTION_ID OmniChnl PromoID
bob_free_goods_id TDD_BOB_FG_ID FGID OmniChnl
eew_lmd_com_doc_itm 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 Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_COM_DOC_ITMS (
    CLIENT,                     -- abap.clnt
    DOCUMENT_ITEM_UUID,         -- Document Item UUID [LMD_ROUTE_DOCUMENT_ITEM_UUID]
    ROUTE_UUID,                 -- DB Key [LMD_COM_KEY]
    STOP_UUID,                  -- DB Key [LMD_COM_KEY]
    DOCUMENT_HEADER_UUID,       -- DB Key [LMD_COM_KEY]
    ITEM_NUMBER,                -- Item ID [LMD_COM_ITEM_ID]
    DOCUMENT_ID,                -- Document No. [LMD_COM_DOC_ID]
    LMD_DOCUMENT_TYPE,          -- Document Type [LMD_COM_DOC_TYPE]
    HL_ITEM_NUMBER,             -- Item ID [LMD_COM_ITEM_ID]
    PRODUCT_ID,                 -- Product ID [LMD_COM_PRODUCT_ID]
    QUANTITY,                   -- Quantity [LMD_COM_QUANTITY]
    ACTUAL_QUANTITY,            -- Quantity [LMD_COM_QUANTITY]
    UOM,                        -- Unit [LMD_COM_UOM]
    BATCH,                      -- Batch [LMD_COM_PRODUCT_BATCH]
    PLANT,                      -- Plant [LMD_COM_PLANT]
    IS_RETURN_ITEM,             -- Return [LMD_COM_IS_RETURN_ITEM]
    IS_FREE_GOODS_ITEM,         -- Free Goods Item [LMD_COM_IS_FREE_GOODS_ITEM]
    REASON_CODE,                -- Reason [LMD_COM_REASON_CODE]
    INVENTORY_GROUP,            -- Inventory Group [LMD_COM_INVENTORY_GROUP]
    INVENTORY_GROUP_DIFF,       -- Difference Inventory Group [LMD_COM_INVENTORY_GROUP_DIFF]
    REF_LMD_DOC_TYPE,           -- Document Type [LMD_COM_DOC_TYPE]
    REF_DOC_ID,                 -- Document No. [LMD_COM_DOC_ID]
    REF_DOC_ID_ITEM,            -- Item ID [LMD_COM_ITEM_ID]
    CUSTOMER_REFERENCE_NUMBER,  -- Customer Reference Number [LMD_COM_DOC_CUSTOMER_REFERENCE]
    UNLOADING_POINT,            -- Unloading Point [LMD_COM_UNLOADING_POINT]
    IS_MANUALLY_ADDED,          -- Manually Added [LMD_COM_IS_MANUALLY_ADDED]
    IS_TIED_EMPTY,              -- Tied Empty [LMD_COM_IS_TIED_EMPTY]
    IS_UNTIED_EMPTY,            -- Untied Empty [LMD_COM_IS_UNTIED_EMPTY]
    TOTAL_GROSS_AMOUNT,         -- Amount [LMD_COM_AMOUNT]
    CONDITION_VALUE_1,          -- Condition Value 1 [LMD_COM_CONDITION_VALUE_1]
    CONDITION_VALUE_2,          -- Condition Value 2 [LMD_COM_CONDITION_VALUE_2]
    CONDITION_VALUE_3,          -- Condition Value 3 [LMD_COM_CONDITION_VALUE_3]
    CONDITION_VALUE_4,          -- Condition Value 4 [LMD_COM_CONDITION_VALUE_4]
    CURRENCY,                   -- Currency [LMD_COM_CURRENCY]
    BOB_PROMOTION_ID,           -- OmniChnl PromoID [TDD_BOB_PROMOTION_ID]
    BOB_FREE_GOODS_ID,          -- FGID OmniChnl [TDD_BOB_FG_ID]
    EEW_LMD_COM_DOC_ITM,        -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, DOCUMENT_ITEM_UUID)
);

Learn More