What is I_LocationAnalysisCube in SAP S/4HANA?

I_LocationAnalysisCube is a composite CDS view in SAP S/4HANA. Location Analysis - Cube It contains 98 fields.

Which tables does I_LocationAnalysisCube read from?

I_LocationAnalysisCube reads data from: I_MaintNotificationTechObj.

What VDM layer is I_LocationAnalysisCube?

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

I_LocationAnalysisCube

DDL: I_LOCATIONANALYSISCUBE SQL: ILOCANALYSISCUBE Type: view COMPOSITE Package: IWOC

98 Fields 1 Data Sources 12 Associations

Location Analysis - Cube

I_LocationAnalysisCube is a Composite CDS View (Cube) that provides data about "Location Analysis - Cube" in SAP S/4HANA. It reads from 1 data source (I_MaintNotificationTechObj) and exposes 98 fields with key field MaintenanceNotification. It has 12 associations to related views. Part of development package IWOC.

SAP Help Documentation

Category	CDS Views for Maintenance Management
Data Category	Cube
Status	Released
Data Extraction Type	Delta-enabled, the extraction is based on field LastChangeDateTime .
Corresponding DataSource	0I_LOCATIONANALYSISCUBE 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 SAP BW/4HANA Content Add-On under Asset Management Plant Maintenance Staging/Corporate Memory .

Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the short description of the header notification? What are the details of the header notification? What is the number of the functional location related to the header notification? What is the number of the equipment related to the header notification? What are the details of the related technical objects (equipment or functional location)? Is the header notification marked for deletion? What are the scheduling details of this header notification? What are the location details of the header notification? What are the account assignment details of the header notification? What are the responsibility details of this header notification? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We strongly recommend that you only use it for this purpose.

Prerequisites
To enable an SAP BW/4HANA system to extract data from your system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA .

Structure
Business Objects This view is built on the following business objects: 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: Header notification short description Header notification data Functional location number Equipment number Technical object data Deletion flag Scheduling parameters Location data, for example Maintenance Plant and Plant Section Account assignment data, for example Company Code and Cost Center Responsibility data, for example Planner Group and Work Center Key Performance Indicators (KPIs) Name Value NumberOfCreatedMaintNotifs Always 1 NumberOfReportedBreakdowns 0 or 1. It is 1 if the maintenance notification has a breakdown flag. NumberOfCreatedMaintOrders 0 or 1. It is 1 if a maintenance order is assigned to the maintenance notification. NumberOfCompletedMaintNotif 0 or 1. It is 1 if the maintenance notification has status Completed . NmbrOfDeltdMaintNotifications 0 or 1. It is 1 if the maintenance notification has status Deleted . NmbrOfOpenMaintNotifications 0 or 1. It is 0 if the maintenance notification has status Completed or Deleted . MaintObjectDowntimeDuration HOUR TotalLeadTimeOfMaintNotif Number of calendar days between the creation date and the completion date LeadTimeUnit DAY NrOfOutstandingMaintNotif 0 or 1. It is 1 if the maintenance notification is not deleted and it has an empty completion date. NrOfMaintNotifCmpltdOnSched 0 or 1. It is 1 if the completion date is before or is on the required end date. NumberOfMaintNotifTasks Number of maintenance tasks assigned to the maintenance notification NrOfMaintNotifSuccssflTasks Number of maintenance tasks with status Successful assigned to the maintenance notification NrOfMaintNotifActiveTasks Number of maintenance tasks which are active (status Outstanding or Released ) assigned to the maintenance notification

View on SAP Help Portal →

Data Sources (1)

Source	Alias	Join Type
I_MaintNotificationTechObj	I_MaintNotificationTechObj	from

Associations (12)

