I_CnsldtnTaskRunLastLog_2

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_CnsldtnTaskRunLastLog_2.
-- 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_CnsldtnTaskRunLastLog_2 AS
SELECT
  cast( fincs_lastlog.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast( fincs_lastlog.rvers as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast( fincs_lastlog.ryear as fincs_fiscalyear preserving type ) AS FiscalYear,
  cast( fincs_lastlog.perid as fincs_period preserving type ) AS FiscalPeriod,
  cast( fincs_lastlog.cacti as fincs_tsk preserving type ) AS ConsolidationTask,
  cast( fincs_lastlog.testrun as fincs_taskrun_is_test preserving type) AS ConsolidationTaskRunIsTest,
  cast( fincs_lastlog.usr as fincs_tasklog_created_by preserving type ) AS CnsldtnTaskLogCreatedByUser,
  cast( fincs_lastlog.time as fincs_tasklog_created_time preserving type ) AS CnsldtnTaskLogCreatedTime,
  cast( fincs_lastlog.datum as fincs_tasklog_created_date preserving type ) AS CnsldtnTaskLogCreatedDate,
  cast( fincs_lastlog.protid_gen as fincs_lognumber preserving type ) AS CnsldtnTaskLogUUID
FROM fincs_lastlog
INNER JOIN I_CnsldtnVersion AS ConsolidationVersion ON /* join condition not captured in parsed metadata */
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_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnTask AS _CnsldtnTask ON ConsolidationTask = _CnsldtnTask.ConsolidationTask  -- association [1..1]
LEFT OUTER JOIN I_ConsolidationTaskLog AS _ConsolidationTaskLog ON CnsldtnTaskLogUUID = _ConsolidationTaskLog.CnsldtnTaskLogUUID  -- association [0..1]
;