What is I_MaintNotificationTaskData in SAP S/4HANA?

I_MaintNotificationTaskData is a composite CDS view in SAP S/4HANA. Maintenance Notification Task Data It contains 52 fields.

Which tables does I_MaintNotificationTaskData read from?

I_MaintNotificationTaskData reads data from: I_MaintNotifTaskTechObj.

What VDM layer is I_MaintNotificationTaskData?

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

I_MaintNotificationTaskData

DDL: I_MAINTNOTIFICATIONTASKDATA SQL: INOTIFTASKDATA Type: view COMPOSITE

52 Fields 1 Data Sources 1 Associations

Maintenance Notification Task Data

I_MaintNotificationTaskData is a Composite CDS View (Fact) that provides data about "Maintenance Notification Task Data" in SAP S/4HANA. It reads from 1 data source (I_MaintNotifTaskTechObj) and exposes 52 fields with key fields MaintenanceNotificationTask, MaintenanceNotification. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Maintenance Management
Data Category	Fact
Status	Released
Data Extraction Type	Delta-enabled, the extraction is based on field LastChangeDateTime .
Corresponding DataSource	0I_MAINTNOTIFICATIONTASKDATA

Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the details of the maintenance notification or service notification tasks? Which functional location is the maintenance notification or service notification assigned to? Which piece of equipment is the maintenance notification or service notification assigned to? What are the details of the damage related to the maintenance notification or service notification items? What are the location details of the maintenance notification or service notification? What are the account assignment details of the maintenance notification or service notification? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We recommend that you only use it for this purpose.

Prerequisites
You have authorizations to display the relevant maintenance notification activities in transactions IW67 and IW23 . This check is based on the following fields: Notification Types ( I_QMEL ) Cost Center ( I_KOSTL ) Maintenance Planner Group ( I_INGRP ) Maintenance Planning Plant ( I_IWERK ) Maintenance Plant ( I_SWERK ) Authorization Group ( I_BEGRP )

Structure
Business Objects This view is built on the following business objects: Maintenance notification task Maintenance notification item Maintenance notification Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Maintenance notification or service notification task data Functional location number Equipment number Damage data Location data, for example Maintenance Plant Account assignment data, for example Cost Center and Controlling Area Key Performance Indicators (KPIs) Name Description NumberOfMaintNotifTasks Always 1 NrOfMaintNotifSuccssflTasks 0 or 1. It is 1 when the status of the maintenance notification task is TSSC ( Successful ). NrOfMaintNotifActiveTasks 0 or 1. It is 1 when the status of the maintenance notification task is TSOS ( Outstanding ) or TSRL ( Released ).

