C_ObjPgMaintNotificationItem

DDL: C_OBJPGMAINTNOTIFICATIONITEM SQL: COBJPGMNTNTFITM Type: view CONSUMPTION
17 Fields 1 Data Sources 3 Associations

Maintenance Notification Item

C_ObjPgMaintNotificationItem is a Consumption CDS View that provides data about "Maintenance Notification Item" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationItemTP) and exposes 17 fields with key fields MaintenanceNotification, MaintenanceNotificationItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintNotificationItemTP I_MaintNotificationItemTP from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_ObjPgMaintNotifActivity _ObjPgMaintNotifActivity $projection.MaintenanceNotificationItem = _ObjPgMaintNotifActivity.MaintenanceNotificationItem and $projection.MaintenanceNotification = _ObjPgMaintNotifActivity.MaintenanceNotification
[0..*] C_ObjPgMaintNotificationTask _ObjPgMaintNotificationTask $projection.MaintenanceNotificationItem = _ObjPgMaintNotificationTask.MaintenanceNotificationItem and $projection.MaintenanceNotification = _ObjPgMaintNotificationTask.MaintenanceNotification
[0..*] C_ObjPgMaintNotificationCause _ObjPgMaintNotificationCause $projection.MaintenanceNotificationItem = _ObjPgMaintNotificationCause.MaintenanceNotificationItem and $projection.MaintenanceNotification = _ObjPgMaintNotificationCause.MaintenanceNotification

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName COBJPGMNTNTFITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Maintenance Notification Item view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Malfunction Item view
UI.headerInfo.typeNamePlural Malfunction Items view
UI.headerInfo.description.value MaintNotifItemText view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.title.value MaintenanceNotificationItem view
UI.headerInfo.title.type #STANDARD view
UI.presentationVariant.sortOrder.by MaintenanceNotificationItem view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_MaintNotificationItemTP MaintenanceNotification Notification
KEY MaintenanceNotificationItem I_MaintNotificationItemTP MaintenanceNotificationItem
MaintNotifItemText I_MaintNotificationItemTP MaintNotifItemText
MaintNotifObjPrtCodeGroup I_MaintNotificationItemTP MaintNotifObjPrtCodeGroup Object Group
MaintNotifObjPrtCodeGroupName Object Group Name
MaintNotifObjPrtCode I_MaintNotificationItemTP MaintNotifObjPrtCode Object Part
MaintNotifObjPrtCodeName
MaintNotifDamageCodeGroup I_MaintNotificationItemTP MaintNotifDamageCodeGroup Damage Group
MaintNotifDamageCodeGroupName Damage Group Name
MaintNotificationDamageCode I_MaintNotificationItemTP MaintNotificationDamageCode
MaintNotifDamageCodeName
NotificationType
MaintNotifItemLongText Long Text
_ObjPgMaintNotifActivity _ObjPgMaintNotifActivity
_ObjPgMaintNotificationCause _ObjPgMaintNotificationCause
_ObjPgMaintNotificationTask _ObjPgMaintNotificationTask
_MaintenanceNotification I_MaintNotificationItemTP _MaintenanceNotification

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_ObjPgMaintNotificationItem.
-- 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: COBJPGMNTNTFITM

CREATE VIEW C_ObjPgMaintNotificationItem AS
SELECT
  I_MaintNotificationItemTP.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationItemTP.MaintenanceNotificationItem AS MaintenanceNotificationItem,
  I_MaintNotificationItemTP.MaintNotifItemText AS MaintNotifItemText,
  I_MaintNotificationItemTP.MaintNotifObjPrtCodeGroup AS MaintNotifObjPrtCodeGroup,
  replace(I_MaintNotificationItemTP._MaintNotifObjPrtCodeGroup._Text[1:Language=$session.system_language].InspSpecAddlCodeGroupText, '&', ' ') AS MaintNotifObjPrtCodeGroupName,
  I_MaintNotificationItemTP.MaintNotifObjPrtCode AS MaintNotifObjPrtCode,
  I_MaintNotificationItemTP._MaintNotifObjPrtCode._Text[1:Language=$session.system_language].InspectionCodeText AS MaintNotifObjPrtCodeName,
  I_MaintNotificationItemTP.MaintNotifDamageCodeGroup AS MaintNotifDamageCodeGroup,
  replace(I_MaintNotificationItemTP._MaintNotifDamageCodeGroup._Text[1:Language=$session.system_language].InspSpecAddlCodeGroupText, '&', ' ') AS MaintNotifDamageCodeGroupName,
  I_MaintNotificationItemTP.MaintNotificationDamageCode AS MaintNotificationDamageCode,
  I_MaintNotificationItemTP._MaintNotificationDamageCode._Text[1:Language=$session.system_language].InspectionCodeText AS MaintNotifDamageCodeName,
  I_MaintNotificationItemTP._MaintenanceNotification.NotificationType AS NotificationType,
  cast('' as eams_ltext ) AS MaintNotifItemLongText,
  I_MaintNotificationItemTP._MaintenanceNotification AS _MaintenanceNotification
FROM I_MaintNotificationItemTP
LEFT OUTER JOIN C_ObjPgMaintNotifActivity AS _ObjPgMaintNotifActivity ON MaintenanceNotificationItem = _ObjPgMaintNotifActivity.MaintenanceNotificationItem AND MaintenanceNotification = _ObjPgMaintNotifActivity.MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintNotificationTask AS _ObjPgMaintNotificationTask ON MaintenanceNotificationItem = _ObjPgMaintNotificationTask.MaintenanceNotificationItem AND MaintenanceNotification = _ObjPgMaintNotificationTask.MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintNotificationCause AS _ObjPgMaintNotificationCause ON MaintenanceNotificationItem = _ObjPgMaintNotificationCause.MaintenanceNotificationItem AND MaintenanceNotification = _ObjPgMaintNotificationCause.MaintenanceNotification  -- association [0..*]
;

Learn More