I_FCC_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_FCC_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.
-- SQL view name: IFCCCLSGTSK

CREATE VIEW I_FCC_ClosingTask AS
SELECT
  fcc_inst_item.mandt AS mandt,
  fcc_inst_item.profile AS ClosingTemplate,
  fcc_inst_item.instance AS ClosingTaskListInstance,
  item AS ClosingTask,
  kind AS ClosingTaskType,
  fcc_inst_item.text AS ClosingTaskName,
  crit_path AS IsCriticalPath,
  exe_usr_id AS ClosingTaskProcessor,
  exe_usr_type AS ClosingTaskProcessorType,
  fcc_inst_item.res_usr_id AS ClosingTaskResponsible,
  fcc_inst_item.res_usr_type AS ClosingTaskResponsibleType,
  global_id AS ClosingTaskGlobalID,
  closing_hier_1 AS CustomDimension1,
  closing_hier_2 AS CustomDimension2,
  closing_hier_3 AS CustomDimension3,
  milestone AS ClosingMilestone,
  closing_phase AS ClosingPhase,
  fcc_inst_item.authgrp AS ClosingAuthorizationGroup
FROM fcc_inst_item
;