CDS标准视图：维护计划数据 C_MaintenancePlanDEX

@AbapCatalog.sqlViewName: 'CMAINTPLANDEX'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Plan Data Extractor'

@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MaintenancePlanCycle'
@ObjectModel.semanticKey: [ 'MaintenancePlan','MaintenancePlanCycle' ]
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true

@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.byElement: {
      name: 'LastChangeDateTime'
    }
  }
}
@Analytics.internalName:#LOCAL
@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #S
  }
}
@AbapCatalog.preserveKey:true
@ObjectModel.modelingPattern:             #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #EXTRACTION_DATA_SOURCE ]

define view C_MaintenancePlanDEX
  as select from I_MaintenancePlanCycle
  association [1..1] to I_MaintenancePlanBasic as _MaintenancePlan          on $projection.MaintenancePlan = _MaintenancePlan.MaintenancePlan
  //                                                                               and $projection.MaintenancePlanCycle  = MaintenancePlanCycle
  -- Extensions, do not expose as association:
  association [0..1] to E_MaintenancePlan      as _MaintenancePlanExtension on $projection.MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan
{
      @ObjectModel.text.element: 'MaintenancePlanDesc'
      @ObjectModel.foreignKey.association: '_MaintenancePlan'
  key I_MaintenancePlanCycle.MaintenancePlan                                           as MaintenancePlan,
      //      @Analytics.internalName: #LOCAL
      //@ObjectModel.foreignKey.association: '_MaintenancePlanCycle'
  key I_MaintenancePlanCycle.MaintenancePlanCycle                                      as MaintenancePlanCycle,

      @Semantics.text: true
      _MaintenancePlan.MaintenancePlanDesc,

      @Semantics.systemDate.createdAt: true
      _MaintenancePlan.CreationDate,

      @Semantics.user.createdBy: true
      _MaintenancePlan.CreatedByUser,

      @Semantics.systemDate.lastChangedAt: true
      _MaintenancePlan.LastChangeDate,

      @Semantics.user.lastChangedBy: true
      _MaintenancePlan.LastChangedByUser,

      _MaintenancePlan.MaintenanceStrategy,

      _MaintenancePlan.SchedulingDuration,

      _MaintenancePlan.MaintPlanIsLockedAgainstCalls,

      _MaintenancePlan.NumberOfMaintenanceItems,

      _MaintenancePlan.MaintenanceCall,


      _MaintenancePlan.LateCompletionShiftInPercent,

      _MaintenancePlan.EarlyCompletionShiftInPercent,

      _MaintenancePlan.LateCompletionTolerancePercent,

      _MaintenancePlan.EarlyCompletionTolerancePct,

      _MaintenancePlan.CycleModificationRatio,

      _MaintenancePlan.MaintPlanSchedgIndicator,

      cast( _MaintenancePlan.CallHorizonPercent as callhorizonpercent preserving type) as CallHorizonPercent,

      cast( _MaintenancePlan.CallHorizonInDays as callhorizonindays preserving type)   as CallHorizonInDays,

      _MaintenancePlan.MaintenanceCallHorizonCalcType,


      _MaintenancePlan.MaintPlanLogicalOperatorCode,

      _MaintenancePlan.AuthorizationGroup,

      @ObjectModel.foreignKey.association: '_MaintenancePlanCatParam'
      _MaintenancePlan.MaintenancePlanCategory,

      _MaintenancePlan.SchedulingDurationUnit,

      _MaintenancePlan.BasicStartDate,

      //        @Semantics.quantity.unitOfMeasure: 'MaintSchedgStartCounterUnit'
      _MaintenancePlan.MaintPlanStartCntrReadingValue,

      //       @ObjectModel.foreignKey.association: '_MeasuringPoint._UnitOfMeasure'
      //        _MeasuringPoint.MeasurementRangeUnit as MaintSchedgStartCounterUnit,

      @Semantics.booleanIndicator
      _MaintenancePlan.PrdcssrCallObjCompltnIsRqd,

      _MaintenancePlan.MaintPlanFreeDefinedAttrib,

      _MaintenancePlan.FactoryCalendar,

      _MaintenancePlan.MaintenanceLeadFloatInDays,

      _MaintenancePlan.SchedulingStartDate,

      _MaintenancePlan.SchedulingStartTime,

      _MaintenancePlan.MultipleCounterPlanShiftFactor,


      //       @Semantics.quantity.unitOfMeasure: 'MaintSchedgEndCounterUnit'
      _MaintenancePlan.MaintPlanEndCntrReadingValue,

      //       @ObjectModel.foreignKey.association: '_MeasuringPoint._UnitOfMeasure'
      //        _MeasuringPoint.MeasurementRangeUnit as MaintSchedgEndCounterUnit,

      _MaintenancePlan.SchedulingEndDate,

      @Semantics.systemDateTime.lastChangedAt: true
      _MaintenancePlan.LastChangeDateTime,


      ComparisonOperator,

      @Semantics.quantity.unitOfMeasure: 'MaintPlanCycRcrrcIntervalUnit'
      MaintPlanCycRcrrcIntervalQty                                                     as MaintPlanCycRcrrcIntervalQty,

      //        @ObjectModel.foreignKey.association: '_UnitOfMeasure'

      //         @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      MaintPlanCycRcrrcIntervalUnit                                                    as MaintPlanCycRcrrcIntervalUnit,

      MaintPlanCycleDesc,

      @ObjectModel.foreignKey.association: '_Language'
      Language,

      //        @ObjectModel.foreignKey.association: '_MeasuringPoint'
      MeasuringPoint,

      MaintPlanCycleStartOffsetValue,

      @Semantics.booleanIndicator:true
      MaintenancePlanCycleIsInactive,

      CycleSetSequence,

      CycleSetSequenceRepeatFactor,

      /* Associations */
      _MaintenancePlan._MaintenancePlanCatParam,
      _UnitOfMeasure,
      _Language,
      _MeasuringPoint,
      _MaintenancePlan
}