C_MaintPlanSchedgOvwQuery

DDL: C_MAINTPLANSCHEDGOVWQUERY SQL: CMPSCHDOVWQRY Type: view CONSUMPTION
80 Fields 1 Data Sources

Maint Plan Scheduling Overview - Qry

C_MaintPlanSchedgOvwQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Asset Management

C_MaintPlanSchedgOvwQuery is a Consumption CDS View that provides data about "Maint Plan Scheduling Overview - Qry" in SAP S/4HANA. It reads from 1 data source (I_MaintPlanSchedgOverviewCube) and exposes 80 fields with key fields MaintenancePlan, MaintenancePlanCallNumber, MaintenanceItem.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryQuery
StatusSpecifies under which scheduling type the maintenance call is found and the current status of that call.
Corresponding DataSource2CCMPSCHDOVWQRY
Purpose
This CDS view allows you to generate a report of maintenance orders and maintenance notifications for a set of equipment, functional locations, or assemblies. With this CDS view, you can: View maintenance orders or maintenance notifications that are planned for the future through preventive maintenance plans. View maintenance calls that are planned for the future and for which call objects are yet to be generated through maintenance plans. Retrieve information to help you prepare for execution of planned maintenance orders. Analyze the details against a fixed set of measures against the call object status such as scheduled calls, calls on hold, calls that are locked, released, or completed. Use filters to retrieve specific information (for example, filter by maintenance plans that are defined for a specific set of equipment or functional locations). Use dimensions and measures to display information in your reports. Define variants for your reports. Export variants as tiles on the SAP Fiori Launchpad. Define custom fields and use them in the analytical query. For example, you can define a fixed set of codes as a code list (relevant for compliance or criticality) and generate a report of maintenance items and maintenance plans that are defined with these custom attributes. This CDS view provides the data to answer the following business questions: Where can you see a list of maintenance calls generated or to be generated for a given period? Where can you see a list of maintenance calls which are scheduled along with their call status? Where can you see the list of calls generated from a maintenance plan with their corresponding call objects which may be a maintenance order or a maintenance notification? How can you find the number of calls that are expected to be generated in future based on the scheduling period that you have maintained? Is there a way to find the variance between the planned date and the completion date for a list of maintenance plans? Can you find the total count of maintenance calls based upon their status (on hold, skipped, fixed, and so on)? How many maintenance calls have been generated? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have one of the following business catalogs assigned: Business catalog from the business role template SAP_BR_ANALYTICS_SPECIALIST SAP_CA_BC_ANA_AQD_PC SAP_CORE_BC_EXT_CCV Business catalog from the business role template SAP_BR_EMPLOYEE SAP_CA_BC_VDM_BROWSE Users who want to use this CDS view must have a role with the following restriction types set to read access: Display Maintenance Plan (IP03) Display Maintenance Plan (IP16) Scheduling Overview (IP24) Display Maintenance Item (IP06) Display Maintenance Item (IP18) Users who want to use this CDS view must have the following authorization objects assigned: I_BEGRP (PM: Authorization Group)

Structure
Fields Used for Filtering The main filters are as follows: MaintenancePlan MaintenanceItem MaintenancePlanCategory MaintenancePlanType MaintenancePlanSortField FunctionalLocation Equipment Class CompletionDate MaintenancePlannerGroup MaintenancePlanningPlant MaintenanceOrderType MaintenanceActivityType TaskListType TaskListGroup MaintenancePlant WorkCenter ABCIndicator CostCenter Further Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute MaintenancePlan Indicates the unique identifier of a maintenance plan. Attribute MaintenancePlanType Indicates the type of a maintenance plan. Attribute Maintenanc

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-MP
CapabilitiesAnalytical Query
PackageAsset Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view allows you to generate a report of maintenance orders and maintenance notifications for a set of equipment, functional locations, or assemblies. With this CDS view, you can:</p> <ul> <li><p>View maintenance orders or maintenance notifications that are planned for the future through preventive maintenance plans.</p></li> <li><p>View maintenance calls that are planned for the future and for which call objects are yet to be generated through maintenance plans.</p></li> <li><p>Retrieve information to help you prepare for execution of planned maintenance orders.</p></li> <li><p>Analyze the details against a fixed set of measures against the call object status such as scheduled calls, calls on hold, calls that are locked, released, or completed.</p></li> <li><p>Use filters to retrieve specific information (for example, filter by maintenance plans that are defined for a specific set of equipment or functional locations).</p></li> <li><p>Use dimensions and measures to display information in your reports.</p></li> <li><p>Define variants for your reports.</p></li> <li><p>Export variants as tiles on the SAP Fiori Launchpad.</p></li> <li><p>Define custom fields and use them in the analytical query. For example, you can define a fixed set of codes as a code list (relevant for compliance or criticality) and generate a report of maintenance items and maintenance plans that are defined with these custom attributes.</p></li> </ul> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Where can you see a list of maintenance calls generated or to be generated for a given period?</p></li> <li><p>Where can you see a list of maintenance calls which are scheduled along with their call status?</p></li> <li><p>Where can you see the list of calls generated from a maintenance plan with their corresponding call objects which may be a maintenance order or a maintenance notification?</p></li> <li><p>How can you find the number of calls that are expected to be generated in future based on the scheduling period that you have maintained?</p></li> <li><p>Is there a way to find the variance between the planned date and the completion date for a list of maintenance plans?</p></li> <li><p>Can you find the total count of maintenance calls based upon their status (on hold, skipped, fixed, and so on)?</p></li> <li><p>How many maintenance calls have been generated?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintPlanSchedgOverviewCube I_MaintPlanSchedgOverviewCube from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CMPSCHDOVWQRY view
EndUserText.label Maint Plan Scheduling Overview - Qry view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
OData.publish true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.internalName #LOCAL view

