I_ClosingTaskExecutionGroup

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_ClosingTaskExecutionGroup.
-- 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_ClosingTaskExecutionGroup AS
SELECT
  profile AS ClosingTemplate,
  instance AS ClosingTaskListInstance,
  flavor AS FinancialTaskListContextType,
  item AS ClosingTask,
  exec_grp_uuid AS ClosingTaskExecutionGroupUUID,
  created_by AS CreatedByUser,
  created_on AS CreationDateTime,
  last_changed_by AS LastChangedByUser,
  last_changed_on AS LastChangeDateTime,
  life_cycle_status AS ClosingTaskLifecycleStatus,
  combined_status AS ClosingTaskStatus,
  duration AS ApplJobDurationInSeconds,
  btc_start_on AS ApplicationJobStartDateTime,
  btc_end_on AS ApplicationJobEndDateTime,
  text AS ClsgTaskStatusChgReasonDesc,
  manual_changed AS ClsgTaskStatusIsChgdManually,
  is_current AS IsCurrentClosingTaskExecution,
  is_testrun AS IsApplicationJobTestRun,
  btc_planned_start_on AS ApplJobPlannedStartDateTime,
  approval_text AS ReviewComment,
  num_of_executions AS NumberOfClosingTaskExecutions
FROM fcco_group_exec
LEFT OUTER JOIN I_ClosingTaskList AS _ClosingTaskList ON ClosingTemplate = _ClosingTaskList.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskList.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_ClosingTask AS _ClosingTask ON ClosingTemplate = _ClosingTask.ClosingTemplate AND ClosingTaskListInstance = _ClosingTask.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTask.FinancialTaskListContextType AND ClosingTask = _ClosingTask.ClosingTask  -- association [1..1]
LEFT OUTER JOIN I_ClosingTemplate AS _ClosingTemplate ON ClosingTemplate = _ClosingTemplate.ClosingTemplate AND FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_FinTaskListContextType AS _FinTaskListContextType ON FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_ClosingTaskExecution AS _ClosingTaskExecution ON ClosingTemplate = _ClosingTaskExecution.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskExecution.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskExecution.FinancialTaskListContextType AND ClosingTask = _ClosingTaskExecution.ClosingTask AND ClosingTaskExecutionGroupUUID = _ClosingTaskExecution.ClosingTaskExecutionGroupUUID  -- association [0..*]
;