C_ObjPgMaintOrderWthDesc

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_ObjPgMaintOrderWthDesc.
-- 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: COPMNTORDWTHDESC

CREATE VIEW C_ObjPgMaintOrderWthDesc AS
SELECT
  I_MaintOrderTechObj.MaintenanceOrder AS MaintenanceOrder,
  I_MaintOrderTechObj.MaintenanceNotification AS MaintenanceNotification,
  I_MaintOrderTechObj._MaintenanceNotification.NotificationText AS MaintenanceNotificationText,
  I_MaintOrderTechObj._Order.BillOfOperations AS TaskListGroup,
  I_MaintOrderTechObj._Order.BillOfOperationsType AS TaskListType,
  I_MaintOrderTechObj._Order.BillOfOperationsVariant AS TaskListGroupCounter,
  $session.system_date AS TaskListKeyDate,
  I_MaintOrderTechObj._Order._BillOfOperationsChangeState.BillOfOperationsDesc AS TaskListDesc,
  I_MaintOrderTechObj.MaintenancePlan AS MaintenancePlan,
  I_MaintOrderTechObj._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  cast (' ' as eams_ltext) AS MaintenanceOrderLongText,
  I_MaintOrderTechObj.OrderHasLongText AS OrderHasLongText,
  I_MaintOrderTechObj.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintOrderTechObj.MaintenanceOrderType AS MaintenanceOrderType,
  I_MaintOrderTechObj.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintOrderTechObj.ControllingArea AS ControllingArea,
  I_MaintOrderTechObj.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_MaintOrderTechObj.Equipment AS Equipment,
  I_MaintOrderTechObj.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintOrderTechObj._Equipment AS _Equipment,
  I_MaintOrderTechObj._LocationAccountAssignment AS _LocationAccountAssignment
FROM I_MaintOrderTechObj
LEFT OUTER JOIN C_MaintNotificationQuickVw AS _MaintNotificationQuickView ON MaintenanceNotification = _MaintNotificationQuickView.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlanQuickVw AS _MaintenancePlanQuickVw ON _MaintenancePlanQuickVw.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN C_MaintTaskListQuickVw AS _MaintTaskListQuickVw ON _MaintTaskListQuickVw.TaskList = TaskList AND _MaintTaskListQuickVw.TaskListType = TaskListType AND _MaintTaskListQuickVw.TaskListGroup = TaskListGroup AND _MaintTaskListQuickVw.TaskListGroupCounter = TaskListGroupCounter  -- association [0..1]
;