I_MaintenanceJobOverallStatus

DDL: I_MAINTENANCEJOBOVERALLSTATUS SQL: IMTJOBOVRLSTS Type: view COMPOSITE

Overall Status of Maintenance Job

I_MaintenanceJobOverallStatus is a Composite CDS View that provides data about "Overall Status of Maintenance Job" in SAP S/4HANA. It reads from 2 data sources (P_MaintenanceJobOverallStatus, P_MaintenanceJobOverallStatus) and exposes 12 fields with key field MaintenanceJobInternalID. It has 3 associations to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
P_MaintenanceJobOverallStatus _MaintenanceJobOverallStatus left_outer
P_MaintenanceJobOverallStatus P_MaintenanceJobOverallStatus from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_EAMOverallStatus _OverallStatus _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _OverallStatus.EAMOverallStatus = $projection.EAMOverallObjectStatus
[0..1] I_EAMOverallStatusProfile _OverallStatusProfile _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
[0..*] I_MaintenanceJobAndWorkItem _MaintenanceJobWorkItem _MaintenanceJobWorkItem.MaintenanceJobInternalID = $projection.MaintenanceJobInternalID and _MaintenanceJobWorkItem.ObjectType = 'OVG'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMTJOBOVRLSTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Overall Status of Maintenance Job view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobInternalID P_MaintenanceJobOverallStatus MaintenanceJobInternalID
ObjectType P_MaintenanceJobOverallStatus ObjectType
StatusObject P_MaintenanceJobOverallStatus StatusObject
EAMOverallObjectStatusProfile P_MaintenanceJobOverallStatus EAMOverallObjectStatusProfile
EAMOverallObjectStatus
MaintenanceNotification
MaintenanceOrder P_MaintenanceJobOverallStatus MaintenanceOrder
_MaintenanceNotification
_MaintenanceOrder P_MaintenanceJobOverallStatus _MaintenanceOrder
_OverallStatus _OverallStatus
_OverallStatusProfile _OverallStatusProfile
_MaintenanceJobWorkItem _MaintenanceJobWorkItem 
@AbapCatalog.sqlViewName: 'IMTJOBOVRLSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Overall Status of Maintenance Job'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType.serviceQuality: #D,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #MIXED
}


define view I_MaintenanceJobOverallStatus
  as select from    P_MaintenanceJobOverallStatus
    left outer join P_MaintenanceJobOverallStatus as _MaintenanceJobOverallStatus on  _MaintenanceJobOverallStatus.MaintenanceJobInternalID = P_MaintenanceJobOverallStatus.MaintenanceJobInternalID
                                                                                  and _MaintenanceJobOverallStatus.EAMOverallStatusSequence > P_MaintenanceJobOverallStatus.EAMOverallStatusSequence
  association [0..1] to I_EAMOverallStatus          as _OverallStatus          on  _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
                                                                               and _OverallStatus.EAMOverallStatus        = $projection.EAMOverallObjectStatus

  association [0..1] to I_EAMOverallStatusProfile   as _OverallStatusProfile   on  _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile

  association [0..*] to I_MaintenanceJobAndWorkItem as _MaintenanceJobWorkItem on  _MaintenanceJobWorkItem.MaintenanceJobInternalID = $projection.MaintenanceJobInternalID
                                                                               and _MaintenanceJobWorkItem.ObjectType               = 'OVG'

{
  key P_MaintenanceJobOverallStatus.MaintenanceJobInternalID,

      P_MaintenanceJobOverallStatus.ObjectType, 
      P_MaintenanceJobOverallStatus.StatusObject, 

      P_MaintenanceJobOverallStatus.EAMOverallObjectStatusProfile,
      cast( P_MaintenanceJobOverallStatus.EAMOverallObjectStatus as eam_iwoc_overall_status ) as EAMOverallObjectStatus,

      -- For DCL
      @Consumption.hidden: true
      P_MaintenanceJobOverallStatus.MaintenanceNotification,
      @Consumption.hidden: true
      P_MaintenanceJobOverallStatus.MaintenanceOrder,

      -- For DCL
      P_MaintenanceJobOverallStatus._MaintenanceNotification,
      P_MaintenanceJobOverallStatus._MaintenanceOrder,

      _OverallStatus,
      _OverallStatusProfile,
      _MaintenanceJobWorkItem
}
where 
      _MaintenanceJobOverallStatus.MaintenanceJobInternalID       is null     
 and P_MaintenanceJobOverallStatus.EAMOverallObjectStatusProfile = 'MAINTJOB'

Learn More