I_ClsgTaskLatestExecutionGroup

DDL: I_CLSGTASKLATESTEXECUTIONGROUP Type: view COMPOSITE Package: FCCO_VDM_APPS

Closing Task Latest Execution Group

I_ClsgTaskLatestExecutionGroup is a Composite CDS View that provides data about "Closing Task Latest Execution Group" in SAP S/4HANA. It reads from 1 data source (I_ClosingTaskExecutionGroup) and exposes 26 fields with key fields ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingTask, IsApplicationJobTestRun. It has 2 associations to related views. Part of development package FCCO_VDM_APPS.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ClosingTaskExecutionGroup I_ClosingTaskExecutionGroup from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGTASKLEXEG view
AbapCatalog.preserveKey true view
EndUserText.label Closing Task Latest Execution Group view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ClosingTemplate ClosingTemplate
KEY ClosingTaskListInstance ClosingTaskListInstance
KEY FinancialTaskListContextType FinancialTaskListContextType
KEY ClosingTask ClosingTask
KEY IsApplicationJobTestRun IsApplicationJobTestRun
ClosingTaskExecutionGroupUUID ClosingTaskExecutionGroupUUID
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ClosingTaskLifecycleStatus ClosingTaskLifecycleStatus
ClosingTaskStatus ClosingTaskStatus
ApplJobDurationInSeconds ApplJobDurationInSeconds
ApplicationJobStartDateTime ApplicationJobStartDateTime
ApplicationJobEndDateTime ApplicationJobEndDateTime
ClsgTaskStatusChgReasonDesc ClsgTaskStatusChgReasonDesc
ClsgTaskStatusIsChgdManually ClsgTaskStatusIsChgdManually
IsCurrentClosingTaskExecution IsCurrentClosingTaskExecution
ApplJobPlannedStartDateTime ApplJobPlannedStartDateTime
ReviewComment ReviewComment
NumberOfClosingTaskExecutions NumberOfClosingTaskExecutions
_ClosingTask _ClosingTask
_ClosingTaskList _ClosingTaskList
_FinTaskListContextType _FinTaskListContextType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog: {sqlViewName: 'ICLSGTASKLEXEG', preserveKey: true}
@EndUserText.label: 'Closing Task Latest Execution Group'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #L,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE

//There can be two latest execution groups per task: one for test run, one for productive run

define view I_ClsgTaskLatestExecutionGroup
  as select from I_ClosingTaskExecutionGroup

  association [0..1] to I_User as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID

  association [0..1] to I_User as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID
{
  key     ClosingTemplate,
  key     ClosingTaskListInstance,
  key     FinancialTaskListContextType,
  key     ClosingTask,
  key     IsApplicationJobTestRun,

          ClosingTaskExecutionGroupUUID,
          CreatedByUser,
          CreationDateTime,
          LastChangedByUser,
          LastChangeDateTime,
          ClosingTaskLifecycleStatus,
          ClosingTaskStatus,
          ApplJobDurationInSeconds,
          ApplicationJobStartDateTime,
          ApplicationJobEndDateTime,
          ClsgTaskStatusChgReasonDesc,
          ClsgTaskStatusIsChgdManually,
          IsCurrentClosingTaskExecution,
          ApplJobPlannedStartDateTime,
          ReviewComment,
          NumberOfClosingTaskExecutions,

          _ClosingTask,
          _ClosingTaskList,
          _FinTaskListContextType,
          _CreatedByUser,
          _LastChangedByUser
}

where
  IsCurrentClosingTaskExecution = 'X'

Learn More