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

  • 视图名称:维护计划数据 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
}
  • 事务代码:IP03

  • 视图结构:

字段名称 设备名称
维护计划 MAINTENANCEPLAN
计数器 MAINTENANCEPLANCYCLE
维护计划文本 MAINTENANCEPLANDESC
创建日期 CREATIONDATE
创建人 CREATEDBYUSER
更改日期 LASTCHANGEDATE
更改人 LASTCHANGEDBYUSER
策略 MAINTENANCESTRATEGY
计划期间 SCHEDULINGDURATION
已锁定 MAINTPLANISLOCKEDAGAINSTCALLS
项目号 NUMBEROFMAINTENANCEITEMS
调用号 MAINTENANCECALL
晚期完全 LATECOMPLETIONSHIFTINPERCENT
早期完全 EARLYCOMPLETIONSHIFTINPERCENT
允差(+) LATECOMPLETIONTOLERANCEPERCENT
允差(-) EARLYCOMPLETIONTOLERANCEPCT
周期修改系数 CYCLEMODIFICATIONRATIO
计划标识 MAINTPLANSCHEDGINDICATOR
维护计划调用的调用区间(百分比) CALLHORIZONPERCENT
维护计划调用的调用区间(天) CALLHORIZONINDAYS
计算类型 MAINTENANCECALLHORIZONCALCTYPE
工序类型 MAINTPLANLOGICALOPERATORCODE
授权组 AUTHORIZATIONGROUP
维护计划类型 MAINTENANCEPLANCATEGORY
计划间隔的单位 SCHEDULINGDURATIONUNIT
周期起始 BASICSTARTDATE
结构计数器读数 MAINTPLANSTARTCNTRREADINGVALUE
完成要求 PRDCSSRCALLOBJCOMPLTNISRQD
分类字段 MAINTPLANFREEDEFINEDATTRIB
工厂日历 FACTORYCALENDAR
提前缓冲 MAINTENANCELEADFLOATINDAYS
开始日期 SCHEDULINGSTARTDATE
开始时间 SCHEDULINGSTARTTIME
班次因子 MCP MULTIPLECOUNTERPLANSHIFTFACTOR
结束计数器 MAINTPLANENDCNTRREADINGVALUE
计划结束日期 SCHEDULINGENDDATE
时戳 LASTCHANGEDATETIME
关系运算符 COMPARISONOPERATOR
维护包周期 MAINTPLANCYCRCRRCINTERVALQTY
单位 MAINTPLANCYCRCRRCINTERVALUNIT
周期正文 MAINTPLANCYCLEDESC
主要语言 LANGUAGE
测量点 MEASURINGPOINT
时间偏置 MAINTPLANCYCLESTARTOFFSETVALUE
未激活 MAINTENANCEPLANCYCLEISINACTIVE
循环集顺序 CYCLESETSEQUENCE
重复因子集 CYCLESETSEQUENCEREPEATFACTOR

作者:观兴

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

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

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

posted @   观兴  阅读(5)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 推荐几款开源且免费的 .NET MAUI 组件库
· 实操Deepseek接入个人知识库
· 易语言 —— 开山篇
· 一个费力不讨好的项目,让我损失了近一半的绩效!
more_horiz
keyboard_arrow_up dark_mode palette
选择主题
点击右上角即可分享
微信分享提示