I_ClosingTask

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_ClosingTask.
-- 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_ClosingTask AS
SELECT
  profile AS ClosingTemplate,
  instance AS ClosingTaskListInstance,
  flavor AS FinancialTaskListContextType,
  item AS ClosingTask,
  folder AS ClosingFolder,
  long_task_id AS ClosingTaskExternalID,
  task_uuid AS ClosingTaskUUID,
  pos AS OrdinalNumber,
  kind AS ClosingTaskType,
  report AS ABAPProgramName,
  transact AS TransactionCode,
  fiori_job_template AS ApplicationJobTemplate,
  web_app_url AS WebsiteURL,
  exe_day_offset AS OffsetDays,
  exe_time AS PlannedStartTime,
  def_time_zone AS TimeZoneID,
  inactive AS ClosingTaskIsInactive,
  locked AS ClosingTaskIsLocked,
  text AS ClosingTaskName,
  cast (text as fcco_task_default_name) AS ClosingTaskDefaultName,
  planned_duration AS PlannedDurationInSeconds,
  planned_start_on AS PlannedStartDateTime,
  planned_end_on AS PlannedEndDateTime,
  ismonthendtask AS IsMonthEndClosingTask,
  isquarterendtask AS IsQuarterEndClosingTask,
  isyearendtask AS IsYearEndClosingTask,
  isspecialendtask AS IsSpecialEndClosingTask,
  isuserdefinedtask AS IsUserDefinedClosingTask,
  crit_path AS IsCriticalPath,
  notified AS NotificationIsRequired,
  start_immd AS ClsgTaskIsStartedImmediately,
  exe_usr_id AS ClosingTaskProcessor,
  cast(exe_usr_type as fcco_task_owner_otype) AS ClosingTaskProcessorType,
  res_usr_id AS ClosingTaskResponsible,
  cast(res_usr_type as fcco_task_res_otype) AS ClosingTaskResponsibleType,
  cast(task_group as fcco_task_group preserving type) AS ClosingTaskGroup,
  authgrp AS ClosingAuthorizationGroup,
  created_by AS CreatedByUser,
  created_on AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_on AS LastChangeDateTime,
  ic_sig AS ClosingTaskSignificance,
  ic_auto AS ClosingTaskAutomationLevel,
  ic_purp AS ClosingTaskPurpose,
  milestone AS ClosingMilestone,
  closing_phase AS ClosingPhase,
  is_testr_supported AS ApplJobTestRunIsSupported,
  semantic_object AS SemanticObject,
  semantic_action AS SemanticObjectAction,
  approval_status AS ClosingTaskApprovalStatus,
  approval_changed_on AS ClsgTaskApprvlStsLastChgDteTme,
  approval_changed_by AS ClsgTaskApprvlStsLastChgdByUsr,
  node_bukrs AS CompanyCodeClosingFolder,
  node_kokrs AS ControllingAreaClosingFolder,
  node_werks AS PlantClosingFolder,
  node_leading AS LeadingOrgUnitClosingFolder,
  noti_con AS ClosingNotificationConfign,
  communication_profile AS ClosingCommunicationProfile,
  bttype AS ClosingBusinessTransactionType,
  approval_type AS ClosingApprovalType,
  task AS ClosingTaskTemplate,
  component AS SAPApplicationComponent,
  combined_status AS ClosingTaskStatus,
  has_attachment AS HasAttachment,
  ismanuallycreated AS ClosingTaskIsCreatedManually,
  istasklistcreated AS ClosingTaskIsInTaskListOnly,
  param_variant_id AS ClosingApplicationJobVariant,
  manual_changed AS ClsgTaskStatusIsChgdManually
