I_DamageAnalysisCube

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_DamageAnalysisCube.
-- 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: IDAMAGEANALYCUBE

CREATE VIEW I_DamageAnalysisCube AS
SELECT
  P_Damageanalysiscube.MaintenanceNotification AS MaintenanceNotification,
  cast(P_Damageanalysiscube.MaintenanceNotificationCause as eam_notif_cause_no) AS MaintenanceNotificationCause,
  cast(P_Damageanalysiscube.MaintNotificationActivity as eam_notif_activity_no) AS MaintNotificationActivity,
  P_Damageanalysiscube.NotificationType AS NotificationType,
  P_Damageanalysiscube.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  MainWorkCenter,
  P_Damageanalysiscube.MaintenancePlant AS MaintenancePlant,
  cast(P_Damageanalysiscube.WorkCenter as eam_maint_work_center) AS WorkCenter,
  P_Damageanalysiscube.MainWorkCenterPlant AS MainWorkCenterPlant,
  P_Damageanalysiscube.NotifProcessingPhase AS NotifProcessingPhase,
  P_Damageanalysiscube.CreatedByUser AS CreatedByUser,
  P_Damageanalysiscube.LastChangedByUser AS LastChangedByUser,
  P_Damageanalysiscube.ReportedByUser AS ReportedByUser,
  P_Damageanalysiscube.CreationDate AS CreationDate,
  P_Damageanalysiscube.LastChangeDate AS LastChangeDate,
  P_Damageanalysiscube.LastChangeDateTime AS LastChangeDateTime,
  P_Damageanalysiscube.NotificationCreationDate AS NotificationCreationDate,
  P_Damageanalysiscube.RequiredStartDate AS RequiredStartDate,
  P_Damageanalysiscube.RequiredEndDate AS RequiredEndDate,
  P_Damageanalysiscube.NotificationReferenceDate AS NotificationReferenceDate,
  P_Damageanalysiscube.MalfunctionStartDate AS MalfunctionStartDate,
  P_Damageanalysiscube.MalfunctionEndDate AS MalfunctionEndDate,
  _Date.CalendarYear AS NotificationCreationYear,
  P_Damageanalysiscube.MaintNotificationCatalog AS MaintNotificationCatalog,
  P_Damageanalysiscube.MaintNotificationCode AS MaintNotificationCode,
  P_Damageanalysiscube.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  P_Damageanalysiscube.MalfunctionEffect AS MalfunctionEffect,
  P_Damageanalysiscube.PlantSection AS PlantSection,
  P_Damageanalysiscube.AssetLocation AS AssetLocation,
  P_Damageanalysiscube.AssetRoom AS AssetRoom,
  P_Damageanalysiscube.BusinessArea AS BusinessArea,
  P_Damageanalysiscube.Assembly AS Assembly,
  P_Damageanalysiscube.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  P_Damageanalysiscube.ABCIndicator AS ABCIndicator,
  P_Damageanalysiscube.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  P_Damageanalysiscube.WBSElementInternalID AS WBSElementInternalID,
  P_Damageanalysiscube.CompanyCode AS CompanyCode,
  P_Damageanalysiscube.CostCenter AS CostCenter,
  P_Damageanalysiscube.ControllingArea AS ControllingArea,
  P_Damageanalysiscube.MaintPriority AS MaintPriority,
  P_Damageanalysiscube.MaintPriorityType AS MaintPriorityType,
  P_Damageanalysiscube.TechnicalObject AS TechnicalObject,
  P_Damageanalysiscube._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  P_Damageanalysiscube.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  P_Damageanalysiscube.Equipment AS Equipment,
  P_Damageanalysiscube.FunctionalLocation AS FunctionalLocation,
  P_Damageanalysiscube.TechnicalObjectCategory AS TechnicalObjectCategory,
  P_Damageanalysiscube.CatalogProfile AS CatalogProfile,
  P_Damageanalysiscube.TechnicalObjectType AS TechnicalObjectType,
  P_Damageanalysiscube.AssetManufacturerName AS AssetManufacturerName,
  P_Damageanalysiscube.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  P_Damageanalysiscube.ManufacturerCountry AS ManufacturerCountry,
  P_Damageanalysiscube.ConstructionMaterial AS ConstructionMaterial,
  P_Damageanalysiscube.ConstructionYear AS ConstructionYear,
  P_Damageanalysiscube.ConstructionMonth AS ConstructionMonth,
  P_Damageanalysiscube.AuthorizationGroup AS AuthorizationGroup,
  P_Damageanalysiscube.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  P_Damageanalysiscube.MaintNotificationDamageCode AS MaintNotificationDamageCode,
  P_Damageanalysiscube.MaintNotifDamageCodeGroup AS MaintNotifDamageCodeGroup,
  P_Damageanalysiscube.NumberOfMaintNotifDamages AS NumberOfMaintNotifDamages,
  P_Damageanalysiscube.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  P_Damageanalysiscube.MaintNotifObjPrtCode AS MaintNotifObjPrtCode,
  cast(P_Damageanalysiscube.MaintNotifObjPrtCodeGroup as eam_obj_part_code_group_head) AS MaintNotifObjPrtCodeGroup,
  P_Damageanalysiscube.NumberOfMaintNotifObjectParts AS NumberOfMaintNotifObjectParts,
  P_Damageanalysiscube.MaintNotifCauseCodeCatalog AS MaintNotifCauseCodeCatalog,
  P_Damageanalysiscube.MaintNotificationCauseCode AS MaintNotificationCauseCode,
  P_Damageanalysiscube.MaintNotifCauseCodeGroup AS MaintNotifCauseCodeGroup,
  P_Damageanalysiscube.MaintNotificationRootCause AS MaintNotificationRootCause,
  P_Damageanalysiscube.NumberOfMaintNotifCauses AS NumberOfMaintNotifCauses,
  P_Damageanalysiscube.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  P_Damageanalysiscube.MaintNotificationActivityCode AS MaintNotificationActivityCode,
  P_Damageanalysiscube.MaintNotifActivityCodeGroup AS MaintNotifActivityCodeGroup,
  P_Damageanalysiscube.NumberOfMaintNotifActivities AS NumberOfMaintNotifActivities,
  P_Damageanalysiscube._ABCIndicator AS _ABCIndicator,
  P_Damageanalysiscube._BusinessArea AS _BusinessArea,
  P_Damageanalysiscube._CompanyCode AS _CompanyCode,
  P_Damageanalysiscube._MaintenanceNotification AS _MaintenanceNotification,
  P_Damageanalysiscube._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  P_Damageanalysiscube._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  P_Damageanalysiscube._MaintenancePlanPlant AS _MaintenancePlanPlant,
  P_Damageanalysiscube._MaintenancePlant AS _MaintenancePlant,
  P_Damageanalysiscube._MaintNotificationCatalog AS _MaintNotificationCatalog,
  P_Damageanalysiscube._MaintNotificationCode AS _MaintNotificationCode,
  P_Damageanalysiscube._MaintNotificationCodeGroup AS _MaintNotificationCodeGroup,
  P_Damageanalysiscube._MalfunctionEffect AS _MalfunctionEffect,
  P_Damageanalysiscube._MaintNotificationTechObj AS _MaintNotificationTechObj,
  P_Damageanalysiscube._ManufacturerCountry AS _ManufacturerCountry,
  P_Damageanalysiscube._UsedConstructionTypeVH AS _UsedConstructionTypeVH,
  P_Damageanalysiscube._PlantSection AS _PlantSection,
  P_Damageanalysiscube._PMNotificationPhase AS _PMNotificationPhase,
  P_Damageanalysiscube._PMNotificationPriority AS _PMNotificationPriority,
  P_Damageanalysiscube._PMNotificationPriorityType AS _PMNotificationPriorityType,
  P_Damageanalysiscube._PMNotificationType AS _PMNotificationType,
  P_Damageanalysiscube._TechnicalObject AS _TechnicalObject,
  P_Damageanalysiscube._Equipment AS _Equipment,
  P_Damageanalysiscube._FunctionalLocation AS _FunctionalLocation,
  P_Damageanalysiscube._TechnicalObjectType AS _TechnicalObjectType,
  P_Damageanalysiscube._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  P_Damageanalysiscube._WBSElementBasicData AS _WBSElementBasicData,
  P_Damageanalysiscube._TechnicalObjectCategory AS _TechnicalObjectCategory,
  P_Damageanalysiscube._TechnicalObjectCodeCatalog AS _TechnicalObjectCodeCatalog
