I_ClosingTemplate

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_ClosingTemplate.
-- 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_ClosingTemplate AS
SELECT
  cast(profile as fcco_profile) AS ClosingTemplate,
  flavor AS FinancialTaskListContextType,
  instance AS ClosingTaskListInstance,
  cast(method as fcco_closing_hierarchy_type) AS ClosingTaskListHierarchyType,
  text AS ClosingTaskListDescription,
  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,
  res_usr_type AS ClosingTaskListResponsibleType,
  template_type AS ClosingTemplateType,
  noti_con AS ClosingNotificationConfign,
  cast(created_by as fcco_created_by) AS CreatedByUser,
  cast(created_on as fcco_created_on) AS CreationDateTime,
  cast(changed_by as fcco_changed_by) AS LastChangedByUser,
  cast(changed_on as fcco_changed_on) AS LastChangeDateTime,
  acc_principle AS AccountingPrinciple,
  lead_communication_profile AS ClosingCommunicationProfile
FROM fcco_hdr
LEFT OUTER JOIN I_FinTaskListContextType AS _FinTaskListContextType ON FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType  -- association [1..1]
LEFT OUTER JOIN I_ClosingTaskListText AS _Text ON ClosingTemplate = _Text.ClosingTemplate AND ClosingTaskListInstance = _Text.ClosingTaskListInstance AND FinancialTaskListContextType = _Text.FinancialTaskListContextType  -- association [0..*]
LEFT OUTER JOIN I_ClosingTaskListHierarchyType AS _ClosingTaskListHierarchyType ON ClosingTaskListHierarchyType = _ClosingTaskListHierarchyType.ClosingTaskListHierarchyType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskListStatus AS _ClosingTaskListStatus ON ClosingTaskListStatus = _ClosingTaskListStatus.ClosingTaskListStatus  -- association [0..1]
LEFT OUTER JOIN I_ClosingType AS _ClosingType ON ClosingType = _ClosingType.ClosingType  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON ClosingTemplateTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_ClosingTaskResponsibleType AS _ClosingTaskListRespType ON ClosingTaskListResponsibleType = _ClosingTaskListRespType.ClosingTaskResponsibleType  -- association [0..1]
LEFT OUTER JOIN I_ClosingTemplateType AS _ClosingTemplateType ON ClosingTemplateType = _ClosingTemplateType.ClosingTemplateType  -- association [0..1]
LEFT OUTER JOIN I_ClsgTaskListFactoryCal AS _FactoryCalendar ON ClosingCommunicationProfile = _FactoryCalendar.ClosingCommunicationProfile AND FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_ClsgTaskListAcctgPrinciple AS _AccountingPrinciple ON ClosingCommunicationProfile = _AccountingPrinciple.ClosingCommunicationProfile AND AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
LEFT OUTER JOIN I_ClosingCommProfile AS _ClosingCommunicationProfile ON ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile  -- association [0..1]
;