C_MaintOrdObjListNotifQuickVw

DDL: C_MAINTORDOBJLISTNOTIFQUICKVW SQL: CMTORDOBJLST Type: view CONSUMPTION
14 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

View for notification list of an order

C_MaintOrdObjListNotifQuickVw is a Consumption CDS View that provides data about "View for notification list of an order" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderObjectList) and exposes 14 fields with key fields MaintenanceOrderObjectList, MaintenanceOrderObjectListItem. It is exposed through 1 OData service (UI_MAINTWRKREQ_ORD_MANAGE). It is used in 1 Fiori application: Manage Maintenance Notifications and Orders.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderObjectList I_MaintenanceOrderObjectList from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMTORDOBJLST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label View for notification list of an order view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MAINTWRKREQ_ORD_MANAGE UI_MAINTWRKREQ_ORD_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4604 Manage Maintenance Notifications and Orders Transactional An app to manage accepted maintenance notifications and orders. Using this app, you can create maintenance orders for notifications, submit the orders for approval, and release the orders.

Manage Maintenance Notifications and Orders

Business Role: Maintenance Planner

With this app, you can manage maintenance notifications and orders that are processed by phases. You can use different filter parameters to display maintenance notifications or orders with specific attributes and perform different actions on them.

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderObjectList MaintenanceOrderObjectList Object list
KEY MaintenanceOrderObjectListItem MaintenanceOrderObjectListItem Object counters
MaintenanceNotification MaintenanceNotification Maintenance Notification
NotificationText _MaintenanceNotification NotificationText Notification Text
NotificationType _MaintenanceNotification NotificationType Notification Type
NotificationTypeName Notification Type Name
MaintPriority _MaintenanceNotification MaintPriority Priority
MaintPriorityDesc Priority Text
MaintenanceObjectIsDown Breakdown
NotificationCreationDate _MaintenanceNotification NotificationCreationDate Notification Date
LatestAcceptableCompletionDate Final Due Date
MaintNotificationLongText Long Text
MaintNotifInternalID _MaintenanceNotification MaintNotifInternalID Object number
_MaintenanceItem _MaintenanceItem

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 C_MaintOrdObjListNotifQuickVw.
-- 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: CMTORDOBJLST

CREATE VIEW C_MaintOrdObjListNotifQuickVw AS
SELECT
  MaintenanceOrderObjectList,
  MaintenanceOrderObjectListItem,
  MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS NotificationText,
  _MaintenanceNotification.NotificationType AS NotificationType,
  _MaintenanceNotification._PMNotificationType._Text[1:Language=$session.system_language].NotificationTypeName AS NotificationTypeName,
  _MaintenanceNotification.MaintPriority AS MaintPriority,
  _MaintenanceNotification._PMNotificationPriority._Text[1:Language=$session.system_language].MaintPriorityDesc AS MaintPriorityDesc,
  _MaintenanceNotification._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  _MaintenanceNotification.NotificationCreationDate AS NotificationCreationDate,
  _MaintenanceNotification._PMNotifMaintenanceData.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  cast( '' as eams_ltext ) AS MaintNotificationLongText,
  _MaintenanceNotification.MaintNotifInternalID AS MaintNotifInternalID
FROM I_MaintenanceOrderObjectList
;

Learn More