LMD_COM_DOC_HDRS

Transparent Table Application Table
44 Fields 3 CDS Views

Last Mile Distribution Document Headers

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_LstMiRouteDocument view from BASIC Last Mile Distribution Route Document
I_LstMiUIRteDocHdrEditStatus view from BASIC Last Mile UI Route Document Edit Status
P_LstMiUIRteDocAddrIDAggrgn view_entity from COMPOSITE

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY document_header_uuid LMD_ROUTE_DOCUMENT_HEADER_UUID Document Header UUID
route_uuid LMD_ROUTE_UUID Route UUID
stop_uuid LMD_ROUTE_STOP_UUID Stop UUID
lmd_document_type LMD_COM_DOC_TYPE Document Type
document_id LMD_COM_DOC_ID Document No.
document_date LMD_COM_DOC_DATE Document Date
document_year LMD_COM_DOCUMENT_YEAR Document Year
soldto_party_id LMD_COM_SOLDTO_PARTY_ID Sold-To Party
shipto_party_id LMD_COM_SHIPTO_PARTY_ID Ship-To Party ID
address_id LMD_COM_ADDRESS_ID Address ID
sales_organization LMD_COM_SALES_ORGANIZATION Sales Organization
distribution_channel LMD_COM_DISTRIBUTION_CHANNEL Distribution Channel
division LMD_COM_DIVISION Division
reason_code LMD_COM_REASON_CODE Reason
requested_delivery_date LMD_COM_DOC_REQD_DELIVERY_DATE Requested Dlvy Date
signature_date LMD_COM_DOC_SIGNATURE_DATE Signature Date
original_signature_date LMD_COM_DOC_SIGNATURE_DATE Signature Date
scheduled_delivery_date LMD_COM_DOC_SCHED_DELIV_DATE Sched. Delivery Date
customer_reference_number LMD_COM_DOC_CUSTOMER_REFERENCE Customer Reference Number
orig_customer_reference_number LMD_COM_DOC_CUSTOMER_REFERENCE Customer Reference Number
created_by_settlement LMD_COM_IS_CREATED_BY_SETTLMNT Created by Settlmt
is_return LMD_COM_IS_RETURN Return
is_manually_added LMD_COM_IS_MANUALLY_ADDED Manually Added
currency LMD_COM_CURRENCY Currency
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
invoice_print_date_time LMD_COM_TIMESTAMP Timestamp
payment_terms LMD_COM_PAYMENT_TERMS Payment Terms
sd_document_type LMD_COM_SD_DOC_TYPE SD Doc. Type
customer_rel_bill_doc_number LMD_COM_CUST_REL_BILL_DOC_NUM Cust. Bill. Doc. No.
customer_rel_order_number LMD_COM_CUST_REL_ORD_NUM Reference Document No.
assigned_amount LMD_RP_AMOUNT_ASSIGNED Assigned Amount
transfer_type LMD_COM_TRANSFER_TYPE Transfer Type
reference_route_id LMD_COM_REFERENCE_ROUTE_ID Reference Route ID
updated_in_tm LMD_COM_UPDATED_IN_TM Updated in TM
original_sales_order_type LMD_COM_ORIGINAL_SLS_ORDR_TYPE Orig. Sls Order Type
load_stop_uuid LMD_ROUTE_LOAD_STOP_UUID Load Stop UUID
origin_code LMD_COM_ORIGIN_CODE Origin
replication_request_status LMD_COM_REPLICATION_REQ_STATUS Replication Request Status
eew_lmd_com_doc_hdr 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 Headers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_COM_DOC_HDRS (
    CLIENT,                          -- abap.clnt
    DOCUMENT_HEADER_UUID,            -- Document Header UUID [LMD_ROUTE_DOCUMENT_HEADER_UUID]
    ROUTE_UUID,                      -- Route UUID [LMD_ROUTE_UUID]
    STOP_UUID,                       -- Stop UUID [LMD_ROUTE_STOP_UUID]
    LMD_DOCUMENT_TYPE,               -- Document Type [LMD_COM_DOC_TYPE]
    DOCUMENT_ID,                     -- Document No. [LMD_COM_DOC_ID]
    DOCUMENT_DATE,                   -- Document Date [LMD_COM_DOC_DATE]
    DOCUMENT_YEAR,                   -- Document Year [LMD_COM_DOCUMENT_YEAR]
    SOLDTO_PARTY_ID,                 -- Sold-To Party [LMD_COM_SOLDTO_PARTY_ID]
    SHIPTO_PARTY_ID,                 -- Ship-To Party ID [LMD_COM_SHIPTO_PARTY_ID]
    ADDRESS_ID,                      -- Address ID [LMD_COM_ADDRESS_ID]
    SALES_ORGANIZATION,              -- Sales Organization [LMD_COM_SALES_ORGANIZATION]
    DISTRIBUTION_CHANNEL,            -- Distribution Channel [LMD_COM_DISTRIBUTION_CHANNEL]
    DIVISION,                        -- Division [LMD_COM_DIVISION]
    REASON_CODE,                     -- Reason [LMD_COM_REASON_CODE]
    REQUESTED_DELIVERY_DATE,         -- Requested Dlvy Date [LMD_COM_DOC_REQD_DELIVERY_DATE]
    SIGNATURE_DATE,                  -- Signature Date [LMD_COM_DOC_SIGNATURE_DATE]
    ORIGINAL_SIGNATURE_DATE,         -- Signature Date [LMD_COM_DOC_SIGNATURE_DATE]
    SCHEDULED_DELIVERY_DATE,         -- Sched. Delivery Date [LMD_COM_DOC_SCHED_DELIV_DATE]
    CUSTOMER_REFERENCE_NUMBER,       -- Customer Reference Number [LMD_COM_DOC_CUSTOMER_REFERENCE]
    ORIG_CUSTOMER_REFERENCE_NUMBER,  -- Customer Reference Number [LMD_COM_DOC_CUSTOMER_REFERENCE]
    CREATED_BY_SETTLEMENT,           -- Created by Settlmt [LMD_COM_IS_CREATED_BY_SETTLMNT]
    IS_RETURN,                       -- Return [LMD_COM_IS_RETURN]
    IS_MANUALLY_ADDED,               -- Manually Added [LMD_COM_IS_MANUALLY_ADDED]
    CURRENCY,                        -- Currency [LMD_COM_CURRENCY]
    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]
    INVOICE_PRINT_DATE_TIME,         -- Timestamp [LMD_COM_TIMESTAMP]
    PAYMENT_TERMS,                   -- Payment Terms [LMD_COM_PAYMENT_TERMS]
    SD_DOCUMENT_TYPE,                -- SD Doc. Type [LMD_COM_SD_DOC_TYPE]
    CUSTOMER_REL_BILL_DOC_NUMBER,    -- Cust. Bill. Doc. No. [LMD_COM_CUST_REL_BILL_DOC_NUM]
    CUSTOMER_REL_ORDER_NUMBER,       -- Reference Document No. [LMD_COM_CUST_REL_ORD_NUM]
    ASSIGNED_AMOUNT,                 -- Assigned Amount [LMD_RP_AMOUNT_ASSIGNED]
    TRANSFER_TYPE,                   -- Transfer Type [LMD_COM_TRANSFER_TYPE]
    REFERENCE_ROUTE_ID,              -- Reference Route ID [LMD_COM_REFERENCE_ROUTE_ID]
    UPDATED_IN_TM,                   -- Updated in TM [LMD_COM_UPDATED_IN_TM]
    ORIGINAL_SALES_ORDER_TYPE,       -- Orig. Sls Order Type [LMD_COM_ORIGINAL_SLS_ORDR_TYPE]
    LOAD_STOP_UUID,                  -- Load Stop UUID [LMD_ROUTE_LOAD_STOP_UUID]
    ORIGIN_CODE,                     -- Origin [LMD_COM_ORIGIN_CODE]
    REPLICATION_REQUEST_STATUS,      -- Replication Request Status [LMD_COM_REPLICATION_REQ_STATUS]
    EEW_LMD_COM_DOC_HDR,             -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, DOCUMENT_HEADER_UUID)
);

Learn More