C_DamageAnalysisQuery

DDL: C_DAMAGEANALYSISQUERY SQL: CDAMAGEANALYQRY Type: view CONSUMPTION
73 Fields 1 Data Sources

Damage Analysis Query

C_DamageAnalysisQuery is a Consumption CDS View that provides data about "Damage Analysis Query" in SAP S/4HANA. It reads from 1 data source (I_DamageAnalysisCube) and exposes 73 fields with key fields MaintenanceNotification, MaintenanceNotificationItem, MaintenanceNotificationCause, MaintNotificationActivity.

Data Sources (1)

SourceAliasJoin Type
I_DamageAnalysisCube I_DamageAnalysisCube from

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Damage Analysis Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CDAMAGEANALYQRY view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
OData.publish true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_DamageAnalysisCube MaintenanceNotification Notification
KEY MaintenanceNotificationItem I_DamageAnalysisCube MaintenanceNotificationItem
KEY MaintenanceNotificationCause I_DamageAnalysisCube MaintenanceNotificationCause
KEY MaintNotificationActivity I_DamageAnalysisCube MaintNotificationActivity
NotificationType I_DamageAnalysisCube NotificationType Notifictn Type
MaintenancePlanningPlant I_DamageAnalysisCube MaintenancePlanningPlant Planning Plant
MainWorkCenter I_DamageAnalysisCube MainWorkCenter Work Center
MainWorkCenterPlant I_DamageAnalysisCube MainWorkCenterPlant Plnt WorkCenter
MaintenancePlant I_DamageAnalysisCube MaintenancePlant Plant
WorkCenter I_DamageAnalysisCube WorkCenter Work Center
NotifProcessingPhase I_DamageAnalysisCube NotifProcessingPhase Notif. Phase
CreatedByUser I_DamageAnalysisCube CreatedByUser User Name
LastChangedByUser I_DamageAnalysisCube LastChangedByUser User Name
ReportedByUser I_DamageAnalysisCube ReportedByUser Reported By
CreationDate I_DamageAnalysisCube CreationDate Time Stamp
LastChangeDate I_DamageAnalysisCube LastChangeDate Time Stamp
NotificationCreationDate I_DamageAnalysisCube NotificationCreationDate Notif. Date
NotificationCreationYear
RequiredStartDate I_DamageAnalysisCube RequiredStartDate Req. Start Date
RequiredEndDate I_DamageAnalysisCube RequiredEndDate Req. End Date
NotificationReferenceDate I_DamageAnalysisCube NotificationReferenceDate Reference Date
MalfunctionStartDate I_DamageAnalysisCube MalfunctionStartDate Malfunct. Start
MalfunctionEndDate I_DamageAnalysisCube MalfunctionEndDate Malfunct. End
MaintNotificationCatalog I_DamageAnalysisCube MaintNotificationCatalog Catalog Type
MaintNotificationCode I_DamageAnalysisCube MaintNotificationCode Coding
MaintNotificationCodeGroup I_DamageAnalysisCube MaintNotificationCodeGroup Code Group
MalfunctionEffect I_DamageAnalysisCube MalfunctionEffect Operational Effect
PlantSection I_DamageAnalysisCube PlantSection Plant Section
AssetLocation I_DamageAnalysisCube AssetLocation Location
AssetRoom I_DamageAnalysisCube AssetRoom Room
BusinessArea I_DamageAnalysisCube BusinessArea Business Area
Assembly I_DamageAnalysisCube Assembly Pegged Reqmt
MaintenancePlannerGroup I_DamageAnalysisCube MaintenancePlannerGroup Planner Group
ABCIndicator I_DamageAnalysisCube ABCIndicator ABC Indicator
MaintObjectFreeDefinedAttrib I_DamageAnalysisCube MaintObjectFreeDefinedAttrib Sort Field
WBSElementInternalID I_DamageAnalysisCube WBSElementInternalID WBS Internal ID
CompanyCode I_DamageAnalysisCube CompanyCode Receiver Company Code
CostCenter I_DamageAnalysisCube CostCenter Cost Center
ControllingArea I_DamageAnalysisCube ControllingArea Controlling Area
MaintPriority I_DamageAnalysisCube MaintPriority Priority
MaintPriorityType I_DamageAnalysisCube MaintPriorityType PriorityType
TechObjIsEquipOrFuncnlLoc I_DamageAnalysisCube TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
Equipment I_DamageAnalysisCube Equipment Equipment check
FunctionalLocation I_DamageAnalysisCube FunctionalLocation Object ID
TechnicalObject I_DamageAnalysisCube TechnicalObject Technical Object
TechnicalObjectLabel I_DamageAnalysisCube TechnicalObjectLabel Technical Object Label
TechnicalObjectType I_DamageAnalysisCube TechnicalObjectType Text object
AssetManufacturerName I_DamageAnalysisCube AssetManufacturerName Manufacturer
ManufacturerPartTypeName I_DamageAnalysisCube ManufacturerPartTypeName Model number
ManufacturerCountry I_DamageAnalysisCube ManufacturerCountry Mnf. Cntry/Regn
ConstructionMaterial I_DamageAnalysisCube ConstructionMaterial ConstType
ConstructionYear I_DamageAnalysisCube ConstructionYear
ConstructionMonth I_DamageAnalysisCube ConstructionMonth
AuthorizationGroup I_DamageAnalysisCube AuthorizationGroup Authorization Group
TechnicalObjectCategory I_DamageAnalysisCube TechnicalObjectCategory Tech. Obj. Category
CatalogProfile I_DamageAnalysisCube CatalogProfile Catalog Profile
MaintNotifDamageCodeCatalog I_DamageAnalysisCube MaintNotifDamageCodeCatalog
MaintNotificationDamageCode I_DamageAnalysisCube MaintNotificationDamageCode
MaintNotifDamageCodeGroup I_DamageAnalysisCube MaintNotifDamageCodeGroup
MaintNotifObjPrtCodeCatalog I_DamageAnalysisCube MaintNotifObjPrtCodeCatalog
MaintNotifObjPrtCode I_DamageAnalysisCube MaintNotifObjPrtCode
MaintNotifObjPrtCodeGroup MaintNotifObjPrtCodeGroup
MaintNotifCauseCodeCatalog I_DamageAnalysisCube MaintNotifCauseCodeCatalog Cause Code Catalog
MaintNotificationCauseCode I_DamageAnalysisCube MaintNotificationCauseCode
MaintNotifCauseCodeGroup I_DamageAnalysisCube MaintNotifCauseCodeGroup
MaintNotificationRootCause I_DamageAnalysisCube MaintNotificationRootCause
MaintNotifActivityCodeCatalog I_DamageAnalysisCube MaintNotifActivityCodeCatalog Activity Code Catalog
MaintNotificationActivityCode I_DamageAnalysisCube MaintNotificationActivityCode
MaintNotifActivityCodeGroup I_DamageAnalysisCube MaintNotifActivityCodeGroup
NumberOfMaintNotifActivities I_DamageAnalysisCube NumberOfMaintNotifActivities
NumberOfMaintNotifDamages I_DamageAnalysisCube NumberOfMaintNotifDamages
NumberOfMaintNotifCauses I_DamageAnalysisCube NumberOfMaintNotifCauses
NumberOfMaintNotifObjectParts I_DamageAnalysisCube NumberOfMaintNotifObjectParts

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_DamageAnalysisQuery.
-- 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: CDAMAGEANALYQRY

