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