C_LocationAnalysisQuery

DDL: C_LOCATIONANALYSISQUERY SQL: CLOCANALYQUERY Type: view CONSUMPTION
52 Fields 1 Data Sources

Location Analysis Query

C_LocationAnalysisQuery is a Consumption CDS View that provides data about "Location Analysis Query" in SAP S/4HANA. It reads from 1 data source (I_LocationAnalysisCube) and exposes 52 fields with key field MaintenanceNotification.

Data Sources (1)

SourceAliasJoin Type
I_LocationAnalysisCube I_LocationAnalysisCube from

Annotations (12)

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

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification I_LocationAnalysisCube MaintenanceNotification Notification
NotificationText I_LocationAnalysisCube NotificationText Description
MaintenancePlant I_LocationAnalysisCube MaintenancePlant Plant
PlantSection I_LocationAnalysisCube PlantSection Plant Section
NotificationType I_LocationAnalysisCube NotificationType Notifictn Type
NotifProcessingPhase I_LocationAnalysisCube NotifProcessingPhase Notif. Phase
MaintenancePlanningPlant I_LocationAnalysisCube MaintenancePlanningPlant Planning Plant
MaintPriority I_LocationAnalysisCube MaintPriority Priority
MaintPriorityType I_LocationAnalysisCube MaintPriorityType PriorityType
BusinessArea I_LocationAnalysisCube BusinessArea Business Area
Assembly I_LocationAnalysisCube Assembly Pegged Reqmt
MaintenancePlannerGroup I_LocationAnalysisCube MaintenancePlannerGroup Planner Group
MaintenanceObjectIsDown I_LocationAnalysisCube MaintenanceObjectIsDown Breakdown
MainWorkCenter I_LocationAnalysisCube MainWorkCenter Work Center
WorkCenter I_LocationAnalysisCube WorkCenter Work Center
AssetLocation I_LocationAnalysisCube AssetLocation Location
AssetRoom I_LocationAnalysisCube AssetRoom Room
ABCIndicator I_LocationAnalysisCube ABCIndicator ABC Indicator
MaintObjectFreeDefinedAttrib I_LocationAnalysisCube MaintObjectFreeDefinedAttrib Sort Field
CostCenter I_LocationAnalysisCube CostCenter Cost Center
ControllingArea I_LocationAnalysisCube ControllingArea Controlling Area
CompanyCode I_LocationAnalysisCube CompanyCode Receiver Company Code
WBSElementInternalID I_LocationAnalysisCube WBSElementInternalID WBS Internal ID
CreationDate I_LocationAnalysisCube CreationDate Time Stamp
LastChangeDate I_LocationAnalysisCube LastChangeDate Time Stamp
NotificationCreationDate I_LocationAnalysisCube NotificationCreationDate Notif. Date
NotificationReferenceDate I_LocationAnalysisCube NotificationReferenceDate Reference Date
RequiredStartDate I_LocationAnalysisCube RequiredStartDate Req. Start Date
RequiredEndDate I_LocationAnalysisCube RequiredEndDate Req. End Date
MalfunctionStartDate I_LocationAnalysisCube MalfunctionStartDate Malfunct. Start
MalfunctionEndDate I_LocationAnalysisCube MalfunctionEndDate Malfunct. End
CreatedByUser I_LocationAnalysisCube CreatedByUser User Name
LastChangedByUser I_LocationAnalysisCube LastChangedByUser User Name
ReportedByUser I_LocationAnalysisCube ReportedByUser Reported By
TechnicalObjectLabel I_LocationAnalysisCube TechnicalObjectLabel Tech. Object
TechObjIsEquipOrFuncnlLoc I_LocationAnalysisCube TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
AuthorizationGroup I_LocationAnalysisCube AuthorizationGroup AuthorizGroup
TechnicalObjectType I_LocationAnalysisCube TechnicalObjectType Text object
AssetManufacturerName I_LocationAnalysisCube AssetManufacturerName Manufacturer
ManufacturerPartTypeName I_LocationAnalysisCube ManufacturerPartTypeName Model number
ManufacturerCountry I_LocationAnalysisCube ManufacturerCountry Mnf. Cntry/Regn
ConstructionYear I_LocationAnalysisCube ConstructionYear
ConstructionMonth I_LocationAnalysisCube ConstructionMonth
Equipment I_LocationAnalysisCube Equipment Equipment check
FunctionalLocation I_LocationAnalysisCube FunctionalLocation Object ID
CatalogProfile I_LocationAnalysisCube CatalogProfile Catalog Profile
NumberOfCreatedMaintNotifs I_LocationAnalysisCube NumberOfCreatedMaintNotifs
NumberOfReportedBreakdowns I_LocationAnalysisCube NumberOfReportedBreakdowns
NumberOfCreatedMaintOrders I_LocationAnalysisCube NumberOfCreatedMaintOrders
NumberOfCompletedMaintNotif I_LocationAnalysisCube NumberOfCompletedMaintNotif
NmbrOfDeltdMaintNotifications I_LocationAnalysisCube NmbrOfDeltdMaintNotifications
NmbrOfOpenMaintNotifications I_LocationAnalysisCube NmbrOfOpenMaintNotifications Open Notifications

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_LocationAnalysisQuery.
-- 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: CLOCANALYQUERY

