CDS标准视图：分配到任务清单的维护包数据 I_PckgTaskListOpalLocData

• 视图名称：分配到任务清单的维护包数据 I_PckgTaskListOpalLocData
• 视图类型：基础
• 视图代码：

点击查看代码

@AbapCatalog.sqlViewName: 'IPCKTLOPALCDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allocation of Maint Packages to Task List Operations Data'

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

@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction: {
    enabled: true
  }
}

@ObjectModel: {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
//      serviceQuality: #C,
    sizeCategory: #M
  }
}

@ObjectModel.modelingPattern:   #EXTRACTION_DATA_SOURCE
@ObjectModel.supportedCapabilities:     [ #EXTRACTION_DATA_SOURCE ]
define view I_PckgTaskListOpAllocData
  as select from I_MaintPckgTaskListOpAlloc
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key TaskListType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key TaskListGroup,

      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key TaskListGroupCounter,

      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key Sequence,

      @ObjectModel.foreignKey.association: '_BillOfOperationsOperation'
  key TaskListOperationInternalId,

      @ObjectModel.foreignKey.association: '_MaintenancePackage'
  key MaintenancePackage,

  key MaintPckgTskListOpAllocIntNmbr,

      ValidityStartDate,

      MaintenancePackageIsRequired,

      AllocIsMaintainedByMaintPlan,

      IsDeleted,

      MaintenanceStrategy,

      AllocationHasInactiveChanges,

      @ObjectModel.foreignKey.association: '_ChangeNumber'
      ChangeNumber,

      CreationDate,

      CreatedByUser,

      LastChangeDate,

      LastChangedByUser,

//      _MaintenanceTaskList.Plant as Plant,
//      _MaintenanceTaskList.TaskListStatus as TaskListStatus,
//      _MaintenanceTaskList.ResponsiblePlannerGroup as ResponsiblePlannerGroup,
//      _MaintenanceTaskList._TechnicalObject.AuthorizationGroup as AuthorizationGroup,
//      _MaintenanceTaskList._TechnicalObject.MaintenancePlanningPlant as MaintenancePlanningPlant,
//      _MaintenanceTaskList._TechnicalObject.MaintenancePlannerGroup as MaintenancePlannerGroup,
//      _MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.ControllingArea as ControllingArea,
//      _MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.CostCenter as CostCenter,
//      _MaintenanceTaskList._TechnicalObject._LocationAccountAssignment.MaintenancePlant as MaintenancePlant ,

      /* Associations - locally defined */
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BillOfOperationsSequence,
      _BillOfOperationsOperation,
      _MaintenanceTaskList,
      _MaintTaskListOperation,
      _MaintenancePackage,
      _ChangeNumber

}

• 事务代码：IA03\IA07\IA09\IA13
  任务清单、成本中心、维护者组、维护计划工厂、维护工厂

• 视图结构：

字段名称	技术名称
任务清单类型	TASKLISTTYPE
组	TASKLISTGROUP
组计数器	TASKLISTGROUPCOUNTER
序列	SEQUENCE
节点	TASKLISTOPERATIONINTERNALID
维护包	MAINTENANCEPACKAGE
计数器	MAINTPCKGTSKLISTOPALLOCINTNMBR
有效期自	VALIDITYSTARTDATE
维护包需求	MAINTENANCEPACKAGEISREQUIRED
标识:维护计划	ALLOCISMAINTAINEDBYMAINTPLAN
删除标识	ISDELETED
策略	MAINTENANCESTRATEGY
未激活	ALLOCATIONHASINACTIVECHANGES
变更编号	CHANGENUMBER
创建日期	CREATIONDATE
创建者	CREATEDBYUSER
更改日期	LASTCHANGEDATE
更改人	LASTCHANGEDBYUSER