What is C_MaintWorkRequestOverviewTP in SAP S/4HANA?

C_MaintWorkRequestOverviewTP is a consumption CDS view in SAP S/4HANA. Maintenance Notification It contains 166 fields.

Which tables does C_MaintWorkRequestOverviewTP read from?

C_MaintWorkRequestOverviewTP reads data from: R_MaintenanceNotificationTP.

What VDM layer is C_MaintWorkRequestOverviewTP?

C_MaintWorkRequestOverviewTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MaintWorkRequestOverviewTP

DDL: C_MAINTWORKREQUESTOVERVIEWTP Type: view_entity CONSUMPTION

166 Fields 1 Data Sources 1 Associations

Maintenance Notification

C_MaintWorkRequestOverviewTP is a Consumption CDS View that provides data about "Maintenance Notification" in SAP S/4HANA. It reads from 1 data source (R_MaintenanceNotificationTP) and exposes 166 fields with key field MaintenanceNotification. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
R_MaintenanceNotificationTP	R_MaintenanceNotificationTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	C_MaintOrderQuickVw	_MaintenanceOrderQuickView	`_MaintenanceOrderQuickView.MaintenanceOrder = $projection.MaintenanceOrder`

Annotations (16)

Name	Value	Level
Metadata.ignorePropagatedAnnotations	true	view
UI.headerInfo.title.type	#STANDARD	view
UI.headerInfo.title.value	MaintenanceNotification	view
UI.headerInfo.description.type	#STANDARD	view
UI.headerInfo.description.value	NotificationText	view
UI.headerInfo.typeNamePlural	Work Requests	view
UI.headerInfo.typeName	Work Request	view
Metadata.allowExtensions	true	view
EndUserText.label	Maintenance Notification	view
Search.searchable	true	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.representativeKey	MaintenanceNotification	view

