FINCS_LOG_HEADER_OLD

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 FINCS_LOG_HEADER_OLD.
-- 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: FINCSLOGHDR

CREATE VIEW FINCS_LOG_HEADER_OLD AS
SELECT
  fincs_log_header.cnsldtnlognumber AS CnsldtnLogNumber,
  fincs_log_header.cnsldtnunit AS ConsolidationUnit,
  fincs_log_header.cnsldtngroup AS ConsolidationGroup,
  cast(concat(fiscalyear,fiscalperiod) as fincs_fiscalyearper ) AS FiscalYearPeriod,
  _Group.ConsolidationGroupText AS ConsolidationGroupText,
  _Unit.ConsolidationUnitText AS ConsolidationUnitText,
  'Y1' AS ConsolidationDimension,
  fincs_log_header.cnsldtntasktype AS CnsldtnTaskType,
  _TaskCat.ConsolidationTaskTypeText AS CnsldtnTaskTypeT,
  fincs_log_header.iscnsldtntestrun AS IsCnsldtnTestRun,
  fincs_log_header.userid AS UserID,
  fincs_log_header.cnsldtnlogdate AS CnsldtnLogDate,
  fincs_log_header.cnsldtnlogtime AS CnsldtnLogTime,
  fincs_log_header.cnsldtntask AS CnsldtnTask,
  _Task.CnsldtnTaskText AS CnsldtnTaskText,
  fincs_log_header.cnsldtnchartofaccounts AS ConsolidationChartOfAccounts,
  _CCOA.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  fincs_log_header.cnsldtnversion AS ConsolidationVersion,
  _Vers.ConsolidationVersionText AS ConsolidationVersionText,
  fincs_log_header.cnsldtnledger AS ConsolidationLedger,
  _Ledger.ConsolidationLedgerName AS ConsolidationLedgerName,
  fincs_log_header.cnsldtndocumenttype AS ConsolidationDocumentType,
  _DT.ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
  fincs_log_header.cnsldtngroupcurrency AS CnsldtnGroupCurrency,
  fincs_log_header.externalid AS ExternalId,
  fincs_log_header.fiscalyear AS FiscalYear,
  fincs_log_header.fiscalperiod AS FiscalPeriod,
  fincs_log_header.status AS Status,
  _Status.ConsolidationTaskStatusText AS ConsolidationTaskStatusText,
  fincs_log_header.cnsldtnmethod AS CnsldtnMethod,
  cast(_Lastlog.IsLastLog as fincs_islastlog) AS IsLastLog,
  fincs_log_header.update_mode AS update_mode,
  fincs_log_header.is_cumulative AS IsCumulative,
  fincs_log_header.timestamp AS timestamp,
  cast( dats_tims_to_tstmp( fincs_log_header.cnsldtnlogdate, fincs_log_header.cnsldtnlogtime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as timestamp ) as createdDateTime AS clientNULLastimestampascreatedDateTime,
  fincs_log_header.consolidationlogtype AS LogType
FROM fincs_log_header
LEFT OUTER JOIN Last_log_UUID_Aggregated AS _Lastlog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CnsldtnGroupAllVH AS _Group ON fincs_log_header.cnsldtngroup = _Group.ConsolidationGroup AND _Group.ConsolidationDimension = 'Y1'  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp AS _Unit ON fincs_log_header.cnsldtnunit = _Unit.ConsolidationUnit AND _Unit.ConsolidationDimension = 'Y1'  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnChartOfAccountsVH AS _CCOA ON fincs_log_header.cnsldtnchartofaccounts = _CCOA.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnDocumentTypeVH AS _DT ON fincs_log_header.cnsldtndocumenttype = _DT.ConsolidationDocumentType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnFiscalPeriodVH AS _Period ON fincs_log_header.fiscalperiod = _Period.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnFiscalYearVH AS _Year ON fincs_log_header.fiscalyear = _Year.FiscalYear  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnLedgerVH AS _Ledger ON fincs_log_header.cnsldtnledger = _Ledger.ConsolidationLedger  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnVersionVH AS _Vers ON fincs_log_header.cnsldtnversion = _Vers.ConsolidationVersion  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnTskCatVH AS _TaskCat ON fincs_log_header.cnsldtntasktype = _TaskCat.ConsolidationTaskType  -- association [0..1]
LEFT OUTER JOIN C_ConsolidationStatusVH AS _Status ON fincs_log_header.status = _Status.ConsolidationTaskStatus  -- association [0..1]
LEFT OUTER JOIN FINCS_FISCAL_YEAR_PEROID AS _YearPeriod ON FiscalYearPeriod = _YearPeriod.FiscalYearPeriod AND _YearPeriod.fiscal_year_variant = 'K4'  -- association [0..1]
LEFT OUTER JOIN FINCS_TASKVH AS _Task ON CnsldtnTask = _Task.CnsldtnTask AND _Task.ConsolidationDimension = 'Y1'  -- association [0..1]
;