What is A_MaintenanceNotification in SAP S/4HANA?

A_MaintenanceNotification is a composite CDS view in SAP S/4HANA. Maintenance Notification It contains 119 fields.

Which tables does A_MaintenanceNotification read from?

A_MaintenanceNotification reads data from: R_MaintenanceNotificationTP.

What VDM layer is A_MaintenanceNotification?

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

A_MaintenanceNotification

DDL: A_MAINTENANCENOTIFICATION Type: view_entity COMPOSITE

119 Fields 1 Data Sources

Maintenance Notification

A_MaintenanceNotification is a Composite CDS View that provides data about "Maintenance Notification" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceNotificationTP) and exposes 119 fields with key field MaintenanceNotification.

Data Sources (1)

Source	Alias	Join Type
R_MaintenanceNotificationTP	R_MaintenanceNotificationTP	projection

Annotations (9)

Name	Value	Level
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.representativeKey	MaintenanceNotification	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
EndUserText.label	Maintenance Notification	view
AccessControl.authorizationCheck	#CHECK	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (119)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceNotification		MaintenanceNotification	Notification
	MaintNotifInternalID		MaintNotifInternalID	Object number
	NotificationText		NotificationText	Description
	MaintPriority		MaintPriority	Priority
	NotificationType		NotificationType	Notifictn Type
	NotifProcessingPhase		NotifProcessingPhase	Notif. Phase
	NotifProcessingPhaseDesc
	MaintPriorityDesc
	CreationDate		CreationDate	Time Stamp
	LastChangeTime		LastChangeTime	Time changed
	LastChangeDate		LastChangeDate	Time Stamp
	LastChangeDateTime		LastChangeDateTime	Timestamp
	CreationTime		CreationTime	Time of Change
	ReportedByUser		ReportedByUser	Reported By
	ReporterFullName		ReporterFullName	Full Name
	PersonResponsible		PersonResponsible	Person Responsible
	MalfunctionEffect		MalfunctionEffect	Effect
	MalfunctionEffectText
	MalfunctionStartDate		MalfunctionStartDate	Malfunct. Start
	MalfunctionStartTime		MalfunctionStartTime	Mal. Start (T.)
	MalfunctionEndDate		MalfunctionEndDate	Malfunct. End
	MalfunctionEndTime		MalfunctionEndTime	Malfunction End
	MaintNotificationCatalog		MaintNotificationCatalog	Catalog Type
	MaintNotificationCode		MaintNotificationCode	Coding
	MaintNotificationCodeGroup		MaintNotificationCodeGroup	Code Group
	CatalogProfile		CatalogProfile	Catalog Profile
	NotificationCreationDate		NotificationCreationDate	Notif. Date
	NotificationCreationTime		NotificationCreationTime	Notif. Time
	NotificationTimeZone		NotificationTimeZone	Notif.Time.Zone
	RequiredStartDate		RequiredStartDate	Req. Start Date
	RequiredStartTime		RequiredStartTime	Req. start time
	RequiredEndDate		RequiredEndDate	Req. End Date
	RequiredEndTime		RequiredEndTime	Req. end time
	LatestAcceptableCompletionDate		LatestAcceptableCompletionDate	Final Due Date
	MaintenanceObjectIsDown		MaintenanceObjectIsDown	Breakdown
	MaintNotificationLongText
	TextObjectCategory		TextObjectCategory	Text object
	TextObjectType		TextObjectType	Text ID
	MaintNotifLongTextForEdit		MaintNotifLongTextForEdit	Long Text
	MaintRequestEditableLongText		MaintRequestEditableLongText	Long Text
	TechnicalObject		TechnicalObject	Technical Object
	TechObjIsEquipOrFuncnlLoc		TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	TechnicalObjectLabel		TechnicalObjectLabel	Tech. Object
	MaintenancePlanningPlant		MaintenancePlanningPlant	Planning Plant
	MaintenancePlannerGroup		MaintenancePlannerGroup	Planner Group
	PlantSection		PlantSection	Plant Section
	ABCIndicator		ABCIndicator	ABC Indicator
	SuperiorTechnicalObject
	SuperiorTechnicalObjectName
	SuperiorObjIsEquipOrFuncnlLoc
	SuperiorTechnicalObjectLabel		SuperiorTechnicalObjectLabel	Technical Object
	ManufacturerPartTypeName		ManufacturerPartTypeName	Model number
	TechObjIsEquipOrFuncnlLocDesc
	FunctionalLocation		FunctionalLocation	Object ID
	FunctionalLocationLabelName		FunctionalLocationLabelName	Functional Loc.
	TechnicalObjectDescription
	AssetLocation		AssetLocation	Location
	LocationName		LocationName	Location Name
	BusinessArea
	CompanyCode
	TechnicalObjectCategory		TechnicalObjectCategory	Tech. Obj. Category
	TechnicalObjectType		TechnicalObjectType	Text object
	MainWorkCenterPlant		MainWorkCenterPlant	Plnt WorkCenter
	MainWorkCenter		MainWorkCenter	Work Center
	PlantName	_MaintPlant	PlantName	Plant Name
	MaintenancePlannerGroupName	_MaintPlantGroup	MaintenancePlannerGroupName	Planner Group Name
	MaintenancePlant		MaintenancePlant	Plant
	LocationDescription		LocationDescription	Current Location
	MainWorkCenterText
	MainWorkCenterPlantName
	MaintenancePlantName
	PlantSectionPersonRespName
	ABCIndicatorDesc
	PersonResponsibleName		PersonResponsibleName	Person Resp.
	MaintNotifRespPartnerFunction		MaintNotifRespPartnerFunction	Partner Funct.
	MaintenanceOrder		MaintenanceOrder	Order
	MaintenanceOrderType		MaintenanceOrderType	Order Type
	MaintNotifProcessingContext		MaintNotifProcessingContext	Notif Procg Context
	MaintenanceActivityType		MaintenanceActivityType	MaintActivType
	MaintObjDowntimeDurationUnit		MaintObjDowntimeDurationUnit	Unit
	MaintObjectDowntimeDuration		MaintObjectDowntimeDuration	Breakdown Dur.
	MaintenancePlan
	MaintenanceItem
	TaskListGroup		TaskListGroup	Group
	TaskListGroupCounter		TaskListGroupCounter	Group Counter
	MaintenancePlanCallNumber
	MaintenanceTaskListType		MaintenanceTaskListType	Task List Type
	TaskList		TaskList
	NotificationReferenceDate		NotificationReferenceDate	Reference Date
	NotificationReferenceTime		NotificationReferenceTime	ReferenceTime
	NotificationCompletionDate		NotificationCompletionDate	Completion Date
	CompletionTime		CompletionTime	Completion Time
	AssetRoom		AssetRoom	Room
	MaintNotifExtReferenceNumber		MaintNotifExtReferenceNumber	Reference No.
	MaintNotifRejectionReasonCode		MaintNotifRejectionReasonCode	Reason Code
	MaintNotifRejectionRsnCodeTxt
	MaintNotifDetectionCatalog		MaintNotifDetectionCatalog	Detection Meth Prfl
	MaintNotifDetectionCode		MaintNotifDetectionCode	Detection Meth
	MaintNotifDetectionCodeText
	MaintNotifDetectionCodeGroup		MaintNotifDetectionCodeGroup	Detection Meth Grp
	MaintNotifDetectionCodeGrpTxt
	MaintNotifProcessPhaseCode		MaintNotifProcessPhaseCode	Process Phase
	MaintNotifProcessSubPhaseCode		MaintNotifProcessSubPhaseCode	Process Subphase
	EAMProcessPhaseCodeDesc
	EAMProcessSubPhaseCodeDesc
	CreationDateTime	_MaintenanceNotificationTP	CreationDateTime	Timestamp
	MalfunctionStartDateTime	_MaintenanceNotificationTP	MalfunctionStartDateTime	Time Stamp
	MalfunctionEndDateTime	_MaintenanceNotificationTP	MalfunctionEndDateTime	Time Stamp
	NotificationCreationDateTime	_MaintenanceNotificationTP	NotificationCreationDateTime	Time Stamp
	MaintNotifRqdStartDateTime	_MaintenanceNotificationTP	MaintNotifRqdStartDateTime	Time Stamp
	MaintNotifRqdEndDateTime	_MaintenanceNotificationTP	MaintNotifRqdEndDateTime	Time Stamp
	PreviousFinalDueDate	_MaintenanceNotificationTP	PreviousFinalDueDate	Prev. Final Due Date
	OriglLtstAccptblCompletionDate	_MaintenanceNotificationTP	OriglLtstAccptblCompletionDate
	MaintenanceRevision		MaintenanceRevision	Revision
	CreatedByUser		CreatedByUser	User Name
	_MalfunctionEffect		_MalfunctionEffect
	_PMNotifMaintenanceData		_PMNotifMaintenanceData
	_MaintNotifPersonResponsible		_MaintNotifPersonResponsible
	_ActiveSystemStatus		_ActiveSystemStatus

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 A_MaintenanceNotification.
-- 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 A_MaintenanceNotification AS
SELECT
  MaintenanceNotification,
  MaintNotifInternalID,
  NotificationText,
  MaintPriority,
  NotificationType,
  NotifProcessingPhase,
  _MaintenanceNotificationTP._PMNotificationPhase._Text[1:Language=$session.system_language].NotifProcessingPhaseDesc AS NotifProcessingPhaseDesc,
  _MaintenanceNotificationTP._PMNotificationPriority._Text[1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  CreationDate,
  LastChangeTime,
  LastChangeDate,
  LastChangeDateTime,
  CreationTime,
  ReportedByUser,
  ReporterFullName,
  PersonResponsible,
  MalfunctionEffect,
  _MaintenanceNotificationTP._MalfunctionEffect._Text[1: Language = $session.system_language ].MalfunctionEffectText AS MalfunctionEffectText,
  MalfunctionStartDate,
  MalfunctionStartTime,
  MalfunctionEndDate,
  MalfunctionEndTime,
  MaintNotificationCatalog,
  MaintNotificationCode,
  MaintNotificationCodeGroup,
  CatalogProfile,
  NotificationCreationDate,
  NotificationCreationTime,
  NotificationTimeZone,
  RequiredStartDate,
  RequiredStartTime,
  RequiredEndDate,
  RequiredEndTime,
  LatestAcceptableCompletionDate,
  MaintenanceObjectIsDown,
  _MaintenanceNotificationTP._TextObjectPlainLongText.PlainLongText AS MaintNotificationLongText,
  TextObjectCategory,
  TextObjectType,
  MaintNotifLongTextForEdit,
  MaintRequestEditableLongText,
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObjectLabel,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  PlantSection,
  ABCIndicator,
  _MaintenanceNotificationTP._TechnicalObject.SuperiorTechnicalObject AS SuperiorTechnicalObject,
  _MaintenanceNotificationTP._TechnicalObject.SuperiorTechnicalObjectName AS SuperiorTechnicalObjectName,
  _MaintenanceNotificationTP._TechnicalObject.SuperiorObjIsEquipOrFuncnlLoc AS SuperiorObjIsEquipOrFuncnlLoc,
  SuperiorTechnicalObjectLabel,
  ManufacturerPartTypeName,
  _MaintenanceNotificationTP._TechObjIsEquipOrFuncnlLoc._Text[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  FunctionalLocation,
  FunctionalLocationLabelName,
  _MaintenanceNotificationTP._TechnicalObject._TechnicalObjectText[1: Language = $session.system_language ].TechnicalObjectDescription AS TechnicalObjectDescription,
  AssetLocation,
  LocationName,
  _MaintenanceNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.BusinessArea AS BusinessArea,
  _MaintenanceNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment.CompanyCode AS CompanyCode,
  TechnicalObjectCategory,
  TechnicalObjectType,
  MainWorkCenterPlant,
  MainWorkCenter,
  _MaintPlant.PlantName AS PlantName,
  _MaintPlantGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  MaintenancePlant,
  LocationDescription,
  _MaintenanceNotificationTP._MainWorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS MainWorkCenterText,
  _MaintenanceNotificationTP._MainWorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
  _MaintenanceNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
  _MaintenanceNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection.PlantSectionPersonRespName AS PlantSectionPersonRespName,
  _MaintenanceNotificationTP._PMNotifMaintenanceData._LocationAccountAssignment._ABCIndicator._Text[1:Language = $session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  PersonResponsibleName,
  MaintNotifRespPartnerFunction,
  MaintenanceOrder,
  MaintenanceOrderType,
  MaintNotifProcessingContext,
  MaintenanceActivityType,
  MaintObjDowntimeDurationUnit,
  MaintObjectDowntimeDuration,
  _MaintenanceNotificationTP._PMNotifMaintenanceData.MaintenancePlan AS MaintenancePlan,
  _MaintenanceNotificationTP._PMNotifMaintenanceData.MaintenanceItem AS MaintenanceItem,
  TaskListGroup,
  TaskListGroupCounter,
  _MaintenanceNotificationTP._PMNotifMaintenanceData.MaintenancePlanCallNumber AS MaintenancePlanCallNumber,
  MaintenanceTaskListType,
  TaskList,
  NotificationReferenceDate,
  NotificationReferenceTime,
  NotificationCompletionDate,
  CompletionTime,
  AssetRoom,
  MaintNotifExtReferenceNumber,
  MaintNotifRejectionReasonCode,
  _MaintenanceNotificationTP._MaintNotifRejectionReasonTxt[1: Language = $session.system_language ].MaintNotifRejectionRsnCodeTxt AS MaintNotifRejectionRsnCodeTxt,
  MaintNotifDetectionCatalog,
  MaintNotifDetectionCode,
  _MaintNotifDetectCodeTxt[1: Language = $session.system_language].MaintNotifDetectionCodeText AS MaintNotifDetectionCodeText,
  MaintNotifDetectionCodeGroup,
  _MaintNotifDetectCodeGroupTxt[1: Language = $session.system_language].MaintNotifDetectionCodeGrpTxt AS MaintNotifDetectionCodeGrpTxt,
  MaintNotifProcessPhaseCode,
  MaintNotifProcessSubPhaseCode,
  _Phase._EAMProcessPhaseText[1: Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  _SubPhase._EAMProcessSubPhaseText[1: Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  _MaintenanceNotificationTP.CreationDateTime AS CreationDateTime,
  _MaintenanceNotificationTP.MalfunctionStartDateTime AS MalfunctionStartDateTime,
  _MaintenanceNotificationTP.MalfunctionEndDateTime AS MalfunctionEndDateTime,
  _MaintenanceNotificationTP.NotificationCreationDateTime AS NotificationCreationDateTime,
  _MaintenanceNotificationTP.MaintNotifRqdStartDateTime AS MaintNotifRqdStartDateTime,
  _MaintenanceNotificationTP.MaintNotifRqdEndDateTime AS MaintNotifRqdEndDateTime,
  _MaintenanceNotificationTP.PreviousFinalDueDate AS PreviousFinalDueDate,
  _MaintenanceNotificationTP.OriglLtstAccptblCompletionDate AS OriglLtstAccptblCompletionDate,
  MaintenanceRevision,
  CreatedByUser
FROM R_MaintenanceNotificationTP
;

Depth:

A_MaintenanceNotification view_entity

R_MaintenanceNotificationTP view_entity