I_MaintenanceCall

DDL: I_MAINTENANCECALL SQL: IMAINTENANCECALL Type: view BASIC

Maintenance Call

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.

1 data source(s) 18 fields

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
KEY MaintenanceCall mhio abnum
KEY MaintenanceItem mhio wppos
MaintenanceOrder mhio aufnr
MaintenanceNotification mhio qmnum
MaintCallHorizonIsNotReached mhio tsenq
SchedulingStatus mhio tstat
CompletionDate mhio addat
CompletionTime mhio adtime
PlannedStartDate mhio gstrp
ReleasedByUserName mhio usermod
ServiceOrder mhio service_order
_MaintenancePlan _MaintenancePlan
_MaintenanceItem _MaintenanceItem
_MaintenanceOrder _MaintenanceOrder
_MaintenanceNotification _MaintenanceNotification
_MaintPlanCallHistory _MaintPlanCallHistory
_ServiceOrder _ServiceOrder 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMAINTENANCECALL'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Maintenance Call'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: [ 'MaintenanceCall' ]
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE 

define view I_MaintenanceCall
  as select from mhio

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

      @ObjectModel.foreignKey.association: '_MaintenancePlan'
  key mhio.warpl         as MaintenancePlan,

  key mhio.abnum         as MaintenanceCall,

      @ObjectModel.foreignKey.association: '_MaintenanceItem'
  key mhio.wppos         as MaintenanceItem,

      @ObjectModel.foreignKey.association: '_MaintenanceOrder'
      mhio.aufnr         as MaintenanceOrder,

      @ObjectModel.foreignKey.association: '_MaintenanceNotification'
      mhio.qmnum         as MaintenanceNotification,

      mhio.tsenq         as MaintCallHorizonIsNotReached,

      mhio.tstat         as SchedulingStatus,

      mhio.addat         as CompletionDate,

      mhio.adtime        as CompletionTime,

//      @Semantics.calendarItem.dtStart: true

      mhio.gstrp         as PlannedStartDate,

      mhio.usermod       as ReleasedByUserName,

      @ObjectModel.foreignKey.association: '_ServiceOrder'
      mhio.service_order as ServiceOrder,

      _MaintenancePlan,
      _MaintenanceItem,
      _MaintenanceOrder,
      _MaintenanceNotification,
      _MaintPlanCallHistory,
      _ServiceOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MHIO"
],
"ASSOCIATED":
[
"I_MAINTENANCEITEM",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDER",
"I_MAINTENANCEPLAN",
"I_MAINTPLANCALLHISTORY",
"I_SERVICEORDERENHCD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More