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