C_ProjSchedOperationGraph

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_ProjSchedOperationGraph.
-- 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.
-- SQL view name: COPERATIONGROVW

CREATE VIEW C_ProjSchedOperationGraph AS
SELECT
  cast (NetworkActivity.ProjectNetworkInternalID as co_aufpl preserving type) AS OrderInternalBillOfOperations,
  NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  NetworkActivity.NetworkActivity AS MaintenanceOrderOperation,
  _MaintenanceOrder._WBSElementData.WBSElementExternalID AS WBSElementExternalID,
  NetworkActivity.NetworkActivityDescription AS OperationDescription,
  _MaintenanceOrder.OrderDescription AS OrderDescription,
  _MaintenanceOrder._WBSElementData.WBSDescription AS WBSDescription,
  _MaintenanceOrder.OrderType AS OrderType,
  _MaintenanceOrder._OrderType._Text[1:Language = $session.system_language].OrderTypeName AS MaintenanceOrderTypeName,
  NetworkActivity.NetworkActivityControlProfile AS OperationControlKey,
  cast ( _OperationControlProfileText.OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  NetworkActivity._WorkCenter.WorkCenter AS OperationWorkCenter,
  NetworkActivity._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  NetworkActivity.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  NetworkActivity.Assembly AS Assembly,
  _AssemblyText.MaterialName AS AssemblyName,
  NetworkActivity.FunctionalLocation AS FunctionalLocation,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _FunctionalLocationText.FunctionalLocationName AS FunctionalLocationName,
  NetworkActivity.Equipment AS Equipment,
  _EquipmentText.EquipmentName AS EquipmentName,
  NetworkActivity.IsMarkedForDeletion AS IsMarkedForDeletion,
  NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityDatesQuantity.StandardDuration AS StandardDuration,
  _NetworkActivityDatesQuantity.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivityDatesQuantity.ActualStartDate AS ActualStartDate,
  _NetworkActivityDatesQuantity.ActualEndDate AS ActualEndDate,
  _NetworkActivityDatesQuantity.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _NetworkActivityDatesQuantity.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  _NetworkActivityDatesQuantity._BscStartConstraintTypeText[1:Language = $session.system_language].StartConstraintTypeText AS ActyBscStartDateConstraintText,
  _NetworkActivityDatesQuantity.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  _NetworkActivityDatesQuantity._BscFinishConstraintTypeText[1:Language = $session.system_language].FinishConstraintTypeText AS ActyBscEndDateConstraintText,
  _NetworkActivityDatesQuantity.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _NetworkActivityDatesQuantity.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  _NetworkActivityDatesQuantity.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  _NetworkActivityDatesQuantity.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  _NetworkActivityDatesQuantity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivityDatesQuantity.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivityDatesQuantity.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  cast( '' as vsnmr_v ) AS Version,
  NetworkActivity.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  NetworkActivity.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  _EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc
FROM I_NetworkActivityByInternalKey AS NetworkActivity
LEFT OUTER JOIN I_NetworkActivityDatesQuantity AS _NetworkActivityDatesQuantity ON OrderInternalBillOfOperations = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProjSchedMaintOrderData AS _MaintenanceOrder ON OrderInternalBillOfOperations = _MaintenanceOrder.OrderInternalBillOfOperations  -- association [0..1]
LEFT OUTER JOIN C_ProjectShedMaintOrderGraph AS _WorkOrderGraphOverview ON MaintenanceOrder = _WorkOrderGraphOverview.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _ActivityConfirmed ON NetworkActivityObject = _ActivityConfirmed.StatusObject AND _ActivityConfirmed.StatusCode = 'I0009'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _ActivityPartiallyConfirmed ON NetworkActivityObject = _ActivityPartiallyConfirmed.StatusObject AND _ActivityPartiallyConfirmed.StatusCode = 'I0010'  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfileText AS _OperationControlProfileText ON OperationControlKey = _OperationControlProfileText.OperationControlProfile AND _OperationControlProfileText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _AssemblyText ON Assembly = _AssemblyText.Material AND _AssemblyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment AND _EquipmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessPhaseText AS _EAMProcessPhaseText ON MaintOrdProcessPhaseCode = _EAMProcessPhaseText.EAMProcessPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhaseText AS _EAMProcessSubPhaseText ON MaintOrdProcessSubPhaseCode = _EAMProcessSubPhaseText.EAMProcessSubPhaseCode  -- association [0..*]
LEFT OUTER JOIN C_ProjectNetworkRelationship AS _Successor ON _Successor.PredecessorProjNtwkIntID = OrderInternalBillOfOperations AND _Successor.PredecessorNtwkActyIntID = NetworkActivityInternalID  -- association [0..*]
LEFT OUTER JOIN C_ProjectNetworkRelationship AS _Predecessor ON _Predecessor.SuccessorProjNtwkIntID = OrderInternalBillOfOperations AND _Predecessor.SuccessorNtwkActyIntID = NetworkActivityInternalID  -- association [0..*]
;