What is I_MaintNotificationTechObj in SAP S/4HANA?

I_MaintNotificationTechObj is a composite CDS view in SAP S/4HANA. Technical Object for Maintenance Notification It contains 95 fields.

Which tables does I_MaintNotificationTechObj read from?

I_MaintNotificationTechObj reads data from: I_MaintenanceNotification.

What VDM layer is I_MaintNotificationTechObj?

I_MaintNotificationTechObj is classified as a Composite view that combines data from multiple basic views.

I_MaintNotificationTechObj

DDL: I_MAINTNOTIFICATIONTECHOBJ SQL: IMAINTNTFTECOBJ Type: view COMPOSITE

95 Fields 1 Data Sources 14 Associations

Technical Object for Maintenance Notification

I_MaintNotificationTechObj is a Composite CDS View (Dimension) that provides data about "Technical Object for Maintenance Notification" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotification) and exposes 95 fields with key field MaintenanceNotification. It has 14 associations to related views.

SAP Help Documentation

Category	CDS Views for Maintenance Management

Purpose
This CDS view ... This CDS view provides the data to answer the following business questions: <Business question> To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: <technical name of restriction type> (<human-readable name>) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. Users who want to use this CDS view must have the following authorization objects assigned: <technical name of authorization objects> (<human-readable name>) Configuration

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_MaintenanceNotification	I_MaintenanceNotification	from

Associations (14)

Cardinality	Target	Alias	Condition
[0..1]	I_TechnicalObject	_TechnicalObject	`_TechnicalObject.TechnicalObject = $projection.TechnicalObject and _TechnicalObject.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc`
[0..1]	I_TechObjIsEquipOrFuncnlLoc	_TechObjIsEquipOrFuncnlLoc	`_TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc`
[0..*]	I_MaintNotifItemTechObj	_MaintenanceNotificationItem	`_MaintenanceNotificationItem.MaintenanceNotification = $projection.MaintenanceNotification`
[0..*]	I_MaintNotifActivityTechObj	_MaintNotificationActivity	`_MaintNotificationActivity.MaintenanceNotification = $projection.MaintenanceNotification`
[0..*]	I_MaintNotifTaskTechObj	_MaintenanceNotificationTask	`_MaintenanceNotificationTask.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	I_MaintNotifLongText	_MaintNotifLongText	`_MaintNotifLongText.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	I_MaintenanceItemTechObj	_MaintenanceItemTechObj	`_MaintenanceItemTechObj.MaintenanceItem = $projection.maintenanceitem`
[0..1]	I_PMContactCardUser	_PMContactCardUser	`_PMContactCardUser.UserID = $projection.ReportedByUser`
[0..1]	I_WorkforcePerson	_MaintNotifPersonResponsible	`_MaintNotifPersonResponsible.PersonExternalID = $projection.PersonResponsible`
[0..1]	I_FunctionalLocationLabel	_FunctionalLocationLabel	`_FunctionalLocationLabel.FunctionalLocation = $projection.functionallocation`
[1..1]	I_NotificationType	_NotificationType	`$projection.NotificationType = _NotificationType.NotificationType`
[0..1]	I_UserDescription	_UserDescription	`_UserDescription.UserID = $projection.ReportedByUser`
[0..1]	I_OrdMstrData	_MaintOrdMstrData	`_MaintOrdMstrData.OrderID = $projection.MaintenanceOrder`
[0..1]	I_MaintNotifEffectCode	_MaintNotificationEffectCode	`$projection.MaintenanceNotification = _MaintNotificationEffectCode.MaintenanceNotification and _MaintNotificationEffectCode.MaintenanceNotificationEffect = '0001'`

Annotations (13)

Name	Value	Level
EndUserText.label	Technical Object for Maintenance Notification	view
Analytics.dataCategory	#DIMENSION	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	IMAINTNTFTECOBJ	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.representativeKey	MaintenanceNotification	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.entityChangeStateId	LastChangeDateTime	view

