CDS标准视图:安排维护计划的调用 I_MAINTENANCEPLANSCHEDULE

视图名称:安排维护计划的调用 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,


      /* Associations - locally defined */
      _MaintenancePlan,
      _SchedulingType,
      _MaintTaskPerformanceUnit,
      _ReleasedByUserName,
      _CallHrznCalcTypeTxt,
      _MaintenancePackage
}

事务代码:#

视图结构:#

字段名称 技术名称
维护计划 MAINTENANCEPLAN
调用号 MAINTENANCEPLANCALLNUMBER
维护包 MAINTENANCEPACKAGE
策略 MAINTENANCESTRATEGY
计划类型 SCHEDULINGTYPE
计划状态 SCHEDULINGSTATUS
测量点 MEASURINGPOINT
单位 MAINTENANCETASKPERFORMANCEUNIT
计划日期 MAINTENANCECALLNEXTPLANNEDDATE
调用日期 MAINTENANCECALLDATE
最后完成 COMPLETIONDATE
COMPLETIONTIME
循环集顺序 CYCLESETSEQUENCE
公司确认的读数 MAINTCALLCOMPLTNCNTRRDNG
TL 计数器 MAINTCALLNEXTPLNDCNTRRDNG
计划状态 MAINTENANCECALLISOUTSTANDING
计划状态 MAINTCALLISINVOKEDONPLNDDATE
计划状态 MAINTCALLHORIZONISNOTREACHED
调用日期 MAINTPLANLASTSCHEDULEDDATE
名称 RELEASEDBYUSERNAME
MAINTPLNCNCTNTDDUEPACKAGESTXT
计算类型 MAINTENANCECALLHORIZONCALCTYPE
前趋完成 MAINTPLANPRDCSSRCALLCOMPLTNDTE
手工调用 MAINTENANCEPLANMANUALCALLDATE

作者:观兴

出处:https://www.cnblogs.com/guanxing/p/18659214

版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。

转载需本人同意,未经同意转载视同接受稿费2元/字

posted @   观兴  阅读(40)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· DeepSeek “源神”启动!「GitHub 热点速览」
· 我与微信审核的“相爱相杀”看个人小程序副业
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
· 上周热点回顾(2.17-2.23)
more_horiz
keyboard_arrow_up dark_mode palette
选择主题
menu
点击右上角即可分享
微信分享提示