I_MaintenancePlanSchedule

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IMPLASCHED'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Scheduled calls for Maintenance Plan'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  modelingPattern:  #NONE,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE],
  semanticKey:  [ 'MaintenancePlan','MaintenancePlanCallNumber' ],
    usageType: {
        dataClass: #MASTER,
        serviceQuality: #C,
        sizeCategory: #M
    }
}
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey: true

define view I_MaintenancePlanSchedule
  as select from I_MaintPlanCallHistory

  association [0..1] to I_MaintCallSchedulingType      as _SchedulingType           on  _SchedulingType.SchedulingType = $projection.SchedulingType

  association [0..1] to P_MaintenanceSingleCycle       as _MaintenanceSingleCycle   on  _MaintenanceSingleCycle.MaintenancePlan = $projection.MaintenancePlan

  association [0..1] to I_UnitOfMeasure                as _MaintTaskPerformanceUnit on  _MaintTaskPerformanceUnit.UnitOfMeasure = $projection.MaintenanceTaskPerformanceUnit

  association [0..1] to P_MaintCallCompltnDateTime     as _MaintCallCompltnDateTime on  _MaintCallCompltnDateTime.MaintenancePlan = $projection.MaintenancePlan
                                                                                    and _MaintCallCompltnDateTime.MaintenanceCall = $projection.MaintenancePlanCallNumber

  association [1..1] to I_MaintenancePlanBasic         as _MaintenancePlan          on  _MaintenancePlan.MaintenancePlan = $projection.MaintenancePlan
  association [1..*] to I_MaintPlanCallHrznCalcTypeTxt as _CallHrznCalcTypeTxt      on  _CallHrznCalcTypeTxt.MaintenanceCallHorizonCalcType = $projection.MaintenanceCallHorizonCalcType

{
  @ObjectModel.foreignKey.association: '_MaintenancePlan'  
  key MaintenancePlan,

  key MaintenancePlanCallNumber,
  key MaintenancePackage,

      MaintenanceStrategy                             as MaintenanceStrategy,
      @ObjectModel.foreignKey.association: '_SchedulingType'
      SchedulingType                                  as SchedulingType,

      SchedulingStatus                                as SchedulingStatus,

      _MaintenanceSingleCycle.MeasuringPoint          as MeasuringPoint,

      @ObjectModel.foreignKey.association: '_MaintTaskPerformanceUnit'
      case _MaintenanceSingleCycle.MaintenanceTaskPerformanceUnit
          when '' then _MaintenancePackage.MaintenanceTaskPerformanceUnit
          else _MaintenanceSingleCycle.MaintenanceTaskPerformanceUnit
      end                                             as MaintenanceTaskPerformanceUnit,

      MaintenanceCallNextPlannedDate                  as MaintenanceCallNextPlannedDate,

      MaintenanceCallDate                             as MaintenanceCallDate,


      case CompletionDate
        when '00000000' then _MaintCallCompltnDateTime.CompletionDate
        else CompletionDate
       end                                            as CompletionDate,

      _MaintCallCompltnDateTime.CompletionTime        as CompletionTime,

      CycleSetSequence                                as CycleSetSequence,
      

      MaintCallCompltnCntrRdng                        as MaintCallCompltnCntrRdng,
      
      @Semantics.quantity.unitOfMeasure: 'MaintenanceTaskPerformanceUnit'
      MaintCallNextPlndCntrRdng                       as MaintCallNextPlndCntrRdng,

      MaintenanceCallIsOutstanding                    as MaintenanceCallIsOutstanding,

      MaintCallIsInvokedOnPlndDate                    as MaintCallIsInvokedOnPlndDate,

      MaintCallHorizonIsNotReached                    as MaintCallHorizonIsNotReached,

      MaintPlanLastScheduledDate                      as MaintPlanLastScheduledDate,

      ReleasedByUserName,

      cast ('' as abap.char(256) )                    as MaintPlnCnctntdDuePackagesTxt,
      _MaintenancePlan.MaintenanceCallHorizonCalcType as MaintenanceCallHorizonCalcType,

      MaintPlanPrdcssrCallCompltnDte,

      MaintenancePlanManualCallDate,     
      
      MaintenanceCallLastPlannedDate, 
      

      /* Associations - locally defined */
      _MaintenancePlan,
      _SchedulingType,
      _MaintTaskPerformanceUnit,
      _ReleasedByUserName,
      _CallHrznCalcTypeTxt,
      _MaintenancePackage
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEPACKAGE",
"I_MAINTENANCEPLANBASIC",
"I_MAINTPLANCALLHISTORY",
"P_MAINTCALLCOMPLTNDATETIME",
"P_MAINTENANCESINGLECYCLE"
],
"ASSOCIATED":
[
"I_MAINTCALLSCHEDULINGTYPE",
"I_MAINTENANCEPACKAGE",
"I_MAINTENANCEPLANBASIC",
"I_MAINTPLANCALLHRZNCALCTYPETXT",
"I_UNITOFMEASURE",
"I_USER",
"P_MAINTCALLCOMPLTNDATETIME",
"P_MAINTENANCESINGLECYCLE"
],
"BASE":
[
"I_MAINTPLANCALLHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/