I_CnsldtnTaskRunPeriodStatus

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_CnsldtnTaskRunPeriodStatus.
-- 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_CnsldtnTaskRunPeriodStatus AS
SELECT
  cast( ConsolidationPeriodStatus.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast( ConsolidationPeriodStatus.rvers as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast( ConsolidationPeriodStatus.ryear as fincs_fiscalyear preserving type ) AS FiscalYear,
  cast( ConsolidationPeriodStatus.perid as fincs_period preserving type ) AS FiscalPeriod,
  cast( ConsolidationPeriodStatus.usr1 as fincs_periodstatuschangedby preserving type ) AS CnsldtnTskRunPerdStsChgdByUser,
  cast( ConsolidationPeriodStatus.datum1 as fincs_periodstatuschangeddate preserving type ) AS CnsldtnTskRunPerdStsChgdDate,
  cast( ConsolidationPeriodStatus.time1 as fincs_periodstatuschangedtime preserving type ) AS CnsldtnTskRunPerdStsChgdTime
FROM tf250 AS ConsolidationPeriodStatus
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]
;