P_MaintOrdersForPlanningC

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 P_MaintOrdersForPlanningC.
-- 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: PMAINTORDPLANC

CREATE VIEW P_MaintOrdersForPlanningC AS
SELECT
  MaintenanceOrder,
  MaintenanceOrderInternalID AS ObjectInternalID,
  MaintenanceActivityType,
  _MaintenanceActivityType._Text[1: Language= $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  MaintenanceOrderType,
  _MaintenanceOrderType._Text[1: Language= $session.system_language ].OrderTypeName AS OrderTypeName,
  MaintPriority,
  _MaintenancePriority._Text[1: Language= $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  MaintPriorityType,
  _MaintenancePriorityType._Text[1: Language= $session.system_language ].MaintPriorityTypeDesc AS MaintPriorityTypeDesc,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS MaintenanceWorkCenter,
  _LocationAccountAssignment.MaintenancePlant AS MaintenanceWorkCenterPlant,
  _MainWorkCenter.WorkCenter AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  MaintOrdBasicStartDate AS ReferenceDate,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenanceRevision,
  _MaintenanceNotification.NotificationType AS NotificationType,
  MaintenanceProcessingPhase,
  I_MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceOrder.Equipment AS Equipment,
  ControllingArea,
  ResponsibleCostCenter,
  _ActiveUserStatusWthStsNmbr.StatusCode AS StatusCode,
  _ActiveUserStatusWthStsNmbr.StatusProfile AS StatusProfile,
  cast( _ActiveUserStatusWthStsNmbr.StatusCode as j_estat preserving type ) AS UserStatus,
  cast( 1 as eam_num_orders_outstanding ) AS NmbrOfOutstandingMaintOrders
FROM I_MaintenanceOrder
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON UserStatus = _StatusObjectActiveStatus.StatusCode  -- association [0..1]
LEFT OUTER JOIN P_MaintStsNumberedUserStatus AS _ActiveUserStatusWthStsNmbr ON _ActiveUserStatusWthStsNmbr.StatusObject = ObjectInternalID  -- association [0..1]
;