FROM P_Damageanalysiscube
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifDamageCodeCatalog ON MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifDamageCodeGroup ON MaintNotifDamageCodeGroup = _MaintNotifDamageCodeGroup.InspectionCodeGroup AND MaintNotifDamageCodeCatalog = _MaintNotifDamageCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationDamageCode ON MaintNotificationDamageCode = _MaintNotificationDamageCode.InspectionCode AND MaintNotifDamageCodeCatalog = _MaintNotificationDamageCode.InspectionCatalog AND MaintNotifDamageCodeGroup = _MaintNotificationDamageCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifObjPrtCodeCatalog ON MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifObjPrtCodeGroup ON MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCodeGroup.InspectionCodeGroup AND MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotifObjPrtCode ON MaintNotifObjPrtCode = _MaintNotifObjPrtCode.InspectionCode AND MaintNotifObjPrtCodeCatalog = _MaintNotifObjPrtCode.InspectionCatalog AND MaintNotifObjPrtCodeGroup = _MaintNotifObjPrtCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationCauseCode ON MaintNotificationCauseCode = _MaintNotificationCauseCode.InspectionCode AND MaintNotifCauseCodeCatalog = _MaintNotificationCauseCode.InspectionCatalog AND MaintNotifCauseCodeGroup = _MaintNotificationCauseCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifCauseCodeCatalog ON MaintNotifCauseCodeCatalog = _MaintNotifCauseCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifCauseCodeGroup ON MaintNotifCauseCodeGroup = _MaintNotifCauseCodeGroup.InspectionCodeGroup AND MaintNotifCauseCodeCatalog = _MaintNotifCauseCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_EAMRootCause AS _MaintNotificationRootCause ON MaintNotificationRootCause = _MaintNotificationRootCause.MaintNotificationRootCause  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _MaintNotifActivityCodeCatalog ON MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _MaintNotifActivityCodeGroup ON MaintNotifActivityCodeGroup = _MaintNotifActivityCodeGroup.InspectionCodeGroup AND MaintNotifActivityCodeCatalog = _MaintNotifActivityCodeGroup.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _MaintNotificationActivityCode ON MaintNotificationActivityCode = _MaintNotificationActivityCode.InspectionCode AND MaintNotifActivityCodeCatalog = _MaintNotificationActivityCode.InspectionCatalog AND MaintNotifActivityCodeGroup = _MaintNotificationActivityCode.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _Date ON NotificationCreationDate = _Date.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactLastChangedBy ON LastChangedByUser = _PMContactLastChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactCreatedBy ON CreatedByUser = _PMContactCreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactReportedBy ON ReportedByUser = _PMContactReportedBy.UserID  -- association [0..1]
LEFT OUTER JOIN C_PMAssetLocationVH AS _Location ON MaintenancePlant = _Location.Plant AND AssetLocation = _Location.Location  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON MainWorkCenterPlant = _WorkCenter.Plant AND WorkCenter = _WorkCenter.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenter ON MainWorkCenterPlant = _MainWorkCenter.Plant AND MainWorkCenter = _MainWorkCenter.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_TechObjAuthznGrp AS _TechObjAuthznGrp ON AuthorizationGroup = _TechObjAuthznGrp.TechObjAuthorizationGroup  -- association [0..1]
;