I_ClosingTaskList

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_ClosingTaskList.
-- 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_ClosingTaskList AS
SELECT
  profile AS ClosingTemplate,
  instance AS ClosingTaskListInstance,
  flavor AS FinancialTaskListContextType,
  long_tasklist_id AS ClosingTaskListExternalID,
  method AS ClosingTaskListHierarchyType,
  cast(text as fcco_task_list_descr) AS ClosingTaskListDescription,
  cast (text as fcco_profile_default_text) AS ClosingTaskListDefaultDesc,
  ready AS ClosingTaskListStatus,
  closing_type AS ClosingType,
  periv AS FiscalYearVariant,
  factory_calendar AS FactoryCalendar,
  authgrp AS ClosingAuthorizationGroup,
  templ_tzone AS ClosingTemplateTimeZone,
  res_usr_id AS ClosingTaskListResponsible,
  cast(res_usr_type as fcco_task_res_otype) AS ClosingTaskListResponsibleType,
  template_type AS ClosingTemplateType,
  noti_con AS ClosingNotificationConfign,
  created_by AS CreatedByUser,
  cast(created_on as fcco_created_on_short) AS CreationDateTime,
  changed_by AS LastChangedByUser,
  cast(changed_on as fcco_changed_on_short) AS LastChangeDateTime,
  rldnr AS Ledger,
  acc_principle AS AccountingPrinciple,
  ddate AS KeyDate,
  gjahr AS FiscalYear,
  poper AS FiscalPeriod,
  lead_communication_profile AS ClosingCommunicationProfile,
  taskset AS ClosingTaskTemplateSet