FROM fcco_task
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_ClosingTemplate AS _ClosingTemplate ON ClosingTemplate = _ClosingTemplate.ClosingTemplate AND FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_ClosingFolder AS _ClosingFolder ON ClosingTemplate = _ClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _ClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType AND ClosingFolder = _ClosingFolder.ClosingFolder  -- association [1..1]
LEFT OUTER JOIN I_FinTaskListContextType AS _FinTaskListContextType ON FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_FinTaskListContextTypeText AS _FinTaskListContextTypeText ON FinancialTaskListContextType = _FinTaskListContextTypeText.FinancialTaskListContextType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskText AS _ClosingTaskText ON ClosingTemplate = _ClosingTaskText.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskText.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskText.FinancialTaskListContextType AND ClosingTask = _ClosingTaskText.ClosingTask  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskExecutionGroup AS _ClosingTaskExecutionGroup ON ClosingTemplate = _ClosingTaskExecutionGroup.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskExecutionGroup.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskExecutionGroup.FinancialTaskListContextType AND ClosingTask = _ClosingTaskExecutionGroup.ClosingTask  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskNotifLog AS _ClosingTaskNotifLog ON ClosingTemplate = _ClosingTaskNotifLog.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskNotifLog.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskNotifLog.FinancialTaskListContextType AND ClosingTask = _ClosingTaskNotifLog.ClosingTask  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskEmail AS _ClosingTaskEmail ON ClosingTemplate = _ClosingTaskEmail.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskEmail.ClosingTaskListInstance AND ClosingTask = _ClosingTaskEmail.ClosingTask  -- association [0..*]
LEFT OUTER JOIN I_ClsgTaskLatestExecutionGroup AS _ClsgTaskLatestExecutionGroup ON ClosingTemplate = _ClsgTaskLatestExecutionGroup.ClosingTemplate AND ClosingTaskListInstance = _ClsgTaskLatestExecutionGroup.ClosingTaskListInstance AND FinancialTaskListContextType = _ClsgTaskLatestExecutionGroup.FinancialTaskListContextType AND ClosingTask = _ClsgTaskLatestExecutionGroup.ClosingTask  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskType AS _ClosingTaskType ON ClosingTaskType = _ClosingTaskType.ClosingTaskType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskTypeText AS _ClosingTaskTypeText ON ClosingTaskType = _ClosingTaskTypeText.ClosingTaskType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskStatus AS _ClosingTaskStatus ON ClosingTaskStatus = _ClosingTaskStatus.ClosingTaskStatus  -- association [1..1]
LEFT OUTER JOIN I_ClosingTaskStatusText AS _ClosingTaskStatusText ON ClosingTaskStatus = _ClosingTaskStatusText.ClosingTaskStatus  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskResponsibleType AS _ClosingTaskProcessorType ON ClosingTaskProcessorType = _ClosingTaskProcessorType.ClosingTaskResponsibleType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskRespTypeText AS _ClosingTaskProcsrTypeText ON ClosingTaskProcessorType = _ClosingTaskProcsrTypeText.ClosingTaskResponsibleType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskResponsibleType AS _ClosingTaskResponsibleType ON ClosingTaskResponsibleType = _ClosingTaskResponsibleType.ClosingTaskResponsibleType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskRespTypeText AS _ClosingTaskRespTypeText ON ClosingTaskResponsibleType = _ClosingTaskRespTypeText.ClosingTaskResponsibleType  -- association [0..*]
LEFT OUTER JOIN I_ClosingApprovalType AS _ClosingApprovalType ON ClosingApprovalType = _ClosingApprovalType.ClosingApprovalType  -- association [0..1]
LEFT OUTER JOIN I_ClosingApprovalTypeText AS _ClosingApprovalTypeText ON ClosingApprovalType = _ClosingApprovalTypeText.ClosingApprovalType  -- association [0..*]
LEFT OUTER JOIN P_MyUserGroup AS _MyUserGroupAsResp ON ClosingTaskResponsible = _MyUserGroupAsResp.ClosingUserGroup  -- association [0..1]
LEFT OUTER JOIN P_MyUserGroupAsSubstitute AS _MyUserGroupAsRespSubst ON ClosingTaskResponsible = _MyUserGroupAsRespSubst.ClosingUserGroup  -- association [0..1]
LEFT OUTER JOIN P_MyUserGroup AS _MyUserGroupAsProcessor ON ClosingTaskProcessor = _MyUserGroupAsProcessor.ClosingUserGroup  -- association [0..1]
LEFT OUTER JOIN P_MyUserGroupAsSubstitute AS _MyUserGroupAsProcessorSubst ON ClosingTaskProcessor = _MyUserGroupAsProcessorSubst.ClosingUserGroup  -- association [0..1]
LEFT OUTER JOIN I_ClosingFolderOrgUnit AS _CompanyCode ON ClosingTemplate = _CompanyCode.ClosingTemplate AND ClosingTaskListInstance = _CompanyCode.ClosingTaskListInstance AND FinancialTaskListContextType = _CompanyCode.FinancialTaskListContextType AND CompanyCodeClosingFolder = _CompanyCode.ClosingFolder  -- association [0..*]
LEFT OUTER JOIN I_ClosingFolderOrgUnit AS _ControllingArea ON ClosingTemplate = _ControllingArea.ClosingTemplate AND ClosingTaskListInstance = _ControllingArea.ClosingTaskListInstance AND FinancialTaskListContextType = _ControllingArea.FinancialTaskListContextType AND ControllingAreaClosingFolder = _ControllingArea.ClosingFolder  -- association [0..*]
LEFT OUTER JOIN I_ClosingFolderOrgUnit AS _Plant ON ClosingTemplate = _Plant.ClosingTemplate AND ClosingTaskListInstance = _Plant.ClosingTaskListInstance AND FinancialTaskListContextType = _Plant.FinancialTaskListContextType AND PlantClosingFolder = _Plant.ClosingFolder  -- association [0..*]
LEFT OUTER JOIN I_ClosingFolder AS _CompanyCodeClosingFolder ON ClosingTemplate = _CompanyCodeClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _CompanyCodeClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _CompanyCodeClosingFolder.FinancialTaskListContextType AND CompanyCodeClosingFolder = _CompanyCodeClosingFolder.ClosingFolder  -- association [0..1]
LEFT OUTER JOIN I_ClosingFolder AS _ControllingAreaClosingFolder ON ClosingTemplate = _ControllingAreaClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _ControllingAreaClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _ControllingAreaClosingFolder.FinancialTaskListContextType AND ControllingAreaClosingFolder = _ControllingAreaClosingFolder.ClosingFolder  -- association [0..1]
LEFT OUTER JOIN I_ClosingFolder AS _PlantClosingFolder ON ClosingTemplate = _PlantClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _PlantClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _PlantClosingFolder.FinancialTaskListContextType AND PlantClosingFolder = _PlantClosingFolder.ClosingFolder  -- association [0..1]
LEFT OUTER JOIN I_ClosingFolder AS _LeadingOrgUnitClosingFolder ON ClosingTemplate = _LeadingOrgUnitClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _LeadingOrgUnitClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _LeadingOrgUnitClosingFolder.FinancialTaskListContextType AND LeadingOrgUnitClosingFolder = _LeadingOrgUnitClosingFolder.ClosingFolder  -- association [0..1]
LEFT OUTER JOIN I_ClosingNotificationConfign AS _ClosingNotificationConfign ON ClosingNotificationConfign = _ClosingNotificationConfign.ClosingNotificationConfign  -- association [0..1]
LEFT OUTER JOIN I_ClsgNotificationConfignText AS _ClsgNotificationConfignText ON ClosingNotificationConfign = _ClsgNotificationConfignText.ClosingNotificationConfign  -- association [0..*]
LEFT OUTER JOIN I_ClosingCommProfile AS _ClosingCommunicationProfile ON ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile  -- association [0..1]
LEFT OUTER JOIN I_ClsgBusTransactionType AS _ClsgBusinessTransactionType ON ClosingBusinessTransactionType = _ClsgBusinessTransactionType.ClosingBusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_ClsgBusTransactionTypeText AS _ClsgBusTransactionTypeText ON ClosingBusinessTransactionType = _ClsgBusTransactionTypeText.ClosingBusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON TimeZoneID = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZoneText AS _TimeZoneText ON TimeZoneID = _TimeZoneText.TimeZoneID  -- association [0..*]
LEFT OUTER JOIN I_ClosingAuthorizationGroup AS _ClosingAuthorizationGroup ON ClosingAuthorizationGroup = _ClosingAuthorizationGroup.ClosingAuthorizationGroup AND _ClosingAuthorizationGroup.ClosingAuthorizationGroupType = 'TASK'  -- association [0..1]
LEFT OUTER JOIN I_ClsgAuthorizationGroupText AS _ClsgAuthorizationGroupText ON ClosingAuthorizationGroup = _ClsgAuthorizationGroupText.ClosingAuthorizationGroup AND _ClsgAuthorizationGroupText.ClosingAuthorizationGroupType = 'TASK'  -- association [0..*]
LEFT OUTER JOIN E_ClosingTask AS _ClosingTaskExtension ON ClosingTemplate = _ClosingTaskExtension.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskExtension.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskExtension.FinancialTaskListContextType AND ClosingTask = _ClosingTaskExtension.ClosingTask  -- association [0..1]
;