Fields (95)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceNotification	I_MaintenanceNotification	MaintenanceNotification	Notification
	MaintPriority	I_MaintenanceNotification	MaintPriority	Priority
	MaintPriorityType	I_MaintenanceNotification	MaintPriorityType	PriorityType
	NotificationType	I_MaintenanceNotification	NotificationType	Notifictn Type
	NotifProcessingPhase	I_MaintenanceNotification	NotifProcessingPhase	Notif. Phase
	CreatedByUser	I_MaintenanceNotification	CreatedByUser	User Name
	LastChangedByUser	I_MaintenanceNotification	LastChangedByUser	User Name
	TaskListGroupCounter0endasTaskList
	LastChangeDateendasLastChangeDate
	LastChangeTimeendasLastChangeTime
	CreationDateendasCreationDate
	CreationTimeendasCreationTime
	LastChangeDateTime	I_MaintenanceNotification	LastChangeDateTime	Timestamp
	CreationDateTime	I_MaintenanceNotification	CreationDateTime	Timestamp
	ReportedByUser	I_MaintenanceNotification	ReportedByUser	Reported By
	PersonResponsible	_PMNotifMaintenanceData	NotificationPersonResponsible	Person Resp. ID
	NotificationText	I_MaintenanceNotification	NotificationText	Description
	MaintenanceOrder	I_MaintenanceNotification	MaintenanceOrder	Order
	RequiredStartDateendasRequiredStartDate
	RequiredStartTimeendasRequiredStartTime
	RequiredEndDateendasRequiredEndDate
	RequiredEndTimeendasRequiredEndTime
	MaintNotifInternalID	I_MaintenanceNotification	MaintNotifInternalID	Object number
	NotificationTimeZone	I_MaintenanceNotification	NotificationTimeZone	Notif.Time.Zone
	WorkCenterInternalID	I_MaintenanceNotification	WorkCenterInternalID	Work Center
	WorkCenterTypeCode	I_MaintenanceNotification	WorkCenterTypeCode	Object Type
	MaintenanceWorkCenterPlant	I_MaintenanceNotification	MaintenanceWorkCenterPlant	Work Ctr Plant
	MaintNotificationCatalog	I_MaintenanceNotification	MaintNotificationCatalog	Catalog Type
	MaintNotificationCode	I_MaintenanceNotification	MaintNotificationCode	Coding
	MaintNotificationCodeGroup	I_MaintenanceNotification	MaintNotificationCodeGroup	Code Group
	IsDeleted	I_MaintenanceNotification	IsDeleted	TRUE
	IsCompleted	I_MaintenanceNotification	IsCompleted
	CatalogProfile	I_MaintenanceNotification	CatalogProfile	Catalog Profile
	NotificationOrigin	I_MaintenanceNotification	NotificationOrigin	Origin ind
	InspectionLot	I_MaintenanceNotification	InspectionLot	Inspection Lot
	MaintenanceTaskListType	_PMNotifMaintenanceData	MaintenanceTaskListType	Task List Type
	TaskListGroup	_PMNotifMaintenanceData	TaskListGroup	Group
	TaskListGroupCounter	_PMNotifMaintenanceData	TaskListGroupCounter	Group Counter
	MalfunctionEffect
	LocationDescription
	MaintenanceObjectIsDown
	MaintObjectDowntimeDuration
	MaintObjDowntimeDurationUnit
	FunctionalLocation
	Equipment
	MaintenanceItem
	MaintenancePlan
	MaintenanceActivityType
	MaintNotifSourceApplication
	NotificationHasLongText		NotificationHasLongText	Long text
	LatestAcceptableCompletionDate
	PreviousFinalDueDate
	OriglLtstAccptblCompletionDate
	MaintNotifExtReferenceNumber	I_MaintenanceNotification	MaintNotifExtReferenceNumber	Reference No.
	MaintObjectLocAcctAssgmtNmbr
	MaintenanceRevision
	_CreatedByUser	I_MaintenanceNotification	_CreatedByUser
	_IsCompleted	I_MaintenanceNotification	_IsCompleted
	_IsDeleted	I_MaintenanceNotification	_IsDeleted
	_StatusObject	I_MaintenanceNotification	_StatusObject
	_LastChangedByUser	I_MaintenanceNotification	_LastChangedByUser
	_MaintenanceNotificationItem		_MaintenanceNotificationItem
	_MaintenanceOrder	I_MaintenanceNotification	_MaintenanceOrder
	_MaintenanceWorkCenterPlant	I_MaintenanceNotification	_MaintenanceWorkCenterPlant
	_MaintNotificationActivity		_MaintNotificationActivity
	_MaintenanceNotificationTask		_MaintenanceNotificationTask
	_MaintNotificationCatalog	I_MaintenanceNotification	_MaintNotificationCatalog
	_MaintNotificationCode	I_MaintenanceNotification	_MaintNotificationCode
	_MaintNotificationCodeGroup	I_MaintenanceNotification	_MaintNotificationCodeGroup
	_MainWorkCenter	I_MaintenanceNotification	_MainWorkCenter
	_PMNotificationPhase	I_MaintenanceNotification	_PMNotificationPhase
	_PMNotificationPriority	I_MaintenanceNotification	_PMNotificationPriority
	_PMNotificationPriorityType	I_MaintenanceNotification	_PMNotificationPriorityType
	_PMNotificationType	I_MaintenanceNotification	_PMNotificationType
	_PMNotifMaintenanceData	I_MaintenanceNotification	_PMNotifMaintenanceData
	_ReportedByUser	I_MaintenanceNotification	_ReportedByUser
	_MaintenancePartner	I_MaintenanceNotification	_MaintenancePartner
	_MaintNotifLongText		_MaintNotifLongText
	_TechnicalObject		_TechnicalObject
	_TechObjIsEquipOrFuncnlLoc		_TechObjIsEquipOrFuncnlLoc
	_MaintenanceItemTechObj		_MaintenanceItemTechObj
	_MalfunctionEffect
	_FunctionalLocationLabel		_FunctionalLocationLabel
	_FunctionalLocation
	_Equipment
	_PMContactCardUser		_PMContactCardUser
	_WorkCenterType	I_MaintenanceNotification	_WorkCenterType
	_StatusObjectActiveStatus	I_MaintenanceNotification	_StatusObjectActiveStatus
	_NotificationHasLongText		_NotificationHasLongText
	_LinearAssetManagementData		_LinearAssetManagementData
	_MaintNotifPersonResponsible		_MaintNotifPersonResponsible
	_LocationAccountAssignment
	_NotificationType		_NotificationType
	_MaintOrdMstrData		_MaintOrdMstrData
	_MaintNotificationEffectCode		_MaintNotificationEffectCode

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_MaintNotificationTechObj.
-- 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: IMAINTNTFTECOBJ

