I_MaintNotificationItem_2

DDL: I_MAINTNOTIFICATIONITEM_2 Type: view_entity COMPOSITE Package: VDM_EAM_NTF
30 Fields 1 Data Sources 8 Associations

Maintenance Notification Item

I_MaintNotificationItem_2 is a Composite CDS View that provides data about "Maintenance Notification Item" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationItemBasic) and exposes 30 fields with key fields MaintenanceNotification, MaintenanceNotificationItem. It has 8 associations to related views. Part of development package VDM_EAM_NTF.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationItemBasic I_MaintNotificationItemBasic from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_MaintenanceNotification_2 _MaintenanceNotification $projection.MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification
[0..1] I_Inspectioncatalog _MaintNotifDamageCodeCatalog $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeCatalog.InspectionCatalog
[0..1] I_InspectionCodeGroup _MaintNotifDamageCodeGroup $projection.MaintNotifDamageCodeGroup = _MaintNotifDamageCodeGroup.InspectionCodeGroup and $projection.MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroup.InspectionCatalog
[0..1] I_InspectionCode _MaintNotificationDamageCode $projection.MaintNotificationDamageCode = _MaintNotificationDamageCode.InspectionCode and $projection.MaintNotifDamageCodeCatalog = _MaintNotificationDamageCode.InspectionCatalog and $projection.MaintNotifDamageCodeGroup = _MaintNotificationDamageCode.InspectionCodeGroup
[0..1] I_Inspectioncatalog _MaintNotifObjPrtCodeCatalog $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeCatalog.InspectionCatalog
[0..1] I_InspectionCodeGroup _MaintNotifObjPrtCodeGroup $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeGroup.InspectionCodeGroup and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroup.InspectionCatalog
[0..1] I_InspectionCode _MaintNotifObjPrtCode $projection.MaintNotifObjPrtCode = _MaintNotifObjPrtCode.InspectionCode and $projection.MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCode.InspectionCatalog and $projection.MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCode.InspectionCodeGroup
[0..1] I_Material _Assembly $projection.Assembly = _Assembly.Material

Annotations (6)

NameValueLevelField
EndUserText.label Maintenance Notification Item view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification Notification
KEY MaintenanceNotificationItem MaintenanceNotificationItem Number of days
MaintNotifItemText MaintNotifItemText Text
MaintNotifItemTxtLanguage MaintNotifItemTxtLanguage Primary lang.
MaintNotifDamageCodeCatalog MaintNotifDamageCodeCatalog
MaintNotifDamageCodeGroup MaintNotifDamageCodeGroup
MaintNotificationDamageCode MaintNotificationDamageCode
MaintNotifDamageCodeVersNumber MaintNotifDamageCodeVersNumber Version
MaintNotifObjPrtCodeCatalog MaintNotifObjPrtCodeCatalog
MaintNotifObjPrtCodeGroup MaintNotifObjPrtCodeGroup
MaintNotifObjPrtCode MaintNotifObjPrtCode
MaintNotifObjectCodeVersNmbr MaintNotifObjectCodeVersNmbr Version
Assembly Assembly Pegged Reqmt
IsDeleted IsDeleted TRUE
NotificationItemExternalID NotificationItemExternalID WBS Element
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
_MaintenanceNotification _MaintenanceNotification
_MaintNotifDamageCodeCatalog _MaintNotifDamageCodeCatalog
_MaintNotifDamageCodeGroup _MaintNotifDamageCodeGroup
_MaintNotificationDamageCode _MaintNotificationDamageCode
_MaintNotifObjPrtCodeCatalog _MaintNotifObjPrtCodeCatalog
_MaintNotifObjPrtCodeGroup _MaintNotifObjPrtCodeGroup
_MaintNotifObjPrtCode _MaintNotifObjPrtCode
_Assembly _Assembly

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_MaintNotificationItem_2.
-- 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_MaintNotificationItem_2 AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationItem,
  MaintNotifItemText,
  MaintNotifItemTxtLanguage,
  MaintNotifDamageCodeCatalog,
  MaintNotifDamageCodeGroup,
  MaintNotificationDamageCode,
  MaintNotifDamageCodeVersNumber,
  MaintNotifObjPrtCodeCatalog,
  MaintNotifObjPrtCodeGroup,
  MaintNotifObjPrtCode,
  MaintNotifObjectCodeVersNmbr,
  Assembly,
  IsDeleted,
  NotificationItemExternalID,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime
FROM I_MaintNotificationItemBasic
LEFT OUTER JOIN I_MaintenanceNotification_2 AS _MaintenanceNotification ON MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification  -- association [1..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifDamageCodeCatalog ON MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifDamageCodeGroup ON MaintNotifDamageCodeGroup = _MaintNotifDamageCodeGroup.InspectionCodeGroup AND MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationDamageCode ON MaintNotificationDamageCode = _MaintNotificationDamageCode.InspectionCode AND MaintNotifDamageCodeCatalog = _MaintNotificationDamageCode.InspectionCatalog AND MaintNotifDamageCodeGroup = _MaintNotificationDamageCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifObjPrtCodeCatalog ON MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifObjPrtCodeGroup ON MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeGroup.InspectionCodeGroup AND MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotifObjPrtCode ON MaintNotifObjPrtCode = _MaintNotifObjPrtCode.InspectionCode AND MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCode.InspectionCatalog AND MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
;

Learn More