I_ConsolidationTaskLog

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_ConsolidationTaskLog.
-- 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_ConsolidationTaskLog AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cast(cnsldtnchartofaccounts as fincs_conschartofaccounts preserving type) AS ConsolidationChartOfAccounts,
  cast(cnsldtngroup as fincs_md_congr preserving type) AS ConsolidationGroup,
  cast(cnsldtnunit as fincs_consolidationunit preserving type) AS ConsolidationUnit,
  cast(cnsldtnversion as fincs_consolidationversion preserving type) AS ConsolidationVersion,
  cast(cnsldtntasktype as fincs_taskcategory preserving type) AS ConsolidationTaskCategory,
  cast(externalid as fincs_extid preserving type) AS CnsldtnTaskLogExternalId,
  cast(applicationjobname as fincs_taskrun_jobname_id preserving type) AS CnsldtnTskRunBackgroundJobName,
  cast(applicationjobcount as fincs_taskrun_job_id preserving type) AS CnsldtnTaskRunBackgroundJob,
  cast(fiscalperiod as fins_fiscalperiod preserving type) AS FiscalPeriod,
  cast(fiscalyear as fis_gjahr_no_conv preserving type) AS FiscalYear,
  cast(userid as fincs_tasklog_created_by preserving type) AS CnsldtnTaskLogCreatedByUser,
  cast(cnsldtntask as fincs_tsk preserving type) AS ConsolidationTask,
  cast(cnsldtndocumenttype as fincs_documenttype preserving type) AS ConsolidationDocumentType,
  cast(cnsldtngroupcurrency as fincs_groupcurrency preserving type) AS ConsolidationGroupCurrency,
  cast(status as fincs_taskrun_sts) AS ConsolidationTaskStatus,
  cast(status as fincs_msg_type preserving type) AS CnsldtnTaskLogMessageType,
  cast(cnsldtnmethod as fincs_method preserving type) AS ConsolidationMethod,
  cast(is_cumulative as fincs_cum_indi preserving type) AS CnsldtnIsCumulative,
  cast(update_mode as fincs_rptdata_updmode preserving type) AS CnsldtnRptdDataUpdateMode,
  cast(createddatetime as fincs_tasklog_created_at preserving type) AS CnsldtnTskLgCreatedDateTime,
  cast(timestamp as fincs_timestamp preserving type) AS CnsldtnTaskLogHeaderDateTime,
  cast(iscnsldtntestrun as fincs_taskrun_is_test preserving type) AS ConsolidationTaskRunIsTest
FROM fincs_log_header
LEFT OUTER JOIN I_ConsolidationTaskLogMessage AS _ConsolidationTaskLogMessage ON CnsldtnTaskLogUUID = _ConsolidationTaskLogMessage.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnTskLgItmRclassfctn AS _CnsldtnTskLgItmRclassfctn ON CnsldtnTaskLogUUID = _CnsldtnTskLgItmRclassfctn.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnTskLgItmCrcyTrnsltn AS _CnsldtnTskLgItmCrcyTrnsltn ON CnsldtnTaskLogUUID = _CnsldtnTskLgItmCrcyTrnsltn.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnTskLgItmManualPosting AS _CnsldtnTskLgItmManualPosting ON CnsldtnTaskLogUUID = _CnsldtnTskLgItmManualPosting.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnTaskLogItemDataEntry AS _CnsldtnTaskLogItemDataEntry ON CnsldtnTaskLogUUID = _CnsldtnTaskLogItemDataEntry.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnTskLgItmLineValdtn AS _CnsldtnTskLgItmLineValdtn ON CnsldtnTaskLogUUID = _CnsldtnTskLgItmLineValdtn.CnsldtnTaskLogUUID  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnTaskCategory AS _CnsldtnTaskCategory ON ConsolidationTaskCategory = _CnsldtnTaskCategory.ConsolidationTaskCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnTask AS _CnsldtnTask ON ConsolidationTask = _CnsldtnTask.ConsolidationTask  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType_2 AS _CnsldtnDocumentType ON ConsolidationDocumentType = _CnsldtnDocumentType.ConsolidationDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConsolidationGroupCurrency ON ConsolidationGroupCurrency = _ConsolidationGroupCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMethod AS _CnsldtnMethod ON ConsolidationMethod = _CnsldtnMethod.ConsolidationMethod  -- association [0..1]
;