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

作者:观兴

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

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

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

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