FROM fcco_hdr
LEFT OUTER JOIN I_ClosingTemplate AS _ClosingTemplate ON ClosingTemplate = _ClosingTemplate.ClosingTemplate AND FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_ClosingTaskListText AS _ClosingTaskListText ON ClosingTemplate = _ClosingTaskListText.ClosingTemplate AND ClosingTaskListInstance = _ClosingTaskListText.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTaskListText.FinancialTaskListContextType  -- association [0..*]
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_ClosingTask AS _ClosingTask ON ClosingTemplate = _ClosingTask.ClosingTemplate AND ClosingTaskListInstance = _ClosingTask.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingTask.FinancialTaskListContextType  -- association [0..*]
LEFT OUTER JOIN I_ClosingFolder AS _ClosingFolder ON ClosingTemplate = _ClosingFolder.ClosingTemplate AND ClosingTaskListInstance = _ClosingFolder.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType  -- association [0..*]
LEFT OUTER JOIN I_ClosingHierarchyNode AS _ClosingHierarchyNode ON ClosingTemplate = _ClosingHierarchyNode.ClosingTemplate AND ClosingTaskListInstance = _ClosingHierarchyNode.ClosingTaskListInstance AND FinancialTaskListContextType = _ClosingHierarchyNode.FinancialTaskListContextType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskListHierarchyType AS _ClosingTaskListHierarchyType ON ClosingTaskListHierarchyType = _ClosingTaskListHierarchyType.ClosingTaskListHierarchyType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskListHierTypeText AS _ClosingTaskListHierTypeText ON ClosingTaskListHierarchyType = _ClosingTaskListHierTypeText.ClosingTaskListHierarchyType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskListStatus AS _ClosingTaskListStatus ON ClosingTaskListStatus = _ClosingTaskListStatus.ClosingTaskListStatus  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskListStatusText AS _ClosingTaskListStatusText ON ClosingTaskListStatus = _ClosingTaskListStatusText.ClosingTaskListStatus  -- association [0..*]
LEFT OUTER JOIN I_ClosingType AS _ClosingType ON ClosingType = _ClosingType.ClosingType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTypeText AS _ClosingTypeText ON ClosingType = _ClosingTypeText.ClosingType  -- association [0..*]
LEFT OUTER JOIN I_ClsgTaskListFiscalYearVar AS _FiscalYearVariant ON ClosingCommunicationProfile = _FiscalYearVariant.ClosingCommunicationProfile AND FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ClsgTskListFiscalYearVarText AS _FiscalYearVariantText ON ClosingCommunicationProfile = _FiscalYearVariantText.ClosingCommunicationProfile AND FiscalYearVariant = _FiscalYearVariantText.FiscalYearVariant  -- association [0..*]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON ClosingTemplateTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_TimeZoneText AS _TimeZoneText ON ClosingTemplateTimeZone = _TimeZoneText.TimeZoneID  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskResponsibleType AS _ClosingTaskListRespType ON ClosingTaskListResponsibleType = _ClosingTaskListRespType.ClosingTaskResponsibleType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskRespTypeText AS _ClosingTaskListRespTypeText ON ClosingTaskListResponsibleType = _ClosingTaskListRespTypeText.ClosingTaskResponsibleType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTemplateType AS _ClosingTemplateType ON ClosingTemplateType = _ClosingTemplateType.ClosingTemplateType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTemplateTypeText AS _ClosingTemplateTypeText ON ClosingTemplateType = _ClosingTemplateTypeText.ClosingTemplateType  -- association [0..*]
LEFT OUTER JOIN I_ClsgTaskListFactoryCal AS _FactoryCalendar ON ClosingCommunicationProfile = _FactoryCalendar.ClosingCommunicationProfile AND FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_ClsgTskListFactoryCalText AS _FactoryCalendarText ON ClosingCommunicationProfile = _FactoryCalendarText.ClosingCommunicationProfile AND FactoryCalendar = _FactoryCalendarText.FactoryCalendar  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskListLedger AS _Ledger ON ClosingCommunicationProfile = _Ledger.ClosingCommunicationProfile AND Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskListLedgerText AS _LedgerText ON ClosingCommunicationProfile = _LedgerText.ClosingCommunicationProfile AND Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_ClsgTaskListAcctgPrinciple AS _AccountingPrinciple ON ClosingCommunicationProfile = _AccountingPrinciple.ClosingCommunicationProfile AND AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
LEFT OUTER JOIN I_ClsgTskListAcctgPrncplText AS _AccountingPrincipleText ON ClosingCommunicationProfile = _AccountingPrincipleText.ClosingCommunicationProfile AND AccountingPrinciple = _AccountingPrincipleText.AccountingPrinciple  -- association [0..*]
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_ClosingAuthorizationGroup AS _ClosingAuthorizationGroup ON ClosingAuthorizationGroup = _ClosingAuthorizationGroup.ClosingAuthorizationGroup AND _ClosingAuthorizationGroup.ClosingAuthorizationGroupType = 'ROOT'  -- association [0..1]
LEFT OUTER JOIN I_ClsgAuthorizationGroupText AS _ClsgAuthorizationGroupText ON ClosingAuthorizationGroup = _ClsgAuthorizationGroupText.ClosingAuthorizationGroup AND _ClsgAuthorizationGroupText.ClosingAuthorizationGroupType = 'ROOT'  -- association [0..*]
LEFT OUTER JOIN I_ClosingCommProfile AS _ClosingCommunicationProfile ON ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskTemplateSet AS _ClosingTaskTemplateSet ON ClosingCommunicationProfile = _ClosingTaskTemplateSet.ClosingCommunicationProfile AND ClosingTaskTemplateSet = _ClosingTaskTemplateSet.ClosingTaskTemplateSet  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskTemplateSetText AS _ClosingTaskTemplateSetText ON ClosingCommunicationProfile = _ClosingTaskTemplateSetText.ClosingCommunicationProfile AND ClosingTaskTemplateSet = _ClosingTaskTemplateSetText.ClosingTaskTemplateSet  -- association [0..*]
LEFT OUTER JOIN P_MyUserGroup AS _MyUserGroupAsResp ON ClosingTaskListResponsible = _MyUserGroupAsResp.ClosingUserGroup  -- association [0..1]
LEFT OUTER JOIN P_MyUserGroupAsSubstitute AS _MyUserGroupAsRespSubst ON ClosingTaskListResponsible = _MyUserGroupAsRespSubst.ClosingUserGroup  -- association [0..1]
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]
;