I_DFS_MaintEquipmentData

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 I_DFS_MaintEquipmentData.
-- 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: IDFSEQUIPDATA
-- Parameters: P_equipment : equnr

CREATE VIEW I_DFS_MaintEquipmentData AS
SELECT
  _MaintEquipTechStsHier.Equipment AS Equipment,
  _MaintNotificationTechSts.MaintenanceNotification AS MaintenanceNotification,
  _MaintenanceOrderTechSts.MaintenanceOrder AS MaintenanceOrder,
  _MaintEquipTechStsHier.FunctionalLocation AS FunctionalLocation,
  _MaintEquipTechStsHier.DfsMaintTechStsAggrgnIsStppd AS DfsMaintTechStsAggrgnIsStppd,
  _MaintEquipTechStsHier.DfsMaintEquipTechStatusProfile AS DfsMaintEquipTechStatusProfile,
  _MaintEquipTechStsHier.DfsMaintHierarchyRankValue AS DfsMaintHierarchyRankValue,
  _MaintEquipTechStsHier.DfsMaintHierParentRankValue AS DfsMaintHierParentRankValue,
  _MaintEquipTechStsHier.DfsMaintSuperordinateEquipNmbr AS DfsMaintSuperordinateEquipNmbr,
  _MaintEquipTechStsHier.DfsMaintEquipmentType AS DfsMaintEquipmentType,
  _MaintNotificationTechSts.DfsMaintNotifTechStatusProfile AS DfsMaintNotifTechStatusProfile,
  _MaintNotificationTechSts.DfsMaintNotifTechStatus AS DfsMaintNotifTechStatus,
  _MaintenanceOrderTechSts._MaintOrderTechSts.StatusCode AS DfsMaintOrderTechStatus,
  _MaintenanceOrderTechSts.DfsMaintOrdTechStatusProfile AS DfsMaintOrdTechStatusProfile
FROM I_DFS_MaintEquipTechStsHier
LEFT OUTER JOIN I_DFS_MaintNotificationTechSts AS _MaintNotificationTechSts ON _MaintNotificationTechSts.Equipment = _MaintEquipTechStsHier.Equipment AND ( _MaintNotificationTechSts.NotifProcessingPhase = '1' OR _MaintNotificationTechSts.NotifProcessingPhase = '2' OR _MaintNotificationTechSts.NotifProcessingPhase = '3' )  -- association [1..1]
LEFT OUTER JOIN I_DFS_MaintenanceOrderTechSts AS _MaintenanceOrderTechSts ON _MaintenanceOrderTechSts.Equipment = _MaintEquipTechStsHier.Equipment AND _MaintenanceOrderTechSts.MaintenanceOrderCategory = '30' AND ( _MaintenanceOrderTechSts.MaintenanceProcessingPhase = '0' OR _MaintenanceOrderTechSts.MaintenanceProcessingPhase = '1' OR _MaintenanceOrderTechSts.MaintenanceProcessingPhase = '2' )  -- association [1..1]
;