I_CnsldtnUnitTaskRun

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_CnsldtnUnitTaskRun.
-- 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_CnsldtnUnitTaskRun AS
SELECT
  cast( tf261.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast( tf261.rvers as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast( tf261.ryear as fincs_fiscalyear preserving type ) AS FiscalYear,
  cast( tf261.perid as fincs_period preserving type ) AS FiscalPeriod,
  cast( tf261.cacti as fincs_tsk preserving type ) AS ConsolidationTask,
  cast( tf261.bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  cast( tf261.error as fincs_taskrun_err_no preserving type ) AS CnsldtnTskRunNmbrOfErrMessages,
  cast( tf261.warng as fincs_taskrun_warn_no preserving type ) AS CnsldtnTskRunNmbrOfWrngMsgs,
  cast( tf261.usr as fincs_taskrun_changeby preserving type ) AS CnsldtnTaskRunChangedByUser,
  cast( tf261.datum as fincs_taskrun_changedat preserving type ) AS CnsldtnTaskRunChangedDate,
  cast( tf261.time as fincs_taskrun_changetime preserving type ) AS CnsldtnTaskRunChangedTime,
  cast( tf261.status as fincs_taskrun_status preserving type ) AS ConsolidationTaskRunStatus
FROM tf261
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_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnTaskRunStatus AS _CnsldtnTaskRunStatus ON ConsolidationTaskRunStatus = _CnsldtnTaskRunStatus.ConsolidationTaskRunStatus  -- association [1..1]
;