I_LastMileVisitList

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LastMileVisitList.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_LastMileVisitList AS
SELECT
  visit_list_uuid AS LastMileVisitListUUID,
  visit_list_id AS LastMileVisitListID,
  visit_list_ext_uuid AS LastMileVisitListExtUUID,
  visit_list_ext_id AS LastMileVisitListExternalID,
  visit_list_type AS LastMileVisitListType,
  driver_id AS LastMileVisitListDriverID,
  execution_date AS LastMileVisitListExecutionDate,
  sales_organisation AS SalesOrganization,
  distribution_channel AS DistributionChannel,
  Division,
  source_location AS SourceLocation,
  description AS LastMileVisitListDescription,
  execution_status AS LastMileVisitListStatus,
  last_changed_at AS LastMileVisitListLastChnDteTme,
  list_timezone AS TimeZoneID,
  created_on AS LastMileVisitListCrtnDateTime,
  execution_organization AS LstMiRteExecutionOrganization,
  errors_exist_in_log AS LastMileVisitListErrorsExist,
  sts_upd_in_extsystem AS LastMileVisitListStatusUpdtExt,
  visit_list_schedule_uuid AS LstMiVstListSchedUUID,
  vehicle_id AS ResourceID,
  delivery_route AS LastMileDeliveryRoute
FROM lmd_vl_visitlist
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON LastMileVisitListDriverID = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListIDVH AS _VisitListIDVH ON LastMileVisitListID = _VisitListIDVH.LastMileVisitListID  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListExtIDVH AS _VisitListExtIDVH ON LastMileVisitListExternalID = _VisitListExtIDVH.LastMileVisitListExternalID  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListTypeVH AS _VisitListTypeVH ON LastMileVisitListType = _VisitListTypeVH.LastMileVisitListType  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListStatusVH AS _VisitListStatusVH ON LastMileVisitListStatus = _VisitListStatusVH.LastMileVisitListStatus  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListOrgVH AS _OrganizationVH ON SalesOrganization = _OrganizationVH.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_LastMileDistrChannelVH AS _DistributionChannelVH ON DistributionChannel = _DistributionChannelVH.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_LastMileDivisionVH AS _DivisionVH ON Division = _DivisionVH.Division  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListStartLocVH AS _StartLocVH ON SourceLocation = _StartLocVH.Location  -- association [0..1]
LEFT OUTER JOIN I_LastMileVisitListErrExistVH AS _ErrorsExistVH ON LastMileVisitListErrorsExist = _ErrorsExistVH.LastMileVisitListErrorsExist  -- association [0..1]
LEFT OUTER JOIN I_LastMileDeliveryRouteVH AS _RouteVH ON LastMileDeliveryRoute = _RouteVH.Route  -- association [0..1]
;