LMD_COM_RP_DOC

Transparent Table Application Table
19 Fields 1 CDS Views

Last Mile Distribution Documents for Route Reporting

LMD_COM_RP_DOC is an SAP database table in S/4HANA. Last Mile Distribution Documents for Route Reporting. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LstMiRptgSetldRouteDocument view from BASIC Last Mile Distr Rptg Setl Route Doc

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY document_uuid lmd_route_document_header_uuid Document Header UUID
document_number vbeln SD Document
document_type lmd_com_rp_doc_type Document Type
display_document_number lmd_com_doc_id Document No.
company_code bukrs Company Code
document_year gjahr Fiscal Year
route_uuid lmd_route_uuid Route UUID
route_id lmd_com_route_id Route ID
route_type lmd_com_route_type Route Type
stop_uuid lmd_route_stop_uuid Stop UUID
execution_org lmd_com_execution_organization Exec. Organization
driver lmd_com_driver_id Driver
co_driver_id lmd_com_driver_id Driver
ship_to_party lmd_com_shipto_party_id Ship-To Party ID
departure_date lmd_com_date_departure Departure Date
departure_shipping_point lmd_com_departure_shipg_point Deptr. Shipg. Point
departure_location_id lmd_com_departure_location Departure Location
number_of_attachments lmd_com_number_of_attachments No. of Attachments

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 Documents for Route Reporting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LMD_COM_RP_DOC (
    CLIENT,                    -- abap.clnt
    DOCUMENT_UUID,             -- Document Header UUID [lmd_route_document_header_uuid]
    DOCUMENT_NUMBER,           -- SD Document [vbeln]
    DOCUMENT_TYPE,             -- Document Type [lmd_com_rp_doc_type]
    DISPLAY_DOCUMENT_NUMBER,   -- Document No. [lmd_com_doc_id]
    COMPANY_CODE,              -- Company Code [bukrs]
    DOCUMENT_YEAR,             -- Fiscal Year [gjahr]
    ROUTE_UUID,                -- Route UUID [lmd_route_uuid]
    ROUTE_ID,                  -- Route ID [lmd_com_route_id]
    ROUTE_TYPE,                -- Route Type [lmd_com_route_type]
    STOP_UUID,                 -- Stop UUID [lmd_route_stop_uuid]
    EXECUTION_ORG,             -- Exec. Organization [lmd_com_execution_organization]
    DRIVER,                    -- Driver [lmd_com_driver_id]
    CO_DRIVER_ID,              -- Driver [lmd_com_driver_id]
    SHIP_TO_PARTY,             -- Ship-To Party ID [lmd_com_shipto_party_id]
    DEPARTURE_DATE,            -- Departure Date [lmd_com_date_departure]
    DEPARTURE_SHIPPING_POINT,  -- Deptr. Shipg. Point [lmd_com_departure_shipg_point]
    DEPARTURE_LOCATION_ID,     -- Departure Location [lmd_com_departure_location]
    NUMBER_OF_ATTACHMENTS,     -- No. of Attachments [lmd_com_number_of_attachments]
    PRIMARY KEY (CLIENT, DOCUMENT_UUID)
);

Learn More