CREATE VIEW C_DamageAnalysisQuery AS
SELECT
  I_DamageAnalysisCube.MaintenanceNotification AS MaintenanceNotification,
  I_DamageAnalysisCube.MaintenanceNotificationItem AS MaintenanceNotificationItem,
  I_DamageAnalysisCube.MaintenanceNotificationCause AS MaintenanceNotificationCause,
  I_DamageAnalysisCube.MaintNotificationActivity AS MaintNotificationActivity,
  I_DamageAnalysisCube.NotificationType AS NotificationType,
  I_DamageAnalysisCube.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_DamageAnalysisCube.MainWorkCenter AS MainWorkCenter,
  I_DamageAnalysisCube.MainWorkCenterPlant AS MainWorkCenterPlant,
  I_DamageAnalysisCube.MaintenancePlant AS MaintenancePlant,
  I_DamageAnalysisCube.WorkCenter AS WorkCenter,
  I_DamageAnalysisCube.NotifProcessingPhase AS NotifProcessingPhase,
  I_DamageAnalysisCube.CreatedByUser AS CreatedByUser,
  I_DamageAnalysisCube.LastChangedByUser AS LastChangedByUser,
  I_DamageAnalysisCube.ReportedByUser AS ReportedByUser,
  I_DamageAnalysisCube.CreationDate AS CreationDate,
  I_DamageAnalysisCube.LastChangeDate AS LastChangeDate,
  I_DamageAnalysisCube.NotificationCreationDate AS NotificationCreationDate,
  cast(I_DamageAnalysisCube.NotificationCreationYear as eam_notif_creation_year) AS NotificationCreationYear,
  I_DamageAnalysisCube.RequiredStartDate AS RequiredStartDate,
  I_DamageAnalysisCube.RequiredEndDate AS RequiredEndDate,
  I_DamageAnalysisCube.NotificationReferenceDate AS NotificationReferenceDate,
  I_DamageAnalysisCube.MalfunctionStartDate AS MalfunctionStartDate,
  I_DamageAnalysisCube.MalfunctionEndDate AS MalfunctionEndDate,
  I_DamageAnalysisCube.MaintNotificationCatalog AS MaintNotificationCatalog,
  I_DamageAnalysisCube.MaintNotificationCode AS MaintNotificationCode,
  I_DamageAnalysisCube.MaintNotificationCodeGroup AS MaintNotificationCodeGroup,
  I_DamageAnalysisCube.MalfunctionEffect AS MalfunctionEffect,
  I_DamageAnalysisCube.PlantSection AS PlantSection,
  I_DamageAnalysisCube.AssetLocation AS AssetLocation,
  I_DamageAnalysisCube.AssetRoom AS AssetRoom,
  I_DamageAnalysisCube.BusinessArea AS BusinessArea,
  I_DamageAnalysisCube.Assembly AS Assembly,
  I_DamageAnalysisCube.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_DamageAnalysisCube.ABCIndicator AS ABCIndicator,
  I_DamageAnalysisCube.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  I_DamageAnalysisCube.WBSElementInternalID AS WBSElementInternalID,
  I_DamageAnalysisCube.CompanyCode AS CompanyCode,
  I_DamageAnalysisCube.CostCenter AS CostCenter,
  I_DamageAnalysisCube.ControllingArea AS ControllingArea,
  I_DamageAnalysisCube.MaintPriority AS MaintPriority,
  I_DamageAnalysisCube.MaintPriorityType AS MaintPriorityType,
  I_DamageAnalysisCube.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_DamageAnalysisCube.Equipment AS Equipment,
  I_DamageAnalysisCube.FunctionalLocation AS FunctionalLocation,
  I_DamageAnalysisCube.TechnicalObject AS TechnicalObject,
  I_DamageAnalysisCube.TechnicalObjectLabel AS TechnicalObjectLabel,
  I_DamageAnalysisCube.TechnicalObjectType AS TechnicalObjectType,
  I_DamageAnalysisCube.AssetManufacturerName AS AssetManufacturerName,
  I_DamageAnalysisCube.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_DamageAnalysisCube.ManufacturerCountry AS ManufacturerCountry,
  I_DamageAnalysisCube.ConstructionMaterial AS ConstructionMaterial,
  I_DamageAnalysisCube.ConstructionYear AS ConstructionYear,
  I_DamageAnalysisCube.ConstructionMonth AS ConstructionMonth,
  I_DamageAnalysisCube.AuthorizationGroup AS AuthorizationGroup,
  I_DamageAnalysisCube.TechnicalObjectCategory AS TechnicalObjectCategory,
  I_DamageAnalysisCube.CatalogProfile AS CatalogProfile,
  I_DamageAnalysisCube.MaintNotifDamageCodeCatalog AS MaintNotifDamageCodeCatalog,
  I_DamageAnalysisCube.MaintNotificationDamageCode AS MaintNotificationDamageCode,
  I_DamageAnalysisCube.MaintNotifDamageCodeGroup AS MaintNotifDamageCodeGroup,
  I_DamageAnalysisCube.MaintNotifObjPrtCodeCatalog AS MaintNotifObjPrtCodeCatalog,
  I_DamageAnalysisCube.MaintNotifObjPrtCode AS MaintNotifObjPrtCode,
  MaintNotifObjPrtCodeGroup,
  I_DamageAnalysisCube.MaintNotifCauseCodeCatalog AS MaintNotifCauseCodeCatalog,
  I_DamageAnalysisCube.MaintNotificationCauseCode AS MaintNotificationCauseCode,
  I_DamageAnalysisCube.MaintNotifCauseCodeGroup AS MaintNotifCauseCodeGroup,
  I_DamageAnalysisCube.MaintNotificationRootCause AS MaintNotificationRootCause,
  I_DamageAnalysisCube.MaintNotifActivityCodeCatalog AS MaintNotifActivityCodeCatalog,
  I_DamageAnalysisCube.MaintNotificationActivityCode AS MaintNotificationActivityCode,
  I_DamageAnalysisCube.MaintNotifActivityCodeGroup AS MaintNotifActivityCodeGroup,
  I_DamageAnalysisCube.NumberOfMaintNotifActivities AS NumberOfMaintNotifActivities,
  I_DamageAnalysisCube.NumberOfMaintNotifDamages AS NumberOfMaintNotifDamages,
  I_DamageAnalysisCube.NumberOfMaintNotifCauses AS NumberOfMaintNotifCauses,
  I_DamageAnalysisCube.NumberOfMaintNotifObjectParts AS NumberOfMaintNotifObjectParts
FROM I_DamageAnalysisCube
;

Learn More