I_CnsldtnGroupTaskRun

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_CnsldtnGroupTaskRun.
-- 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_CnsldtnGroupTaskRun AS
SELECT
  cast( tf271.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast( tf271.rvers as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast( tf271.ryear as fincs_fiscalyear preserving type ) AS FiscalYear,
  cast( tf271.perid as fincs_period preserving type ) AS FiscalPeriod,
  cast( tf271.cacti as fincs_tsk preserving type ) AS ConsolidationTask,
  cast( tf271.bunit as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
  cast( tf271.error as fincs_taskrun_err_no preserving type ) AS CnsldtnTskRunNmbrOfErrMessages,
  cast( tf271.warng as fincs_taskrun_warn_no preserving type ) AS CnsldtnTskRunNmbrOfWrngMsgs,
  cast( tf271.usr as fincs_taskrun_changeby preserving type ) AS CnsldtnTaskRunChangedByUser,
  cast( tf271.datum as fincs_taskrun_changedat preserving type ) AS CnsldtnTaskRunChangedDate,
  cast( tf271.time as fincs_taskrun_changetime preserving type ) AS CnsldtnTaskRunChangedTime,
  cast( tf271.status as fincs_taskrun_status preserving type ) AS ConsolidationTaskRunStatus
FROM tf271
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnTask AS _CnsldtnTask ON ConsolidationTask = _CnsldtnTask.ConsolidationTask  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnTaskRunStatus AS _CnsldtnTaskRunStatus ON ConsolidationTaskRunStatus = _CnsldtnTaskRunStatus.ConsolidationTaskRunStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _CnsldtnTaskRunChangedByUser ON CnsldtnTaskRunChangedByUser = _CnsldtnTaskRunChangedByUser.UserID  -- association [0..1]
;