CREATE VIEW I_MaintNotificationTechObj AS
SELECT
  I_MaintenanceNotification.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceNotification.MaintPriority AS MaintPriority,
  I_MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  I_MaintenanceNotification.NotificationType AS NotificationType,
  I_MaintenanceNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintenanceNotification.CreatedByUser AS CreatedByUser,
  I_MaintenanceNotification.LastChangedByUser AS LastChangedByUser,
  case _PMNotifMaintenanceData.MaintenanceTaskListType when '' then '' else concat( concat( concat( concat(_PMNotifMaintenanceData.MaintenanceTaskListType,'/'), ltrim(_PMNotifMaintenanceData.TaskListGroup,'0') ),'/' ), ltrim( _PMNotifMaintenanceData.TaskListGroupCounter,'0') ) end as TaskList AS TaskListGroupCounter0endasTaskList,
  case LastChangeTime when '240000' then dats_add_days(I_MaintenanceNotification.LastChangeDate,1,'NULL') else I_MaintenanceNotification.LastChangeDate end as LastChangeDate AS LastChangeDateendasLastChangeDate,
  case LastChangeTime when '240000' then '000000' else I_MaintenanceNotification.LastChangeTime end as LastChangeTime AS LastChangeTimeendasLastChangeTime,
  case CreationTime when '240000' then dats_add_days(I_MaintenanceNotification.CreationDate,1,'NULL') else I_MaintenanceNotification.CreationDate end as CreationDate AS CreationDateendasCreationDate,
  case CreationTime when '240000' then '000000' else I_MaintenanceNotification.CreationTime end as CreationTime AS CreationTimeendasCreationTime,
  I_MaintenanceNotification.LastChangeDateTime AS LastChangeDateTime,
  I_MaintenanceNotification.CreationDateTime AS CreationDateTime,
  I_MaintenanceNotification.ReportedByUser AS ReportedByUser,
  _PMNotifMaintenanceData.NotificationPersonResponsible AS PersonResponsible,
  I_MaintenanceNotification.NotificationText AS NotificationText,
  I_MaintenanceNotification.MaintenanceOrder AS MaintenanceOrder,
  case RequiredStartTime when '240000' then dats_add_days(I_MaintenanceNotification.RequiredStartDate,1,'NULL') else I_MaintenanceNotification.RequiredStartDate end as RequiredStartDate AS RequiredStartDateendasRequiredStartDate,
  case RequiredStartTime when '240000' then '000000' else I_MaintenanceNotification.RequiredStartTime end as RequiredStartTime AS RequiredStartTimeendasRequiredStartTime,
  case RequiredEndTime when '240000' then dats_add_days(I_MaintenanceNotification.RequiredEndDate,1,'NULL') else I_MaintenanceNotification.RequiredEndDate end as RequiredEndDate AS RequiredEndDateendasRequiredEndDate,
  case RequiredEndTime when '240000' then '000000' else I_MaintenanceNotification.RequiredEndTime end as RequiredEndTime AS RequiredEndTimeendasRequiredEndTime,
  I_MaintenanceNotification.MaintNotifInternalID AS MaintNotifInternalID,
  I_MaintenanceNotification.NotificationTimeZone AS NotificationTimeZone,
  I_MaintenanceNotification.WorkCenterInternalID AS WorkCenterInternalID,
  I_MaintenanceNotification.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_MaintenanceNotification.MaintenanceWorkCenterPlant AS MaintenanceWorkCenterPlant,
  I_MaintenanceNotification.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_MaintenanceNotification.MaintNotificationCode AS MaintNotificationCode,
  I_MaintenanceNotification.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  I_MaintenanceNotification.IsDeleted AS IsDeleted,
  I_MaintenanceNotification.IsCompleted AS IsCompleted,
  I_MaintenanceNotification.CatalogProfile AS CatalogProfile,
  I_MaintenanceNotification.NotificationOrigin AS NotificationOrigin,
  I_MaintenanceNotification.InspectionLot AS InspectionLot,
  _PMNotifMaintenanceData.MaintenanceTaskListType AS MaintenanceTaskListType,
  _PMNotifMaintenanceData.TaskListGroup AS TaskListGroup,
  _PMNotifMaintenanceData.TaskListGroupCounter AS TaskListGroupCounter,
  I_MaintenanceNotification._PMNotifMaintenanceData.MalfunctionEffect AS MalfunctionEffect,
  I_MaintenanceNotification._PMNotifMaintenanceData.LocationDescription AS LocationDescription,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectDowntimeDuration AS MaintObjectDowntimeDuration,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjDowntimeDurationUnit AS MaintObjDowntimeDurationUnit,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData.Equipment AS Equipment,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceItem AS MaintenanceItem,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenancePlan AS MaintenancePlan,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceActivityType AS MaintenanceActivityType,
  cast('' as pm_source_appl) AS MaintNotifSourceApplication,
  NotificationHasLongText,
  I_MaintenanceNotification._PMNotifMaintenanceData.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  I_MaintenanceNotification._PMNotifMaintenanceData.PreviousFinalDueDate AS PreviousFinalDueDate,
  I_MaintenanceNotification._PMNotifMaintenanceData.OriglLtstAccptblCompletionDate AS OriglLtstAccptblCompletionDate,
  I_MaintenanceNotification.MaintNotifExtReferenceNumber AS MaintNotifExtReferenceNumber,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_MaintenanceNotification._PMNotifMaintenanceData.MaintenanceRevision AS MaintenanceRevision,
  I_MaintenanceNotification._CreatedByUser AS _CreatedByUser,
  I_MaintenanceNotification._IsCompleted AS _IsCompleted,
  I_MaintenanceNotification._IsDeleted AS _IsDeleted,
  I_MaintenanceNotification._StatusObject AS _StatusObject,
  I_MaintenanceNotification._LastChangedByUser AS _LastChangedByUser,
  I_MaintenanceNotification._MaintenanceOrder AS _MaintenanceOrder,
  I_MaintenanceNotification._MaintenanceWorkCenterPlant AS _MaintenanceWorkCenterPlant,
  I_MaintenanceNotification._MaintNotificationCatalog AS _MaintNotificationCatalog,
  I_MaintenanceNotification._MaintNotificationCode AS _MaintNotificationCode,
  I_MaintenanceNotification._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  I_MaintenanceNotification._MainWorkCenter AS _MainWorkCenter,
  I_MaintenanceNotification._PMNotificationPhase AS _PMNotificationPhase,
  I_MaintenanceNotification._PMNotificationPriority AS _PMNotificationPriority,
  I_MaintenanceNotification._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_MaintenanceNotification._PMNotificationType AS _PMNotificationType,
  I_MaintenanceNotification._PMNotifMaintenanceData AS _PMNotifMaintenanceData,
  I_MaintenanceNotification._ReportedByUser AS _ReportedByUser,
  I_MaintenanceNotification._MaintenancePartner AS _MaintenancePartner,
  I_MaintenanceNotification._PMNotifMaintenanceData._MalfunctionEffect AS _MalfunctionEffect,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation,
  I_MaintenanceNotification._PMNotifMaintenanceData._Equipment AS _Equipment,
  I_MaintenanceNotification._WorkCenterType AS _WorkCenterType,
  I_MaintenanceNotification._StatusObjectActiveStatus AS _StatusObjectActiveStatus,
  I_MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment AS _LocationAccountAssignment
