CRMS4_IU_I_UMN

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 CRMS4_IU_I_UMN.
-- 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.

CREATE VIEW CRMS4_IU_I_UMN AS
SELECT
  I_MaintenanceNotification.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceNotification.MaintPriority AS MaintPriority,
  I_MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  I_MaintenanceNotification.NotificationType AS NotificationType,
  I_MaintenanceNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintenanceNotification.ReportedByUser AS ReportedByUser,
  I_MaintenanceNotification.NotificationText AS NotificationText,
  I_MaintenanceNotification.LongTextLanguage AS LongTextLanguage,
  I_MaintenanceNotification.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceNotification.RequiredStartDate AS RequiredStartDate,
  I_MaintenanceNotification.RequiredStartTime AS RequiredStartTime,
  I_MaintenanceNotification.RequiredEndDate AS RequiredEndDate,
  I_MaintenanceNotification.RequiredEndTime AS RequiredEndTime,
  I_MaintenanceNotification.NotificationCreationDate AS NotificationCreationDate,
  I_MaintenanceNotification.NotificationCreationTime AS NotificationCreationTime,
  I_MaintenanceNotification.NotificationReferenceDate AS NotificationReferenceDate,
  I_MaintenanceNotification.NotificationHasLongText AS NotificationHasLongText,
  I_MaintenanceNotification.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintenanceNotification.NotificationTimeZone AS NotificationTimeZone,
  I_MaintenanceNotification.NotificationReferenceTime AS NotificationReferenceTime,
  I_MaintenanceNotification.NotificationCompletionDate AS NotificationCompletionDate,
  I_MaintenanceNotification.NotificationCompletionTime AS NotificationCompletionTime,
  I_MaintenanceNotification.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintenanceNotification.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintenanceNotification.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  I_MaintenanceNotification.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_MaintenanceNotification.MaintNotificationCode AS MaintNotificationCode,
  I_MaintenanceNotification.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  I_MaintenanceNotification.CatalogProfile AS CatalogProfile,
  I_MaintenanceNotification.NotificationOrigin AS NotificationOrigin,
  I_MaintenanceNotification.IsDeleted AS IsDeleted,
  I_MaintenanceNotification.IsCompleted AS IsCompleted,
  I_MaintenanceNotification.LastChangeDateTime AS LastChangeDateTime,
  I_MaintenanceNotification.SerialNumber AS SerialNumber,
  I_MaintenanceNotification.Material AS Material,
  I_MaintenanceNotification.AdditionalDeviceData AS AdditionalDeviceData,
  I_MaintenanceNotification.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
  I_MaintenanceNotification.MasterLanguage AS MasterLanguage,
  I_MaintenanceNotification.DfsMaintNotificationObjectNmbr AS DfsMaintNotificationObjectNmbr,
  MaintenanceNotification.kunum AS kunum,
  _BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceNotification._PMNotifMaintenanceData.Equipment AS Equipment,
  I_MaintenanceNotification._PMNotificationType.NotificationCategory AS NotificationCategory,
  I_MaintenanceNotification._IsCompleted AS _IsCompleted,
  I_MaintenanceNotification._IsDeleted AS _IsDeleted,
  I_MaintenanceNotification._LinearAssetManagementData AS _LinearAssetManagementData,
  I_MaintenanceNotification._MaintenanceNotificationItem AS _MaintenanceNotificationItem,
  I_MaintenanceNotification._Maintenancenotificationtask AS _Maintenancenotificationtask,
  I_MaintenanceNotification._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintenanceNotification._MaintenancePartner AS _MaintenancePartner,
  I_MaintenanceNotification._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant,
  I_MaintenanceNotification._MaintNotificationActivity AS _MaintNotificationActivity,
  I_MaintenanceNotification._MaintNotificationCatalog AS _MaintNotificationCatalog,
  I_MaintenanceNotification._MaintNotificationCode AS _MaintNotificationCode,
  I_MaintenanceNotification._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  I_MaintenanceNotification._MainWorkCenter AS _MainWorkCenter,
  I_MaintenanceNotification._Material AS _Material,
  I_MaintenanceNotification._NotificationHasLongText AS _NotificationHasLongText,
  I_MaintenanceNotification._PMNotificationPhase AS _PMNotificationPhase,
  I_MaintenanceNotification._PMNotificationPriority AS _PMNotificationPriority,
  I_MaintenanceNotification._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_MaintenanceNotification._PMNotificationType AS _PMNotificationType,
  I_MaintenanceNotification._PMNotifMaintenanceData AS _PMNotifMaintenanceData,
  I_MaintenanceNotification._ReportedByUser AS _ReportedByUser,
  I_MaintenanceNotification._StatusObject AS _StatusObject,
  I_MaintenanceNotification._StatusObjectActiveStatus AS _StatusObjectActiveStatus,
  I_MaintenanceNotification._TechnicalObjectCodeCatalog AS _TechnicalObjectCodeCatalog,
  I_MaintenanceNotification._WorkCenterType AS _WorkCenterType
FROM I_MaintenanceNotification
INNER JOIN qmel AS MaintenanceNotification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _BusinessPartner ON _BusinessPartner.Customer = MaintenanceNotification.kunum  -- association [1..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON maintobjectlocacctassgmtnmbr = _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
;