I_TaskListToFuncnlLocAlloc

DDL: I_TASKLISTTOFUNCNLLOCALLOC SQL: ITSKLSTTOFLALLOC Type: view BASIC

Allocation of Task Lists to Functional Location

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

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
tapl tapl from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_FunctionalLocation _FunctionalLocation _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation
[1..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 ITSKLSTTOFLALLOC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation of Task Lists to Functional Location view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation tapl tplnr
KEY TaskListType tapl plnty
KEY TaskListGroup tapl plnnr
KEY TaskListGroupCounter tapl plnal
KEY AdditionalCriteriaCounter tapl zkriz
KEY ItemCounter tapl zaehl
ValidityStartDate tapl datuv
IsDeleted tapl loekz
ChangeNumber tapl aennr
MaintenancePlanningPlant tapl iwerk
CreationDate tapl andat
CreatedByUser
LastChangeDate tapl aedat
LastChangedByUser
_FunctionalLocation _FunctionalLocation
_MaintenanceTaskList _MaintenanceTaskList
_MaintenanceTaskListType _MaintenanceTaskListType 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'ITSKLSTTOFLALLOC'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Allocation of Task Lists to Functional Location'
@ObjectModel.representativeKey: [ 'ItemCounter' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #BASIC


define view I_TaskListToFuncnlLocAlloc
  as select from tapl

  association [1..1] to I_FunctionalLocation      as _FunctionalLocation      on  _FunctionalLocation.FunctionalLocation = $projection.FunctionalLocation

  association [1..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 tapl.tplnr                                                  as   FunctionalLocation,
      
      @ObjectModel.foreignKey.association: '_MaintenanceTaskListType'
  key tapl.plnty                                                  as   TaskListType,
  
  key tapl.plnnr                                                  as   TaskListGroup,
  
  key tapl.plnal                                                  as   TaskListGroupCounter,
  
  key tapl.zkriz                                                  as   AdditionalCriteriaCounter,
  
  key tapl.zaehl                                                  as   ItemCounter,
      
      tapl.datuv                                                  as   ValidityStartDate,
      
      tapl.loekz                                                  as   IsDeleted,
      
      tapl.aennr                                                  as   ChangeNumber,
      
      tapl.iwerk                                                  as   MaintenancePlanningPlant,
      
      @Semantics.systemDate.createdAt: true
      tapl.andat                                                  as   CreationDate,
      
      @Semantics.user.createdBy: true
      cast(tapl.annam as vdm_createdbyuserid preserving type)     as   CreatedByUser,
      
      @Semantics.systemDate.lastChangedAt: true
      tapl.aedat                                                  as   LastChangeDate,
      
      @Semantics.user.lastChangedBy: true
      cast(tapl.aenam as vdm_lastchangedbyuserid preserving type) as   LastChangedByUser,


      /* Associations */
      _FunctionalLocation,
      _MaintenanceTaskList,
      _MaintenanceTaskListType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TAPL"
],
"ASSOCIATED":
[
"I_FUNCTIONALLOCATION",
"I_MAINTENANCETASKLIST",
"I_MAINTENANCETASKLISTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More