I_MaintenanceNotificationBasic

DDL: I_MAINTENANCENOTIFICATIONBASIC Type: view_entity BASIC
67 Fields 2 Data Sources

Maintenance Notification Basic

I_MaintenanceNotificationBasic is a Basic CDS View that provides data about "Maintenance Notification Basic" in SAP S/4HANA. It reads from 2 data sources (qmih, qmel) and exposes 67 fields with key field MaintenanceNotification.

Data Sources (2)

SourceAliasJoin Type
qmih MaintNotif from
qmel Notification inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Maintenance Notification Basic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification qmih qmnum Notification
NotificationType qmel qmart Notifictn Type
NotificationText qmel qmtxt Description
MaintenanceOrder qmel aufnr SettlementOrder
MaintNotifProcessingContext qmih maintnotifprocessingcontext Notif Procg Context
MaintNotifRejectionReasonCode qmih notifrejectionreasoncode Reason Code
MaintPriorityType qmel artpr PriorityType
MaintPriority qmel priok Priority
LatestAcceptableCompletionDate qmih lacd_date Final Due Date
PreviousFinalDueDate qmih old_lacd_date Prev. Final Due Date
CatalogProfile qmel rbnr Catalog Profile
CatalogProfileOriginCode qmel rbnri Profile Origin
Equipment qmih equnr Equipment
MaintObjectLocAcctAssgmtNmbr qmih iloan Loc/AccAssmt
LocationDescription qmih loc_desc Current Location
RequiredStartDate qmel strmn Required Start
RequiredStartTime qmel strur Req. start time
RequiredEndDate qmel ltrmn Required End
RequiredEndTime qmel ltrur Req. end time
NotificationCreationDate qmel qmdat Notif. Date
NotificationCreationTime qmel mzeit Notif. Time
NotificationReferenceDate qmel bezdt Reference Date
NotificationReferenceTime qmel bezur ReferenceTime
NotificationCompletionDate qmel qmdab Completion Date
NotificationCompletionTime qmel qmzab Completion Time
MalfunctionStartDate qmih ausvn Malfunct. Start
MalfunctionStartTime qmih auztv Mal. Start (T.)
MalfunctionEndDate qmih ausbs Malfunct. End
MalfunctionEndTime qmih auztb Malfunction End
MaintNotificationCatalog qmel qmkat Catalog Type
MaintNotificationCodeGroup qmel qmgrp Code Group
MaintNotificationCode qmel qmcod Coding
MaintenanceObjectIsDown qmih msaus Breakdown
MaintObjectDowntimeDuration qmih auszt Breakdown Dur.
MaintObjDowntimeDurationUnit qmih maueh Unit
MaintNotifDetectionCatalog qmih detectioncatalog Detection Meth Prfl
MaintNotifDetectionCodeGroup qmih detectioncodegroup Detection Meth Grp
MaintNotifDetectionCode qmih detectioncode Detection Meth
MalfunctionEffect qmih auswk Effect
MaintNotifInternalID qmel objnr Val. Obj. No.
NotificationHasLongText qmel indtx Long text
NotificationTimeZone qmel tzonso Notif.Time.Zone
NotificationTimeZoneOrigin qmel tzonid Time zone orig.
MaintenancePlan qmih warpl MaintenancePlan
MaintenanceItem qmih wapos MaintItem
MaintenancePlanCallNumber qmih abnum Stage number
MaintenanceTaskListType qmih plnty Task List Type
TaskListGroup qmih plnnr Task List Group
TaskListGroupCounter qmih plnal Referenced BOO Variant
MaintenanceActivityType qmih ilart MaintActivType
NotifProcessingPhase qmel phase Step
MaintNotifProcessPhaseCode qmih maintnotifovrlprocphase Process Phase
MaintNotifProcessSubPhaseCode qmih maintnotifovrlprocsubphase Process Subphase
WorkCenterInternalID qmel arbpl Work Center
MainWorkCenterPlant qmel arbplwerk Work Ctr Plant
MainWorkCenterTypeCode qmel crobjty Object Type
MaintenancePlannerGroup qmih ingrp Planner Group
MaintenancePlanningPlant qmih iwerk Planning Plant
NotificationPersonResponsible qmih notificationpersonresponsible Person Resp. ID
ReportedByUser qmel qmnam Reported By
CreatedByUser qmel ernam User Name
CreationDate qmel erdat Entered On
CreationTime qmel erzeit Time created
LastChangedByUser qmel aenam User Name
LastChangeDate qmel aedat Obsolete
LastChangeTime qmel aezeit Time changed
LastChangeDateTime qmel changeddatetime Time Stamp

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_MaintenanceNotificationBasic.
-- 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 I_MaintenanceNotificationBasic AS
SELECT
  MaintNotif.qmnum AS MaintenanceNotification,
  Notification.qmart AS NotificationType,
  Notification.qmtxt AS NotificationText,
  Notification.aufnr AS MaintenanceOrder,
  MaintNotif.maintnotifprocessingcontext AS MaintNotifProcessingContext,
  MaintNotif.notifrejectionreasoncode AS MaintNotifRejectionReasonCode,
  Notification.artpr AS MaintPriorityType,
  Notification.priok AS MaintPriority,
  MaintNotif.lacd_date AS LatestAcceptableCompletionDate,
  MaintNotif.old_lacd_date AS PreviousFinalDueDate,
  Notification.rbnr AS CatalogProfile,
  Notification.rbnri AS CatalogProfileOriginCode,
  MaintNotif.equnr AS Equipment,
  MaintNotif.iloan AS MaintObjectLocAcctAssgmtNmbr,
  MaintNotif.loc_desc AS LocationDescription,
  Notification.strmn AS RequiredStartDate,
  Notification.strur AS RequiredStartTime,
  Notification.ltrmn AS RequiredEndDate,
  Notification.ltrur AS RequiredEndTime,
  Notification.qmdat AS NotificationCreationDate,
  Notification.mzeit AS NotificationCreationTime,
  Notification.bezdt AS NotificationReferenceDate,
  Notification.bezur AS NotificationReferenceTime,
  Notification.qmdab AS NotificationCompletionDate,
  Notification.qmzab AS NotificationCompletionTime,
  MaintNotif.ausvn AS MalfunctionStartDate,
  MaintNotif.auztv AS MalfunctionStartTime,
  MaintNotif.ausbs AS MalfunctionEndDate,
  MaintNotif.auztb AS MalfunctionEndTime,
  Notification.qmkat AS MaintNotificationCatalog,
  Notification.qmgrp AS MaintNotificationCodeGroup,
  Notification.qmcod AS MaintNotificationCode,
  MaintNotif.msaus AS MaintenanceObjectIsDown,
  MaintNotif.auszt AS MaintObjectDowntimeDuration,
  MaintNotif.maueh AS MaintObjDowntimeDurationUnit,
  MaintNotif.detectioncatalog AS MaintNotifDetectionCatalog,
  MaintNotif.detectioncodegroup AS MaintNotifDetectionCodeGroup,
  MaintNotif.detectioncode AS MaintNotifDetectionCode,
  MaintNotif.auswk AS MalfunctionEffect,
  Notification.objnr AS MaintNotifInternalID,
  Notification.indtx AS NotificationHasLongText,
  Notification.tzonso AS NotificationTimeZone,
  Notification.tzonid AS NotificationTimeZoneOrigin,
  MaintNotif.warpl AS MaintenancePlan,
  MaintNotif.wapos AS MaintenanceItem,
  MaintNotif.abnum AS MaintenancePlanCallNumber,
  MaintNotif.plnty AS MaintenanceTaskListType,
  MaintNotif.plnnr AS TaskListGroup,
  MaintNotif.plnal AS TaskListGroupCounter,
  MaintNotif.ilart AS MaintenanceActivityType,
  Notification.phase AS NotifProcessingPhase,
  MaintNotif.maintnotifovrlprocphase AS MaintNotifProcessPhaseCode,
  MaintNotif.maintnotifovrlprocsubphase AS MaintNotifProcessSubPhaseCode,
  Notification.arbpl AS WorkCenterInternalID,
  Notification.arbplwerk AS MainWorkCenterPlant,
  Notification.crobjty AS MainWorkCenterTypeCode,
  MaintNotif.ingrp AS MaintenancePlannerGroup,
  MaintNotif.iwerk AS MaintenancePlanningPlant,
  MaintNotif.notificationpersonresponsible AS NotificationPersonResponsible,
  Notification.qmnam AS ReportedByUser,
  Notification.ernam AS CreatedByUser,
  Notification.erdat AS CreationDate,
  Notification.erzeit AS CreationTime,
  Notification.aenam AS LastChangedByUser,
  Notification.aedat AS LastChangeDate,
  Notification.aezeit AS LastChangeTime,
  Notification.changeddatetime AS LastChangeDateTime
FROM qmih AS MaintNotif
INNER JOIN qmel AS Notification ON /* join condition not captured in parsed metadata */
;

Learn More