Cardinality	Target	Alias	Condition
[0..1]	I_WorkCenterBySemanticKey	_MainWorkCenterBySemanticKey	`$projection.MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter and $projection.MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant`
[0..1]	I_WorkCenterBySemanticKey	_WorkCenterBySemanticKey	`$projection.workcenter = _WorkCenterBySemanticKey.WorkCenter and $projection.WorkCenterPlant = _WorkCenterBySemanticKey.Plant`
[0..*]	I_EquipmentData	_EquipmentData	`_EquipmentData.Equipment = $projection.Equipment`
[0..1]	I_FunctionalLocationData	_FunctionalLocationData	`_FunctionalLocationData.FunctionalLocation = $projection.FunctionalLocation`
[0..1]	P_MaintNotifTaskCount	_MaintNotifTaskCount	`_MaintNotifTaskCount.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	P_MaintNotifSuccssflTaskCount	_MaintNotifSuccssflTaskCount	`_MaintNotifSuccssflTaskCount.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	P_MaintNotifOutStdgReldTaskCnt	_MaintNotifOutStdgReldTaskCnt	`_MaintNotifOutStdgReldTaskCnt.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	P_MaintNotifTechnicalObject	_MaintNotifTechnicalObject	`_MaintNotifTechnicalObject.MaintenanceNotification = $projection.MaintenanceNotification`
[0..1]	I_TechnicalObjectType	_TechnicalObjectType	`_TechnicalObjectType.TechnicalObjectType = $projection.technicalobjecttype`
[0..1]	I_Country	_ManufacturerCountry	`$projection.manufacturercountry = _ManufacturerCountry.Country`
[0..1]	I_TechnicalReport	_TechnicalObjectCodeCatalog	`$projection.catalogprofile = _TechnicalObjectCodeCatalog.CatalogProfile -- Extensions, do not expose as association:`
[0..1]	E_PMNotifMaintenanceData	_NotifMaintenanceDataExtension	`_NotifMaintenanceDataExtension.MaintenanceNotification = $projection.MaintenanceNotification`

Annotations (17)

Name	Value	Level
EndUserText.label	Location Analysis - Cube	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.sqlViewName	ILOCANALYSISCUBE	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AbapCatalog.compiler.compareFilter	true	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.byElement.name	LastChangeDateTime	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
ObjectModel.sapObjectNodeType.name	MaintenanceNotification	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (98)

Key	Field	Source Table	Source Field	Description
KEY	MaintenanceNotification	I_MaintNotificationTechObj	MaintenanceNotification	Notification
	NotificationText	I_MaintNotificationTechObj	NotificationText	Description
	MaintenancePlant
	PlantSection
	NotificationType	I_MaintNotificationTechObj	NotificationType	Notifictn Type
	NotifProcessingPhase	I_MaintNotificationTechObj	NotifProcessingPhase	Notif. Phase
	MaintenancePlanningPlant
	MaintPriority	I_MaintNotificationTechObj	MaintPriority	Priority
	MaintPriorityType	I_MaintNotificationTechObj	MaintPriorityType	PriorityType
	NotificationOrigin	I_MaintNotificationTechObj	NotificationOrigin
	IsDeleted	I_MaintNotificationTechObj	IsDeleted	TRUE
	BusinessArea
	Assembly
	MaintenancePlannerGroup
	MaintenanceObjectIsDown
	MainWorkCenter
	MainWorkCenterPlant
	WorkCenter
	WorkCenterPlant
	AssetLocation
	AssetRoom
	ABCIndicator
	MaintObjectFreeDefinedAttrib
	CostCenter
	ControllingArea
	CompanyCode
	WBSElementInternalID
	WBSElement
	CreationDate	I_MaintNotificationTechObj	CreationDate	Time Stamp
	CreationTime	I_MaintNotificationTechObj	CreationTime	Time of Change
	LastChangeDate	I_MaintNotificationTechObj	LastChangeDate	Time Stamp
	NotificationCreationDate	I_MaintNotificationTechObj	NotificationCreationDate	Notif. Date
	NotificationCreationTime	I_MaintNotificationTechObj	NotificationCreationTime	Notif. Time
	NotificationCompletionDate	I_MaintNotificationTechObj	NotificationCompletionDate	Completion Date
	CompletionTime	I_MaintNotificationTechObj	CompletionTime	Completion Time
	NotificationReferenceDate	I_MaintNotificationTechObj	NotificationReferenceDate	Reference Date
	RequiredStartDate	I_MaintNotificationTechObj	RequiredStartDate	Req. Start Date
	RequiredStartTime	I_MaintNotificationTechObj	RequiredStartTime	Req. start time
	RequiredEndDate	I_MaintNotificationTechObj	RequiredEndDate	Req. End Date
	RequiredEndTime	I_MaintNotificationTechObj	RequiredEndTime	Req. end time
	MalfunctionStartDate
	MalfunctionStartTime
	MalfunctionEndDate
	MalfunctionEndTime
	LastChangeDateTime	I_MaintNotificationTechObj	LastChangeDateTime	Timestamp
	CreatedByUser	I_MaintNotificationTechObj	CreatedByUser	User Name
	LastChangedByUser	I_MaintNotificationTechObj	LastChangedByUser	User Name
	ReportedByUser	I_MaintNotificationTechObj	ReportedByUser	Reported By
	TechnicalObjectLabel	_MaintNotifTechnicalObject	TechnicalObjectLabel	Tech. Object
	TechObjIsEquipOrFuncnlLoc	I_MaintNotificationTechObj	TechObjIsEquipOrFuncnlLoc	Tech. Obj. Type
	TechnicalObjectType	_MaintNotifTechnicalObject	TechnicalObjectType	Text object
	AssetManufacturerName	_MaintNotifTechnicalObject	AssetManufacturerName	Manufacturer
	ManufacturerPartTypeName	_MaintNotifTechnicalObject	ManufacturerPartTypeName	Model number
	AuthorizationGroup	_MaintNotifTechnicalObject	AuthorizationGroup	AuthorizGroup
	ManufacturerCountry	_MaintNotifTechnicalObject	ManufacturerCountry	Mnf. Cntry/Regn
	ConstructionYear
	ConstructionMonth
	Equipment	I_MaintNotificationTechObj	Equipment	Equipment check
	FunctionalLocation	I_MaintNotificationTechObj	FunctionalLocation	Object ID
	CatalogProfile	_MaintNotifTechnicalObject	CatalogProfile	Catalog Profile
	LinearDataStartPoint
	LinearDataEndPoint
	LinearDataLength
	LinearDataUnitOfMeasure
	NumberOfCreatedMaintNotifs
	MaintObjDowntimeDurationUnit
	LeadTimeUnit
	NumberOfMaintNotifTasks
	NrOfMaintNotifSuccssflTasks
	NrOfMaintNotifActiveTasks
	_MaintenancePlant
	_MaintenancePlanningPlant
	_MaintenancePlanPlant
	_PlantSection
	_IsDeleted	I_MaintNotificationTechObj	_IsDeleted
	_PMNotificationPhase	I_MaintNotificationTechObj	_PMNotificationPhase
	_PMNotificationType	I_MaintNotificationTechObj	_PMNotificationType
	_PMNotificationPriority	I_MaintNotificationTechObj	_PMNotificationPriority
	_PMNotificationPriorityType	I_MaintNotificationTechObj	_PMNotificationPriorityType
	_BusinessArea
	_MaintenancePlannerGroup
	_MaintenanceObjectIsDown
	_ABCIndicator
	_CompanyCode
	_WBSElementBasicData
	_LinearDataUnitOfMeasure
	_MainWorkCenterPlant
	_WorkCenterPlant
	_TechObjIsEquipOrFuncnlLoc	I_MaintNotificationTechObj	_TechObjIsEquipOrFuncnlLoc
	_TechnicalObjectType		_TechnicalObjectType
	_ManufacturerCountry		_ManufacturerCountry
	_Equipment
	_FunctionalLocation
	_TechnicalObjectCodeCatalog		_TechnicalObjectCodeCatalog
	_EquipmentData		_EquipmentData
	_FunctionalLocationData		_FunctionalLocationData
	_MainWorkCenterBySemanticKey		_MainWorkCenterBySemanticKey
	_WorkCenterBySemanticKey		_WorkCenterBySemanticKey

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_LocationAnalysisCube.
-- 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: ILOCANALYSISCUBE

CREATE VIEW I_LocationAnalysisCube AS
SELECT
  I_MaintNotificationTechObj.MaintenanceNotification AS MaintenanceNotification,
  I_MaintNotificationTechObj.NotificationText AS NotificationText,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.PlantSection AS PlantSection,
  I_MaintNotificationTechObj.NotificationType AS NotificationType,
  I_MaintNotificationTechObj.NotifProcessingPhase AS NotifProcessingPhase,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_MaintNotificationTechObj.MaintPriority AS MaintPriority,
  I_MaintNotificationTechObj.MaintPriorityType AS MaintPriorityType,
  I_MaintNotificationTechObj.NotificationOrigin AS NotificationOrigin,
  I_MaintNotificationTechObj.IsDeleted AS IsDeleted,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.BusinessArea AS BusinessArea,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.Assembly AS Assembly,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  cast( I_MaintNotificationTechObj._MainWorkCenter.WorkCenter as gewrk preserving type ) AS MainWorkCenter,
  cast( I_MaintNotificationTechObj._MainWorkCenter.Plant as wergw preserving type ) AS MainWorkCenterPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._WorkCenter.Plant AS WorkCenterPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.AssetLocation AS AssetLocation,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.AssetRoom AS AssetRoom,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.CostCenter AS CostCenter,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.ControllingArea AS ControllingArea,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.CompanyCode AS CompanyCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment.WBSElementInternalID AS WBSElementInternalID,
  cast( I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._WBSElementBasicData.WBSElement as ps_posid preserving type ) AS WBSElement,
  I_MaintNotificationTechObj.CreationDate AS CreationDate,
  I_MaintNotificationTechObj.CreationTime AS CreationTime,
  I_MaintNotificationTechObj.LastChangeDate AS LastChangeDate,
  I_MaintNotificationTechObj.NotificationCreationDate AS NotificationCreationDate,
  I_MaintNotificationTechObj.NotificationCreationTime AS NotificationCreationTime,
  I_MaintNotificationTechObj.NotificationCompletionDate AS NotificationCompletionDate,
  I_MaintNotificationTechObj.CompletionTime AS CompletionTime,
  I_MaintNotificationTechObj.NotificationReferenceDate AS NotificationReferenceDate,
  I_MaintNotificationTechObj.RequiredStartDate AS RequiredStartDate,
  I_MaintNotificationTechObj.RequiredStartTime AS RequiredStartTime,
  I_MaintNotificationTechObj.RequiredEndDate AS RequiredEndDate,
  I_MaintNotificationTechObj.RequiredEndTime AS RequiredEndTime,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MalfunctionStartDate AS MalfunctionStartDate,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MalfunctionStartTime AS MalfunctionStartTime,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MalfunctionEndDate AS MalfunctionEndDate,
  I_MaintNotificationTechObj._PMNotifMaintenanceData.MalfunctionEndTime AS MalfunctionEndTime,
  I_MaintNotificationTechObj.LastChangeDateTime AS LastChangeDateTime,
  I_MaintNotificationTechObj.CreatedByUser AS CreatedByUser,
  I_MaintNotificationTechObj.LastChangedByUser AS LastChangedByUser,
  I_MaintNotificationTechObj.ReportedByUser AS ReportedByUser,
  _MaintNotifTechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  I_MaintNotificationTechObj.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintNotifTechnicalObject.TechnicalObjectType AS TechnicalObjectType,
  _MaintNotifTechnicalObject.AssetManufacturerName AS AssetManufacturerName,
  _MaintNotifTechnicalObject.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  _MaintNotifTechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  _MaintNotifTechnicalObject.ManufacturerCountry AS ManufacturerCountry,
  cast( _MaintNotifTechnicalObject.ConstructionYear as eam_techobj_construction_year ) AS ConstructionYear,
  cast( _MaintNotifTechnicalObject.ConstructionMonth as eam_techobj_construction_month ) AS ConstructionMonth,
  I_MaintNotificationTechObj.Equipment AS Equipment,
  I_MaintNotificationTechObj.FunctionalLocation AS FunctionalLocation,
  _MaintNotifTechnicalObject.CatalogProfile AS CatalogProfile,
  cast( cast( I_MaintNotificationTechObj._LinearAssetManagementData.LinearDataStartPoint as abap.dec(11, 3) ) as eaml_start_point ) AS LinearDataStartPoint,
  cast( cast( I_MaintNotificationTechObj._LinearAssetManagementData.LinearDataEndPoint as abap.dec(11, 3) ) as eaml_end_point ) AS LinearDataEndPoint,
  I_MaintNotificationTechObj._LinearAssetManagementData.LinearDataLength AS LinearDataLength,
  I_MaintNotificationTechObj._LinearAssetManagementData.LinearDataUnitOfMeasure AS LinearDataUnitOfMeasure,
  cast( 1 as smofn ) AS NumberOfCreatedMaintNotifs,
  cast('STD' as maueh) AS MaintObjDowntimeDurationUnit,
  cast('TAG' as qeinhtag) AS LeadTimeUnit,
  cast(_MaintNotifTaskCount.NumberOfMaintNotifTasks as qzhlmass ) AS NumberOfMaintNotifTasks,
  cast(_MaintNotifSuccssflTaskCount.NrOfMaintNotifSuccssflTasks as qzhlmerf ) AS NrOfMaintNotifSuccssflTasks,
  cast(_MaintNotifOutStdgReldTaskCnt.NrOfMaintNotifActiveTasks as qzhlmaof ) AS NrOfMaintNotifActiveTasks,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._MaintenancePlanPlant AS _MaintenancePlanPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._PlantSection AS _PlantSection,
  I_MaintNotificationTechObj._IsDeleted AS _IsDeleted,
  I_MaintNotificationTechObj._PMNotificationPhase AS _PMNotificationPhase,
  I_MaintNotificationTechObj._PMNotificationType AS _PMNotificationType,
  I_MaintNotificationTechObj._PMNotificationPriority AS _PMNotificationPriority,
  I_MaintNotificationTechObj._PMNotificationPriorityType AS _PMNotificationPriorityType,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._BusinessArea AS _BusinessArea,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._MaintenanceObjectIsDown AS _MaintenanceObjectIsDown,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._ABCIndicator AS _ABCIndicator,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._CompanyCode AS _CompanyCode,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._WBSElementBasicData AS _WBSElementBasicData,
  I_MaintNotificationTechObj._LinearAssetManagementData._LinearDataUnitOfMeasure AS _LinearDataUnitOfMeasure,
  I_MaintNotificationTechObj._MainWorkCenter._Plant AS _MainWorkCenterPlant,
  I_MaintNotificationTechObj._PMNotifMaintenanceData._LocationAccountAssignment._WorkCenter._Plant AS _WorkCenterPlant,
  I_MaintNotificationTechObj._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc
FROM I_MaintNotificationTechObj
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenterBySemanticKey ON MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter AND MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON workcenter = _WorkCenterBySemanticKey.WorkCenter AND WorkCenterPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_EquipmentData AS _EquipmentData ON _EquipmentData.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationData AS _FunctionalLocationData ON _FunctionalLocationData.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN P_MaintNotifTaskCount AS _MaintNotifTaskCount ON _MaintNotifTaskCount.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN P_MaintNotifSuccssflTaskCount AS _MaintNotifSuccssflTaskCount ON _MaintNotifSuccssflTaskCount.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN P_MaintNotifOutStdgReldTaskCnt AS _MaintNotifOutStdgReldTaskCnt ON _MaintNotifOutStdgReldTaskCnt.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN P_MaintNotifTechnicalObject AS _MaintNotifTechnicalObject ON _MaintNotifTechnicalObject.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectType AS _TechnicalObjectType ON _TechnicalObjectType.TechnicalObjectType = technicalobjecttype  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ManufacturerCountry ON manufacturercountry = _ManufacturerCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_TechnicalReport AS _TechnicalObjectCodeCatalog ON catalogprofile = _TechnicalObjectCodeCatalog.CatalogProfile  -- association [0..1]
LEFT OUTER JOIN E_PMNotifMaintenanceData AS _NotifMaintenanceDataExtension ON _NotifMaintenanceDataExtension.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
;

Depth:

I_LocationAnalysisCube view

I_MaintNotificationTechObj view

C_LocationAnalysisQuery view