Fields (80)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan Maintenance Plan
KEY MaintenancePlanCallNumber MaintenancePlanCallNumber Maintenance Plan Call Number
KEY MaintenanceItem MaintenanceItem Maintenance item
NumberOfMaintenancePlanCalls NumberOfMaintenancePlanCalls Number of Maintenance Plan Calls
NrOfMrkdForDeltnMaintPlans NrOfMrkdForDeltnMaintPlans Number of Maintenance Plans Marked for Deletion
NrOfInactiveMaintenancePlans NrOfInactiveMaintenancePlans Number of inactive Maintenance Plans
NrOfScheduledMaintenancePlans NrOfScheduledMaintenancePlans Number of scheduled Maintenance Plans
NrOfCreatedMaintenancePlans NrOfCreatedMaintenancePlans Number of created Maintenance Plans
NrOfFixedMaintenancePlanCalls NrOfFixedMaintenancePlanCalls Number of fixed Maintenance Plan calls
NrOfSkippedMaintPlanCalls NrOfSkippedMaintPlanCalls Number of skipped Maintenance Plan calls
NrOfMnllyCalledMaintPlnCalls NrOfMnllyCalledMaintPlnCalls Number of manually called Maintenance Plan calls
NrOfCalledMaintenancePlanCalls NrOfCalledMaintenancePlanCalls Number of called Maintenance Plan calls
NrOfCompletedMaintPlanCalls NrOfCompletedMaintPlanCalls Number of completed Maintenance Plan calls
NrOfOnHoldMaintenancePlanCalls NrOfOnHoldMaintenancePlanCalls Number of on hold Maintenance Plan calls
NrOfInactiveMaintPlanCalls NrOfInactiveMaintPlanCalls Number of inactive Maintenance Plan calls
MaintenancePlanCategory MaintenancePlanCategory Maintenance plan category
MaintenancePlanType MaintenancePlanType Maintenance Plan Type
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
MaintenancePlanSortField MaintenancePlanSortField Sort field for maintenance plans
MaintenancePlanCycle MaintenancePlanCycle Counter in Control Tables
MeasuringPoint MeasuringPoint Measuring Point
MaintPlanActiveSystemStatus MaintPlanActiveSystemStatus Maintenance Plan Status
MaintenanceCallNextPlannedDate MaintenanceCallNextPlannedDate Next planned date
MaintenanceCallDate MaintenanceCallDate Call date
MaintenanceItemDescription MaintenanceItemDescription Item Short Text
FunctionalLocation FunctionalLocation Functional Location
FunctionalLocationObjectType FunctionalLocationObjectType Object Type of Functional Location
ConstructionMaterial ConstructionMaterial Construction type material of the object
Equipment Equipment Equipment Number
EquipmentObjectType EquipmentObjectType Object Type of Equipment
Class Class Class number
Assembly Assembly Pegged Reqmt
Material Material Material Number
SerialNumber SerialNumber Serial Number
MaintItemHasObjectList MaintItemHasObjectList Indicator if an Object List is linked to the Maint Item
MaintenanceOrder MaintenanceOrder Order Number
MaintenanceNotification MaintenanceNotification Notification Number
ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
RevisionNumber RevisionNumber Revision Number
PlannedStartDate PlannedStartDate Basic start date
LatestAcceptableCompletionDate LatestAcceptableCompletionDate Final Due Date
CompletionDate CompletionDate Completion Date for Call Object
CompletionTime CompletionTime Completion Time for Call Object
MaintCallHorizonIsNotReached MaintCallHorizonIsNotReached Scheduling status: call horizon not reached
MaintenancePlanCallStatus MaintenancePlanCallStatus Maintenance Plan Call Status
ReleasedByUserName ReleasedByUserName Scheduling determined by user
ServiceOrder ServiceOrder Transaction ID
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group for Customer Service and Plant Maintenance
MaintenancePlanningPlant MaintenancePlanningPlant Maintenance Planning Plant
BusinessArea BusinessArea Business Area
MaintenanceOrderType MaintenanceOrderType Order Type
NotificationType NotificationType Notification Type
MaintenanceActivityType MaintenanceActivityType Maintenance Activity Type
MainWorkCenterInternalID MainWorkCenterInternalID Object ID of the Work Center
MainWorkCenter MainWorkCenter Main Work Center
TaskListType TaskListType Task List Type
TaskListGroup TaskListGroup Key for Task List Group
TaskListGroupCounter TaskListGroupCounter Group Counter
PurchaseOrder PurchaseOrder Purchase order number
PurchaseOrderItem PurchaseOrderItem Purchase order item number
MaintenancePlant MaintenancePlant Maintenance Plant
AssetLocation AssetLocation Location of maintenance object
AssetRoom AssetRoom Room
PlantSection PlantSection Plant Section
WorkCenter WorkCenter Work Center
ABCIndicator ABCIndicator ABC Indicator for Technical Object
MaintObjectFreeDefinedAttrib MaintObjectFreeDefinedAttrib Location Sort Field
CompanyCode CompanyCode Receiver Company Code
MasterFixedAsset MasterFixedAsset Main Asset Number
FixedAsset FixedAsset Asset Subnumber
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
WBSElementExternalID WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited
StandingOrderNumber StandingOrderNumber Standing order number
SalesDocument SalesDocument Sales Document
SalesDocumentItem SalesDocumentItem Sales Document Item
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
OrganizationDivision OrganizationDivision Org. Division
AuthorizationGroup AuthorizationGroup Technical Object Authorization Group

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_MaintPlanSchedgOvwQuery.
-- 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: CMPSCHDOVWQRY

