I_ClsgTaskLatestExecutionGroup

DDL: I_CLSGTASKLATESTEXECUTIONGROUP Type: view COMPOSITE Package: FCCO_VDM_APPS
26 Fields 1 Data Sources 2 Associations

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.

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 WBS sched. prof
KEY ClosingTaskListInstance ClosingTaskListInstance TaskCount
KEY FinancialTaskListContextType FinancialTaskListContextType Task List Context
KEY ClosingTask ClosingTask Task ID
KEY IsApplicationJobTestRun IsApplicationJobTestRun
ClosingTaskExecutionGroupUUID ClosingTaskExecutionGroupUUID UUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ClosingTaskLifecycleStatus ClosingTaskLifecycleStatus Life Cycle
ClosingTaskStatus ClosingTaskStatus Status
ApplJobDurationInSeconds ApplJobDurationInSeconds Tot.Duration in Days
ApplicationJobStartDateTime ApplicationJobStartDateTime Started On
ApplicationJobEndDateTime ApplicationJobEndDateTime Ended On
ClsgTaskStatusChgReasonDesc ClsgTaskStatusChgReasonDesc User Group
ClsgTaskStatusIsChgdManually ClsgTaskStatusIsChgdManually Manual Changed
IsCurrentClosingTaskExecution IsCurrentClosingTaskExecution TRUE
ApplJobPlannedStartDateTime ApplJobPlannedStartDateTime Time Stamp
ReviewComment ReviewComment
NumberOfClosingTaskExecutions NumberOfClosingTaskExecutions
_ClosingTask _ClosingTask
_ClosingTaskList _ClosingTaskList
_FinTaskListContextType _FinTaskListContextType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ClsgTaskLatestExecutionGroup.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ClsgTaskLatestExecutionGroup AS
SELECT
  ClosingTemplate,
  ClosingTaskListInstance,
  FinancialTaskListContextType,
  ClosingTask,
  IsApplicationJobTestRun,
  ClosingTaskExecutionGroupUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ClosingTaskLifecycleStatus,
  ClosingTaskStatus,
  ApplJobDurationInSeconds,
  ApplicationJobStartDateTime,
  ApplicationJobEndDateTime,
  ClsgTaskStatusChgReasonDesc,
  ClsgTaskStatusIsChgdManually,
  IsCurrentClosingTaskExecution,
  ApplJobPlannedStartDateTime,
  ReviewComment,
  NumberOfClosingTaskExecutions
FROM I_ClosingTaskExecutionGroup
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;

Learn More