CREATE VIEW C_LocationAnalysisQuery AS
SELECT
  I_LocationAnalysisCube.MaintenanceNotification AS MaintenanceNotification,
  I_LocationAnalysisCube.NotificationText AS NotificationText,
  I_LocationAnalysisCube.MaintenancePlant AS MaintenancePlant,
  I_LocationAnalysisCube.PlantSection AS PlantSection,
  I_LocationAnalysisCube.NotificationType AS NotificationType,
  I_LocationAnalysisCube.NotifProcessingPhase AS NotifProcessingPhase,
  I_LocationAnalysisCube.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_LocationAnalysisCube.MaintPriority AS MaintPriority,
  I_LocationAnalysisCube.MaintPriorityType AS MaintPriorityType,
  I_LocationAnalysisCube.BusinessArea AS BusinessArea,
  I_LocationAnalysisCube.Assembly AS Assembly,
  I_LocationAnalysisCube.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_LocationAnalysisCube.MaintenanceObjectIsDown AS MaintenanceObjectIsDown,
  I_LocationAnalysisCube.MainWorkCenter AS MainWorkCenter,
  I_LocationAnalysisCube.WorkCenter AS WorkCenter,
  I_LocationAnalysisCube.AssetLocation AS AssetLocation,
  I_LocationAnalysisCube.AssetRoom AS AssetRoom,
  I_LocationAnalysisCube.ABCIndicator AS ABCIndicator,
  I_LocationAnalysisCube.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  I_LocationAnalysisCube.CostCenter AS CostCenter,
  I_LocationAnalysisCube.ControllingArea AS ControllingArea,
  I_LocationAnalysisCube.CompanyCode AS CompanyCode,
  I_LocationAnalysisCube.WBSElementInternalID AS WBSElementInternalID,
  I_LocationAnalysisCube.CreationDate AS CreationDate,
  I_LocationAnalysisCube.LastChangeDate AS LastChangeDate,
  I_LocationAnalysisCube.NotificationCreationDate AS NotificationCreationDate,
  I_LocationAnalysisCube.NotificationReferenceDate AS NotificationReferenceDate,
  I_LocationAnalysisCube.RequiredStartDate AS RequiredStartDate,
  I_LocationAnalysisCube.RequiredEndDate AS RequiredEndDate,
  I_LocationAnalysisCube.MalfunctionStartDate AS MalfunctionStartDate,
  I_LocationAnalysisCube.MalfunctionEndDate AS MalfunctionEndDate,
  I_LocationAnalysisCube.CreatedByUser AS CreatedByUser,
  I_LocationAnalysisCube.LastChangedByUser AS LastChangedByUser,
  I_LocationAnalysisCube.ReportedByUser AS ReportedByUser,
  I_LocationAnalysisCube.TechnicalObjectLabel AS TechnicalObjectLabel,
  I_LocationAnalysisCube.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_LocationAnalysisCube.AuthorizationGroup AS AuthorizationGroup,
  I_LocationAnalysisCube.TechnicalObjectType AS TechnicalObjectType,
  I_LocationAnalysisCube.AssetManufacturerName AS AssetManufacturerName,
  I_LocationAnalysisCube.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_LocationAnalysisCube.ManufacturerCountry AS ManufacturerCountry,
  I_LocationAnalysisCube.ConstructionYear AS ConstructionYear,
  I_LocationAnalysisCube.ConstructionMonth AS ConstructionMonth,
  I_LocationAnalysisCube.Equipment AS Equipment,
  I_LocationAnalysisCube.FunctionalLocation AS FunctionalLocation,
  I_LocationAnalysisCube.CatalogProfile AS CatalogProfile,
  I_LocationAnalysisCube.NumberOfCreatedMaintNotifs AS NumberOfCreatedMaintNotifs,
  I_LocationAnalysisCube.NumberOfReportedBreakdowns AS NumberOfReportedBreakdowns,
  I_LocationAnalysisCube.NumberOfCreatedMaintOrders AS NumberOfCreatedMaintOrders,
  I_LocationAnalysisCube.NumberOfCompletedMaintNotif AS NumberOfCompletedMaintNotif,
  I_LocationAnalysisCube.NmbrOfDeltdMaintNotifications AS NmbrOfDeltdMaintNotifications,
  I_LocationAnalysisCube.NmbrOfOpenMaintNotifications AS NmbrOfOpenMaintNotifications
FROM I_LocationAnalysisCube
;

Learn More