Business Warehouse (BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help BI Content Product Lifecycle Management Asset Lifecycle Management Plant Maintenance .

Constraints
This CDS view does not contain some fields related to service notifications. These are the following: Customer Number ( KUNUM ) Division ( SPART ) Sales Organization ( VKORG ) Distribution Channel ( VTWEG )

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_MaintNotifTaskTechObj	I_MaintNotifTaskTechObj	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	E_PMNotifMaintenanceData	_NotifMaintenanceDataExtension	`_NotifMaintenanceDataExtension.MaintenanceNotification = $projection.MaintenanceNotification`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	INOTIFTASKDATA	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Maintenance Notification Task Data	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	MaintenanceNotificationTask	view
Metadata.ignorePropagatedAnnotations	true	view
Analytics.dataCategory	#FACT	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.byElement.name	LastChangeDateTime	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (52)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceNotificationTask		MaintenanceNotificationTask
KEY	MaintenanceNotification		MaintenanceNotification	Notification
	MaintenanceNotificationItem		MaintenanceNotificationItem
	MaintNotifTaskTxt		MaintNotifTaskTxt
	MaintNotifTaskCode		MaintNotifTaskCode
	MaintNotifTaskCodeGroup		MaintNotifTaskCodeGroup
	MaintNotifTaskCodeCatalog		MaintNotifTaskCodeCatalog
	IsDeleted		IsDeleted	TRUE
	LastChangeDateTime		LastChangeDateTime	Timestamp
	AssemblyHeader
	Equipment
	FunctionalLocation
	MaintenancePlanningPlant
	MaintenancePlannerGroup
	MaintenancePlant
	ControllingArea
	CostCenter
	NotificationOrigin	_MaintenanceNotification	NotificationOrigin
	NotificationType	_MaintenanceNotification	NotificationType	Notifictn Type
	NotificationCreationDate	_MaintenanceNotification	NotificationCreationDate	Notif. Date
	Assembly	_MaintenanceNotificationItem	Assembly	Pegged Reqmt
	MaintNotifDamageCodeCatalog	_MaintenanceNotificationItem	MaintNotifDamageCodeCatalog
	MaintNotificationDamageCode	_MaintenanceNotificationItem	MaintNotificationDamageCode
	MaintNotifDamageCodeGroup	_MaintenanceNotificationItem	MaintNotifDamageCodeGroup
	DefectClass	_MaintenanceNotificationItem	DefectClass	Defect Class
	MaintNotifObjPrtCode	_MaintenanceNotificationItem	MaintNotifObjPrtCode
	MaintNotifObjPrtCodeGroup	_MaintenanceNotificationItem	MaintNotifObjPrtCodeGroup
	MaintNotifObjPrtCodeCatalog	_MaintenanceNotificationItem	MaintNotifObjPrtCodeCatalog
	NumberOfMaintNotifTasks
	_MaintenanceNotification		_MaintenanceNotification
	_MaintenanceNotificationItem		_MaintenanceNotificationItem
	_MaintNotifTaskCodeCatalog		_MaintNotifTaskCodeCatalog
	_MaintNotifTaskCodeGroup		_MaintNotifTaskCodeGroup
	_MaintNotificationTaskCode		_MaintNotificationTaskCode
	_IsDeleted		_IsDeleted
	_AssemblyHeader
	_Equipment
	_MaintenancePlanningPlant
	_MaintenancePlannerGroup
	_PMNotificationType	_MaintenanceNotification	_PMNotificationType
	_FunctionalLocation
	_MaintenancePlant
	_ControllingArea
	_CostCenter
	_Assembly	_MaintenanceNotificationItem	_Assembly
	_MaintNotifDamageCodeCatalog	_MaintenanceNotificationItem	_MaintNotifDamageCodeCatalog
	_MaintNotificationDamageCode	_MaintenanceNotificationItem	_MaintNotificationDamageCode
	_MaintNotifDamageCodeGroup	_MaintenanceNotificationItem	_MaintNotifDamageCodeGroup
	_DefectClass	_MaintenanceNotificationItem	_DefectClass
	_MaintNotifObjPrtCode	_MaintenanceNotificationItem	_MaintNotifObjPrtCode
	_MaintNotifObjPrtCodeGroup	_MaintenanceNotificationItem	_MaintNotifObjPrtCodeGroup
	_MaintNotifObjPrtCodeCatalog	_MaintenanceNotificationItem	_MaintNotifObjPrtCodeCatalog

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_MaintNotificationTaskData.
-- 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: INOTIFTASKDATA

CREATE VIEW I_MaintNotificationTaskData AS
SELECT
  MaintenanceNotificationTask,
  MaintenanceNotification,
  MaintenanceNotificationItem,
  MaintNotifTaskTxt,
  MaintNotifTaskCode,
  MaintNotifTaskCodeGroup,
  MaintNotifTaskCodeCatalog,
  IsDeleted,
  LastChangeDateTime,
  _MaintenanceNotification._PMNotifMaintenanceData.Assembly AS AssemblyHeader,
  _MaintenanceNotification._PMNotifMaintenanceData.Equipment AS Equipment,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  _MaintenanceNotification._PMNotifMaintenanceData.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceNotification._PMNotifMaintenanceData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.ControllingArea AS ControllingArea,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment.CostCenter AS CostCenter,
  _MaintenanceNotification.NotificationOrigin AS NotificationOrigin,
  _MaintenanceNotification.NotificationType AS NotificationType,
  _MaintenanceNotification.NotificationCreationDate AS NotificationCreationDate,
  _MaintenanceNotificationItem.Assembly AS Assembly,
  _MaintenanceNotificationItem.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  _MaintenanceNotificationItem.MaintNotificationDamageCode AS MaintNotificationDamageCode,
  _MaintenanceNotificationItem.MaintNotifDamageCodeGroup AS MaintNotifDamageCodeGroup,
  _MaintenanceNotificationItem.DefectClass AS DefectClass,
  _MaintenanceNotificationItem.MaintNotifObjPrtCode AS MaintNotifObjPrtCode,
  _MaintenanceNotificationItem.MaintNotifObjPrtCodeGroup AS MaintNotifObjPrtCodeGroup,
  _MaintenanceNotificationItem.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  cast( 1 as qzhlmass ) AS NumberOfMaintNotifTasks,
  _MaintenanceNotification._PMNotifMaintenanceData._Assembly AS _AssemblyHeader,
  _MaintenanceNotification._PMNotifMaintenanceData._Equipment AS _Equipment,
  _MaintenanceNotification._PMNotifMaintenanceData._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  _MaintenanceNotification._PMNotifMaintenanceData._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  _MaintenanceNotification._PMNotificationType AS _PMNotificationType,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._ControllingArea AS _ControllingArea,
  _MaintenanceNotification._PMNotifMaintenanceData._LocationAccountAssignment._CostCenter AS _CostCenter,
  _MaintenanceNotificationItem._Assembly AS _Assembly,
  _MaintenanceNotificationItem._MaintNotifDamageCodeCatalog AS _MaintNotifDamageCodeCatalog,
  _MaintenanceNotificationItem._MaintNotificationDamageCode AS _MaintNotificationDamageCode,
  _MaintenanceNotificationItem._MaintNotifDamageCodeGroup AS _MaintNotifDamageCodeGroup,
  _MaintenanceNotificationItem._DefectClass AS _DefectClass,
  _MaintenanceNotificationItem._MaintNotifObjPrtCode AS _MaintNotifObjPrtCode,
  _MaintenanceNotificationItem._MaintNotifObjPrtCodeGroup AS _MaintNotifObjPrtCodeGroup,
  _MaintenanceNotificationItem._MaintNotifObjPrtCodeCatalog AS _MaintNotifObjPrtCodeCatalog
FROM I_MaintNotifTaskTechObj
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON _NotifMaintenanceDataExtension.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
;

Depth:

I_MaintNotificationTaskData view

I_MaintNotifTaskTechObj view