R_ProjSchedMaintOrderGraphTP

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_ProjSchedMaintOrderGraphTP.
-- 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_ProjSchedMaintOrderGraphTP AS
SELECT
  MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  Hierarchy.ProjectObjectRootNode AS ProjectObjectRootNode,
  MaintenanceOrder.OrderDescription AS MaintenanceOrderDesc,
  cast( MaintenanceOrder._OrderType._Text[1:Language = $session.system_language].OrderTypeName as ps_s4_auarttext preserving type) AS OrderTypeName,
  MaintenanceOrder.ObjectInternalID AS ProjectNetworkObject,
  cast( MaintenanceOrder.ProjectInternalID as ps_s4_pspnr preserving type) AS ProjectInternalID,
  cast( MaintenanceOrder.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  _MaintenanceOrderBasicData.MaintenanceActivityType AS MaintenanceActivityType,
  _MaintenanceOrderBasicData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  cast( _MaintenanceOrderBasicData._MaintenancePlannerGroup.MaintenancePlannerGroupName as eam_planner_group_name preserving type ) AS MaintenancePlannerGroupName,
  MaintenanceOrder.MainWorkCenter AS WorkCenter,
  cast( _MaintenanceOrderBasicData._MainWorkCenter._Text[1:Language = $session.system_language].WorkCenterText as workcentertext preserving type ) AS WorkCenterText,
  cast( _MaintenanceOrderBasicData.MaintOrdPersonResponsible as ps_vernr ) AS ResponsiblePerson,
  _MaintenanceOrderBasicData._ProjSchedMaintOrdRespPerson.MaintOrdPersonResponsibleName AS MaintOrdPersonResponsibleName,
  cast( _MaintenanceOrderBasicData.MaintPriority as priok ) AS MaintPriority,
  cast( _MaintenanceOrderBasicData._PriorityText[1:Language = $session.system_language].GenericPriorityDesc as priokx preserving type ) AS MaintPriorityDesc,
  _MaintenanceOrderBasicData.MaintenanceNotification AS MaintenanceNotification,
  _Notification.NotificationText AS MaintenanceNotificationText,
  MaintenanceOrder.IsMarkedForDeletion AS IsMarkedForDeletion,
  _MaintenanceOrderBasicData.OperationSystemCondition AS OperationSystemCondition,
  MaintenanceOrder.CompanyCode AS CompanyCode,
  cast( MaintenanceOrder._CompanyCode.CompanyCodeName as fac_co_code_name ) AS CompanyCodeName,
  MaintenanceOrder.ControllingArea AS ControllingArea,
  cast( MaintenanceOrder._ControllingArea.ControllingAreaName as ps_s4_bezei) AS ControllingAreaName,
  MaintenanceOrder.BusinessArea AS BusinessArea,
  cast( MaintenanceOrder._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_gtext preserving type ) AS BusinessAreaName,
  MaintenanceOrder.ResponsibleCostCenter AS ResponsibleCostCenter,
  cast( MaintenanceOrder._ResponsibleCostCenterText[1:Language = $session.system_language].CostCenterName as fis_kostl_name preserving type ) AS ResponsibleCostCenterName,
  MaintenanceOrder.ProfitCenter AS ProfitCenter,
  MaintenanceOrder._ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName as ProfitCenterName AS ProfitCenterNameasProfitCenterName,
  MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _Plant.PlantName AS MaintenancePlanningPlantName,
  cast( MaintenanceOrder.PlannedStartDate as ps_s4_pstrt) AS PlannedStartDate,
  cast( MaintenanceOrder.PlannedEndDate as ps_s4_pende) AS PlannedEndDate,
  cast( MaintenanceOrder.ScheduledBasicStartDate as ps_s4_gstrs) AS ScheduledBasicStartDate,
  cast( MaintenanceOrder.ScheduledBasicEndDate as ps_s4_co_gltrs) AS ScheduledBasicEndDate,
  cast( MaintenanceOrder.ActualStartDate as cgpl_actualstartdate) AS ActualStartDate,
  cast( MaintenanceOrder.ActualEndDate as pshlp_actual_finish_de) AS ActualEndDate,
  MaintenanceOrder.BasicSchedulingType AS BasicSchedulingType,
  MaintenanceOrder._SchedulingTypeText[1:Language = $session.system_language].SchedulingTypeName AS SchedulingTypeName,
  _MaintenanceOrderBasicData.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _Notification.NotificationReportingDate AS NotificationReportingDate,
  _Notification.NotificationRequiredStartDate AS NotificationRequiredStartDate,
  _Notification.NotificationRequiredEndDate AS NotificationRequiredEndDate,
  cast( '' as vsnmr_v ) AS Version,
  _Project.ProjectExternalID AS ProjectExternalID,
  _Project.ProjectDescription AS ProjectDescription,
  _WBSElementData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementData.WBSDescription AS WBSDescription,
  _ProjectNetwork.ProjectNetwork AS ProjectNetwork,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  _NetworkActivity.NetworkActivity AS NetworkActivity,
  _NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription,
  _MaintenanceOrderBasicData.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _MaintenanceOrderBasicData._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  _MaintenanceOrderBasicData.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  _MaintenanceOrderBasicData._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  MaintenanceOrder.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  MaintenanceOrder.SuperiorProjectNetworkIntID AS SuperiorProjectNetworkIntID,
  MaintenanceOrder.SuperiorNtwkActivityInternalID AS SuperiorNtwkActivityInternalID,
  MaintenanceOrder.Plant AS Plant,
  MaintenanceOrder.MRPController AS MRPController,
  MaintenanceOrder.OrderType AS OrderType,
  MaintenanceOrder.OrderCategory AS OrderCategory,
  MaintenanceOrder.CostCenter AS CostCenter,
  MaintenanceOrder.ScheduledForecastedStartDate AS LatestSchedldFcstdStartDate,
  MaintenanceOrder.ScheduledForecastedEndDate AS LatestSchedldFcstdEndDate,
  MaintenanceOrder.PriorityCode AS PriorityCode,
  MaintenanceOrder.CreationDate AS CreationDate,
  MaintenanceOrder.CreatedByUser AS CreatedByUser,
  MaintenanceOrder.LastChangeDate AS LastChangeDate,
  MaintenanceOrder._Plant.FactoryCalendar AS FactoryCalendar
FROM I_ProjSchedMaintOrderData AS MaintenanceOrder
INNER JOIN I_ProjectObjectHierNodeRltn AS Hierarchy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProjSchedOperationGraphTP AS _MaintenanceOperation ON MaintenanceOrder = _MaintenanceOperation.MaintenanceOrder AND ProjectObjectRootNode = _MaintenanceOperation.ProjectObjectRootNode  -- association [1..*]
LEFT OUTER JOIN R_ProjectForNetworkGraphTP AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [1..1]
LEFT OUTER JOIN R_WBSElementForGraphTP AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Notification AS _Notification ON MaintenanceOrder = _Notification.OrderID  -- association [0..*]
LEFT OUTER JOIN R_ProjectNetworkForGraphTP AS _ProjectNetwork ON _ProjectNetwork.ProjectNetwork = SuperiorProjectNetwork  -- association [0..1]
LEFT OUTER JOIN R_NetworkActivityForGraphTP AS _NetworkActivity ON _NetworkActivity.ProjectNetworkInternalID = SuperiorProjectNetworkIntID AND _NetworkActivity.NetworkActivityInternalID = SuperiorNtwkActivityInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElementData ON _WBSElementData.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjSchedMaintOrderBasicData AS _MaintenanceOrderBasicData ON MaintenanceOrder = _MaintenanceOrderBasicData.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;