C_VehSchedgActivityTree

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 C_VehSchedgActivityTree.
-- 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 C_VehSchedgActivityTree AS
SELECT
  I_VehSchedgActyHierSource.VehSchedgExplanationLogUUID AS VehSchedgExplanationLogUUID,
  VehSchedgProblem,
  VehSchedgSolutionStep,
  VehSchedgTranspActivity,
  VehSchedgObjectColorCode,
  VehSchedgTranspParentActivity,
  VehSchedgTranspActyCategory,
  VehSchedgTranspActyCatDesc,
  TranspOrdNetDuration,
  FreightOrder,
  TransportationOrderCategory,
  TransportationOrderCatDesc,
  TranspOrdCapacityTranspOrdUUID,
  ResourceAdditionalUUID,
  SourceLocation,
  DestinationLocation,
  AccptblStrtOfActyStrtDteTme,
  AccptblStrtOfActyEndDteTme,
  AccptblEndOfActyStrtDteTme,
  AccptblEndOfActyEndDteTme,
  RequestedActyStrtDteTme,
  RequestedActyEndDteTme,
  EarlyDeliveriesPenaltyCostVal,
  LateDeliveriesPenaltyCostVal,
  VehSchedgInternalReference,
  ResourceBreakCalendar,
  HandlingResourceBreakCal,
  ResourceCapacityCalendar,
  ResourceConsumptionValue,
  MaximumBreakDuration,
  TransportationUnitUUID,
  TransportationDriverUUID,
  TransportationOrderUUID,
  VehSchedgSolutionStepType,
  TranspActyPlanStartDateTime,
  TranspActyPlanEndDateTime,
  VehSchedgActyDurnEndDteTme,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyLevel,
  HierarchyDrillState,
  HierarchyTreeSize
FROM I_VehSchedgActyHierSource
LEFT OUTER JOIN C_VehSchedgExplanationLog AS _ExplanationLog ON VehSchedgExplanationLogUUID = _ExplanationLog.VehSchedgExplanationLogUUID  -- association [1..1]
LEFT OUTER JOIN C_VehSchedgActivityTree AS _ActyHierSource ON VehSchedgExplanationLogUUID = _ActyHierSource.VehSchedgExplanationLogUUID AND VehSchedgProblem = _ActyHierSource.VehSchedgProblem AND VehSchedgSolutionStep = _ActyHierSource.VehSchedgSolutionStep AND VehSchedgTranspParentActivity = _ActyHierSource.VehSchedgTranspActivity  -- association [0..1]
LEFT OUTER JOIN C_VehSchedgActivityLink AS _ActivityLink ON VehSchedgExplanationLogUUID = _ActivityLink.VehSchedgExplanationLogUUID AND VehSchedgTranspActivity = _ActivityLink.VehSchedgPredecessorTranspActy  -- association [1..*]
LEFT OUTER JOIN C_EquipmentTypeAndResource AS _ResourceTransp ON ResourceAdditionalUUID = _ResourceTransp.ResourceAdditionalUUID  -- association [0..1]
LEFT OUTER JOIN C_VehSchedgTranspOrderDowntime AS _TranspOrderDowntime ON VehSchedgExplanationLogUUID = _TranspOrderDowntime.VehSchedgExplanationLogUUID AND TransportationOrderUUID = _TranspOrderDowntime.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_VehSchedgRestSolution AS _RestSolution ON VehSchedgExplanationLogUUID = _RestSolution.VehSchedgExplanationLogUUID AND VehSchedgTranspActivity = _RestSolution.VehSchedgTranspActivity AND VehSchedgProblem = _RestSolution.VehSchedgProblem AND VehSchedgSolutionStep = _RestSolution.VehSchedgSolutionStep  -- association [0..*]
;