C_MalfunctionReportWorkItem

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_MalfunctionReportWorkItem.
-- 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: CMFREPWKITEM

CREATE VIEW C_MalfunctionReportWorkItem AS
SELECT
  _Operation.MaintenanceOrder AS MaintenanceOrder,
  _Operation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _Order.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _Order.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _Order.MaintenanceNotification AS MaintenanceNotification,
  _Order._MaintenanceNotification.NotificationText AS NotificationText,
  _Operation.OperationDescription AS OperationDescription,
  _Operation.OperationPersonResponsible AS OperationPersonResponsible,
  _Operation._WorkCenter.WorkCenter AS OperationWorkCenter,
  _Operation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _Operation.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  _Operation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _Operation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _Operation.Plant AS Plant,
  _OperationOverallStatus.EAMOverallObjectStatusProfile AS EAMOverallObjectStatusProfile,
  _OperationOverallStatus.EAMOverallObjectStatus AS EAMOverallObjectStatus,
  cast( case when _Order._StatusObjectStatus[ StatusCode = 'I3350' and StatusIsInactive = '' ].StatusObject is not null then 'F2023' else '' end as pm_source_appl) AS MaintOrderSourceApplication,
  cast( case when _Order._MaintenanceNotification._StatusObjectActiveStatus[ StatusCode = 'I3351' ].StatusObject is not null then 'F1511' else '' end as pm_source_appl) AS MaintNotifSourceApplication,
  cast( '' as eams_ui_myself_myteam ) AS MaintenanceJobSelection,
  _Order._MaintenanceNotification._PMNotificationPriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _Order._MaintenanceNotification._PMNotificationPriority.MaintPriority AS MaintPriority,
  _Order._MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  _Operation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  case when _Operation.Equipment != '' then cast( _Operation.Equipment as eams_tec_obj ) when _Operation.FunctionalLocation != '' then cast( _Operation.FunctionalLocation as eams_tec_obj ) else _Order.TechnicalObject end as TechnicalObject AS TechnicalObjectendasTechnicalObject,
  case when _Operation.Equipment != '' then _Operation.Equipment else _Order.Equipment end as Equipment AS EquipmentendasEquipment,
  case when _Operation.Equipment != '' then _Operation._Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName else _Order._Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName end as EquipmentName AS EquipmentNameendasEquipmentName,
  _Order.FunctionalLocation AS FunctionalLocation,
  _Operation._FunctionalLocation._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _Operation._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _Order._FunctionalLocation._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS OpFunctionalLocationLabelName,
  _Order._FunctionalLocation._FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS OperationFunctionalLocation,
  _Order._StatusObjectStatus AS _StatusObjectStatus,
  _OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  _Operation._MaintenanceOrder AS _MaintenanceOrder,
  _Operation._WorkCenter AS _WorkCenter,
  _OperationOverallStatus._OverallStatus AS _OverallStatus,
  _OperationOverallStatus._OverallStatusProfile AS _OverallStatusProfile
FROM I_MaintenanceOrderOperation AS _Operation
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IsDeletedStatus ON _IsDeletedStatus.StatusCode = 'I0013' AND _IsDeletedStatus.StatusObject = _Operation.MaintOrderOperationInternalID AND _IsDeletedStatus.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _Order ON _Order.MaintenanceOrder = _Operation.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_Malfunctionreport AS _MalfunctionReport ON _MalfunctionReport.MaintenanceNotification = maintenancenotification  -- association [1..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _OperationPersonResponsible ON OperationPersonResponsible = _OperationPersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceJobSelection AS _MaintenanceJobSelection ON _MaintenanceJobSelection.MaintenanceJobSelection = MaintenanceJobSelection  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON _WorkCenterText.WorkCenterInternalID = OperationWorkCenterInternalID AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN C_PMWorkCenterVH AS _WorkCenterVH ON OperationWorkCenter = _WorkCenterVH.WorkCenter AND Plant = _WorkCenterVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_EAMObjectOverallStatus AS _OperationOverallStatus ON MaintOrderOperationInternalID = _OperationOverallStatus.StatusObject AND _OperationOverallStatus.EAMOverallObjectStatusProfile = 'MAINTJOB'  -- association [0..1]
LEFT OUTER JOIN C_JobListStatusVH AS _JobListStatusVH ON eamoverallobjectstatus = _JobListStatusVH.EAMOverallStatus AND eamoverallobjectstatusprofile = _JobListStatusVH.EAMOverallStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriority AS _JobListPriority ON maintpriority = _JobListPriority.MaintPriority AND maintprioritytype = _JobListPriority.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectForEditVH AS _TechnicalObjectVH ON _TechnicalObjectVH.TechnicalObject = TechnicalObject AND _TechnicalObjectVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectVH.TechnicalObjectLabel = TechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = functionallocation  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;