I_MaintOrdObjListNotif

DDL: I_MAINTORDOBJLISTNOTIF Type: view_entity COMPOSITE
31 Fields 1 Data Sources 2 Associations

Maintenance order object list notifications

I_MaintOrdObjListNotif is a Composite CDS View that provides data about "Maintenance order object list notifications" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderObjectList) and exposes 31 fields with key fields MaintenanceOrderObjectList, MaintenanceOrderObjectListItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderObjectList _ObjList from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_MaintNotificationItemTP_3 _ObjListMaintNotifItemTP $projection.MaintenanceNotification = _ObjListMaintNotifItemTP.MaintenanceNotification
[0..1] I_MaintNotificationTechObj _MaintNotifTechObj $projection.MaintenanceNotification = _MaintNotifTechObj.MaintenanceNotification

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance order object list notifications view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrderObjectList I_MaintenanceOrderObjectList MaintenanceOrderObjectList Object list
KEY MaintenanceOrderObjectListItem I_MaintenanceOrderObjectList MaintenanceOrderObjectListItem Object counters
MaintNotifTechObjIsDefault _ObjList1 MaintNotifTechObjIsDefault
MaintenanceNotification I_MaintenanceOrderObjectList MaintenanceNotification Notification
MalfunctionEffect _MaintNotifTechObj MalfunctionEffect Effect
MalfunctionStartDate _MaintNotifTechObj MalfunctionStartDate Malfunct. Start
MalfunctionStartTime _MaintNotifTechObj MalfunctionStartTime Mal. Start (T.)
clientNULLasMalfunctionStartDateTime
MalfunctionEndDate _MaintNotifTechObj MalfunctionEndDate Malfunct. End
MalfunctionEndTime _MaintNotifTechObj MalfunctionEndTime Malfunction End
clientNULLasMalfunctionEndDateTime
NotificationTimeZone _MaintNotifTechObj NotificationTimeZone Notif.Time.Zone
MaintNotificationCode _MaintNotifTechObj MaintNotificationCode Coding
MaintNotificationCatalog _MaintNotifTechObj MaintNotificationCatalog Catalog Type
MaintNotificationCodeGroup _MaintNotifTechObj MaintNotificationCodeGroup Code Group
CatalogProfile _MaintNotifTechObj CatalogProfile Catalog Profile
MaintNotifCodgCatalogTypeCode
MaintNotifActivityCodeCatalog
MaintNotifCauseCodeCatalog
MaintNotifDamageCodeCatalog
MaintNotifObjPrtCodeCatalog
MaintObjDowntimeDurationUnit _MaintNotifTechObj MaintObjDowntimeDurationUnit Unit
MaintenanceObjectIsDown _MaintNotifTechObj MaintenanceObjectIsDown Breakdown
MaintNotifDetectionCatalog
MaintNotifDetectionCodeGroup
MaintNotifDetectionCode
NotificationText _MaintNotifTechObj NotificationText Description
_MalfunctionEffect _MaintNotifTechObj _MalfunctionEffect
_ObjListMaintNotifItemTP _ObjListMaintNotifItemTP
_MaintNotifTechObj _MaintNotifTechObj
_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 I_MaintOrdObjListNotif.
-- 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_MaintOrdObjListNotif AS
SELECT
  _ObjList.MaintenanceOrderObjectList AS MaintenanceOrderObjectList,
  _ObjList.MaintenanceOrderObjectListItem AS MaintenanceOrderObjectListItem,
  _ObjList1.MaintNotifTechObjIsDefault AS MaintNotifTechObjIsDefault,
  _ObjList.MaintenanceNotification AS MaintenanceNotification,
  _MaintNotifTechObj.MalfunctionEffect AS MalfunctionEffect,
  _MaintNotifTechObj.MalfunctionStartDate AS MalfunctionStartDate,
  _MaintNotifTechObj.MalfunctionStartTime AS MalfunctionStartTime,
  dats_tims_to_tstmp( _MaintNotifTechObj.MalfunctionStartDate, _MaintNotifTechObj.MalfunctionStartTime, _MaintNotifTechObj.NotificationTimeZone, $session.client, 'NULL' ) as MalfunctionStartDateTime AS clientNULLasMalfunctionStartDateTime,
  _MaintNotifTechObj.MalfunctionEndDate AS MalfunctionEndDate,
  _MaintNotifTechObj.MalfunctionEndTime AS MalfunctionEndTime,
  dats_tims_to_tstmp( _MaintNotifTechObj.MalfunctionEndDate, _MaintNotifTechObj.MalfunctionEndTime, _MaintNotifTechObj.NotificationTimeZone, $session.client, 'NULL' ) as MalfunctionEndDateTime AS clientNULLasMalfunctionEndDateTime,
  _MaintNotifTechObj.NotificationTimeZone AS NotificationTimeZone,
  _MaintNotifTechObj.MaintNotificationCode AS MaintNotificationCode,
  _MaintNotifTechObj.MaintNotificationCatalog AS MaintNotificationCatalog,
  _MaintNotifTechObj.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  _MaintNotifTechObj.CatalogProfile AS CatalogProfile,
  _MaintNotifTechObj._PMNotificationType.MaintNotifCodgCatalogTypeCode AS MaintNotifCodgCatalogTypeCode,
  _MaintNotifTechObj._PMNotificationType.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  _MaintNotifTechObj._PMNotificationType.MaintNotifCauseCodeCatalog AS MaintNotifCauseCodeCatalog,
  _MaintNotifTechObj._PMNotificationType.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  _MaintNotifTechObj._PMNotificationType.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  _MaintNotifTechObj.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  _MaintNotifTechObj.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  _MaintNotifTechObj._PMNotifMaintenanceData.MaintNotifDetectionCatalog AS MaintNotifDetectionCatalog,
  _MaintNotifTechObj._PMNotifMaintenanceData.MaintNotifDetectionCodeGroup AS MaintNotifDetectionCodeGroup,
  _MaintNotifTechObj._PMNotifMaintenanceData.MaintNotifDetectionCode AS MaintNotifDetectionCode,
  _MaintNotifTechObj.NotificationText AS NotificationText,
  _MaintNotifTechObj._MalfunctionEffect AS _MalfunctionEffect
FROM I_MaintenanceOrderObjectList AS _ObjList
LEFT OUTER JOIN C_MaintNotificationItemTP_3 AS _ObjListMaintNotifItemTP ON MaintenanceNotification = _ObjListMaintNotifItemTP.MaintenanceNotification  -- association [1..*]
LEFT OUTER JOIN I_MaintNotificationTechObj AS _MaintNotifTechObj ON MaintenanceNotification = _MaintNotifTechObj.MaintenanceNotification  -- association [0..1]
;

Learn More