C_MaintOrdObjListNotifQuickVw

DDL: C_MAINTORDOBJLISTNOTIFQUICKVW SQL: CMTORDOBJLST Type: view CONSUMPTION
14 Fields 1 Data Sources

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.

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

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