P_MaintNotificationSearch

DDL: P_MAINTNOTIFICATIONSEARCH SQL: PNOTIFSEARCH Type: view BASIC
67 Fields 1 Data Sources 1 Associations

P_MaintNotificationSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 67 fields with key field MaintenanceNotification. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotification I_MaintenanceNotification from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.MaintenanceNotification = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'QMEL' and _LongText.TextObjectType = 'LTXT'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PNOTIFSEARCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaintenanceNotification view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Notification
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
NotificationType NotificationType Notifictn Type
NotifProcessingPhase I_MaintenanceNotification NotifProcessingPhase Notif. Phase
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
ReportedByUser ReportedByUser Reported By
CreationDate CreationDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDate LastChangeDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
NotificationText NotificationText Description
MaintenanceOrder MaintenanceOrder Order
RequiredStartDate RequiredStartDate Req. Start Date
RequiredStartTime RequiredStartTime Req. start time
RequiredEndDate RequiredEndDate Req. End Date
RequiredEndTime RequiredEndTime Req. end time
NotificationCreationDate NotificationCreationDate Notif. Date
NotificationCreationTime NotificationCreationTime Notif. Time
NotificationReferenceDate NotificationReferenceDate Reference Date
NotificationHasLongText NotificationHasLongText Long text
MaintNotifInternalID MaintNotifInternalID Object number
NotificationTimeZone NotificationTimeZone Notif.Time.Zone
NotificationReferenceTime NotificationReferenceTime ReferenceTime
NotificationCompletionDate NotificationCompletionDate Completion Date
NotificationCompletionTime NotificationCompletionTime Completion Time
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
MaintenanceWorkCenterPlant MaintenanceWorkCenterPlant Work Ctr Plant
MaintNotificationCatalog MaintNotificationCatalog Catalog Type
MaintNotificationCode MaintNotificationCode Coding
MaintNotificationCodeGroup MaintNotificationCodeGroup Code Group
CatalogProfile CatalogProfile Catalog Profile
NotificationOrigin NotificationOrigin Origin ind
IsDeleted IsDeleted TRUE
IsCompleted IsCompleted
LastChangeDateTime LastChangeDateTime Timestamp
LatestAcceptableCompletionDate _PMNotifMaintenanceData LatestAcceptableCompletionDate Final Due Date
_CreatedByUser _CreatedByUser
_IsCompleted _IsCompleted
_IsDeleted _IsDeleted
_LastChangedByUser _LastChangedByUser
_LinearAssetManagementData _LinearAssetManagementData
_MaintenanceNotificationItem _MaintenanceNotificationItem
_Maintenancenotificationtask _Maintenancenotificationtask
_MaintenanceOrder _MaintenanceOrder
_MaintenancePartner _MaintenancePartner
_MaintenanceWorkCenterPlant _MaintenanceWorkCenterPlant
_MaintNotificationActivity _MaintNotificationActivity
_MaintNotificationCatalog _MaintNotificationCatalog
_MaintNotificationCode _MaintNotificationCode
_MaintNotificationCodeGroup _MaintNotificationCodeGroup
_MainWorkCenter _MainWorkCenter
_NotificationHasLongText _NotificationHasLongText
_PMNotificationPhase _PMNotificationPhase
_PMNotificationPriority _PMNotificationPriority
_PMNotificationPriorityType _PMNotificationPriorityType
_PMNotificationType _PMNotificationType
_PMNotifMaintenanceData _PMNotifMaintenanceData
_ReportedByUser _ReportedByUser
_StatusObject _StatusObject
_StatusObjectActiveStatus _StatusObjectActiveStatus
_TechnicalObjectCodeCatalog _TechnicalObjectCodeCatalog
_WorkCenterType _WorkCenterType
_LongText _LongText

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 P_MaintNotificationSearch.
-- 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: PNOTIFSEARCH
-- Parameters: P_Language : abap.lang

CREATE VIEW P_MaintNotificationSearch AS
SELECT
  MaintenanceNotification,
  MaintPriority,
  MaintPriorityType,
  NotificationType,
  I_MaintenanceNotification.NotifProcessingPhase AS 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 AS LatestAcceptableCompletionDate
FROM I_MaintenanceNotification
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON MaintenanceNotification = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'QMEL' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
;

Learn More