Fields (166)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceNotification		MaintenanceNotification	Notification
	MaintNotifInternalID		MaintNotifInternalID	Notification InternalID
	NotificationText		NotificationText	Description
	MaintPriority		MaintPriority	Priority
	MaintPriorityType		MaintPriorityType	Priority Type
	GenericPriorityColorCode		GenericPriorityColorCode
	NotificationType		NotificationType	Notification Type
	NotificationTypeName			Notification Type Text
	NotifProcessingPhase		NotifProcessingPhase	Notification Status
	NotifProcessingPhaseDesc			Notification Status Text
	MaintPriorityDesc			Priority Description
	MaintNotifRejectionRsnCodeTxt
	CreatedByUser		CreatedByUser	Created By
	LastChangedByUser		LastChangedByUser	Last Chnaged By User
	CreationDate		CreationDate	Time Stamp
	LastChangeTime		LastChangeTime	Last Change Time
	LastChangeDate		LastChangeDate	Last Change Date
	LastChangeDateTime		LastChangeDateTime	Changed On/At
	CreationTime		CreationTime	Creation Time
	CreationDateTime		CreationDateTime	Created On/At
	ReportedByUser		ReportedByUser	Reported By
	ReporterFullName		ReporterFullName	Reported Full Name
	PersonResponsible		PersonResponsible	Person Responsible
	MalfunctionEffect		MalfunctionEffect	Operational Effect
	MalfunctionStartDate		MalfunctionStartDate	Malfunction Start
	MalfunctionStartTime		MalfunctionStartTime	Malfunction Start Time
	MalfunctionStartDateTime		MalfunctionStartDateTime	Malfunction Start
	MalfunctionEndDate		MalfunctionEndDate	Malfunction End Date
	MalfunctionEndTime		MalfunctionEndTime	Malfunction End Time
	MalfunctionEndDateTime		MalfunctionEndDateTime	Malfunction End
	MaintNotificationCatalog		MaintNotificationCatalog	Catalog
	MaintNotificationCode		MaintNotificationCode	Failure Mode
	InspectionCodeText			Description
	MaintNotificationCodeGroup		MaintNotificationCodeGroup	Failure Mode Group
	InspSpecAddlCodeGroupText			Description
	CatalogProfile		CatalogProfile	Catalog Profile
	CatalogProfileTextlocalized			Catalog Profile Text
	NotificationCreationDate		NotificationCreationDate	Reported On Date
	NotificationCreationTime		NotificationCreationTime	Reported Time
	NotificationCreationDateTime		NotificationCreationDateTime	Reported On/At
	NotificationTimeZone		NotificationTimeZone	Reported Time Zone
	RequiredStartDate		RequiredStartDate	Required Start Date
	RequiredStartTime		RequiredStartTime	Required Start Time
	MaintNotifRqdStartDateTime		MaintNotifRqdStartDateTime	Required Start
	RequiredEndDate		RequiredEndDate	Required End Date
	RequiredEndTime		RequiredEndTime	Required End Time
	MaintNotifRqdEndDateTime		MaintNotifRqdEndDateTime	Required Finish
	LatestAcceptableCompletionDate		LatestAcceptableCompletionDate	Final Due Date
	MaintenanceObjectIsDown		MaintenanceObjectIsDown	Breakdown
	MaintObjectDowntimeDuration		MaintObjectDowntimeDuration	Breakdown Duration
	MaintNotifDowntimeDuration		MaintNotifDowntimeDuration	Breakdown Duration
	MaintObjDowntimeDurationUnit		MaintObjDowntimeDurationUnit	Breakdown Duration Unit
	TextObjectCategory		TextObjectCategory	Text object
	TextObjectType		TextObjectType	Text ID
	MaintNotifLongTextForEdit		MaintNotifLongTextForEdit	Add Long Text
	TechnicalObject		TechnicalObject	Technical Object
	MaintObjectFreeDefinedAttrib		MaintObjectFreeDefinedAttrib	Sort Field
	TechObjIsEquipOrFuncnlLoc		TechObjIsEquipOrFuncnlLoc	Technical Object Type
	TechnicalObjectLabel		TechnicalObjectLabel	Tech. Object
	MaintenancePlanningPlant		MaintenancePlanningPlant	Planning Plant
	MaintenancePlannerGroup		MaintenancePlannerGroup	Planner Group
	AssetManufacturerName		AssetManufacturerName	Manufacturer
	PlantSection		PlantSection	Plant Section
	ABCIndicator		ABCIndicator	ABC Indicator
	AssetRoom		AssetRoom	Room
	ManufacturerPartTypeName		ManufacturerPartTypeName	Model Number
	TechObjIsEquipOrFuncnlLocDesc
	FunctionalLocation		FunctionalLocation	Object ID
	FunctionalLocationName
	SuperiorFunctionalLocationName
	FunctionalLocationLabelName		FunctionalLocationLabelName	Functional Loc.
	AssetLocation		AssetLocation	Location
	LocationName		LocationName	Location Name
	BusinessArea			Business Area
	CompanyCode			Company Code
	TechnicalObjectCategory		TechnicalObjectCategory	Category
	TechnicalObjectCategoryDesclocalized			Malfunction Effect Description
	TechnicalObjectType		TechnicalObjectType	Object Type
	WorkCenterInternalID		WorkCenterInternalID	Main Work Center Number
	MainWorkCenterPlant		MainWorkCenterPlant	Main Work Center Plant
	MainWorkCenter		MainWorkCenter	Main Work Center
	MaintenanceWorkCenterPlant		MaintenanceWorkCenterPlant	Maintenance Work Center
	MaintenanceWorkCenterPlantName			Maintenance Work Center Plant Name
	MaintenancePlant		MaintenancePlant	Maintenance Plant
	MaintenanceWorkCenter		MaintenanceWorkCenter	Maintenance Work Center
	WorkCenterTypeCode		WorkCenterTypeCode	Work Center Type
	LocationDescription		LocationDescription	Current Location
	MaintWorkRequestAttchKey		MaintWorkRequestAttchKey	Object Key
	MaintNotifSourceApplication		MaintNotifSourceApplication	Source Application
	MaintNotifWithLeadingZeros		MaintNotifWithLeadingZeros	Character Field of Length 12
	MainWorkCenterText
	MainWorkCenterPlantName
	MaintenancePlantName
	PlantSectionPersonRespName
	PlantSectionPersonRespPhone
	ABCIndicatorDesc
	PersonResponsibleName		PersonResponsibleName	Person Resp.
	MaintNotifRespPartnerFunction		MaintNotifRespPartnerFunction	Partner Funct.
	ActiveTechnicalObject		ActiveTechnicalObject	Tech. Object
	ActiveTechnicalObjectType		ActiveTechnicalObjectType	Tech. Obj. Type
	MaintenanceOrder		MaintenanceOrder	Order
	MaintenanceOrderType		MaintenanceOrderType	Order Type
	MaintenanceOrderTypeName
	MaintEvtIsCreatedByCurrentUser		MaintEvtIsCreatedByCurrentUser	Truth Value
	MaintNotifProcessPhaseCode		MaintNotifProcessPhaseCode	Notification Phase
	MaintNotifProcessSubPhaseCode		MaintNotifProcessSubPhaseCode	Notification Subphase
	EAMProcessSubPhaseCodeDesc
	EAMProcessPhaseCodeDesc
	MaintNotifRejectionReasonCode		MaintNotifRejectionReasonCode	Reason
	NotificationCompletionDate		NotificationCompletionDate	Completion Date
	NotificationReferenceDate		NotificationReferenceDate	Reference Date
	NotificationReferenceTime		NotificationReferenceTime	ReferenceTime
	MaintNotifReferenceDateTime		MaintNotifReferenceDateTime	Reference Date/Time
	MaintNotifCompletionDateTime		MaintNotifCompletionDateTime	Completion Date/Time
	MalfunctionEffectText			Malfunction Effect Description
	_TechObjHier		_TechObjHier
	_MalfunctionEffect		_MalfunctionEffect
	_PMNotifMaintenanceData		_PMNotifMaintenanceData
	_MaintNotifPersonResponsible		_MaintNotifPersonResponsible
	_ActiveSystemStatus		_ActiveSystemStatus
	_TechnicalObjQuickVw		_TechnicalObjQuickVw
	TechObjInstallationLocation		TechObjInstallationLocation	Identifying Level
	IdentifyingLabel		IdentifyingLabel	Identifying Label
	MaintenanceTaskListType		MaintenanceTaskListType	Task List Type
	TaskListGroup		TaskListGroup	Task List Group
	TaskListGroupCounter		TaskListGroupCounter	Task List Counter
	TaskList		TaskList	Task List
	virtualUICT_TaskListboole_d
	TaskListKeyDate		TaskListKeyDate
	virtualTaskListDescplantext			Task List Description
	MaintenancePlan
	MaintenancePlanDesc			Maintenance Plan Description
	MaintenancePlanCallNumber			Maintenance Plan Call Number
	MaintenanceItem
	MaintenanceItemDescription			Maintenance Item Text
	MaintNotifDetectionCatalog		MaintNotifDetectionCatalog	Detection Catalog
	MaintNotifDetectionCode		MaintNotifDetectionCode	Detection Method
	MaintNotifDetectionCodeText
	MaintNotifDetectionCodeGroup		MaintNotifDetectionCodeGroup	Detection Group
	MaintNotifDetectionCodeGrpTxt
	WorkRequestTextTemplate		WorkRequestTextTemplate	Template
	MaintNotifProcessingContext		MaintNotifProcessingContext	Notification Processing Context
	MaintNotifProcgCntxtIsAllwd		MaintNotifProcgCntxtIsAllwd	Truth Value
	HierarchyNodeLevel		HierarchyNodeLevel	Hierarchy Node Level
	MaintNotifCodgCatalogTypeCode
	Equipment			Equipment
	MaintNotifEffectCodeGrpText
	MaintNotifEffectCtlgCodeText
	_TechnicalObject		_TechnicalObject
	_MaintenanceOrderQuickView		_MaintenanceOrderQuickView
	FullName	_CreatedByUserSimpl	UserDescription	Full Name
	MaintNotifEffectCodeGroup	_FailureEffect	MaintNotifEffectCodeGroup	Failure Effect Group
	MaintNotifEffectCode	_FailureEffect	MaintNotifEffectCode	Failure Effect
	MaintenanceProcessingPhase	_MaintenanceOrder	MaintenanceProcessingPhase	Phase
	MaintOrdProcessPhaseCode	_MaintenanceOrder	MaintOrdProcessPhaseCode	Process Phase
	MaintNotifProcgContextText	_MaintNotifProcgContextTxt	MaintNotifProcgContextText	Notification Processing Context Text
	MaintenanceOrderDesc	_MaintOrdMstrData	OrderDescription
	PlantName	_MaintPlant	PlantName	Plant Name
	MaintenancePlannerGroupName	_MaintPlantGroup	MaintenancePlannerGroupName	Planner Group Name
	InspectionLot	_MaintWorkRequestOverviewTP	InspectionLot	Inspection Lot
	MaintNotifEffectCatalog	_PMNotificationType	MaintNotifEffectCatalog	Failure Effect Catlg
	MaintNotifActivityCodeCatalog	_PMNotificationType	MaintNotifActivityCodeCatalog
	MaintNotifDamageCodeCatalog	_PMNotificationType	MaintNotifDamageCodeCatalog
	MaintNotifObjPrtCodeCatalog	_PMNotificationType	MaintNotifObjPrtCodeCatalog
	MaintNotifCauseCodeCatalog	_PMNotificationType	MaintNotifCauseCodeCatalog
	SuperiorFuncnlLocLabelName	_SupFunctionalLocationLabel	FunctionalLocationLabelName	Superior Functional Location

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_MaintWorkRequestOverviewTP.
-- 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 C_MaintWorkRequestOverviewTP AS
SELECT
  MaintenanceNotification,
  MaintNotifInternalID,
  NotificationText,
  MaintPriority,
  MaintPriorityType,
  GenericPriorityColorCode,
  NotificationType,
  _NotificationType._NotificationTypeName[1:Language=$session.system_language].NotificationTypeName AS NotificationTypeName,
  NotifProcessingPhase,
  _MaintWorkRequestOverviewTP._PMNotificationPhase._Text[1:Language=$session.system_language].NotifProcessingPhaseDesc AS NotifProcessingPhaseDesc,
  _MaintWorkRequestOverviewTP._PMNotificationPriority._Text[1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  _MaintWorkRequestOverviewTP._MaintNotifRejectionReasonTxt[1: Language = $session.system_language ].MaintNotifRejectionRsnCodeTxt AS MaintNotifRejectionRsnCodeTxt,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeTime,
  LastChangeDate,
  LastChangeDateTime,
  CreationTime,
  CreationDateTime,
  ReportedByUser,
  ReporterFullName,
  PersonResponsible,
  MalfunctionEffect,
  MalfunctionStartDate,
  MalfunctionStartTime,
  MalfunctionStartDateTime,
  MalfunctionEndDate,
  MalfunctionEndTime,
  MalfunctionEndDateTime,
  MaintNotificationCatalog,
  MaintNotificationCode,
  _MaintNotificationCode._Text[1: Language = $session.system_language ].InspectionCodeText AS InspectionCodeText,
  MaintNotificationCodeGroup,
  _MaintNotificationCodeGroup._Text[1: Language = $session.system_language ].InspSpecAddlCodeGroupText AS InspSpecAddlCodeGroupText,
  CatalogProfile,
  _TechnicalReportText.CatalogProfileText : localized AS CatalogProfileTextlocalized,
  NotificationCreationDate,
  NotificationCreationTime,
  NotificationCreationDateTime,
  NotificationTimeZone,
  RequiredStartDate,
  RequiredStartTime,
  MaintNotifRqdStartDateTime,
  RequiredEndDate,
  RequiredEndTime,
  MaintNotifRqdEndDateTime,
  LatestAcceptableCompletionDate,
  MaintenanceObjectIsDown,
  MaintObjectDowntimeDuration,
  MaintNotifDowntimeDuration,
  MaintObjDowntimeDurationUnit,
  TextObjectCategory,
  TextObjectType,
  MaintNotifLongTextForEdit,
  TechnicalObject,
  MaintObjectFreeDefinedAttrib,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObjectLabel,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  AssetManufacturerName,
  PlantSection,
  ABCIndicator,
  AssetRoom,
  ManufacturerPartTypeName,
  _MaintWorkRequestOverviewTP._TechObjIsEquipOrFuncnlLocDesc[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  FunctionalLocation,
  _SupFunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  _SuperiorFuncLocText[1:Language = $session.system_language].FunctionalLocationName AS SuperiorFunctionalLocationName,
  FunctionalLocationLabelName,
  AssetLocation,
  LocationName,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._LocationAccountAssignment.BusinessArea AS BusinessArea,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._LocationAccountAssignment.CompanyCode AS CompanyCode,
  TechnicalObjectCategory,
  _TechnicalObjectCategoryT.TechnicalObjectCategoryDesc : localized AS TechnicalObjectCategoryDesclocalized,
  TechnicalObjectType,
  WorkCenterInternalID,
  MainWorkCenterPlant,
  MainWorkCenter,
  MaintenanceWorkCenterPlant,
  _MaintWorkRequestOverviewTP._MaintenanceWorkCenterPlant.PlantName AS MaintenanceWorkCenterPlantName,
  MaintenancePlant,
  MaintenanceWorkCenter,
  WorkCenterTypeCode,
  LocationDescription,
  MaintWorkRequestAttchKey,
  MaintNotifSourceApplication,
  MaintNotifWithLeadingZeros,
  _MaintWorkRequestOverviewTP._MainWorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS MainWorkCenterText,
  _MaintWorkRequestOverviewTP._MainWorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection.PlantSectionPersonRespName AS PlantSectionPersonRespName,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection.PlantSectionPersonRespPhone AS PlantSectionPersonRespPhone,
  _ABCIndicatorText[1:Language = $session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  PersonResponsibleName,
  MaintNotifRespPartnerFunction,
  ActiveTechnicalObject,
  ActiveTechnicalObjectType,
  MaintenanceOrder,
  MaintenanceOrderType,
  _MaintOrderType._Text[1:Language=$session.system_language].OrderTypeName AS MaintenanceOrderTypeName,
  MaintEvtIsCreatedByCurrentUser,
  MaintNotifProcessPhaseCode,
  MaintNotifProcessSubPhaseCode,
  _SubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  _Phase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  MaintNotifRejectionReasonCode,
  NotificationCompletionDate,
  NotificationReferenceDate,
  NotificationReferenceTime,
  MaintNotifReferenceDateTime,
  MaintNotifCompletionDateTime,
  _MaintWorkRequestOverviewTP._MalfunctionEffect._Text[1: Language = $session.system_language ].MalfunctionEffectText AS MalfunctionEffectText,
  TechObjInstallationLocation,
  IdentifyingLabel,
  MaintenanceTaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskList,
  virtual UICT_TaskList : boole_d AS virtualUICT_TaskListboole_d,
  TaskListKeyDate,
  virtual TaskListDesc : plantext AS virtualTaskListDescplantext,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData.MaintenancePlan AS MaintenancePlan,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._MaintenancePlan.MaintenancePlanDesc AS MaintenancePlanDesc,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData.MaintenancePlanCallNumber AS MaintenancePlanCallNumber,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData.MaintenanceItem AS MaintenanceItem,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData._MaintenanceItem.MaintenanceItemDescription AS MaintenanceItemDescription,
  MaintNotifDetectionCatalog,
  MaintNotifDetectionCode,
  _MaintNotifDetectCodeTxt[1: Language = $session.system_language].MaintNotifDetectionCodeText AS MaintNotifDetectionCodeText,
  MaintNotifDetectionCodeGroup,
  _MaintNotifDetectCodeGroupTxt[1: Language = $session.system_language].MaintNotifDetectionCodeGrpTxt AS MaintNotifDetectionCodeGrpTxt,
  WorkRequestTextTemplate,
  MaintNotifProcessingContext,
  MaintNotifProcgCntxtIsAllwd,
  HierarchyNodeLevel,
  _MaintWorkRequestOverviewTP._PMNotificationType.MaintNotifCodgCatalogTypeCode AS MaintNotifCodgCatalogTypeCode,
  _MaintWorkRequestOverviewTP._PMNotifMaintenanceData.Equipment AS Equipment,
  _FailureEffect._MaintNotifEffectCodeGroup._Text[1: Language = $session.system_language ].InspSpecAddlCodeGroupText AS MaintNotifEffectCodeGrpText,
  _FailureEffect._MaintNotificationEffectCode._Text[1: Language = $session.system_language ].InspectionCodeText AS MaintNotifEffectCtlgCodeText,
  _CreatedByUserSimpl.UserDescription AS FullName,
  _FailureEffect.MaintNotifEffectCodeGroup AS MaintNotifEffectCodeGroup,
  _FailureEffect.MaintNotifEffectCode AS MaintNotifEffectCode,
  _MaintenanceOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  _MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _MaintNotifProcgContextTxt.MaintNotifProcgContextText AS MaintNotifProcgContextText,
  _MaintOrdMstrData.OrderDescription AS MaintenanceOrderDesc,
  _MaintPlant.PlantName AS PlantName,
  _MaintPlantGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _MaintWorkRequestOverviewTP.InspectionLot AS InspectionLot,
  _PMNotificationType.MaintNotifEffectCatalog AS MaintNotifEffectCatalog,
  _PMNotificationType.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  _PMNotificationType.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  _PMNotificationType.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  _PMNotificationType.MaintNotifCauseCodeCatalog AS MaintNotifCauseCodeCatalog,
  _SupFunctionalLocationLabel.FunctionalLocationLabelName AS SuperiorFuncnlLocLabelName
FROM R_MaintenanceNotificationTP
LEFT OUTER JOIN C_MaintOrderQuickVw AS _MaintenanceOrderQuickView ON _MaintenanceOrderQuickView.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
;

Depth:

C_MaintWorkRequestOverviewTP view_entity

R_MaintenanceNotificationTP view_entity