I_LSTMIRPTGSETLDROUTEDOCUMENT

CDS View
14 Fields 2 CDS Views

Last Mile Distr Rptg Setl Route Doc

I_LSTMIRPTGSETLDROUTEDOCUMENT is a CDS View in S/4HANA. Last Mile Distr Rptg Setl Route Doc. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_LstMiExternalDocuments view from COMPOSITE
P_LstMiExternalDocuments view union_all COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY LastMileRouteDocumentNumber LastMileRouteDocumentNumber 1
KEY LastMileRouteDocumentType LastMileRouteDocumentType 1
CompanyCode CompanyCode 1
LastMileRoute LastMileRoute 1
LastMileRouteDepartureLocation LastMileRouteDepartureLocation 1
LastMileRouteDocumentYear LastMileRouteDocumentYear 1
LastMileRouteType LastMileRouteType 1
LastMileRouteUUID LastMileRouteUUID 1
LstMiRptgRouteDocumentType LstMiRptgRouteDocumentType 1
LstMiRteDisplayDocumentNumber LstMiRteDisplayDocumentNumber 1
LstMiRteExecutionOrganization LstMiRteExecutionOrganization 1
ShipToParty ShipToParty 1
TranspOrdDepartureDate TranspOrdDepartureDate 1
TransportationVehicleDriver TransportationVehicleDriver 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 Distr Rptg Setl Route Doc
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LSTMIRPTGSETLDROUTEDOCUMENT (
    LASTMILEROUTEDOCUMENTNUMBER,
    LASTMILEROUTEDOCUMENTTYPE,
    COMPANYCODE,
    LASTMILEROUTE,
    LASTMILEROUTEDEPARTURELOCATION,
    LASTMILEROUTEDOCUMENTYEAR,
    LASTMILEROUTETYPE,
    LASTMILEROUTEUUID,
    LSTMIRPTGROUTEDOCUMENTTYPE,
    LSTMIRTEDISPLAYDOCUMENTNUMBER,
    LSTMIRTEEXECUTIONORGANIZATION,
    SHIPTOPARTY,
    TRANSPORDDEPARTUREDATE,
    TRANSPORTATIONVEHICLEDRIVER,
    PRIMARY KEY (LASTMILEROUTEDOCUMENTNUMBER, LASTMILEROUTEDOCUMENTTYPE)
);

Learn More