FROM I_MaintenanceNotification
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON _TechnicalObject.TechnicalObject = TechnicalObject AND _TechnicalObject.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifItemTechObj AS _MaintenanceNotificationItem ON _MaintenanceNotificationItem.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifActivityTechObj AS _MaintNotificationActivity ON _MaintNotificationActivity.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifTaskTechObj AS _MaintenanceNotificationTask ON _MaintenanceNotificationTask.MaintenanceNotification = MaintenanceNotification  -- association [0..*]
LEFT OUTER JOIN I_MaintNotifLongText AS _MaintNotifLongText ON _MaintNotifLongText.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItemTechObj AS _MaintenanceItemTechObj ON _MaintenanceItemTechObj.MaintenanceItem = maintenanceitem  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactCardUser ON _PMContactCardUser.UserID = ReportedByUser  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _MaintNotifPersonResponsible ON _MaintNotifPersonResponsible.PersonExternalID = PersonResponsible  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = functionallocation  -- association [0..1]
LEFT OUTER JOIN I_NotificationType AS _NotificationType ON NotificationType = _NotificationType.NotificationType  -- association [1..1]
LEFT OUTER JOIN I_UserDescription AS _UserDescription ON _UserDescription.UserID = ReportedByUser  -- association [0..1]
LEFT OUTER JOIN I_OrdMstrData AS _MaintOrdMstrData ON _MaintOrdMstrData.OrderID = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifEffectCode AS _MaintNotificationEffectCode ON MaintenanceNotification = _MaintNotificationEffectCode.MaintenanceNotification AND _MaintNotificationEffectCode.MaintenanceNotificationEffect = '0001'  -- association [0..1]
;

Depth:

I_MaintNotificationTechObj view

I_MaintenanceNotification view