I_MaintenanceCall

DDL: I_MAINTENANCECALL SQL: IMAINTENANCECALL Type: view BASIC
18 Fields 1 Data Sources 6 Associations

Maintenance Call

I_MaintenanceCall (Basic)

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

Asset Management

I_MaintenanceCall is a Basic CDS View that provides data about "Maintenance Call" in SAP S/4HANA. It reads from 1 data source (mhio) and exposes 18 fields with key fields MaintenancePlan, MaintenanceCall, MaintenanceItem. It has 6 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
StatusScheduling status
Purpose
This CDS view is designed to provide a comprehensive overview of maintenance calls within an organization. It integrates various aspects of maintenance operations, including plans, items, orders, notifications, and service orders, allowing users to access detailed information about each maintenance call and its associated elements. This CDS view provides the data to answer the following business questions: What are the details of each maintenance call, including the associated maintenance plan, item, order, and notification? Has the maintenance call horizon been reached, and what is the current scheduling status? When is the planned start date for each maintenance call, and who released it? What is the completion date and time for each maintenance call? How can historical data related to maintenance plan calls be accessed for analysis and reporting purposes? 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 a role with the following restriction types set to read access: BEGRP These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description RELEASEDBYUSERNAME User scheduling MAINTCALLHORIZONISNOTREACHED Scheduling status SCHEDULINGSTATUS Scheduling status PLANNEDSTARTDATE Basic start date COMPLETIONDATE Completion Date MAINTENANCECALL MntPlan Call No. COMPLETIONTIME Completion Time MAINTENANCEORDER Order SERVICEORDER Transaction ID MAINTENANCENOTIFICATION Notification MAINTENANCEPLAN Maintenance Plan MAINTENANCEITEM Maintenance Item

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-TL
CapabilitiesData Source for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
mhio mhio from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_MaintenancePlan _MaintenancePlan _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
[0..1] I_MaintenanceItem _MaintenanceItem _MaintenanceItem.MaintenanceItem = $projection.MaintenanceItem
[0..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
[0..1] I_MaintenanceNotification _MaintenanceNotification _MaintenanceNotification.MaintenanceNotification = $projection.MaintenanceNotification
[0..1] I_ServiceOrderEnhcd _ServiceOrder _ServiceOrder.ServiceOrder = $projection.ServiceOrder
[0..*] I_MaintPlanCallHistory _MaintPlanCallHistory _MaintPlanCallHistory.MaintenancePlan = $projection.MaintenancePlan and _MaintPlanCallHistory.MaintenancePlanCallNumber = $projection.MaintenanceCall

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IMAINTENANCECALL view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Maintenance Call view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan mhio warpl Maintenance Plan
KEY MaintenanceCall mhio abnum Maintenance Plan Call Number
KEY MaintenanceItem mhio wppos Maintenance item
MaintenanceOrder mhio aufnr SettlementOrder
MaintenanceNotification mhio qmnum Notification Number
MaintCallHorizonIsNotReached mhio tsenq Scheduling status: call horizon not reached
SchedulingStatus mhio tstat Scheduling status
CompletionDate mhio addat Completion Date for Call Object
CompletionTime mhio adtime Completion Time for Call Object
PlannedStartDate mhio gstrp Basic start date
ReleasedByUserName mhio usermod Scheduling determined by user
ServiceOrder mhio service_order Transaction ID
_MaintenancePlan _MaintenancePlan
_MaintenanceItem _MaintenanceItem
_MaintenanceOrder _MaintenanceOrder
_MaintenanceNotification _MaintenanceNotification
_MaintPlanCallHistory _MaintPlanCallHistory
_ServiceOrder _ServiceOrder

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_MaintenanceCall.
-- 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: IMAINTENANCECALL

CREATE VIEW I_MaintenanceCall AS
SELECT
  mhio.warpl AS MaintenancePlan,
  mhio.abnum AS MaintenanceCall,
  mhio.wppos AS MaintenanceItem,
  mhio.aufnr AS MaintenanceOrder,
  mhio.qmnum AS MaintenanceNotification,
  mhio.tsenq AS MaintCallHorizonIsNotReached,
  mhio.tstat AS SchedulingStatus,
  mhio.addat AS CompletionDate,
  mhio.adtime AS CompletionTime,
  mhio.gstrp AS PlannedStartDate,
  mhio.usermod AS ReleasedByUserName,
  mhio.service_order AS ServiceOrder
FROM mhio
LEFT OUTER JOIN I_MaintenancePlan AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON _MaintenanceItem.MaintenanceItem = MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_ServiceOrderEnhcd AS _ServiceOrder ON _ServiceOrder.ServiceOrder = ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanCallHistory AS _MaintPlanCallHistory ON _MaintPlanCallHistory.MaintenancePlan = MaintenancePlan AND _MaintPlanCallHistory.MaintenancePlanCallNumber = MaintenanceCall  -- association [0..*]
;

Learn More