I_VehSchedgActivitySolution

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_VehSchedgActivitySolution.
-- 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_VehSchedgActivitySolution AS
SELECT
  Activity.VehSchedgExplanationLogUUID AS VehSchedgExplanationLogUUID,
  Solutions.VehSchedgProblem AS VehSchedgProblem,
  Solutions.VehSchedgSolutionStep AS VehSchedgSolutionStep,
  Activity.VehSchedgTranspActivity AS VehSchedgTranspActivity,
  Color.VehSchedgObjectColorCode AS VehSchedgObjectColorCode,
  Activity.VehSchedgTranspActivityUUID AS VehSchedgTranspActivityUUID,
  Activity.VehSchedgTranspParentActivity AS VehSchedgTranspParentActivity,
  Activity.VehSchedgTranspActyCategory AS VehSchedgTranspActyCategory,
  Activity.TranspOrdNetDuration AS TranspOrdNetDuration,
  Activity.FreightOrder AS FreightOrder,
  Activity.TransportationOrderCategory AS TransportationOrderCategory,
  Activity.TranspOrdCapacityTranspOrdUUID AS TranspOrdCapacityTranspOrdUUID,
  Activity.ResourceID AS ResourceID,
  Activity.SourceLocation AS SourceLocation,
  Activity.DestinationLocation AS DestinationLocation,
  Activity.AccptblStrtOfActyStrtDteTme AS AccptblStrtOfActyStrtDteTme,
  Activity.AccptblStrtOfActyEndDteTme AS AccptblStrtOfActyEndDteTme,
  Activity.AccptblEndOfActyStrtDteTme AS AccptblEndOfActyStrtDteTme,
  Activity.AccptblEndOfActyEndDteTme AS AccptblEndOfActyEndDteTme,
  Activity.RequestedActyStrtDteTme AS RequestedActyStrtDteTme,
  Activity.RequestedActyEndDteTme AS RequestedActyEndDteTme,
  Activity.EarlyDeliveriesPenaltyCostVal AS EarlyDeliveriesPenaltyCostVal,
  Activity.LateDeliveriesPenaltyCostVal AS LateDeliveriesPenaltyCostVal,
  Activity.VehSchedgInternalReference AS VehSchedgInternalReference,
  Activity.ResourceBreakCalendar AS ResourceBreakCalendar,
  Activity.HandlingResourceBreakCal AS HandlingResourceBreakCal,
  Activity.ResourceCapacityCalendar AS ResourceCapacityCalendar,
  Activity.ResourceConsumptionValue AS ResourceConsumptionValue,
  Activity.MaximumBreakDuration AS MaximumBreakDuration,
  Activity.TransportationUnitUUID AS TransportationUnitUUID,
  Activity.TransportationDriverUUID AS TransportationDriverUUID,
  Activity.TransportationOrderUUID AS TransportationOrderUUID,
  TranspOrderInfo.ResourceAdditionalUUID AS ResourceAdditionalUUID,
  Solutions.VehSchedgSolutionStepType AS VehSchedgSolutionStepType,
  Solutions.TranspActyPlanStartDateTime AS TranspActyPlanStartDateTime,
  Solutions.TranspActyPlanEndDateTime AS TranspActyPlanEndDateTime
FROM I_VehSchedgActivity AS Activity
INNER JOIN I_VehSchedgSolutions AS Solutions ON /* join condition not captured in parsed metadata */
INNER JOIN I_VehSchedgTranspOrderInfo AS TranspOrderInfo ON /* join condition not captured in parsed metadata */
INNER JOIN I_TranspGanttDfltObjColor AS Color ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VehSchedgRestSolution AS _RestSolution ON VehSchedgExplanationLogUUID = _RestSolution.VehSchedgExplanationLogUUID AND VehSchedgTranspActivity = _RestSolution.VehSchedgTranspActivity AND VehSchedgProblem = _RestSolution.VehSchedgProblem AND VehSchedgSolutionStep = _RestSolution.VehSchedgSolutionStep AND VehSchedgSolutionStepType = _RestSolution.VehSchedgSolutionStepType  -- association [0..*]
LEFT OUTER JOIN C_VehSchedgActivityLink AS _ActivityLink ON VehSchedgExplanationLogUUID = _ActivityLink.VehSchedgExplanationLogUUID AND VehSchedgTranspActivity = _ActivityLink.VehSchedgPredecessorTranspActy  -- association [0..*]
;