I_CnsldtnTaskLogHeader

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_CnsldtnTaskLogHeader.
-- 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: ICNSLDTNTLHDR

CREATE VIEW I_CnsldtnTaskLogHeader AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cnsldtnchartofaccounts AS ConsolidationChartOfAccounts,
  cnsldtndimension AS ConsolidationDimension,
  cnsldtndocumenttype AS ConsolidationDocumentType,
  cast(cnsldtngroup as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
  cnsldtngroupcurrency AS GroupCurrency,
  cnsldtnledger AS ConsolidationLedger,
  cnsldtnlogdate AS CnsldtnLogHeaderDate,
  cnsldtnlogtime AS CnsldtnLogHeaderTime,
  cnsldtnmethod AS ConsolidationMethod,
  cnsldtntask AS ConsolidationTask,
  cnsldtntasktype AS TaskType,
  cast( cnsldtnunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  cast(cnsldtnversion as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  _VersionT[1: Language = $session.system_language].ConsolidationVersionText AS ConsolidationVersionText,
  ExternalId,
  FiscalPeriod,
  cast(fiscalyear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  iscnsldtntestrun AS IsConsolidationTaskTestRun,
  is_cumulative AS CnsldtnIsCumulative,
  status AS CnsldtnTaskLogMessageType,
  update_mode AS CnsldtnIsUpdateMode,
  UserID,
  cast(timestamp as fincs_timestamp preserving type) AS CnsldtnLogHeaderDateTime,
  logid_timestamp AS CnsldtnTaskLogHeaderGroupID,
  cast( yearperiod as fins_fyearperiod ) AS FiscalYearPeriod,
  applicationjobname AS ReferenceApplicationJobName,
  applicationjobcount AS ApplicationJob,
  stepcount AS JobStepNumber
FROM fincs_log_header
LEFT OUTER JOIN I_CnsldtnVersionT AS _VersionT ON ConsolidationVersion = _VersionT.ConsolidationVersion  -- association [0..1]
;