R_ProjSchedOperationGraphTP

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 R_ProjSchedOperationGraphTP.
-- 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 R_ProjSchedOperationGraphTP AS
SELECT
  cast (MaintenanceOperation.ProjectNetworkInternalID as co_aufpl preserving type) AS OrderInternalBillOfOperations,
  MaintenanceOperation.NetworkActivityInternalID AS NetworkActivityInternalID,
  Hierarchy.ProjectObjectRootNode AS ProjectObjectRootNode,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  MaintenanceOperation.NetworkActivity AS MaintenanceOrderOperation,
  _MaintenanceOrder._WBSElementData.WBSElementExternalID AS WBSElementExternalID,
  MaintenanceOperation.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,
  MaintenanceOperation.NetworkActivityControlProfile AS OperationControlKey,
  cast ( _OperationControlProfileText.OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  MaintenanceOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  MaintenanceOperation._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  MaintenanceOperation.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  MaintenanceOperation.Assembly AS Assembly,
  _AssemblyText.MaterialName AS AssemblyName,
  MaintenanceOperation.FunctionalLocation AS FunctionalLocation,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _FunctionalLocationText.FunctionalLocationName AS FunctionalLocationName,
  MaintenanceOperation.Equipment AS Equipment,
  _EquipmentText.EquipmentName AS EquipmentName,
  MaintenanceOperation.IsMarkedForDeletion AS IsMarkedForDeletion,
  MaintenanceOperation.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,
  MaintenanceOperation.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  MaintenanceOperation.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  _EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivityDatesQuantity.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  _NetworkActivityUserFields.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityUserFields.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityUserFields.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityUserFields.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityUserFields.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityUserFields.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _NetworkActivityUserFields.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityUserFields.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityUserFields.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityUserFields.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  cast ( _NetworkActivityUserFields.FreeDefinedAmount1 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount1,
  cast ( _NetworkActivityUserFields.FreeDefinedAmount2 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount2,
  _NetworkActivityUserFields.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityUserFields.FreeDefinedDate2 AS FreeDefinedDate2,
  MaintenanceOperation._WorkCenter.WorkCenter AS WorkCenter,
  MaintenanceOperation.OperationImportance AS OperationImportance,
  MaintenanceOperation.NetworkActivityCurrency AS NetworkActivityCurrency,
  MaintenanceOperation.NetworkActivityObjectCurrency AS NetworkActivityObjectCurrency,
  MaintenanceOperation.CompanyCode AS CompanyCode,
  MaintenanceOperation.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  _NetworkActivityDatesQuantity.PlannedDeliveryDurationInDays AS PlannedDeliveryDurationInDays,
  MaintenanceOperation.FactoryCalendar AS FactoryCalendar,
  _NetworkActivityDatesQuantity.ActualExecutionStartTime AS ActualExecutionStartTime,
  _NetworkActivityDatesQuantity.ActualExecutionEndTime AS ActualExecutionEndTime,
  MaintenanceOperation.WorkCenterInternalID AS WorkCenterInternalID,
  MaintenanceOperation.ControllingArea AS ControllingArea,
  MaintenanceOperation._WorkCenter AS _WorkCenter
FROM I_ProjSchedMaintOrdOpByIntKey AS MaintenanceOperation
INNER JOIN I_ProjectObjectHierNodeRltn AS Hierarchy ON /* join condition not captured in parsed metadata */
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 R_ProjSchedMaintOrderGraphTP AS _WorkOrderGraphOverview ON MaintenanceOrder = _WorkOrderGraphOverview.MaintenanceOrder  -- association [0..*]
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 R_ProjectNetworkRelationshipTP AS _Successor ON _Successor.PredecessorProjNtwkIntID = OrderInternalBillOfOperations AND _Successor.PredecessorNtwkActyIntID = NetworkActivityInternalID AND _Successor.ProjectObjectRootNode = ProjectObjectRootNode  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkRelationshipTP AS _Predecessor ON _Predecessor.SuccessorProjNtwkIntID = OrderInternalBillOfOperations AND _Predecessor.SuccessorNtwkActyIntID = NetworkActivityInternalID AND _Predecessor.ProjectObjectRootNode = ProjectObjectRootNode  -- association [0..*]
LEFT OUTER JOIN I_NetworkActivityUserFields AS _NetworkActivityUserFields ON _NetworkActivityUserFields.ProjectNetworkInternalID = OrderInternalBillOfOperations AND _NetworkActivityUserFields.NetworkActivityInternalID = NetworkActivityInternalID  -- association [1..1]
;