C_Malfunctionreport

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_Malfunctionreport.
-- 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: CMALFUNCREPORT

CREATE VIEW C_Malfunctionreport AS
SELECT
  I_MaintNotificationTechObj.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationTechObj.NotificationText AS NotificationText,
  I_MaintNotificationTechObj.NotificationType AS NotificationType,
  I_MaintNotificationTechObj.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintNotificationTechObj.MaintenanceOrder AS MaintenanceOrder,
  I_MaintNotificationTechObj._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_MaintNotificationTechObj.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintNotificationTechObj._MainWorkCenter.WorkCenter AS WorkCenter,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  I_MaintNotificationTechObj.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  I_MaintNotificationTechObj.MaintPriority AS MaintPriority,
  I_MaintNotificationTechObj._PMNotificationPriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  I_MaintNotificationTechObj._PMNotificationPriority._Text[1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  I_MaintNotificationTechObj.MaintPriorityType AS MaintPriorityType,
  I_MaintNotificationTechObj.TechnicalObject AS TechnicalObject,
  I_MaintNotificationTechObj._TechObjIsEquipOrFuncnlLoc._Text[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_MaintNotificationTechObj.Equipment AS Equipment,
  I_MaintNotificationTechObj.FunctionalLocation AS FunctionalLocation,
  _FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _FunctionalLocationText.FunctionalLocationName AS FunctionalLocationName,
  _EquipmentText.EquipmentName AS EquipmentName,
  cast( I_MaintNotificationTechObj.PersonResponsible as persno ) AS PersonResponsible,
  cast('' as eams_person_responsible_name) AS PersonResponsibleName,
  I_MaintNotificationTechObj.ReporterFullName AS ReporterFullName,
  I_MaintNotificationTechObj.MalfunctionEffect AS MalfunctionEffect,
  I_MaintNotificationTechObj.CreatedByUser AS CreatedByUser,
  cast('' as eams_person_responsible_name) AS CreatedByUserName,
  I_MaintNotificationTechObj.MalfunctionStartDate AS MalfunctionStartDate,
  I_MaintNotificationTechObj.MalfunctionStartTime AS MalfunctionStartTime,
  I_MaintNotificationTechObj.MalfunctionEndDate AS MalfunctionEndDate,
  I_MaintNotificationTechObj.MalfunctionEndTime AS MalfunctionEndTime,
  I_MaintNotificationTechObj.NotificationCreationDate AS NotificationCreationDate,
  I_MaintNotificationTechObj.NotificationCreationTime AS NotificationCreationTime,
  I_MaintNotificationTechObj.NotificationTimeZone AS NotificationTimeZone,
  cast( '000000000000' as timestamp ) AS NotificationDateTime,
  cast( '000000000000' as timestamp ) AS MalfunctionStartDateTime,
  cast( '000000000000' as timestamp ) AS MalfunctionEndDateTime,
  _OverallJobStatus.EAMOverallObjectStatus AS EAMOverallObjectStatus,
  _OverallJobStatus.EAMOverallObjectStatusProfile AS EAMOverallObjectStatusProfile,
  I_MaintNotificationTechObj._PMNotificationPriority AS _PMNotificationPriority,
  _OverallJobStatus._OverallStatus AS _OverallStatus,
  _OverallJobStatus._OverallStatusProfile AS _OverallStatusProfile
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintNotifInternalID = _StatusObjectStatus.StatusObject  -- association [1..*]
LEFT OUTER JOIN I_MaintenanceJobOverallStatus AS _OverallJobStatus ON MaintNotifInternalID = _OverallJobStatus.MaintenanceJobInternalID  -- association [0..1]
LEFT OUTER JOIN C_MalfunctionOvrStatsVH AS _OverallStatusVH ON eamoverallobjectstatus = _OverallStatusVH.EAMOverallStatus AND eamoverallobjectstatusprofile = _OverallStatusVH.EAMOverallStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _MaintNotifPersonResponsible ON PersonResponsible = _MaintNotifPersonResponsible.PersonExternalID  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PersonResponsible ON PersonResponsible = _PersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PersonInvolved ON PersonInvolved = _PersonInvolved.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN C_MalfunctionReportInvlmnts AS _Involvement ON _Involvement.MaintenanceJobInternalID = MaintNotifInternalID  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardUser AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN C_PMWorkCenterVH AS _WorkCenterVH ON workcenter = _WorkCenterVH.WorkCenter AND MaintenanceWorkCenterPlant = _WorkCenterVH.Plant AND _WorkCenterVH.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObjectText AS _TechnicalObjectText ON TechnicalObject = _TechnicalObjectText.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObjectText.TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechnicalObjectFlatVH AS _TechnicalObjectVH ON TechnicalObject = _TechnicalObjectVH.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObjectVH.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectForEditVH AS _TechnicalObjectForEditVH ON TechnicalObjectLabel = _TechnicalObjectForEditVH.TechnicalObjectLabel AND TechnicalObject = _TechnicalObjectForEditVH.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObjectForEditVH.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_Malfunctionreporttype AS _MalfunctionReportType ON NotificationType = _MalfunctionReportType.NotificationType  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment AND _EquipmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON MaintenanceNotification = _NotifMaintenanceDataExtension.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;