CREATE VIEW C_MaintPlanSchedgOvwQuery AS
SELECT
  MaintenancePlan,
  MaintenancePlanCallNumber,
  MaintenanceItem,
  NumberOfMaintenancePlanCalls,
  NrOfMrkdForDeltnMaintPlans,
  NrOfInactiveMaintenancePlans,
  NrOfScheduledMaintenancePlans,
  NrOfCreatedMaintenancePlans,
  NrOfFixedMaintenancePlanCalls,
  NrOfSkippedMaintPlanCalls,
  NrOfMnllyCalledMaintPlnCalls,
  NrOfCalledMaintenancePlanCalls,
  NrOfCompletedMaintPlanCalls,
  NrOfOnHoldMaintenancePlanCalls,
  NrOfInactiveMaintPlanCalls,
  MaintenancePlanCategory,
  MaintenancePlanType,
  MaintenanceStrategy,
  MaintenancePlanSortField,
  MaintenancePlanCycle,
  MeasuringPoint,
  MaintPlanActiveSystemStatus,
  MaintenanceCallNextPlannedDate,
  MaintenanceCallDate,
  MaintenanceItemDescription,
  FunctionalLocation,
  FunctionalLocationObjectType,
  ConstructionMaterial,
  Equipment,
  EquipmentObjectType,
  Class,
  Assembly,
  Material,
  SerialNumber,
  MaintItemHasObjectList,
  MaintenanceOrder,
  MaintenanceNotification,
  ServiceEntrySheet,
  RevisionNumber,
  PlannedStartDate,
  LatestAcceptableCompletionDate,
  CompletionDate,
  CompletionTime,
  MaintCallHorizonIsNotReached,
  MaintenancePlanCallStatus,
  ReleasedByUserName,
  ServiceOrder,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  BusinessArea,
  MaintenanceOrderType,
  NotificationType,
  MaintenanceActivityType,
  MainWorkCenterInternalID,
  MainWorkCenter,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  PurchaseOrder,
  PurchaseOrderItem,
  MaintenancePlant,
  AssetLocation,
  AssetRoom,
  PlantSection,
  WorkCenter,
  ABCIndicator,
  MaintObjectFreeDefinedAttrib,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ControllingArea,
  CostCenter,
  WBSElementExternalID,
  StandingOrderNumber,
  SalesDocument,
  SalesDocumentItem,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  AuthorizationGroup
FROM I_MaintPlanSchedgOverviewCube
;

Learn More