C_MaintPlanCallObject

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_MaintPlanCallObject.
-- 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: CMPLANCALLOBJ

CREATE VIEW C_MaintPlanCallObject AS
SELECT
  MaintenancePlan,
  MaintenancePlanCallNumber,
  MaintenanceItem,
  _MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  _MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  MaintenanceOrder,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceItem._MaintenanceOrderType._Text[1:Language = $session.system_language ].OrderTypeName AS OrderTypeName,
  _MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _MaintenanceOrder.MaintOrdBasicStartTime AS MaintOrdBasicStartTime,
  _MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _MaintenanceOrder.MaintOrdBasicEndTime AS MaintOrdBasicEndTime,
  _MaintenanceOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintenanceOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS MaintenanceNotificationText,
  _MaintenanceNotification.NotificationType AS NotificationType,
  _MaintenanceItem._PMNotificationType._Text[1:Language = $session.system_language ].NotificationTypeName AS NotificationTypeName,
  _MaintenanceNotification.RequiredStartDate AS RequiredStartDate,
  _MaintenanceNotification.RequiredEndDate AS RequiredEndDate,
  cast (dats_tims_to_tstmp( _MaintenanceNotification.RequiredStartDate, _MaintenanceNotification.RequiredStartTime, _MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdStartDateTime,
  cast (dats_tims_to_tstmp( _MaintenanceNotification.RequiredEndDate, _MaintenanceNotification.RequiredEndTime, _MaintenanceNotification.NotificationTimeZone, $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifRqdEndDateTime,
  ServiceOrder,
  _ServiceOrder.ServiceDocumentDescription AS ServiceOrderDescription,
  _ServiceOrder.ServiceDocumentType AS ServiceDocumentType,
  _ServiceOrder._ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language ].ServiceDocumentTypeName AS ServiceOrderTypeName,
  _ServiceOrder.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  _ServiceOrder.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  cast(SchedulingStatus as char1 preserving type ) AS SchedulingStatus,
  cast ('' as abap.sstring(256) ) AS SchedulingStatusText,
  PlannedStartDate,
  ReleasedByUserName,
  CompletionDate,
  CompletionTime,
  _MaintPlanCallHistory.SchedulingType AS SchedulingType,
  _MaintPlanCallHistory._SchedulingType._Text[1: Language = $session.system_language ].SchedulingTypeName AS SchedulingTypeName,
  _MaintPlanCallHistory.MaintCallIsInvokedOnPlndDate AS MaintCallIsInvokedOnPlndDate,
  _MaintPlanCallHistory.MaintenanceCallIsOutstanding AS MaintenanceCallIsOutstanding,
  cast ( 000 as int1 preserving type ) AS MaintPlanStatusCriticality,
  case _MaintenanceItem.MaintenancePlanCallObject when '' then _MaintenanceOrder.MaintPriority when '2' then _MaintenanceNotification.MaintPriority else '' end as MaintPriority AS MaintPriorityelseendasMaintPriority,
  _ServiceOrder.ServiceDocumentPriority AS ServiceDocumentPriority,
  _ServiceOrder._ServiceDocumentPriority AS _ServiceDocumentPriority
FROM I_MaintPlanCallObject
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON _MaintenanceOrderType.OrderType = MaintenanceOrderType  -- association [1..1]
LEFT OUTER JOIN I_PMNotificationType AS _PMNotificationType ON _PMNotificationType.NotificationType = NotificationType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON _ServiceDocumentType.ServiceDocumentType = ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_MaintCallSchedulingType AS _SchedulingType ON _SchedulingType.SchedulingType = SchedulingType  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderQuickVw AS _MaintenanceOrderQuickView ON _MaintenanceOrderQuickView.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlanQuickVw AS _MaintenancePlanQuickVw ON _MaintenancePlanQuickVw.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN C_MaintNotificationQuickVw AS _MaintNotificationQuickView ON _MaintNotificationQuickView.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanMaintCall AS _MaintPlanCallHistory ON _MaintPlanCallHistory.MaintenancePlan = MaintenancePlan AND _MaintPlanCallHistory.MaintenancePlanCallNumber = MaintenancePlanCallNumber  -- association [0..1]
;