I_TASKLISTTOEQUIPALLOC

CDS View

Allocation of Task Lists to Equipments

I_TASKLISTTOEQUIPALLOC is a CDS View in S/4HANA. Allocation of Task Lists to Equipments. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_TaskListToEquipAlloc view_entity from COMPOSITE Allocation of Task Lists to Equipment 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Allocation of Task Lists to Equipments'
@ObjectModel.representativeKey: 'ItemCounter'
@Analytics.technicalName: 'ITSKLSTTOEQALLOC'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #BASIC


define view entity I_TaskListToEquipAlloc
  as select from eapl

  association [1..1] to I_Equipment               as _Equipment               on  _Equipment.Equipment = $projection.Equipment

  association [0..1] to I_MaintenanceTaskList     as _MaintenanceTaskList     on  _MaintenanceTaskList.TaskListType         = $projection.TaskListType
                                                                              and _MaintenanceTaskList.TaskListGroup        = $projection.TaskListGroup
                                                                              and _MaintenanceTaskList.TaskListGroupCounter = $projection.TaskListGroupCounter

  association [1..1] to I_MaintenanceTaskListType as _MaintenanceTaskListType on  _MaintenanceTaskListType.TaskListType = $projection.TaskListType

{
  key eapl.equnr                                                          as   Equipment,

      @ObjectModel.foreignKey.association: '_MaintenanceTaskListType'
  key eapl.plnty                                                          as   TaskListType,

  key eapl.plnnr                                                          as   TaskListGroup,

  key eapl.plnal                                                          as   TaskListGroupCounter,

  key eapl.zkriz                                                          as   AdditionalCriteriaCounter,

  key eapl.zaehl                                                          as   ItemCounter,

      eapl.datuv                                                          as   ValidityStartDate,

      eapl.loekz                                                          as   IsDeleted,

      eapl.aennr                                                          as   ChangeNumber,

      eapl.swerk                                                          as   MaintenancePlant,

      eapl.iwerk                                                          as   MaintenancePlanningPlant,

      eapl.plnvw                                                          as   TaskListUsage,

      @Semantics.systemDate.createdAt: true
      eapl.andat                                                          as   CreationDate,

      @Semantics.user.createdBy: true
      cast(eapl.annam as vdm_createdbyuserid preserving type)             as   CreatedByUser,

      @Semantics.systemDate.lastChangedAt: true
      eapl.aedat                                                          as   LastChangeDate,

      @Semantics.user.lastChangedBy: true
      cast(eapl.aenam as vdm_lastchangedbyuserid preserving type)         as   LastChangedByUser,


      /* Associations */
      _Equipment,
      _MaintenanceTaskList,
      _MaintenanceTaskListType
}

Learn More