I_TaskListToEquipAlloc

DDL: I_TASKLISTTOEQUIPALLOC SQL: ITSKLSTTOEQALLOC Type: view BASIC

Allocation of Task Lists to Equipments

I_TaskListToEquipAlloc is a Basic CDS View that provides data about "Allocation of Task Lists to Equipments" in SAP S/4HANA. It reads from 1 data source (eapl) and exposes 19 fields with key fields Equipment, TaskListType, TaskListGroup, TaskListGroupCounter, AdditionalCriteriaCounter. It has 3 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
eapl eapl from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Equipment _Equipment _Equipment.Equipment = $projection.Equipment
[0..1] I_MaintenanceTaskList _MaintenanceTaskList _MaintenanceTaskList.TaskListType = $projection.TaskListType and _MaintenanceTaskList.TaskListGroup = $projection.TaskListGroup and _MaintenanceTaskList.TaskListGroupCounter = $projection.TaskListGroupCounter
[1..1] I_MaintenanceTaskListType _MaintenanceTaskListType _MaintenanceTaskListType.TaskListType = $projection.TaskListType

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITSKLSTTOEQALLOC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation of Task Lists to Equipments view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Equipment eapl equnr
KEY TaskListType eapl plnty
KEY TaskListGroup eapl plnnr
KEY TaskListGroupCounter eapl plnal
KEY AdditionalCriteriaCounter eapl zkriz
KEY ItemCounter eapl zaehl
ValidityStartDate eapl datuv
IsDeleted eapl loekz
ChangeNumber eapl aennr
MaintenancePlant eapl swerk
MaintenancePlanningPlant eapl iwerk
TaskListUsage eapl plnvw
CreationDate eapl andat
CreatedByUser
LastChangeDate eapl aedat
LastChangedByUser
_Equipment _Equipment
_MaintenanceTaskList _MaintenanceTaskList
_MaintenanceTaskListType _MaintenanceTaskListType 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'ITSKLSTTOEQALLOC'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Allocation of Task Lists to Equipments'
@ObjectModel.representativeKey: [ 'ItemCounter' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #BASIC


define view 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAPL"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More