CDS标准视图：维护任务清单数据 I_MaintenanceTaskListData

• 视图名称：维护任务清单数据 I_MaintenanceTaskListData
• 视图类型：基础
• 视图代码：

点击查看代码

@AbapCatalog.sqlViewName: 'IPMTASKLISTDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Task List Data'

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'TaskListVersionCounter'
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions: true


@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true,
    delta.byElement: {
      name: 'LastChangeDateTime'
    }
  }
}

@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #XL
  }

}
@ObjectModel.modelingPattern:   #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #EXTRACTION_DATA_SOURCE ]
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_MaintenanceTaskListData
  as select from I_MaintenanceTaskList
  association [0..*] to I_EquipmentData          as _EquipmentData          on _EquipmentData.Equipment = $projection.Equipment
  association [0..1] to I_FunctionalLocationData as _FunctionalLocationData on _FunctionalLocationData.FunctionalLocation = $projection.FunctionalLocation
{
      @ObjectModel.foreignKey.association: '_TaskListType'
  key TaskListType,
      @ObjectModel.foreignKey.association: '_TaskListGroup'
  key TaskListGroup,
      @ObjectModel.foreignKey.association: '_TaskListGroupCounter'
  key TaskListGroupCounter,
      @ObjectModel.text.element: 'TaskListDesc'
  key TaskListVersionCounter,
      @Semantics.text: true
      TaskListDesc,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea,
      @ObjectModel.foreignKey.association: '_MaintenancePlanningPlant'
      MaintenancePlanningPlant,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_ResponsiblePlannerGroup'
      ResponsiblePlannerGroup,
      @ObjectModel.foreignKey.association: '_Assembly'
      Assembly,
      @ObjectModel.foreignKey.association: '_MaintenanceStrategy'
      MaintenanceStrategy,
      @ObjectModel.foreignKey.association: '_TaskListUsage'
      TaskListUsage,
      @ObjectModel.foreignKey.association: '_ConfigurableIndicator'
      BillOfOperationIsConfigurable,
      @ObjectModel.foreignKey.association: '_TaskListStatus'
      TaskListStatus,
      @ObjectModel.foreignKey.association: '_OperationSystemCondition'
      OperationSystemCondition,
      IsDeleted,
      IsMarkedForDeletion,

      ValidityStartDate,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,

      @ObjectModel.foreignKey.association: '_WorkCenter'
      _WorkCenter.WorkCenter,
      @ObjectModel.foreignKey.association: '_WorkCenterPlant'
      _WorkCenter.Plant  as WorkCenterPlant,
      @ObjectModel.foreignKey.association: '_EquipmentData'
      Equipment,
      @ObjectModel.foreignKey.association: '_FunctionalLocationData'
      FunctionalLocation,

      _Assembly,
      _ControllingArea,
      _Equipment,
      _EquipmentData,
      _FunctionalLocation,
      _FunctionalLocationData,
      _ConfigurableIndicator,
      _MaintenancePlanningPlant,
      _MaintenanceStrategy,
      _OperationSystemCondition,
      _Plant,
      _ResponsiblePlannerGroup,
      _TaskListStatus,
      _TaskListType,
      _TaskListGroup,
      _TaskListGroupCounter,
      _TaskListUsage,
      _WorkCenter._WorkCenter,
      _WorkCenter._Plant as _WorkCenterPlant
}

• 事务代码：IA03/IA09/IA13/IA07
  PM计划工厂、工作计划、状态、成本中心、维护工作中心、维护计划组、维护计划工厂、维护工厂、权限组

• 视图结构：

字段名称	技术名称
任务清单类型	TASKLISTTYPE
组	TASKLISTGROUP
组计数器	TASKLISTGROUPCOUNTER
计数器	TASKLISTVERSIONCOUNTER
描述	TASKLISTDESC
成本控制范围	CONTROLLINGAREA
计划工厂	MAINTENANCEPLANNINGPLANT
工厂	PLANT
计划人员组	RESPONSIBLEPLANNERGROUP
装配	ASSEMBLY
策略	MAINTENANCESTRATEGY
用途	TASKLISTUSAGE
可配套的	BILLOFOPERATIONISCONFIGURABLE
状态	TASKLISTSTATUS
系统条件	OPERATIONSYSTEMCONDITION
删除标识	ISDELETED
删除标记	ISMARKEDFORDELETION
有效期起始日期	VALIDITYSTARTDATE
创建日期	CREATIONDATE
更改于	LASTCHANGEDATE
时戳	LASTCHANGEDATETIME
工作中心	WORKCENTER
工厂	WORKCENTERPLANT
设备	EQUIPMENT
功能位置	FUNCTIONALLOCATION