P_MaintNotificationSearch

//Maintenance Notification anchor view for CDS search model

@AbapCatalog.sqlViewName: 'PNOTIFSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MaintenanceNotification'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_MaintNotificationSearch
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : abap.lang
  as select from I_MaintenanceNotification
  association [0..*] to I_TextObjectPlainLongText as _LongText on  $projection.MaintenanceNotification = _LongText.TextObjectKey
                                                               and _LongText.TextObjectCategory        = 'QMEL'
                                                               and _LongText.TextObjectType            = 'LTXT'
{
      //I_MaintenanceNotification

  key MaintenanceNotification,
      MaintPriority,
      MaintPriorityType,
      NotificationType,
      I_MaintenanceNotification.NotifProcessingPhase,
      CreatedByUser,
      LastChangedByUser,
      ReportedByUser,
      CreationDate,
      LastChangeTime,
      LastChangeDate,
      CreationTime,
      CreationDateTime,
      NotificationText,
      MaintenanceOrder,
      RequiredStartDate,
      RequiredStartTime,
      RequiredEndDate,
      RequiredEndTime,
      NotificationCreationDate,
      NotificationCreationTime,
      NotificationReferenceDate,
      NotificationHasLongText,
      MaintNotifInternalID,
      NotificationTimeZone,
      NotificationReferenceTime,
      NotificationCompletionDate,
      NotificationCompletionTime,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      MaintenanceWorkCenterPlant,
      MaintNotificationCatalog,
      MaintNotificationCode,
      MaintNotificationCodeGroup,
      CatalogProfile,
      NotificationOrigin,
      IsDeleted,
      IsCompleted,
      LastChangeDateTime,
      _PMNotifMaintenanceData.LatestAcceptableCompletionDate,
      /* Associations */
      //I_MaintenanceNotification

      _CreatedByUser,
      _IsCompleted,
      _IsDeleted,
      _LastChangedByUser,
      _LinearAssetManagementData,
      _MaintenanceNotificationItem,
      _Maintenancenotificationtask,
      _MaintenanceOrder,
      _MaintenancePartner,
      _MaintenanceWorkCenterPlant,
      _MaintNotificationActivity,
      _MaintNotificationCatalog,
      _MaintNotificationCode,
      _MaintNotificationCodeGroup,
      _MainWorkCenter,
      _NotificationHasLongText,
      _PMNotificationPhase,
      _PMNotificationPriority,
      _PMNotificationPriorityType,
      _PMNotificationType,
      _PMNotifMaintenanceData,
      _ReportedByUser,
      _StatusObject,
      _StatusObjectActiveStatus,
      _TechnicalObjectCodeCatalog,
      _WorkCenterType,
      _LongText
}